【DataGuard】 TNS:could not resolve the connect identifier specified

  Duplicate From Active Database Errors : Ora-17627: Ora-12154: Tns:Could Not Resolve The C [ID 1144273.1]

ORA-17629: Cannot connect to the remote database server

ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified

ORA-17629: Cannot connect to the remote database server

这里的错误主要有中间的 

ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified 确定！！

原因：

In the tnsnames.ora of the machine where is the source database, there are 2 services created to connect to auxiliary database that have the same "service name" but different configuration.

解决方法：

1. To be sure that the tnsnames.ora file of each machine (machine where is the source database and machine where is the auxiliary database) has the service name to connect to auxiliary database.

2. Verify that there are not duplicate service_name with different configuration in the tnsnames.ora file.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22664653/viewspace-707061/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22664653/viewspace-707061/