多谢大家!!!!
各位,下面是我的LISTENER.ORA# LISTENER.ORA Network Configuration File: E:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_INDBS5 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\Oracle\Ora81)
(PROGRAM = extproc)
)
)INDBS5 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 3.245.99.41 )(PORT = 1523))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)
下面是tnsnames.ora# TNSNAMES.ORA Network Configuration File: E:\Oracle\Ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.INDBS5 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 3.245.99.41)(PORT = 1523))
)
(CONNECT_DATA =
(SERVICE_NAME = INDBS5)
)
)下面是出错信息:Connecting...ORA-12541: TNS:no listener
The test did not succeed.Some of the information you provided may be incorrect.
Press Back to review the information provided for net service name, or Change Login to change username.
各位,下面是我的LISTENER.ORA# LISTENER.ORA Network Configuration File: E:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_INDBS5 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\Oracle\Ora81)
(PROGRAM = extproc)
)
)INDBS5 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 3.245.99.41 )(PORT = 1523))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)
下面是tnsnames.ora# TNSNAMES.ORA Network Configuration File: E:\Oracle\Ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.INDBS5 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 3.245.99.41)(PORT = 1523))
)
(CONNECT_DATA =
(SERVICE_NAME = INDBS5)
)
)下面是出错信息:Connecting...ORA-12541: TNS:no listener
The test did not succeed.Some of the information you provided may be incorrect.
Press Back to review the information provided for net service name, or Change Login to change username.
我还以为就是这样的,是不是某一个版本的oracle 有这些问题
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\Oracle\Ora81)
(PROGRAM = E:\oracle\ORA81\BIN\extproc)
)
)
还是存在别的什么问题,该程序有一些命令,你试试,如:status,如果说listener没起来,你用start试试,再看具体的错是什么
当然,原则上你用什么port(除了Oracle保留的)不影响listener的正常运行
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = INDBS5 )
(ORACLE_HOME = e:\oracle\ora81)
(SID_NAME = INDBS5 )
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 3.245.99.41 )(PORT = 1523))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)