Oracle DBA Tips and Techniques

By Arjun Raja

Warning The database discovery finished with some warnings: Can’t resolve a non-optional query descriptor property DiscoveryRoots (DiscoveryRoots)

Posted by Arjun Raja on July 24, 2012

Warning The database discovery finished with some warnings: Can’t resolve a non-optional query descriptor property
[DiscoveryRoots] (DiscoveryRoots)

I installed the Oracle 12c agent using the silent mode – downloaded the zip file to the server where the agent was
being installed .

I noticed none of the databases or listeners had been discovered in the Cloud control web page even after the agent
install was successful.

While trying to manually discover them via Cloud control I received the message

Warning The database discovery finished with some warnings: Can’t resolve a non-optional query descriptor property
[DiscoveryRoots] (DiscoveryRoots)
I checked the log file on the agent server.

cd $AGENT_HOME/sysman/log

view gcagent.log

Noticed the following errors during installation –

2012-07-23 14:41:50,055 [42:F5077C5B:HTTP Listener-42 – /emd/main/ (DispatchRequests)] INFO – (begin processing requests for
OMS@6488096@middba3=>[134302570780001])
2012-07-23 14:41:50,056 [42:F5077C5B] INFO – >>> Dispatching request: PutFileRequest
(/u01/oracle/agent12c/install/logs/oracle.sysman.oh_12.1.0.1.0_DISCOVERY_52.zip len
gth=302837 BIN) <<<
2012-07-23 14:41:50,130 [89:68BCA6D1:JobReader-GCThread-36-89] WARN – JobReader encountered an exception:java.io.IOException: Broken pipe 2012-07-23 14:41:50,136 [42:F5077C5B] INFO – >>> Reporting exception: oracle.sysman.emSDK.agent.client.exception.PerformOperationException: Unable to create file /u01/oracle/agent12c/install/logs
/oracle.sysman.oh_12.1.0.1.0_DISCOVERY_52.zip: No such file or directory

I checked the path mentioned in the error and realised there was no directory install/logs under /u01/oracle/agent12c.

Created those directories and ran a discovery again and it worked.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: