ORA-12162：TNS:net service name is incorrectly specified错误

jiawang

今天使用oracle用户登录sqlplus出现“ORA-12162: TNS:net service name is incorrectly specified”。
[oracle@strong ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 18 15:08:19 2018
Copyright (c) 1982, 2013, 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


网上查询是没有设置ORACLE_SID环境变量原因。


验证ORACLE_SID环境变量(为空）
[oracle@strong ~]$ echo $ORACLE_SID



但是我明明在环境变量中设置了ORACLE_SID
[oracle@strong ~]$ ls -la
总用量 36
drwx------. 4 oracle dba  4096 6月  28 2017 .
drwxr-xr-x. 3 root   root 4096 6月  28 2017 ..
-rw-------. 1 oracle dba   919 10月 21 10:41 .bash_history
-rw-r--r--. 1 oracle dba    18 8月  29 2012 .bash_logout
-rw-r--r--. 1 oracle dba   441 6月  28 2017 .bash_profile
-rw-r--r--. 1 oracle dba   124 8月  29 2012 .bashrc
drwxr-xr-x. 2 oracle dba  4096 7月  14 2010 .gnome2
drwxr-xr-x. 4 oracle dba  4096 6月  28 2017 .mozilla
-rw-------. 1 oracle dba   649 6月  28 2017 .viminfo
[oracle@strong ~]$ cat ~./bash_profile
cat: ~./bash_profile: 没有那个文件或目录
[oracle@strong ~]$ cat ~/.bash_profile
# .bash_profile


# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
umask 022
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=YADATA
export ORACLE_UNQNAME=YADATA
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LOIBRARY_PATH=$ORACLE_HOME/lib:
export CVUQDISK_GRP=dba

export PATH
[oracle@strong ~]$
手动设置oralce_sid
[oracle@strong ~]$ export ORACLE_SID=YADATA   
[oracle@strong ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 18 15:18:13 2018
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>


验证数据库状态：
SQL> select status,instance_name from v$instance;  
STATUS       INSTANCE_NAME
------------ ----------------
OPEN         YADATA