TNS-01155: 在 LISTENER.ORA 中指定的 SID_LIST_LISTENER 参数不正确 NL-00303: NV 字符串中存在语法错误

Question

LSNRCTL> start启动tnslsnr: 请稍候...

TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
系统参数文件为D:\oracle\oracle_database\product\11.2.0\dbhome_1\network\admin\l
stener.ora
写入d:\oracle\oracle_database\diag\tnslsnr\john\listener\alert\log.xml的日志信息

监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=john)(PORT=1521)))
TNS-01155: 在 LISTENER.ORA 中指定的 SID_LIST_LISTENER 参数不正确
NL-00303: NV 字符串中存在语法错误

监听程序未能启动。请参阅上面的错误消息...

下面是我的Listener.ora文件
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\oracle\oracle_database\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\oracle_database\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)

(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\oracle\oracle_database\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = john)(PORT = 1521))
)
)

ADR_BASE_LISTENER = D:\oracle\oracle_database

Answer 1

（sid_desc= ..........） 字段要放到sid_list裏面。
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\oracle\oracle_database\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\oracle_database\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)

(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\oracle\oracle_database\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
)