Hi all,
We have an agent for OEM Cloud Control 12c that is "Pending". We tried to stop/clean/restart but nothing changed and when we try to resynchronize it, the job is scheduled but never run (we tested scheduling a job on the repository and it's ok, and we have other agents that are working fine).
We also tried to run command line "emctl resync repos -agentlist agent-name" but we get this error :
(Note: we are not sure of what to give as agent-name argument)
2015-06-01 11:28:26,209 [main] ERROR resync.ResyncRepos main.174 - SQLException while trying to start resync!
java.sql.SQLException: ORA-06502: PL/SQL : erreur numérique ou erreur sur une valeur
ORA-06512: Ã "SYSMAN.EMD_MAINTENANCE", ligne 2324
ORA-06512: Ã ligne 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1006)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4714)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at oracle.sysman.emctl.resync.ResyncRepos.main(ResyncRepos.java:150)
Some command output :
./emctl start agent
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved.
Starting agent .......... started.
./emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 12.1.0.2.0
OMS Version : 12.1.0.2.0
Protocol Version : 12.1.0.1.0
Agent Home : /oracle/agent12c/agent_inst
Agent Binaries : /oracle/agent12c/core/12.1.0.2.0
Agent Process ID : 21310
Parent Process ID : 21258
Agent URL : https://targethost:3872/emd/main/
Repository URL : https://omsserver:4904/empbs/upload
Started at : 2015-06-01 11:43:49
Started by user : oracle
Last Reload : (none)
Last successful upload : (none)
Last attempted upload : (none)
Total Megabytes of XML files uploaded so far : 0
Number of XML files pending upload : 1
Size of XML files pending upload(MB) : 0
Available disk space on upload filesystem : 32,43 %
Collection Status : Collections enabled
Heartbeat Status : Ok
Last attempted heartbeat to OMS : 2015-06-01 11:44:15
Last successful heartbeat to OMS : 2015-06-01 11:44:15
Next scheduled heartbeat to OMS : 2015-06-01 11:45:15
---------------------------------------------------------------
Agent is Running and Ready
./emctl pingOMS
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD pingOMS completed successfully
Hope someone can help us we this issue.
Regards,