ORA-12154錯誤分析
ORA-12154: TNS:could not resolve service name
First open the tnsnames.ora file and check the settings
eg-
CHECK1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =CHECK2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = CHECK3)
)
)
IN THE ABOVE GIVEN SCRIPT
CHECK1---> Data Source Name u r Connecting from the front end
CHECK2---> Server name to which u r connecting
CHECK3---> Service name/SID of the Data base u r connecting
* - c:> ping CHECK2 (Host ip or name)
if you cannot ping that means the client server network problem. Else
* - c:> telnet CHECK2:1521
if you cannot connect to port ,network problem . Else
* - c:> TNSPING CHECK1
if still the same error
check SQLNET.ORA
Commect other settings and keep only following line and TNSPING.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
If not NTS change to NONE and TNSPING.
If Still not working check whether a Spyware running on your PC.
Run spyware detection tool.
- Do you have multiple Oracle installations on your machines like Oracle client and Developer ?
If so you'll have to set up the tnsnames.ora on both HOMES.
Or else setup the registry.
Add string value TNS_ADMIN to HKEY_LOCAL_MACHINESOFTWAREORACLE
Set the values of TNS_ADMIN to the folder where the tnsnames.ora you set up resides.
Eg. C:oracleora92admin
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/166555/viewspace-783893/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [20180428]DNS與ORA-12154錯誤.txtDNS
- net 日誌分析錯誤
- web拼圖錯誤分析Web
- ORA-25138錯誤分析
- ORA-12154 和 TNS-03505 監聽錯誤的解決方法
- java.exe出錯錯誤分析 (轉)Java
- timesten11218 ORA-12154錯誤解決一例
- ORA-00600錯誤分析
- ORA-04021錯誤分析
- ORA-07445錯誤分析
- ORA-00942錯誤分析
- ORA-04031錯誤分析
- 通過錯誤堆疊資訊和原始碼分析錯誤來源原始碼
- [java基礎]之基本錯誤分析Java
- GoldenGate 常見錯誤分析(二)Go
- 產品需求分析中常見錯誤?
- ORA-27100錯誤分析
- ORA-01950錯誤分析
- ORA-03113錯誤分析
- ORA-12571錯誤分析
- ORA-01691錯誤分析
- ORA-31600錯誤分析
- ORA-00205錯誤分析
- ORA-00920錯誤分析
- ORA-27123錯誤分析
- ORA-01555錯誤分析
- ORA-01589錯誤分析
- ORA-12560錯誤分析
- ORA-00265錯誤分析
- Ora-03113 錯誤分析
- IIS 錯誤程式碼分析手冊
- ORA-03113錯誤分析(轉)
- Laravel Excpetions(錯誤處理) 原始碼分析Laravel原始碼
- ORA-04031錯誤分析和解決
- 一個ORA-604錯誤的分析
- Oracle ORA-07445 [0000000000000000] 錯誤分析Oracle
- ORA-01090錯誤分析
- ORA-00312錯誤分析