Oracle DataGuard FAL[client, ARC2]: Error 16191 connecting to 问题处理过程记录
1. 问题描述
Oracle DataGuard日志传输失败，日志信息如下所示，
|
1 2 3 4 5 6 7 8 9 |
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, ARC2]: Error 16191 connecting to epmsn for fetching gap sequence SQL> select * from v$archive_gap; --日志存在gap |
2. 问题分析
日志中显示的非常清晰，该问题主要由以下原因造成，
检查数据库参数remote_login_passwordfile，值为SHARED or EXCLUSIVE(默认);
SYS密码是否与password file一致，即是否最近改过sys密码,没有同步password file;
dg 源和目标端password file是否同步;
11g默认密码大小写敏感，生成密码文件时是否添加参数ignorecase。
目标端password file格式： orapw+sid。
3. 恢复过程
3.1 修改源端sys密码
|
1 2 3 |
SQL> alter user sys identified by Star_1234; User altered. SQL> |
3.2 生成源端password file
|
1 2 3 |
mv orapwepmsn bak_orapwepmsn ---备份源密码文件 orapwd file=orapwepmsn password=Star_1234 ignorecase=y ---重新生成密码文件 scp orapwepmsn oracle@hsql:$ORACLE_HOME/dbs/ --传输密码文件到dg目标端 |
4. 重新开启adg
|
1 2 3 |
alter database recover managed standby database cancel; alter database open; alter database recover managed standby database using current logfile disconnect; |
分类: 技术