Hi fellows,
Facts:
- Oracle 11g 11.1.0.6
- CentOS 6.5
- Single Instance.
- Only file systems in database, NOT asm.
- OLTP
We have reconfigured the emctl following a guide on metalink.
All steps were sucessfully completed.
I have restarted the service and everything looks going fine:
[oracle@bdanr002 bin]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.1.0.6.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://localhost:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ....... started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.1.0/db_1/localhost_bdanr/sysman/log
[oracle@bdanr002 bin]$ date
mar abr 26 22:59:10 PET 2016
Some records on emagent.trc are:
2016-04-26 23:16:05 Thread-3672479488 WARN vpxoci: OCI Error -- ErrorCode(1873): ORA-01873: la precision inicial del intervalo es demasiado peque?a
ORA-06512: en "DBSNMP.MGMT_RESPONSE", linea 1017
ORA-06512: en "DBSNMP.MGMT_RESPONSE", linea 927
ORA-06512: en linea 7
SQL = "/* OracleOEM */
BEGIN
IF (:1 = 'READ WRITE' AND (:2 = '2' OR :2 = '3')) THEN
"...
LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=bdanr)))
2016-04-26 23:16:05 Thread-3672479488 ERROR fetchlets.sql: ORA-01873: la precision inicial del intervalo es demasiado peque?a
ORA-06512: en "DBSNMP.MGMT_RESPONSE", linea 1017
ORA-06512: en "DBSNMP.MGMT_RESPONSE", linea 927
ORA-06512: en linea 7
2016-04-26 23:16:05 Thread-3672479488 ERROR engine: [oracle_database,bdanr,sql_response_collect] : nmeegd_GetMetricData failed : ORA-01873: la precision inicial del intervalo es demasiado peque?a
ORA-06512: en "DBSNMP.MGMT_RESPONSE", linea 1017
ORA-06512: en "DBSNMP.MGMT_RESPONSE", linea 927
ORA-06512: en linea 7
2016-04-26 23:16:05 Thread-3672479488 WARN collector: <nmecmc.c> Error exit. Error message: ORA-01873: la precision inicial del intervalo es demasiado peque?a
ORA-06512: en "DBSNMP.MGMT_RESPONSE", linea 1017
ORA-06512: en "DBSNMP.MGMT_RESPONSE", linea 927
ORA-06512: en linea 7
2016-04-26 23:16:58 Thread-3669329664 ERROR fetchlets.oslinetok: Process stderr = tail: no se puede abrir «+2» para lectura: No existe el fichero o el directorio
Failed to run grep at /u01/app/oracle/product/11.1.0/db_1/sysman/admin/scripts/osCpuUsage.pl line 51.
2016-04-26 23:16:58 Thread-3669329664 ERROR engine: [host,localhost,CPUUsage] : nmeegd_GetMetricData failed : tail: no se puede abrir «+2» para lectura: No existe el fichero o el directorio
Failed to run grep at /u01/app/oracle/product/11.1.0/db_1/sysman/admin/scripts/osCpuUsage.pl line 51.
2016-04-26 23:16:58 Thread-3669329664 WARN collector: <nmecmc.c> Error exit. Error message: tail: no se puede abrir «+2» para lectura: No existe el fichero o el directorio
Failed to run grep at /u01/app/oracle/product/11.1.0/db_1/sysman/admin/scripts/osCpuUsage.pl line 51.
Searching on metalink refers error ORA-01873 for a bug that was fixed on 10g version.
Maybe tat records belong to emagent.trc looks familiar for someone?
Please, your help, I cannot enter to my EM link.
THANKS in advance.
cesar.