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

心已赠人 2022-05-26 02:20 117阅读 0赞

转自：http://blog.itpub.net/29505646/viewspace-1463405/

启动oracle时，使用 sysdba或其他用户登录失败。报错如下：

![70][]

**原因：未指定SID**

解决：

[oracle@e1 ~]$ echo $ORACLE_SID
    
    
    [oracle@e1 ~]$ 
    [oracle@e1 ~]$ export ORACLE_SID=P1
    [oracle@e1 ~]$ echo $ORACLE_SID
    P1
    [oracle@e1 ~]$ sqlplus / as sysdba
    
    SQL*Plus: Release 11.2.0.3.0 Production on Fri Oct 24 14:28:13 2014
    
    Copyright (c) 1982, 2011, Oracle. All rights reserved.
    
    Connected to an idle instance.
    
    SYS@P1>startup 
    ORACLE instance started.
    
    Total System Global Area 920678400 bytes
    Fixed Size 1348720 bytes
    Variable Size 549456784 bytes
    Database Buffers 364904448 bytes
    Redo Buffers 4968448 bytes
    Database mounted.
    Database opened.

**补充**：数据库启动完成后，还需要启动监听程序：

SQL>exit;
    //查看监听
    [oracle@localhost ~]$ lsnrctl stat
    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 20-JUL-2018 10:41:56
    
    Copyright (c) 1991, 2009, Oracle.  All rights reserved.
    
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    TNS-12541: TNS:no listener
     TNS-12560: TNS:protocol adapter error
      TNS-00511: No listener
       Linux Error: 2: No such file or directory
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP).......
    
    //启动监听
    [oracle@localhost ~]$ lsnrctl start
    
    ....（省略）
    ....（省略）
    The command completed successfully

[70]: /images/20220526/9c8dbdef86e742d7bac22faee2b82694.png