sample listener.ora and tnsnames.ora file for RAC PROD and DR/Standby database
PROD RAC DB:
DB: RAC12C (RAC12C1 & RAC12C2)
Nodes: node1 & node2
DR/Standby RAC DB:
DB: RACSB (RACSB1 & RACSB2)
Nodes: oraclenode1 & oraclenode2
PROD:
[oracle@node1 ~]$ srvctl status database -d RAC12C
Instance RAC12C1 is running on node node1
Instance RAC12C2 is running on node node2
[oracle@node1 ~]$
[oracle@node1 ~]$ lsnrctl status LISTENER_RAC12C
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 17-MAR-2022 00:22:44
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node1-vip.localdomain.com)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER_RAC12C
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 24-FEB-2022 05:15:14
Uptime 20 days 19 hr. 7 min. 30 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/node1/listener_rac12c/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.38.4.135)(PORT=1522)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.38.4.133)(PORT=1522)))
Services Summary...
Service "RAC12C" has 1 instance(s).
Instance "RAC12C1", status READY, has 1 handler(s) for this service...
Service "RAC12CXDB" has 1 instance(s).
Instance "RAC12C1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@node1 ~]$
[oracle@node2 ~]$ lsnrctl status LISTENER_RAC12C
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 17-MAR-2022 00:27:37
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node2-vip.localdomain.com)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER_RAC12C
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 15-MAR-2022 05:05:35
Uptime 1 days 19 hr. 22 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/node2/listener_rac12c/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.38.4.137)(PORT=1522)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.38.4.134)(PORT=1522)))
Services Summary...
Service "RAC12C" has 1 instance(s).
Instance "RAC12C2", status READY, has 1 handler(s) for this service...
Service "RAC12CXDB" has 1 instance(s).
Instance "RAC12C2", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@node2 ~]$
[oracle@node1 ~]$ cd /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/
[oracle@node1 admin]$
[oracle@node1 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
ADR_BASE_LISTENER_RAC12C = /u01/app/oracle
LISTENER_RAC12C =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip.localdomain.com)(PORT = 1522))
)
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_RAC12C=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER_RAC12C=SUBNET # line added by Agent
[oracle@node1 admin]$
[oracle@node2 ~]$ cd /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/
[oracle@node2 admin]$
[oracle@node2 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
ADR_BASE_LISTENER_RAC12C = /u01/app/oracle
LISTENER_RAC12C =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip.localdomain.com)(PORT = 1522))
)
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_RAC12C=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER_RAC12C=SUBNET # line added by Agent
[oracle@node2 admin]$
[oracle@node1 admin]$ cat tnsnames.ora
# tnsnames.ora.node2 Network Configuration File: /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/tnsnames.ora.node2
# Generated by Oracle configuration tools.
RAC12C =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = nodescan.localdomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC12C)
)
)
RAC12C1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip.localdomain.com)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC12C)
(SID = RAC12C1)
)
)
RAC12C2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip.localdomain.com)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC12C)
(SID = RAC12C2)
)
)
RACSB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orclscan.localdomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RACSB)
)
)
RACSB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclenode1-vip.localdomain.com)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RACSB)
(SID = RACSB1)
)
)
RACSB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclenode2-vip.localdomain.com)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RACSB)
(SID = RACSB2)
)
)
[oracle@node1 admin]$
[oracle@node2 admin]$ cat tnsnames.ora
# tnsnames.ora.node2 Network Configuration File: /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/tnsnames.ora.node2
# Generated by Oracle configuration tools.
RAC12C =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = nodescan.localdomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC12C)
)
)
RAC12C1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip.localdomain.com)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC12C)
(SID = RAC12C1)
)
)
RAC12C2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip.localdomain.com)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC12C)
(SID = RAC12C2)
)
)
RACSB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orclscan.localdomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RACSB)
)
)
RACSB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclenode1-vip.localdomain.com)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RACSB)
(SID = RACSB1)
)
)
RACSB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclenode2-vip.localdomain.com)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RACSB)
(SID = RACSB2)
)
)
[oracle@node2 admin]$
DR/Standby:
[oracle@oraclenode1 admin]$ srvctl status database -d RACSB
Instance RACSB1 is running on node oraclenode1
Instance RACSB2 is running on node oraclenode2
[oracle@oraclenode1 admin]$
[oracle@oraclenode1 admin]$ lsnrctl status LISTENER_RACSB
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 17-MAR-2022 00:16:31
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oraclenode1-vip.localdomain.com)(PORT=1523)))
STATUS of the LISTENER
------------------------
Alias LISTENER_RACSB
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 15-MAR-2022 21:07:23
Uptime 1 days 3 hr. 9 min. 7 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/oraclenode1/listener_racsb/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.38.4.138)(PORT=1523)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.38.4.110)(PORT=1523)))
Services Summary...
Service "RACSB" has 1 instance(s).
Instance "RACSB1", status READY, has 1 handler(s) for this service...
Service "RACSBXDB" has 1 instance(s).
Instance "RACSB1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@oraclenode1 admin]$
[oracle@oraclenode2 admin]$ lsnrctl status LISTENER_RACSB
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 17-MAR-2022 00:16:55
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oraclenode2-vip.localdomain.com)(PORT=1523)))
STATUS of the LISTENER
------------------------
Alias LISTENER_RACSB
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 15-MAR-2022 21:18:17
Uptime 1 days 2 hr. 58 min. 38 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/oraclenode2/listener_racsb/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.38.4.170)(PORT=1523)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.38.4.115)(PORT=1523)))
Services Summary...
Service "RACSB" has 1 instance(s).
Instance "RACSB2", status READY, has 1 handler(s) for this service...
Service "RACSBXDB" has 1 instance(s).
Instance "RACSB2", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@oraclenode2 admin]$
[oracle@oraclenode1 admin]$ cd /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/
[oracle@oraclenode1 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER_RACSB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclenode1-vip.localdomain.com)(PORT = 1523))
)
ADR_BASE_LISTENER_RACSB = /u01/app/oracle
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_RACSB=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER_RACSB=SUBNET # line added by Agent
[oracle@oraclenode1 admin]$
[oracle@oraclenode2 admin]$ cd /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/
[oracle@oraclenode2 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER_RACSB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclenode2-vip.localdomain.com)(PORT = 1523))
)
ADR_BASE_LISTENER_RACSB = /u01/app/oracle
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_RACSB=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER_RACSB=SUBNET # line added by Agent
[oracle@oraclenode2 admin]$
[oracle@oraclenode1 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
RACSB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orclscan.localdomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RACSB)
)
)
RACSB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclenode1-vip.localdomain.com)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RACSB)
(SID = RACSB1)
)
)
RACSB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclenode2-vip.localdomain.com)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RACSB)
(SID = RACSB2)
)
)
RAC12C =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = nodescan.localdomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC12C)
)
)
RAC12C1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip.localdomain.com)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC12C)
(SID = RAC12C1)
)
)
RAC12C2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip.localdomain.com)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC12C)
(SID = RAC12C2)
)
)
[oracle@oraclenode1 admin]$
[oracle@oraclenode2 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0.1/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
RACSB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orclscan.localdomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RACSB)
)
)
RACSB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclenode1-vip.localdomain.com)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RACSB)
(SID = RACSB1)
)
)
RACSB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclenode2-vip.localdomain.com)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RACSB)
(SID = RACSB2)
)
)
RAC12C =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = nodescan.localdomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC12C)
)
)
RAC12C1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip.localdomain.com)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC12C)
(SID = RAC12C1)
)
)
RAC12C2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip.localdomain.com)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC12C)
(SID = RAC12C2)
)
)
[oracle@oraclenode2 admin]$
Regards,
Mallik
No comments:
Post a Comment