Oracle常见错误——TNS-01150

# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2/network/admin/listener.ora
# Generated by Oracle configuration tools.
ORA92 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.26)(PORT = 1521)
)
      )
    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ora92)
      (ORACLE_HOME = /opt/oracle/product/9.2)
    )
  )
LOGGING_LISTENER = OFF

 

我补充整理一下，listener.ora里创建的每个listener对应2个部分，分别是：

NAME=

和

SID_LIST_NAME=

     两个部分名称name必须一致，LZ估计是手工修改了名称。