PDB are not getting discovered through Oracle Cloud Discovery

[Suvetha S]

Hi All,

We are trying to discover Pluggable database which in Cloud and followed all the perquisites as mentioned in the below document. We are able to discover the Container database and also created user in the CDB level. But PDb database are still not getting discovered. the extension section which brings the PDBs are not present in the Discovery logs of Oracle Discovery schedules to troubleshoot further. Please advice. 

[Pratiksha]

We have recently faced the issue. Oracle DB on UNIX pattern is responsible for this. We have done changes in order to  able to connect to PDB. You need to dubug the pattern, with db team. Once they see the command which ServiceNow been using they will guide you on what you need. 

For me updating the values in the command helped. 

"export TNS_ADMIN=" + $ora_home_exe + "/network/admin;export ORACLE_HOME=" + $ora_home_exe + "; echo  \"select CDB from v\$database;\" |" + "\"" + $ora_home_exe + "/bin/sqlplus\" -s " + "'$$username$$'/'$$password$$'@" + $computer_system.primaryHostname +".FQDN(change this):" + "1521(The port might not be coming ) "+ "/" + "Service_name_ADMIN"

I hope it helps. 

[Jomin Johncy]

1. Check if applicative credential is created on Oracle Instance level. 

2. On step 49/50 of the identification step (assuming its Oracle DB on UNIX) of pattern check if the SSH credential is able to access tnsnames.ora file. 

3. If step 2 succeeds, then check on extension section (this is where applicative credential defined on Oracle Instance level is used) whether all the values are passed like Pratiksha mentioned (not required to pass port 1521 as you would be getting that value in step 49/50). 

export TNS_ADMIN=" + $ora_home_exe + "/network/admin;export ORACLE_HOME=" + $ora_home_exe + "; echo  \"select CDB from v\$database;\" |" + "\"" + $ora_home_exe + "/bin/sqlplus\" -s " + "'$$username$$'/'$$password$$'@" + $computer_system.primaryHostname +".FQDN(change this):" + "1521(The port might not be coming ) "+ "/" + "Service_name_ADMIN"