敗家貓:解決oracle 11g ORA-16191

2009年06月15日

在練習題 oracle 11g guard時，遇到10g沒有遇過的問題

------------- 取出一段的log -----------

Mon Jun 15 22:49:50 2009

Error 1017 received logging on to the standby

------------------------------------------------------------

Check that the primary and standby are using a password file

and remote_login_passwordfile is set to SHARED or EXCLUSIVE,

and that the SYS password is same in the password files.

returning error ORA-16191

------------------------------------------------------------

Errors in file /u01/app/oracle/diag/rdbms/tguard140/tguard/trace/tguard_arc0_16298.trc:

ORA-16191: Primary log shipping client not logged on standby

PING[ARC0]: Heartbeat failed to connect to standby 'tguard141'. Error is 16191.

Mon Jun 15 22:54:52 2009

Error 1017 received logging on to the standby

網路上有很多的解決的文章，經測試後的我所做過的的動作

1、我把二台oracle的帳號設成相同

2、密碼檔重建，orapwd$ORACLE_SID 的密碼設成跟sys相同，並加上 ignorecase=Y

3、sqlplus 都可登入二邊的db

4、查看 fal_client 、fal_server、remote_login_passwordfile、log_archive_dest_x

5、查看 sec_case_sensitive_logon 為 FLASE

以上的動作都不必重同二邊的db，只要設定對就馬上可以同步了~~

參考的網址

Posted by my_work at 樂多Roodo! │23:16 │回應(0) │引用(0) │DB

樂多分類：網路/3C 共同主題：Oracle 工具：編輯本文
標籤：oracle

http://cgi.blog.roodo.com/trackback/9235493