oracle ora-12154问题总结,ORA-12154记一次细节错误

报错内容：

[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博客 ” ，链接：http://blog.itpub.net/28473562/viewspace-2107912/，如需转载，请注明出处，否则将追究法律责任。