Standby Database - Configuring TNSNAMES.ORA & LISTENER.ORA Files
Posted on 2001-07-02
I am using 32-bit Oracle 22.214.171.124.0 for both the Primary and Standby databases and each database is on a separate host/server. Both hosts are running the same version of the operating system.
After following Chapter 5 "Oracle8i Standby Database Concepts and Administration Release 2 (8.1.6)" documentation on setting up the network files for the Primary and Standby databases, I am unable to establish a connection between the two using the "sqlplus email@example.com" on the Primary database.
Here are the statistics:
Primary database SID = CAB32P
Primary database host = ALPHA
Standby database SID = CAB32P
Standby database host = ZENITH
(The Standby database SID is CAB32P since this is the actual SID of the Standby database, internally and in the Standby database's INITCAB32S.ORA file ("S" for Standby.)) In addition, every Oracle Net8 Listener connection between all 32-bit Oracle 126.96.36.199.0 servers is being performed successfully via port 1521.
To test the connectivity, the following has been performed:
-- Primary database is open and the Standby database is mounted with the "alter database mount standby database;" statement.
-- Primary and Standby database Listeners have been shutdown and started for the changes to the TNSNAMES.ORA and/or LISTENER.ORA files to take effect, respectively.
Once this problem is corrected, I can activate the following INIT.ORA parameter in the Primary database:
log_archive_dest_2 = 'service=cab32s.zenith optional reopen=30'
PRIMARY DATABASE - TNSNAMES.ORA File
cab32s.zenith = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp) (HOST = zenith)(PORT = 1521)) (CONNECT_DATA = (SID = cab32p)))
STANDBY DATABASE - LISTENER.ORA File
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/test)(PROGRAM = extproc))
(SID_DESC = (GLOBAL_DBNAME = test)(ORACLE_HOME = (u01/app/oracle/product/8.1.6-64)(SID_NAME = test)))
STBY1_LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp)(KEY = cab32p)))
SID_LIST_STBY1_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = cab32p) (ORACLE_HOME = /u01/app/oracle/product/test)))
ORACLE ERROR WHEN "sqlplus firstname.lastname@example.org"
IS EXECUTED FROM PRIMARY DATABASE
ORA-12154: TNS:could not resolve service name
Thank you in advance for all feedback on this.