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)
Leave a Reply