Enterprise Manager 12c - Perl Based Metric Collections Fail with Message "ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc" (Doc ID 1909379.1)

Last updated on AUGUST 19, 2022

Applies to:

Symptoms

The agent is running and is able to upload to the OMS without any issues.

However the perl based metric collections are failing and the the file [...]//agent_inst/sysman/log/gcagent.log shows error messages such as:

<metric_name>:em_error=Error message from script <perlscript>.pl:Could not connect to dbsnmp/(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOSTNAME>.<DOMAIN>)(Port=1521))(CONNECT_DATA=(SID=orcl1))): ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc.

2014-06-10 22:56:54,050, ha_rac_intrconn : oracle_database.<HOSTNAME>.<DOMAIN>_orcl1 oracle.sysman.emSDK.agent.client.exception.RunCollectionItemException: 
Metric evaluation failed : ha_rac_intrconn:em_error=Error message from script dbIntrConn.pl:Could not connect to 
dbsnmp/(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOSTNAME>.<DOMAIN>)(Port=1521))(CONNECT_DATA=(SID=orcl1))): 
ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.