Error in Agent Log refers to ghost DB

[former_member204618]

Hi All,

I've recently upgraded Oracle 10g to 12c on AIX 6.1 and have noticed a strange error in the Agent Logs.

Time 2016 04 14 08:39:13:024 
Severity Error 
Location com.sap.smd.e2edcc.db 
Text [DatabaseInfoPushJob] Exception calling DataEnrichment Manager Bean. 
[EXCEPTION]
 java.rmi.RemoteException: RfcExecutionException; nested exception is: 
com.sap.sup.admin.abap.rfc.exception.RfcExecutionException: An exception occured during the execution of the function 'FM_DIAGLS_PUSH_DATABASE': Cannot retrieve database 'RAM.DBTypeForSAP.ORA.SystemHome.myhost'nullnull
at com.sap.sup.dataenrichment.impl.DataEnrichmentManager.pushDatabaseData(DataEnrichmentManager.java:381)
at sun.reflect.GeneratedMethodAccessor851.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:331)
at com.sap.engine.services.rmi_p4.P4DynamicSkeleton.dispatch(P4DynamicSkeleton.java:159)
at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:337)
at com.sap.engine.services.rmi_p4.DispatchImpl._run(DispatchImpl.java:201)
at com.sap.engine.services.rmi_p4.server.P4SessionProcessor.request(P4SessionProcessor.java:137)
at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)
at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)
at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)
at java.security.AccessController.doPrivileged(Native Method)
at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:104)
at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:176)
Caused by: com.sap.sup.admin.abap.rfc.exception.RfcExecutionException: An exception occured during the execution of the function 'FM_DIAGLS_PUSH_DATABASE': Cannot retrieve database 'RAM.DBTypeForSAP.ORA.SystemHome.myhost'nullnull
at com.sap.sup.admin.abap.rfc.function.RfcFunction.execute(RfcFunction.java:111)
at com.sap.sup.dataenrichment.impl.DataEnrichmentManager.pushDatabaseData(DataEnrichmentManager.java:376)
... 13 more
Caused by: com.sap.mw.jco.JCO$AbapException: (126) RETRIEVE_EXCEPTION: LMDB Retrieve Error
at com.sap.mw.jco.JCO$Client.execute(JCO.java:3714)
at com.sap.sup.admin.abap.rfc.function.RfcFunction.execute(RfcFunction.java:81)
... 14 more













ThreadName Thread[ExRun:OutsideDiscovery_1,5,OutsideDiscovery:ExecTG] 

The key error is "RAM.DBTypeForSAP.ORA.SystemHome.myhost" When I run

/usr/sap/hostctrl/exe/saphostctrl -function ListDatabases

It lists a Database that doesn't exist in the old Oracle Home!

Instance name: SID, Hostname: myhost, Vendor: ora, Type: ora, Release: 12.1.0.2.0
  Database name: SID, Status: Running
    Component name: Instance (Instance), Status: Running (Instance is started)
    Component name: Database (Database), Status: Running (Database is in normal state)
    Component name: Archiver (Archiver), Status: Stopped (Archiver is disabled)
    Component name: Listener (Listener), Status: Running (Listener is started)
Instance name: RAM, Hostname: myhost, Vendor: ora, Type: ora, Release: 10.2.0.5.0
  Database name: RAM, Status: Stopped
    Component name: Instance (Instance), Status: Stopped (Instance is stopped)
    Component name: Database (Database), Status: Stopped (Database is stopped)
    Component name: Archiver (Archiver), Status: Stopped (Archiver is stopped)
    Component name: Listener (Listener), Status: Stopped (Listener is stopped)

I do not know why this is showing, this wasn't there and isn't there in UAT which has yet to be upgraded.

What could be causing this and how do I solve it?

Thanks

Craig

[former_member204618 · Accepted solution]

Hi all,

I removed the old Oracle 10g home and the problem is resolved.

Cheers

Craig

[MichaelFoley]

HI Craig,

To stop this from occurring, please see Note 2227586.

Follow the option 2 to remove monitoring from the non existent DB.

Thanks
Michael

[manish_singh13]

Hi Craig,

Please check below SAP Note:

1946339 - "FM_DIAGLS_PUSH_DATABASE: The Host '<oradbhostname>' does not exist" - Solution Manager 7....

Thanks,

MPS

[former_member204618]

Hi Manish,

Unfortunately I already looked at this note and it's not applicable, it says the fix is in ST710 SP08 I am running SP14.  Not only that but there is no IP listed in the listener only hostname.  I've checked both the old listener as well as the new one.

My only option now even though it was on the books anyway, is to remove the old oracle home.

Thanks

Craig

[former_member204080]

Hi Craig,

Have you tried reinstalling the  Agent freshly 

Regards,

Murali

[former_member204618]

Hi Murali,

No I haven't done that and that seems a little extreme, besides which that'll involve getting our UNIX team involved and that takes time.

I have however installed new hostagents via the auto update mechanism but that hasn't resolved it.

Cheers

Craig