ITPub博客

首页 > 数据库 > Oracle > dataguard ora-01017 ora-16191

dataguard ora-01017 ora-16191

原创 Oracle 作者:cccgw 时间:2008-05-27 11:30:12 0 删除 编辑

ORA-01017: invalid username/password; logon denied

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

[@more@]

PRIMARY

Errors in file /u01/oracle/admin/shtest/bdump/shtest_arc1_24494.trc:
ORA-01017: invalid username/password; logon denied
Mon May 26 19:16:08 2008
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
------------------------------------------------------------
Mon May 26 19:16:08 2008
Errors in file /u01/oracle/admin/shtest/bdump/shtest_arc1_24494.trc:
ORA-16191: Primary log shipping client not logged on standby
PING[ARC1]: Heartbeat failed to connect to standby 'SH_STANDBY'. Error is 16191.

STANDBY

Errors in file /u01/oracle/admin/shtest/bdump/shtest_mrp0_23193.trc:
ORA-01017: invalid username/password; logon denied
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
------------------------------------------------------------
FAL[client, MRP0]: Error 16191 connecting to SH_PRIMARY for fetching gap sequence
Mon May 26 19:15:27 2008
Errors in file /u01/oracle/admin/shtest/bdump/shtest_mrp0_23193.trc:
ORA-16191: Primary log shipping client not logged on standby
Mon May 26 19:15:28 2008
Completed: alter database recover managed standby database disconnect from session
解决办法:除了按提示检查外,密码文件不能带.ora后缀,改掉后正常了。

LINUX 不需要sqlnet.ora,密码文件不能带.ora的后缀。最好cp orapw 到orapwSID。

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

下一篇: rebuild index 排序
请登录后发表评论 登录
全部评论

注册时间:2012-08-27

  • 博文量
    82
  • 访问量
    1035049