lsnrctl>start test
启动snslsnr:请稍后...

tns_01151:在listener.ora 中缺少监听器名称test

我的listener.ora全文如下：

LISTENER.ORA Network Configuration File: E:\Oracle\Ora81\network\admin\listener.ora

Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)
(HOST = dajian2000)(PORT = 1521)
)
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = zhj)
(ORACLE_HOME = E:\Oracle\Ora81)
(SID_NAME = zhj)
)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = E:\Oracle\Ora81)
(SID_NAME = test)
)
)

---------------------------------------------------------------
答案是这样的：

是误删注册表，
在HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleOraHome81TNSListener
看看有没有ImagePath，如果没有的话加上并使其指向ORACLE_HOME\BIN\TNSLSNR