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

  • intser

    2015-03-17 20:48:50
  • Oracle
  • 原创

点击(此处)折叠或打开

  1. [oracle@e1 ~]$ sqlplus / as sysdba

  3. SQL*Plus: Release 11.2.0.3.0 Production on Fri Oct 24 14:25:44 2014

  5. Copyright (c) 1982, 2011, Oracle. All rights reserved.

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


  11. Enter user-name:
  12. ERROR:
  13. ORA-12162: TNS:net service name is incorrectly specified


  16. Enter user-name:
  17. ERROR:
  18. ORA-12162: TNS:net service name is incorrectly specified


  21. SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
  22. [oracle@e1 ~]$


这个错误是因为ORACLE_SID变量没有传进去造成的。
把ORACLE_SID变量赋值，登录数据库。

点击(此处)折叠或打开

  1. [oracle@e1 ~]$ echo $ORACLE_SID


    [oracle@e1 ~]$ 
    [    oracle@e1 ~]$ export ORACLE_SID=P1
  2. [oracle@e1 ~]$ echo $ORACLE_SID
  3. P1
  4. [oracle@e1 ~]$ sqlplus / as sysdba

  6. SQL*Plus: Release 11.2.0.3.0 Production on Fri Oct 24 14:28:13 2014

  8. Copyright (c) 1982, 2011, Oracle. All rights reserved.

  10. Connected to an idle instance.

  12. SYS@P1>startup
  13. ORACLE instance started.

  15. Total System Global Area 920678400 bytes
  16. Fixed Size 1348720 bytes
  17. Variable Size 549456784 bytes
  18. Database Buffers 364904448 bytes
  19. Redo Buffers 4968448 bytes
  20. Database mounted.
  21. Database opened.
  22. SYS@P1>


请使用浏览器的分享功能分享到微信等