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

ORA-16191:
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.




错误:
standby报的错误:
FAL[client, ARC3]: Error 16191 connecting to primary2 for fetching gap sequence
Errors in file /oracle/diag/rdbms/ztsta2/ztpri2/trace/ztpri2_arc3_24458.trc:
ORA-16191: Primary log shipping client not logged on standby
Errors in file /oracle/diag/rdbms/ztsta2/ztpri2/trace/ztpri2_arc3_24458.trc:
ORA-16191: Primary log shipping client not logged on standby




primary报的错误:
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
------------------------------------------------------------
Errors in file /oracle/diag/rdbms/ztpri2/ztpri2/trace/ztpri2_arc2_24844.trc:
ORA-16191: Primary log shipping client not logged on standby
PING[ARC2]: Heartbeat failed to connect to standby 'standby2'. Error is 16191.




解决方案:
其实日志和错误提示已经很明显了
1、the primary and standby are using a password file
2、 remote_login_passwordfile is set to SHARED or EXCLUSIVE
3、the SYS password is same in the password files




1、主库和备库的密码文件要一致,一般情况先是主库创建密码文件,然后把密码文件拷贝到备库,我遇到的问题集就是备库密码文件貌似过期了,然后从主库拷贝一份就好了
eg:orapwd file=$ORACLE_HOME/db_1/dbs/orapwSID password=****** force=y


2、看主库和备库的初始化参数:remote_login_passwordfile='EXCLUSIVE' 或 shared


3、主库的系统用户密码和密码文件的一样









  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值