Erreur de type dans OMS Alerte :
datetime="2012-09-09T10:42:11+00:00">datetime="2012-09-09T10:42:11+00:00">2012-09-09 09:56:14,400 [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR receiver.AbstractOMSHandshake logp.251 - OMSHandshake failed.(AGENT URL = https://hostname.domainame:3872/emd/main/)(ERROR = AGENT_TZ_MISMATCH)
Si on essai de démarrer le service sur le nœud dans notre exemple (hostname):
[oracle@hostname]/EMAgent/oracle/agent11g/bin # ./emctl start agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
Starting agent ....... failed.
Consult the log files in: /EMAgent/oracle/agent11g/sysman/log
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
Starting agent ....... failed.
Consult the log files in: /EMAgent/oracle/agent11g/sysman/log
Dans ce cas la faut réinitialiser Time Zome comme suit :
[oracle@hostname]/EMAgent/oracle/agent11g/bin # ./emctl resetTZ agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
Updating /EMAgent/oracle/agent11g/sysman/config/emd.properties...
Successfully updated /EMAgent/oracle/agent11g/sysman/config/emd.properties.
Login as the em repository user and run the script:
exec mgmt_target.set_agent_tzrgn('hostname.domainame:3872:3872','+01:00')
and commit the changes
This can be done for example by logging into sqlplus and doing
SQL> exec mgmt_target.set_agent_tzrgn('omu2.otalgerie.com:3872','+01:00')
SQL> commit
[oracle@hostname]/EMAgent/oracle/agent11g/bin #
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
Updating /EMAgent/oracle/agent11g/sysman/config/emd.properties...
Successfully updated /EMAgent/oracle/agent11g/sysman/config/emd.properties.
Login as the em repository user and run the script:
exec mgmt_target.set_agent_tzrgn('hostname.domainame:3872:3872','+01:00')
and commit the changes
This can be done for example by logging into sqlplus and doing
SQL> exec mgmt_target.set_agent_tzrgn('omu2.otalgerie.com:3872','+01:00')
SQL> commit
[oracle@hostname]/EMAgent/oracle/agent11g/bin #
Exécutez la commande donner par le service emctl sur OMS :
oracle@omshost:/home/oracle#sqlplus
/as
SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 9 10:06:43 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: sysdba
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exec mgmt_target.set_agent_tzrgn('hostname.domainame:3872','+01:00');
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
oracle@omshost:/home/oracle#
/as
SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 9 10:06:43 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: sysdba
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exec mgmt_target.set_agent_tzrgn('hostname.domainame:3872','+01:00');
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
oracle@omshost:/home/oracle#