| Rohit Chouhan |
Posted: Dec 31, 2007 12:52:29 AM |
Total Post: 11
Joined: Aug, 2007
|
Hi
I configured data guard in my test server (version 10.2.0.1.0).
Primary database is running on Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Standby database is running on Oracle Database 11g Enterprise Edition Release 11.1.0.6.0
After configuration i noticed the following error in alert log file.
Errors in file /u02/testdb/bdump/test_arc1_24607.trc:
ORA-16191: Primary log shipping client not logged on standby
PING[ARC1]: Heartbeat failed to connect to standby 'STANDBY_TEST'. Error is 16191.
------------------------------------------------------------
SQL> SELECT DEST_ID "ID", STATUS "DB_status", DESTINATION "Archive_dest", ERROR "Error" FROM V$ARCHIVE_DEST WHERE DEST_ID <=2;
ID DB_status Archive_dest Error
----- --------- -------------------- ----------
1 VALID /u02/testdb/archive
2 ERROR stdby ORA-16191: Primary log shipping client not logged on standby
Both primary and standby databases are using password file authentication, and password for sys user in both databases is also same.
Primary Database was created manually.
Can you help me out.
Thanks |
|
|
 Babu |
| Posted: Dec 31, 2007 05:45:20 AM |  |
|
Total Post: 86
Joined: Oct, 2007
|
ORA-16191: Primary log shipping client not logged on standby
Cause: An attempt to ship redo to standby without logging on to standby or with invalid user credentials.
Action: Check that primary and standby are using password files and that both primary and standby have the same SYS password. Restart primary and/or standby after ensuring that password file is accessible and REMOTE_LOGIN_PASSWORDFILE initialization parameter is set to SHARED or EXCLUSIVE.
|
|
|
|
|
| MOH_DBA |
| Posted: Feb 09, 2008 12:41:11 PM | |
|
Total Post: 123
Joined: Nov, 2007
|
>>Primary database is running on Oracle Database 10g Enterprise Edition >>Release 10.2.0.1.0
>>Standby database is running on Oracle Database 11g Enterprise Edition >>Release 11.1.0.6.0
Oracle DataGuard must only be with same versions 10.2.0 for the primary and 10.2.0 for the standby.
Heterogeneous DataGuard: are for platforms not versions.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
