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、主库的系统用户密码和密码文件的一样
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、主库的系统用户密码和密码文件的一样