Oracle 10g ORA-12154: TNS: could not resolve the connect identifier specified
我的電腦上之前安裝了Oracle 10g database,配置完變數用PL/SQL操作一切OK .當又安裝完Oracle 10g client後,問題出現了,用PL/SQL登陸時或者進行遠端連線時反覆提示:ORA-12154: TNS: could not resolve the connect identifier specified
對於初學者,我反覆的在"Oracle - OraDb10g_home3"下的"配置和移植工具"中的"Net Manager"中查詢問題所在.請教高手,也沒有召見問題的原因.我鬱悶了,隨後自己決定來搞定這個問題.
我做了大量的反覆的資料檢視和自我檢查,靈感在下班的時候出現,我突然意識到我的"環境變數"一直被忽視.
開啟後我發現我當前的環境變數這樣設定的:
path == G:\oracle\product\10.2.0\client_2\bin;G:\oracle\product\10.2.0\client_1;d:\app\Administrator\product\11.1.0
\client_1;d:\app\Administrator\product\11.1.0\client_1\bin;d:\oracle\product\10.2.0\db_1\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;D:\j2sdk\bin;C:\Program Files\Common Files\Thunder Network\KanKan\Codecs;
問題出現了.隨後我該成如下:
path == d:\oracle\product\10.2.0\db_1\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;D:\j2sdk\bin;C:\Program Files\Common Files\Thunder Network\KanKan\Codecs;G:\oracle;【去掉G:\oracle;也OK】
OK !!! 問題在最後的關頭被我解決了!!!不錯.
這就是: "不拋棄 不放棄"
tnsnames.ora配置 【根據個人情況而定,我的例項是wilson】
# tnsnames.ora Network Configuration File: G:\oracle\product\10.2.0\client_2\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
WILSON =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = [遠端IP地址])(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = wilson.msxq.com)
)
)
WILSON_192.168.232.100 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = [遠端IP地址])(PORT = 1521))
)
(CONNECT_DATA =
(SID = wilson)
(SERVICE_NAME = wilson.msxq.com)
)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25533574/viewspace-690122/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-12154: TNS:could not resolve the connect identifier specifiedIDE
- ORA-12154: TNS: could not resolve the connect identifier specifiedIDE
- 【DataGuard】 TNS:could not resolve the connect identifier specifiedIDE
- Oracle案例09——ORA-12154: TNS:could not resolve the connect identifier specifiedOracleIDE
- EF:Oracle.DataAccess.Client.OracleException: ORA-12154: TNS:could not resolve the connect identifier specifiedOracleclientExceptionIDE
- 關於ORA-12154: TNS:could not resolve the connect identifier specified的問題IDE
- ORA-12154: TNS:could not resolve service name / TNS-03505: Failed to resolve nameAI
- TNS-12518: TNS:listener could not hand off client connection For ORACLE 10G (AIX6.1)clientOracle 10gAI
- ora-12169 tns net service name given as connect identifier is too longIDE
- oracle 10g控制檯登入出現Io 異常:Unknown host specified 或ORA-12154 TNS無法解析指定的連線識別符號等Oracle 10g符號
- Oracle案例05——ORA-12162: TNS:net service name is incorrectly specifiedOracle
- [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
- How to use Form6i connect Oracle 10gORMOracle 10g
- 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
- oracle 11g登陸報錯'ORA-12162: TNS:net service name is incorrectly specified'Oracle
- 解決ORA-12154: TNS無法解析一例
- powerdesigner15連線oracle 10g 報Could not Initialize JavaVM!Oracle 10gJava
- Fatal NI connect error 12170 TNS-12535 TNS-00505Error
- Fatal NI connect error 12170 TNS-12535/TNS-00505 TNS:operation timed outError
- ORA-01788: CONNECT BY clause required in this query block For ORACLE 10GUIBloCOracle 10g
- 異常org.hibernate.QueryException: could not resolve property的原因Exception
- Fatal NI Connect Error 12170, 'TNS-12535: TNS:operation timed outError
- Connect oracle database error in sqlplus: ORA-12560: TNS: protocol adapter errorOracleDatabaseErrorSQLProtocolAPT
- 【故障處理】ORA-12162: TNS:net service name is incorrectly specified
- AndroidStudio升級報錯Unable to resolve dependency for ':app@debug/compileClasspath': Could not resolve cAndroidAPPCompile
- oracle database link 報錯ORA-12154: TNS: 無法解析指定的連線識別符號OracleDatabase符號
- yml:java.lang.IllegalArgumentException: Could not resolve placeholder ‘jdbc.driverClassName‘JavaExceptionJDBC
- 記一次解決:TNS-12518: TNS:listener could not hand off client connectionclient
- Oracle connect byOracle
- ORA-12154:TNS:無法解析指定的連線識別符號符號
- Oracle Custom Support Identifier(CSI)OracleIDE
- hadoop啟動時,報ssh: Could not resolve hostname xxx: NamHadoop
- Fatal NI connect error 12170 TNS-12535 TNS-00505 解決辦法Error
- ORA-12518: TNS:listener could not hand off client connectionclient