My Oracle Support Banner

Database status down after relocating target using 'emcli relocate_targets' in 12c (Doc ID 1554184.1)

Last updated on FEBRUARY 07, 2020

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.1.0 to 12.1.0.2.0 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Database status is shown as down after relocating using following commands:

emcli relocate_targets -src_agent="<Source_Agent_Hostname>:<Source_Agent_Port>" -dest_agent="<Destination_Agent_Hostname>:<Destination_Agent_Port>" -target_name="<DB_Target_Name>" -target_type=oracle_database -copy_from_src -force=yes
emcli modify_target -name="<DB_Target_Name>" -type=oracle_database -properties=MachineName:"<Hostname>" 

 

gcagent.log in AGENT_INST/sysman/log has following messages:

2013-05-16 17:19:58,959 [141:81EA264F:GC.Executor.8] DEBUG - End task oracle_database:PACERQA:Response
2013-05-16 17:20:01,963 [139:C4EB6FEA] DEBUG - Execution error:
oracle.sysman.emSDK.agent.fetchlet.exception.FetchletException: Failed to connect: java.sql.SQLException: The Network Adapter could not establish the connection
at oracle.sysman.gcagent.addon.fetchlet.sqlfetchlet.SqlFetchlet.getMetric(SqlFetchlet.java:857)
at oracle.sysman.gcagent.target.interaction.execution.FetchletFactory.getMetric(FetchletFactory.java:388)
at oracle.sysman.gcagent.target.interaction.execution.ExecuteTask.executeQueryDescriptor(ExecuteTask.java:1002)
at oracle.sysman.gcagent.target.interaction.execution.ExecuteTask.runTask(ExecuteTask.java:3745)
at oracle.sysman.gcagent.target.interaction.execution.ExecuteTask.call(ExecuteTask.java:4848)
at oracle.sysman.gcagent.metadata.impl.collection.MetricColl$1.call(MetricColl.java:519)
at oracle.sysman.gcagent.metadata.impl.collection.MetricColl$1.call(MetricColl.java:486)
at oracle.sysman.gcagent.task.TaskFutureImpl$WrappedTask.accountedCall(TaskFutureImpl.java:548)
at oracle.sysman.gcagent.task.TaskFutureImpl$WrappedTask.call(TaskFutureImpl.java:581)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
..........
Caused by: java.sql.SQLException: The Network Adapter could not establish the connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:525)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
........
Caused by: java.net.NoRouteToHostException: No route to host
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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