运行->regedit->local_machine->system->currentcontrolset->services->
oracleorahome81tnslistener看有没有ImagePath这个变量,没有的话加上
值为"..\bin\tnslsnr.exe"就可以了
oracleorahome81tnslistener看有没有ImagePath这个变量,没有的话加上
值为"..\bin\tnslsnr.exe"就可以了
Cause: The SERVICE_NAME in the CONNECT_DATA was not found in the listener's tables.Action: Check to make sure that the SERVICE_NAME specified is correct.
# Generated by Oracle configuration tools.SAVE_CONFIG_ON_STOP_LISTENER1 = TRUELISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1923168.1.164)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.138)(PORT = 1521))
)
)
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = om)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = om)
(ORACLE_HOME = /home/oracle/product/9.2.0)
(SID_NAME = om)
)
)LISTENERa =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = om)(PORT = 1522))
)
)
)SID_LIST_LISTENERa =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = a)
(ORACLE_HOME = /home/oracle/product/9.2.0)
(SID_NAME = a)
)
)