报错内容：
[oracle@standby ~]$ rman target sys/oracle@standby auxiliary sys/oracle@orcl
Recovery Manager: Release 11.2.0.3.0 - Production on Fri May 27 11:59:45 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: SINGLE (DBID=3883461843)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-12154: TNS:could not resolve the connect identifier specified
问题描述：
使用RMAN连接目标端的辅助库时报ORA-12154: TNS:could not resolve the connect identifier specified，像这种错误一般也就是TNS没有配置正确，或者tns名称打错导致，今天我遇到的这个问题比较奇葩，因为只是关注与TNS配置是否正确，没有去看tnsname.ora这个文件本身内容格式是否正确,本次的原因很简单：
[oracle@standby ~]$ more /u01/app/oracle/product/11.2.0/dbhome_2/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome
_2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
standby =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.101)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = standby)
)
)
p
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.102)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
解决方法:
把多余的P去掉就好了，唉，还是要细心
[oracle@standby ~]$ rman target sys/oracle@standby auxiliary sys/oracle@orcl
Recovery Manager: Release 11.2.0.3.0 - Production on Fri May 27 11:59:45 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: SINGLE (DBID=3883461843)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-12154: TNS:could not resolve the connect identifier specified
问题描述：
使用RMAN连接目标端的辅助库时报ORA-12154: TNS:could not resolve the connect identifier specified，像这种错误一般也就是TNS没有配置正确，或者tns名称打错导致，今天我遇到的这个问题比较奇葩，因为只是关注与TNS配置是否正确，没有去看tnsname.ora这个文件本身内容格式是否正确,本次的原因很简单：
[oracle@standby ~]$ more /u01/app/oracle/product/11.2.0/dbhome_2/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome
_2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
standby =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.101)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = standby)
)
)
p
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.102)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
解决方法:
把多余的P去掉就好了，唉，还是要细心
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28473562/viewspace-2107912/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
