Hi,
I followed http://www.oracle-base.com/articles/11g/DataGuardSetup_11gR2.php .
Primary database : dgtst
sid : dgtst
Machine name : hercules
Standby databae : drtst
sid : dgtst
machine name : pulse
In standby machine :
DB is in nomount status .
$ echo $ORACLE_SID
dgtst
$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/DG11gR2TST
Tnsping is OK from standby machine to both databases:
$ tnsping dgtst
TNS Ping Utility for HPUX: Version 11.2.0.2.0 - Production on 24-FEB-2012 17:41:20
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hercules)(PORT = 1528)))
(CONNECT_DATA = (SERVICE_NAME = dgtst)))
OK (0 msec)
$ tnsping drtst
TNS Ping Utility for HPUX: Version 11.2.0.2.0 - Production on 24-FEB-2012 17:41:32
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = pulse)(PORT = 1528)))
(CONNECT_DATA = (SERVICE_NAME = dgtst)))
OK (0 msec)
Trying to connect to primary database from the standby machine: OK
$ sqlplus sys/UsingTheSamePassword@dgtst as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Feb 24 17:50:18 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
SQL>
Trying to connect to standby database from the standby machine: FAILED
$ sqlplus sys/UsingTheSamePassword@drtst as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Feb 24 17:51:28 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Please note that i copied the orapwd file from primary machine to the standby machine.
Hence the sys password is the same for primary and standby database
Please Advice