文章详情

  • 游戏榜单
  • 软件榜单
关闭导航
热搜榜
热门下载
热门标签
php爱好者> php文档>物理DG的FAL_CLIENT设置错误引起的主库报错

物理DG的FAL_CLIENT设置错误引起的主库报错

时间:2010-11-09  来源:jasonwang328

今天生产库一直在报以下错误,查看trace文件后发现是physical standby的LOG_ARCHIVE_DEST_1有问题,可奇怪的是physical standby的LOG_ARCHIVE_DEST_1连的是本机
最后发现是FAL_SERVER、FAL_CLIENT设置有问题,在physical standby找不到fal_client为billdb2的tnsnames,把他改为racdg后正常(在tnsnames.ora中有racdg,指向本机)

生产库报错:
Sun Nov 7 11:28:56 2010
Errors in file /u01/app/admin/billdb/bdump/billdb2_arc3_2215.trc:
ORA-12154: TNS:could not resolve the connect identifier specified
FAL[server, ARC3]: Error 12154 creating remote archivelog file 'billdb2'
FAL[server, ARC3]: FAL archive failed, see trace file.


trace文件信息:
*** 2010-11-07 11:28:56.089
Redo shipping client performing standby login
OCIServerAttach failed -1
.. Detailed OCI error val is 12154 and errmsg is 'ORA-12154: TNS:could not resolve the connect identifier specified
'
*** 2010-11-07 11:28:56.090 60639 kcrr.c
Error 12154 received logging on to the standby
Error 12154 connecting to destination LOG_ARCHIVE_DEST_1 standby host 'billdb2'
kcrrwupirfs KCRROCIS Handle 0x0x7fbfffcbe0 has NULL OCI servicehandle - Returning success
Error 12154 attaching to destination LOG_ARCHIVE_DEST_1 standby host 'billdb2'
ORA-12154: TNS:could not resolve the connect identifier specified
*** 2010-11-07 11:28:56.090 58901 kcrr.c
kcrrfail: dest:1 err:12154 force:0 blast:1
kcrrwupirfs KCRROCIS Handle 0x0x7fbfffcbe0 has NULL OCI servicehandle - Returning success
kcrrwkx: unknown error:12154
ORA-16055: FAL request rejected
ARCH: Connecting to console port...
ARCH: Connecting to console port...
kcrrwkx: nothing to do (end)


physical standby的信息:
log_archive_dest_1 string LOCATION=/u02/archive/billdb/
VALID_FOR=(ONLINE_LOGFILES,ALL
_ROLES) DB_UNIQUE_NAME=racdg

fal_client string billdb2
fal_server string rac
物理DG的FAL_CLIENT设置错误引起的主库报错.
相关阅读 更多 +
排行榜 更多 +
云漫

云漫

生活实用 下载
证照签

证照签

生活实用 下载
云漫文学

云漫文学

生活实用 下载