密码文件命名规则(转)

关于Oracle中密码文件名的规则

 

今天整Dataguard，建了两个备库，日志总是无法传送到备库，主库的alert.log错误信息如下：
*** 2008-11-03 15:41:05.900
Redo shipping client performing standby login
ORA-01017: invalid username/password; logon denied
OCI_DBVER attribute value retrieval failed error=1017
*** 2008-11-03 15:41:05.996 60679 kcrr.c
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
It may be necessary to define the DB_ALLOWED_LOGON_VERSION
initialization parameter to the value "10". Check the
manual for information on this initialization parameter.
------------------------------------------------------------
Error 16191 connecting to destination LOG_ARCHIVE_DEST_3 standby host 'db_logstdby'
Error 16191 attaching to destination LOG_ARCHIVE_DEST_3 standby host 'db_logstdby'
ORA-16191: Primary log shipping client not logged on standby
*** 2008-11-03 15:41:05.995 60679 kcrr.c
PING[ARC3]: Heartbeat failed to connect to standby 'db_logstdby'. Error is 16191.
*** 2008-11-03 15:41:05.995 58941 kcrr.c
kcrrfail: dest:3 err:16191 force:0 blast:1
Redo shipping client performing standby login
ORA-01017: invalid username/password; logon denied
OCI_DBVER attribute value retrieval failed error=1017
*** 2008-11-03 15:41:06.131 60679 kcrr.c
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
It may be necessary to define the DB_ALLOWED_LOGON_VERSION
initialization parameter to the value "10". Check the
manual for information on this initialization parameter.
------------------------------------------------------------
Error 16191 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'db_phystdby'
Error 16191 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'db_phystdby'
ORA-16191: Primary log shipping client not logged on standby
*** 2008-11-03 15:41:06.131 60679 kcrr.c
PING[ARC3]: Heartbeat failed to connect to standby 'db_phystdby'. Error is 16191.
*** 2008-11-03 15:41:06.131 58941 kcrr.c
kcrrfail: dest:2 err:16191 force:0 blast:1

按照其中的提示，确认密码文件建了，且密码相同，且设置了对应的初始化参数，可是怎么都不行，后来想是不是密码文件有一定的规则呢。果然。。。。
刚开始密码文件这么建立的，alert.log产生错误：
$ orapwd file=$ORACLE_HOME/dbs/pwd$ORACLE_SID.ora password=iamwangnc entries=5
后来把.ora后缀去掉了，错误仍在：
$ orapwd file=$ORACLE_HOME/dbs/pwd$ORACLE_SID password=iamwangnc entries=5
最后把前缀也修改了，终于可以传送日志了：
$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=iamwangnc entries=5

总结：所以unix/Linux环境中，密码文件一定是要用orapw， 没有例外。
      windows 环境中中用pwd.ora。所以说网络上的操作手册不能不分操作系统，拿过来就用，
      在windows下配置的dataguard和unix/Linux下配置的dataguard还是有些区别的。
      还是Oracle的官方文档最可靠！