ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 【DataGuard】 TNS:could not resolve the connect identifier specified

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

原创 Linux操作系统 作者:杨奇龙 时间:2011-09-09 22:49:38 0 删除 编辑
 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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
MySQL DBA NoSQL DEVOPS

注册时间:2009-10-07

  • 博文量
    1026
  • 访问量
    7700028