系统集成Oraclerac同步

Oracle 11g rac Error 1017 received logging on to the standby

双机RAC系统:Solaris 10版本:Oracle 11.2.0.1.0检查Oracle 日志发现大量报错,报错如下Tue Dec 12 21:31:34 2017Error 1017 received logging on to the standbyCheck that the primary and standby are using a password fileand remote_login_passwordfile is set to SHAR...显示全部

双机RAC
系统:Solaris 10
版本:Oracle 11.2.0.1.0

检查Oracle 日志发现大量报错,报错如下

Tue Dec 12 21:31:34 2017

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

两个节点归档日志信息

节点1

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /arca
Oldest online log sequence 52157
Next log sequence to archive 52159
Current log sequence 52159
SQL>

节点2

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /arcb
Oldest online log sequence 43991
Next log sequence to archive 43993
Current log sequence 43993
SQL>

求助

收起
参与10

返回renou2012的回答

renou2012renou2012  数据库管理员 , KE

报错信息已经提示,密码文件问题,建议拷贝主库的密码文件到备库,需要保证主备库的sys密码文件一致。
密码文件目录为$ORACLE_HOME/dbs/orapw+SID

金融其它 · 2017-12-13
浏览3475
王磊磊 邀答

回答者

renou2012
数据库管理员KE

renou2012 最近回答过的问题

回答状态

  • 发布时间:2017-12-13
  • 关注会员:2 人
  • 回答浏览:3475
  • X社区推广