合 ORA-12162: TNS:net service name is incorrectly specified

【故障处理】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 orapmon\

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 orapmon\

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

后续精彩内容已被站长无情隐藏，请输入验证码解锁本文！

验证码：

获取验证码： 请先关注本站微信公众号，然后回复“验证码”，获取验证码。在微信里搜索“AiDBA”或者“dbaup6”或者微信扫描右侧二维码都可以关注本站微信公众号。