How discover oracle CDB and plugable data base?

pratiksha5
Mega Sage

‎07-22-2024 09:58 PM - edited ‎07-23-2024 01:38 AM

We are able to discover the host machine. Have created a credentials for cmdb_ci_db_ora_instance. Database team confirmed that the user have access to both. 

 

This one is using Oracle DB on Unix pattern. 

 

Identification 54.6. keep listener info is failing saying that the 

 Failed to retrieve remote data: SSH connection to host, IP address, has been reset unexpectedly.

 

 

The listener info is used to get the service name in the step 55

 

The exploration section Get Oracle Instance size info step number 7 check CDB unix has command 

"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 + ":" + $connect_sql[1].listener_port + "/" + $connect_sql[1].service_name

Here I am getting the following error : 

Failed to retrieve remote data: Execution of co


mmand export TNS_ADMIN=/u02/app/oracle/p roduct/19.0.0.0/dbhome_1/network/admin;exp ort ORACLE_HOME=/u02/app/oracle/product/ 19.0.0.0/dbhome_1; echo "select CDB from v


I$database;" |"/u02/app/oracle/product/19.0.0.
0/dbhome_1/bin/sqlplus" -s 'ABC:/*****'@of3
Pre

dbvm06-07bs1:/ on host 102.230.2.106 failed w th status O. ERROR:
ORA-12504: TNS: listener was not given the SE RVICE_NAME in CONNECT_DATA
Followi
Equals
SP2-0306: Invalid option.


Starts V Usage: CONN[ECT] [(logon|/|proxy) [AS {SYSD
BAISYSOPER|SYSASM|SYSBACKUP|SYSDG|S

Starts V
YSKM|SYSRAC)] [edition=valuell
where < logon> := ‹username> [/<password>] [@<connect_identifier>]

Starts W
‹proxy>:= ‹proxyuser>[<username>]l/< pas
sword>|@<connect_identifier>]

 

I have open ticket with ServiceNow. It's not moving so asking in community for suggestions. 

 

Regards, 

Pratiksha

 @ashutoshmunot, @doug_schulze

Labels:
0 Helpfuls
  • 634 Views
3 REPLIES 3

Yashsvi
Kilo Sage

‎07-22-2024 10:22 PM

Hi @pratiksha5,

please check below link:

https://www.servicenow.com/community/itom-forum/discovery-oracle-cbd-pdbs/m-p/906148

Thank you, please make helpful if you accept the solution.

0 Helpfuls

pratiksha5
Mega Sage
In response to Yashsvi

‎07-22-2024 10:26 PM

It's a diffrent  issue. 

0 Helpfuls

devpc
Tera Contributor

‎04-29-2025 07:59 AM - edited ‎04-29-2025 08:06 AM

Hi, I've got the same issue, have you resolve in any way? thanks

I've also an error on step 8

2025-04-29 15:54:05: Command result:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

and step 9

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 4476
Additional information: 1888000907
Process ID: 0
Session ID: 0 Serial number: 0



 

0 Helpfuls