溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
【故障處理】ORA-12162: TNS:net service name is incorrectly specified
今天拿到一個新的環境，可是執行sqlplus / as sysdba的時候不能登錄，報ORA-12162: TNS:net service name is incorrectly specified的錯誤，之前沒有碰到過，就隨時記錄下，備查。
Last unsuccessful login: Thu Mar 19 16:59:06 BEIST 2015 on /dev/pts/0 from 200.31.177.54
Last login: Thu Jul 16 22:44:20 BEIST 2015 on ftp from ::ffff:200.31.156.201
*******************************************************************************
* *
* *
* Welcome to AIX Version 5.3! *
* *
* *
* Please see the README file in /usr/lpp/bos for information pertinent to *
* this release of the AIX Operating System. *
* *
* *
*******************************************************************************
oracle@SJCk4:/home/oracle>
oracle@SJCk4:/home/oracle>
oracle@SJCk4:/home/oracle>ps -ef|grep ora_pmon_
oracle 348182 1 0 Apr 25 - 7:42 ora_pmon_DATAWDB
oracle 630842 1 0 Apr 25 - 20:02 ora_pmon_COGDB
oracle 843948 1 0 Apr 25 - 6:45 ora_pmon_ETLDB
oracle 5005418 4427974 0 09:44:03 pts/0 0:00 grep ora_pmon_
oracle@SJCk4:/home/oracle>ORACLE_SID=DATAWDB
oracle@SJCk4:/home/oracle>echo $ORACLE_SID
DATAWDB
oracle@SJCk4:/home/oracle>
oracle@SJCk4:/home/oracle>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 17 09:56:44 2015
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
oracle@SJCk4:/home/oracle>echo $ORACLE_HOME
/app/oracle/product/10.2.0/db_1
oracle@SJCk4:/home/oracle>echo $ORACLE_SID
DATAWDB
oracle@SJCk4:/home/oracle>
oracle@SJCk4:/home/oracle>
oracle@SJCk4:/home/oracle>
oracle@SJCk4:/home/oracle>
oracle@SJCk4:/home/oracle>export ORACLE_SID=DATAWDB
oracle@SJCk4:/home/oracle>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 17 09:59:27 2015
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL>
SQL>
[oracle@rhel6_lhr ~]$ oerr ora 12162
12162, 00000, "TNS:net service name is incorrectly specified"
// *Cause: The connect descriptor corresponding to the net service name in
// TNSNAMES.ORA or in the directory server (Oracle Internet Directory) is
// incorrectly specified.
// *Action: If using local naming make sure there are no syntax errors in
// the corresponding connect descriptor in the TNSNAMES.ORA file. If using
// directory naming check the information provided through the administration
// used for directory naming.
[oracle@rhel6_lhr ~]$
可以確定的是ORA-12162是由于ORACLE_SID未設置或者設置不正確導致的，推薦使用export ORACLE_SID=XXX來設置，當不能設置的時候再用ORACLE_SID=XXX來直接設置。
另外的一篇blog參考：http://blog.itpub.net/26736162/viewspace-1735917/
...........................................................................................................................................................................................
本文作者：小麥苗，只專注于數據庫的技術，更注重技術的運用
ITPUB BLOG：http://blog.itpub.net/26736162
本文地址：http://blog.itpub.net/26736162/viewspace-1736192/
本文pdf版：http://yunpan.cn/QCwUAI9bn7g7w 提取碼：af2d
QQ：642808185 若加QQ請注明你所正在讀的文章標題
創作時間地點：2015-07-17 10:00~ 2015-07-17 19:00 于×××交易中心
<版權所有，文章允許轉載，但須以鏈接方式注明源地址，否則追究法律責任!>
...........................................................................................................................................................................................
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
