Hello everyone,
At first I'd like to say I'm a beginer in Oracle databases and I need help. I need to configure simple standby database. I have followed this http://www.oracle-base.com/articles/11g/data-guard-setup-11gr2.php tutorial to do that. Problem is that primary db cannot log on to the standby db. Informations privided below:
Primary DB:
CentOS 6.4
Oracle 11gR2
ORACLE_SID=primdb1
SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;
MESSAGE
--------------------------------------------------------------------------------
ARC0: Archival started
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC1: Beginning to archive thread 1 sequence 31 (336165-356856)
Error 12514 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'stbydb1'. Error is 12514.
ARC1: Completed archiving thread 1 sequence 31 (336165-356856)
ARC3: Archival started
MESSAGE
--------------------------------------------------------------------------------
Error 12514 received logging on to the standby
FAL[server, ARC2]: Error 12514 creating remote archivelog file 'stbydb1'
ARC3: Beginning to archive thread 1 sequence 32 (356856-357024)
ARC3: Completed archiving thread 1 sequence 32 (356856-357024)
ARC0: Beginning to archive thread 1 sequence 33 (357024-357138)
ARC0: Completed archiving thread 1 sequence 33 (357024-357138)
17 rows selected.
[oracle@oracled dbhome_1]$ bin/lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 31-JUL-2013 11:00:13
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 31-JUL-2013 10:37:38
Uptime 0 days 0 hr. 22 min. 35 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /u01/app/oracle/diag/tnslsnr/oracled/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracled)(PORT=1521)))
Services Summary...
Service "primdb1" has 1 instance(s).
Instance "primdb1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@oracled dbhome_1]$ bin/tnsping stbydb1
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 31-JUL-2013 11:00:55
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =10.132.28.33)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = stbydb1)))
OK (0 msec)
[oracle@oracled dbhome_1]$ cat network/admin/tnsnames.ora
primdb1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.234)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = primdb1)
)
)
stbydb1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.132.28.33)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = stbydb1)
)
)
Standby DB:
CentOS 6.4
Oracle 11gR2
ORACLE_SID=primdb1
| SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS; | |
MESSAGE
--------------------------------------------------------------------------------
ARC0: Archival started
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
Error 1017 received logging on to the standby
FAL[client, ARC2]: Error 16191 connecting to primdb1 for fetching gap sequence
ARC3: Archival started
Attempt to start background Managed Standby Recovery process
MRP0: Background Managed Standby Recovery process started
Managed Standby Recovery not using Real Time Apply
MESSAGE
--------------------------------------------------------------------------------
Clearing online redo logfile 1 /u01/app/oracle/oradata/primdb1/redo01.log
Clearing online redo logfile 1 complete
Media Recovery Waiting for thread 1 sequence 22
14 rows selected.
[oracle@rh1 dbhome_1]$ bin/lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 31-JUL-2013 07:05:55
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 31-JUL-2013 06:39:13
Uptime 0 days 0 hr. 26 min. 42 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /u01/app/oracle/diag/tnslsnr/rh1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rh1.localdomain)(PORT=1521)))
Services Summary...
Service "db" has 1 instance(s).
Instance "db", status READY, has 1 handler(s) for this service...
Service "stbydb1" has 1 instance(s).
Instance "primdb1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@rh1 dbhome_1]$ cat network/admin/tnsnames.ora
db =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.132.28.33)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db.WORLD)
)
)
db2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.132.28.37)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db.WORLD)
)
)
primdb1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.132.28.31)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = primdb1)
)
)
stbydb1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.132.28.33)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = stbydb1)
)
)
Thanks in advance for help.
Cheers.