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

现象:
root@dbserver/# su - oracle
$ sqlplus / as sysdba


SQL*Plus: Release 10.2.0.4.0 - Production on Thu Apr 24 10:26:14 2014


Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


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




Enter user-name: ^C

$ sqlplus /nolog


SQL*Plus: Release 10.2.0.4.0 - Production on Thu Apr 24 10:26:25 2014


Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


SQL> conn / as sysdba
ERROR:
ORA-12162: TNS:net service name is incorrectly specified




SQL> 


原因:
因为没有声明ORACLE_SID导致的,声明之后就没问题了。


解决方案:


$ export ORACLE_SID=ORCL
$ sqlplus / as sysdba


SQL*Plus: Release 10.2.0.4.0 - Production on Thu Apr 24 10:28:57 2014


Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.




Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> 

11-09 16:43
查看更多