Unable to Discover Oracle 12c Discovery(PDB & CDB's)

sboddu
Kilo Contributor

Hi Team,

I have configured the Applicative credentials and perform discovery on the Linux server. It got discovered but instead of falling the record in cmdb_ci_db_ora_pdb_instance table it was updated in cmdb_ci_db_ora_instance table. It was not not using the Applicative credentials also checked in crentials IP Affinity as well.

Thanks in advance.

5 REPLIES 5

SiD2
ServiceNow Employee
ServiceNow Employee

Hi @sboddu,

The cmdb_ci_db_ora_pdb_instance is populated in extension section of the pattern, so first this cmdb_ci_db_ora_instance CI gets created and then the extension section executes.

Can you let me know if you are getting any errors.

Also for which step do you think the applicative credentials are not working? Can you elaborate your issue with more details..

Please mark Helpful / Accept Solution so that it helps others with similar questions.

sboddu
Kilo Contributor

Hi SiD,

Initially I have configured the applicative credential type in Credentials: 

and ran a discovery on the IP. The linux server got discovered I see CDB's got discovered and PDB's were not and also the discovery is not used the applicative credentials. No records in "IP Affinity"

I can see Linux Server got Updated, and in ECC Queue I see " snc_error=Could not read listener.ora: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora. Unable to accurately determine listener"

find_real_file.png

Could you please help me out with the pre requisites for performing 12c discovery.

Thanks in advance:

SiD2
ServiceNow Employee
ServiceNow Employee

Hi @sboddu,

Seems some permission or access issues w.r.t reading that listener.ora or be it any thing in your database environment.

From this error I couldn't make out much, but check the discovery pattern log and you might observe some error in one of pattern step, this would give you pin pointed direction as to what command is failing.

On the applicative credentials, in pattern steps, there will be a configuration to run using applicative credentials, then only it would be used. So when you check the pattern log you can know until which step execution happened. There might be a case where any of the steps didn't use this credential.

 

I found some good doc reg 12c discovery in SNOW docs, sharing here, it mentions about some permissions in prerequisites, try following this, hope it resolves.

https://docs.servicenow.com/bundle/orlando-it-operations-management/page/product/service-mapping/ref...

If this didn't help, as said try debugging from the pattern log as mentioned above.

 

Please mark the appropriate responses as Correct/Helpful so that this thread gets closed and helps others with the same question in the future.

Please mark Helpful / Accept Solution so that it helps others with similar questions.

We have given the permission mentioned in the document. https://docs.servicenow.com/bundle/washingtondc-it-operations-management/page/product/service-mappin...

I am getting the follwoing error : 

Jul 2, 2024 11:19:50 PM:: Test failed: Get Oracle PDB info if exit section running for Oracle CDB installations. Failed Condition(s): [(${isCDB} : value=) EQUALS "yes"]
 
 
 

 

We are able to see the CDB, oracel services, cluster, listeners, only PDB are not working. The applicative credentials being created for cmdb_ci_db_ora_pdb_instance but not helping either.