连Oracle出现无监听程序

(1)检查OracleOraDb10g_home1TNSListener监听服务是否启动;OracleServiceTEST服务是否启动。(2)tnsping test，不通的话检查product/10.2.0/db_1/NETWORK/ADMIN目录下listener.ora与tnsnames.ora中test的host是否和机器的IP一致。例如：

LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.18)(PORT = 1521))      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))    )  )

TEST =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.18)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = test)    )  )(3)再次启动。