ITPub博客

首页 > 数据库 > Oracle > 【故障处理】ORA-12162 错误的处理

【故障处理】ORA-12162 错误的处理

Oracle 作者:lhrbest 时间:2015-07-17 14:03:36 0 删除 编辑

【故障处理】ORA-12162: TNS:net service name is incorrectly specified

 

一.1  场景

今天拿到一个新的环境,可是执行sqlplus / as sysdba的时候不能登录,报ORA-12162: TNS:net service name is incorrectly specified的错误,之前没有碰到过,就随时记录下,备查。

 

一.2  实验还原

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>

 

 

 

 

一.3  总结

[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/

 

 

 

一.4  About Me

 

...........................................................................................................................................................................................

本文作者:小麦苗,只专注于数据库的技术,更注重技术的运用

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 于外汇交易中心

<版权所有,文章允许转载,但须以链接方式注明源地址,否则追究法律责任!>

...........................................................................................................................................................................................

 

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26736162/viewspace-1736192/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
QQ:646634621| 网名:小麦苗| 微信公众号:xiaomaimiaolhr| 11g OCM| QQ群:618766405 微信群:私聊| 《数据库笔试面试宝典》作者| OCP、OCM、高可用(RAC+DG+OGG)网络班开讲啦,有需要的小伙伴可以私聊我。

注册时间:2012-09-23

  • 博文量
    1353
  • 访问量
    8144011