【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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ORA-12154: TNS:could not resolve the connect identifier specifiedIDE
- ORA-12154: TNS: could not resolve the connect identifier specifiedIDE
- Oracle案例09——ORA-12154: TNS:could not resolve the connect identifier specifiedOracleIDE
- Oracle 10g ORA-12154: TNS: could not resolve the connect identifier specifiedOracle 10gIDE
- 關於ORA-12154: TNS:could not resolve the connect identifier specified的問題IDE
- EF：Oracle.DataAccess.Client.OracleException: ORA-12154: TNS:could not resolve the connect identifier specifiedOracleclientExceptionIDE
- ORA-12154: TNS:could not resolve service name / TNS-03505: Failed to resolve nameAI
- ora-12169 tns net service name given as connect identifier is too longIDE
- ubuntu : xcb:could not connect to display.Ubuntu
- [Nagios] Error: Template timman specified in contact definition could not beiOSError
- TNS-12518: TNS:listener could not hand off client connectionclient
- TNS-12518 TNS listener could not hand off client connectionclient
- psql: error: could not connect to server: No such file or directorySQLErrorServer
- Could not resolve host: 'localhost 報錯解決辦法localhost
- Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedded datasource couldAI
- Fatal NI connect error 12170 TNS-12535 TNS-00505Error
- Fatal NI connect error 12170 TNS-12535/TNS-00505 TNS:operation timed outError
- Fatal NI Connect Error 12170, 'TNS-12535: TNS:operation timed outError
- Oracle案例05——ORA-12162: TNS:net service name is incorrectly specifiedOracle
- 【故障處理】ORA-12162: TNS:net service name is incorrectly specified
- 異常org.hibernate.QueryException: could not resolve property的原因Exception
- AndroidStudio升級報錯Unable to resolve dependency for ':app@debug/compileClasspath': Could not resolve cAndroidAPPCompile
- 記一次解決：TNS-12518: TNS:listener could not hand off client connectionclient
- yml：java.lang.IllegalArgumentException: Could not resolve placeholder ‘jdbc.driverClassName‘JavaExceptionJDBC
- TNS-12518: TNS:listener could not hand off client connection For ORACLE 10G （AIX6.1)clientOracle 10gAI
- Fatal NI connect error 12170 TNS-12535 TNS-00505 解決辦法Error
- hadoop啟動時，報ssh: Could not resolve hostname xxx: NamHadoop
- ORA-12518: TNS:listener could not hand off client connectionclient
- ORA-12518, TNS:listener could not hand off client connectionclient
- ORA - 12502 TNS:listener received no CONNECT_DATA from clientclient
- Could not resolve placeholder 'redis.pool.maxTotal' in string value "${redis.pool.maxTotal}"Redis
- Centos7中Could not resolve host: mirrorlist.centos.org; 未知的錯誤"CentOS
- 記錄:yum Could not resolve host: mirrors.cloud.aliyuncs.com； Unknown error解決CloudError
- Could not resolve com.android.support.constraint:constraint-layout:1.1.3AndroidAI
- 執行flutter run命令報錯：:ERROR: Could not connect to lockdownd, error code -17FlutterError
- Could Not Save Service Alias: TNS-04415 : File I/O Error [ID 798206.1]Error
- lua 中連結 Redis 使用域名報錯 failed to connect: no resolver defined to resolveRedisAI
- oracle 11g登陸報錯'ORA-12162: TNS:net service name is incorrectly specified'Oracle