oracle密码文件后缀名导致Data Guard不能传送日志

DG远程传送日志出现问题，primary手动切换日志，standby没有接收到远端送过来的日志。

手工归档结束后，没有出现任何错误提示，检查alert文件：

 

Sql代码

1. Sun Aug  1 23:18:12 2010   
2. Errors in file /opt/app/oracle/admin/orcl/bdump/orcl_arc0_32525.trc:   
3. ORA-16191: Primary log shipping client not logged on standby   
4. Sun Aug  1 23:18:12 2010   
5. Starting background process QMNC   
6. Sun Aug  1 23:18:12 2010   
7. FAL[server, ARC0]: Error 16191 creating remote archivelog file 'ORCL_DG'  
8. FAL[server, ARC0]: FAL archive failed, see trace file.   
9. Sun Aug  1 23:18:12 2010   
10. Errors in file /opt/app/oracle/admin/orcl/bdump/orcl_arc0_32525.trc:   
11. ORA-16055: FAL request rejected   
12. ARCH: FAL archive failed. Archiver continuing  

Sun Aug  1 23:18:12 2010Errors in file /opt/app/oracle/admin/orcl/bdump/orcl_arc0_32525.trc:ORA-16191: Primary log shipping client not logged on standbySun Aug  1 23:18:12 2010Starting background process QMNCSun Aug  1 23:18:12 2010FAL[server, ARC0]: Error 16191 creating remote archivelog file 'ORCL_DG'FAL[server, ARC0]: FAL archive failed, see trace file.Sun Aug  1 23:18:12 2010Errors in file /opt/app/oracle/admin/orcl/bdump/orcl_arc0_32525.trc:ORA-16055: FAL request rejectedARCH: FAL archive failed. Archiver continuing

 

 

 

检查后台进程跟踪文件orcl_arc0_32525.trc

Java代码

1. Error 16191 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'ORCL_DG'  
2. Error 16191 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'ORCL_DG'  
3. ORA-16191: Primary log shipping client not logged on standby   
4. *** 2010-08-01 23:31:56.277 58941 kcrr.c   
5. kcrrfail: dest:2 err:16191 force:0 blast:1  
6. kcrrwkx: unknown error:16191  
7. ORA-16055: FAL request rejected   
8. ARCH: Connecting to console port...   
9. ARCH: Connecting to console port...   
10. kcrrwkx: nothing to do (end)   
11. *** 2010-08-01 23:32:17.142  
12. kcrrwkx: nothing to do (end)   
13. *** 2010-08-01 23:33:17.169  
14. kcrrwkx: nothing to do (end)   
15. *** 2010-08-01 23:34:17.197  
16. Redo shipping client performing standby login   
17. ORA-01017: invalid username/password; logon denied   
18. OCI_DBVER attribute value retrieval failed error=1017  
19. *** 2010-08-01 23:34:17.213 60679 kcrr.c   
20. Error 1017 received logging on to the standby   
21. ------------------------------------------------------------   
22. Check that the primary and standby are using a password file   
23. and remote_login_passwordfile is set to SHARED or EXCLUSIVE,   
24. and that the SYS password is same in the password files.   
25.       returning error ORA-16191  
26. It may be necessary to define the DB_ALLOWED_LOGON_VERSION   
27. initialization parameter to the value "10".  Check the   
28. manual for information on this initialization parameter.  

Error 16191 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'ORCL_DG'Error 16191 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'ORCL_DG'ORA-16191: Primary log shipping client not logged on standby*** 2010-08-01 23:31:56.277 58941 kcrr.ckcrrfail: dest:2 err:16191 force:0 blast:1kcrrwkx: unknown error:16191ORA-16055: FAL request rejectedARCH: Connecting to console port...ARCH: Connecting to console port...kcrrwkx: nothing to do (end)*** 2010-08-01 23:32:17.142kcrrwkx: nothing to do (end)*** 2010-08-01 23:33:17.169kcrrwkx: nothing to do (end)*** 2010-08-01 23:34:17.197Redo shipping client performing standby loginORA-01017: invalid username/password; logon deniedOCI_DBVER attribute value retrieval failed error=1017*** 2010-08-01 23:34:17.213 60679 kcrr.cError 1017 received logging on to the standby------------------------------------------------------------Check that the primary and standby are using a password fileand remote_login_passwordfile is set to SHARED or EXCLUSIVE,and that the SYS password is same in the password files.      returning error ORA-16191It may be necessary to define the DB_ALLOWED_LOGON_VERSIONinitialization parameter to the value "10".  Check themanual for information on this initialization parameter.

 

 

按照提示依次（invalid username/password，ALLOWED_LOGON_VERSION
，remote_login_passwordfile）做了检查，都没有问题。

 

最后发现是密码文件有.ora后缀导致的。应该是orcle不人性的一个地方或者一个bug吧。

 

主备库上分别重建下密码文件，一切正常了：

Java代码

1. [oracle@master bdump]$ rm $ORACLE_HOME/dbs/orapwORCL.ora   
2. [oracle@master bdump]$ orapwd file=$ORACLE_HOME/dbs/orapwORCL password=xxxxxx entries=30   

[oracle@master bdump]$ rm $ORACLE_HOME/dbs/orapwORCL.ora[oracle@master bdump]$ orapwd file=$ORACLE_HOME/dbs/orapwORCL password=xxxxxx entries=30