Environment details:-
Hostname | gg1.soumya.com |
Server IP | 192.168.0.110 |
DB Version | 19.3.0 |
Container DB SID | TESTCDB |
PDB1 SID | TESTPDB1 |
PDB2 SID | TESTPDB2 |
ORACLE_HOME | /u01/app/oracle/product/19.0.0/dbhome_1 |
vi $ORACLE_HOME/network/admin/listener.ora LISTENER = [DESCRIPTION_LIST = [DESCRIPTION = [ADDRESS = [PROTOCOL = TCP][HOST = gg1.soumya.com][PORT = 1521]] [ADDRESS = [PROTOCOL = IPC][KEY = EXTPROC1521]] ] ] SID_LIST_LISTENER = [SID_LIST = [SID_DESC = [GLOBAL_DBNAME = TESTDB] [SID_NAME = TESTDB] ] [SID_DESC = [GLOBAL_DBNAME = TESTPDB1] [SID_NAME = TESTPDB1] ] [SID_DESC = [GLOBAL_DBNAME = TESTPDB2] [SID_NAME = TESTPDB2] ] ] |
vi $ORACLE_HOME/network/admin/tnsnames.ora TESTCDB = [DESCRIPTION = [ADDRESS = [PROTOCOL = TCP][HOST = gg1.soumya.com][PORT = 1521]] [CONNECT_DATA = [SERVER = DEDICATED] [SERVICE_NAME = TESTCDB] ] ] TESTPDB1 = [DESCRIPTION = [ADDRESS = [PROTOCOL = TCP][HOST = gg1.soumya.com][PORT = 1521]] [CONNECT_DATA = [SERVER = DEDICATED] [SERVICE_NAME = TESTPDB1] ] ] TESTPDB2 = [DESCRIPTION = [ADDRESS = [PROTOCOL = TCP][HOST = gg1.soumya.com][PORT = 1521]] [CONNECT_DATA = [SERVER = DEDICATED] [SERVICE_NAME = TESTPDB2] ] ] |
Verify Listener status
[oracle@gg1 admin]$ lsnrctl status LISTENER LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 26-DEC-2020 20:19:14 Copyright [c] 1991, 2019, Oracle. All rights reserved. Connecting to [DESCRIPTION=[ADDRESS=[PROTOCOL=TCP][HOST=gg1.soumya.com][PORT=1521]]] STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 26-DEC-2020 19:57:29 Uptime 0 days 0 hr. 21 min. 45 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/gg1/listener/alert/log.xml Listening Endpoints Summary... [DESCRIPTION=[ADDRESS=[PROTOCOL=tcp][HOST=gg1.soumya.com][PORT=1521]]] Services Summary... Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance[s]. Instance "testdb", status READY, has 1 handler[s] for this service... Service "TESTDB" has 2 instance[s]. Instance "TESTDB", status UNKNOWN, has 1 handler[s] for this service... Instance "testdb", status READY, has 1 handler[s] for this service... Service "TESTPDB1" has 2 instance[s]. Instance "TESTPDB1", status UNKNOWN, has 1 handler[s] for this service... Instance "testdb", status READY, has 1 handler[s] for this service... Service "TESTPDB2" has 2 instance[s]. Instance "TESTPDB2", status UNKNOWN, has 1 handler[s] for this service... Instance "testdb", status READY, has 1 handler[s] for this service... Service "b74ddd0efa7a8c6ae0536e00a8c0a6b5" has 1 instance[s]. Instance "testdb", status READY, has 1 handler[s] for this service... Service "b74de34fad898e5fe0536e00a8c0203a" has 1 instance[s]. Instance "testdb", status READY, has 1 handler[s] for this service... Service "testdbXDB" has 1 instance[s]. Instance "testdb", status READY, has 1 handler[s] for this service... The command completed successfully |
Verify tns entries
[oracle@gg1 admin]$ tnsping testcdb TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 26-DEC-2020 20:20:44 Copyright [c] 1997, 2019, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact [DESCRIPTION = [ADDRESS = [PROTOCOL = TCP][HOST = gg1.soumya.com][PORT = 1521]] [CONNECT_DATA = [SERVER = DEDICATED] [SERVICE_NAME = TESTCDB]]] OK [0 msec] [oracle@gg1 admin]$ tnsping testpdb1 TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 26-DEC-2020 20:20:49 Copyright [c] 1997, 2019, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact [DESCRIPTION = [ADDRESS = [PROTOCOL = TCP][HOST = gg1.soumya.com][PORT = 1521]] [CONNECT_DATA = [SERVER = DEDICATED] [SERVICE_NAME = TESTPDB1]]] OK [0 msec] |