LISTENER.ORA配置:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nttcom28)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_SP2))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/app/oracle/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(SERVICE_NAME = imttraf)
(ORACLE_HOME = /opt/oracle/app/oracle/product/9.2.0)
(SID_NAME = imttraf)
)
(SID_DESC =
(SID_NAME = EX301SP2)
(ORACLE_HOME = /opt/oracle/app/oracle/product/9.2.0)
(PROGRAM = extproc)
)
)
TNSNAMES.ORA配置:
NTTCOM29.IMTTRAF =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nttcom29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = imttraf)
)
)NTTCOM28.IMTTRAF =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nttcom28)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = imttraf)
)
)NTTD.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nttcom28)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = imttraf)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nttcom28)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)EXTPROC_SP2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_SP2))
)
(CONNECT_DATA =
(SID = EX301SP2)
(PRESENTATION = RO)
)
)LSNRCTL START执行以后表示服务EX301SP2已经启动,并且有一个HANDLER,但是在用TNSPING EXTPROC_SP2的时候却不通,报"TNS-03505:不能解析名字!"请问各位大下,如何解决啊?兄弟急等啊!
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nttcom28)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_SP2))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/app/oracle/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(SERVICE_NAME = imttraf)
(ORACLE_HOME = /opt/oracle/app/oracle/product/9.2.0)
(SID_NAME = imttraf)
)
(SID_DESC =
(SID_NAME = EX301SP2)
(ORACLE_HOME = /opt/oracle/app/oracle/product/9.2.0)
(PROGRAM = extproc)
)
)
TNSNAMES.ORA配置:
NTTCOM29.IMTTRAF =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nttcom29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = imttraf)
)
)NTTCOM28.IMTTRAF =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nttcom28)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = imttraf)
)
)NTTD.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nttcom28)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = imttraf)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nttcom28)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)EXTPROC_SP2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_SP2))
)
(CONNECT_DATA =
(SID = EX301SP2)
(PRESENTATION = RO)
)
)LSNRCTL START执行以后表示服务EX301SP2已经启动,并且有一个HANDLER,但是在用TNSPING EXTPROC_SP2的时候却不通,报"TNS-03505:不能解析名字!"请问各位大下,如何解决啊?兄弟急等啊!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货