ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle11gr2之orapwd变化

Oracle11gr2之orapwd变化

原创 Linux操作系统 作者:redhouser 时间:2013-07-22 11:59:04 0 删除 编辑
 
1,Oracle10gr2,如果密码相同,则密码文件相同。
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
[oracle@bnet95 ~]$ cd $ORACLE_HOME/dbs
[oracle@bnet95 dbs]$ orapwd file=a password=oracle
[oracle@bnet95 dbs]$ orapwd file=b password=oracle
[oracle@bnet95 dbs]$ diff a b
[oracle@bnet95 dbs]$
[oracle@bnet95 dbs]$ strings a
]\[Z
ORACLE Remote Password file
INTERNAL
AB27B53EDC5FEF41
8A8F025737A9097A

2,Oracle11gr2,即使密码相同,则密码文件也不同。
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
[oracle@h11g dbs]$ orapwd file=a password=oracle
[oracle@h11g dbs]$ orapwd file=b password=oracle
[oracle@h11g dbs]$ diff a b
Binary files a and b differ
[oracle@h11g dbs]$ strings a
]\[Z
ORACLE Remote Password file
INTERNAL
AB27B53EDC5FEF41
8A8F025737A9097A
[oracle@h11g dbs]$ strings b
]\[Z
ORACLE Remote Password file
INTERNAL
AB27B53EDC5FEF41
8A8F025737A9097A
3,应用:
在搭建同主机dataguard时,备库使用orapwd创建的passwordfile,主库无法传送日志,报如下错误。使用复制主库密码文件方式,问题解决。
SQL>select error from v$archive_dest_status where error is not null;
ERROR
-----------------------------------------------------------------
ORA-16191: Primary log shipping client not logged on standby

[oracle@h11g dbs]$ oerr ora 16191
16191, 0000, "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.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/18922393/viewspace-766834/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-05-26

  • 博文量
    211
  • 访问量
    801696