这几天在windows机器上测试了一下oracle11G的standby功能,测试时发现不能同步archive
log,日志中出现如下错误:
Alert文件中错误信息:
Errors in file
d:\oracle\diag\rdbms\db11g\db11g\trace\db11g_arc1_988.trc:
ORA-01031:
权限不足
PING[ARC1]: Heartbeat failed to connect to standby 'db11gstb'. Error is
1031.
Wed Sep 24 14:55:56 2008Thread 1
advanced to log sequence 23
Current log# 2 seq# 23 mem# 0:
D:\ORACLE\ORADATA\DB11G\REDO02.LOG
TRACE文件中的错误信息:
*** 2008-09-24
14:55:54.322
Redo shipping client performing standby login
OCISessionBegin
failed. Error -1
.. Detailed OCI error val is 1017 and errmsg is 'ORA-01017:
用户名/口令无效; 登录被拒绝
'
An attempt to establish secure session using password
verifier based approach will be attempted..
OCISessionBegin failed. Error
-1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031:
权限不足
'
An attempt to establish secure session using password verifier
based approach will be attempted..
OCISessionBegin failed -1
.. Detailed
OCI error val is 1031 and errmsg is 'ORA-01031: 权限不足
'
*** 2008-09-24
14:55:54.525 1095 krsh.c
Error 1031 received logging on to the
standby
Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host
'db11gstb'
Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby
host 'db11gstb'
ORA-01031: 权限不足
*** 2008-09-24 14:55:54.540 1095
krsh.c
PING[ARC1]: Heartbeat failed to connect to standby 'db11gstb'. Error
is 1031.
*** 2008-09-24 14:55:54.540 26884 kcrr.c
kcrrfail: dest:2
err:1031 force:0 blast:1
由于错误信息中提示说用户名密码错,由于我创建数据库时打开了oracle11G的密码敏感的选项,怀疑是这个问题引起的,于时把两边数据库的sec_case_sensitive_logon参数改成false,禁用大小写敏感,发现问题依旧,最后检查密码文件时,发现orapwd工具多了一个ignorecase的选项,重新建密码文件:
orapwd file=PWDdb11g.ora password=sys ignorecase=y
orapwd file=PWDdb11gstb.ora password=sys ignorecase
后问题解决。又试了试直接把主库的密码文件拷贝成standby库的密码文件,发现问题同样能解决,真是不知道这种手工用orapwd建的密码文件和拷贝的有什么不同。
这不知道是oracle11g的BUG还是我建standby数据库的方法不对。
阅读(2980) | 评论(1) | 转发(0) |