数据库服务器采用Oracle 10g,Windows 2003系统.
应用程序运行在另外一台Oralce 8i 的数据库服务器上.应用程序通过insp连接字符串访问oracle 10g数据库服务器.
应用程序用Pro*C写的程序以用户clengzha/clengzha@insp访问Oracle 10g数据库.但是程序启动并且运行OK,但是有时应用程序就莫名奇妙的退出.
程序日志没有发现异常的地方.应用程序所在目录下有sqlnet.log如下:
***********************************************************************
Fatal NI connect error 12203, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=S:\Common\BIN\test_alm.exe)(HOST=ONLINE)(USER=Administrator))))VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.0.5.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - Production
Time: 12-NOV-07 11:07:51
Tracing not turned on.
Tns error struct:
nr err code: 12203
TNS-12203: TNS:unable to connect to destination
ns main err code: 12560
TNS-12560: TNSrotocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 0
nt OS err code: 0
***********************************************************************
Fatal NI connect error 12203, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=S:\Common\BIN\test_alm.exe)(HOST=ONLINE)(USER=Administrator))))VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.0.5.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - Production
Time: 12-NOV-07 11:07:52
Tracing not turned on.
Tns error struct:
nr err code: 12203
TNS-12203: TNS:unable to connect to destination
ns main err code: 12560
TNS-12560: TNSrotocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 0
nt OS err code: 0
***********************************************************************
Fatal NI connect error 12203, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=S:\Common\BIN\tmr010.exe)(HOST=ONLINE)(USER=Administrator))))VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.0.5.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - Production
Time: 12-NOV-07 11:07:54
Tracing not turned on.
Tns error struct:
nr err code: 12203
TNS-12203: TNS:unable to connect to destination
ns main err code: 12560
TNS-12560: TNSrotocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 0
nt OS err code: 0
***********************************************************************
Fatal NI connect error 12203, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=S:\Common\BIN\tmr010.exe)(HOST=ONLINE)(USER=Administrator))))VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.0.5.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - Production
Time: 12-NOV-07 11:07:54
Tracing not turned on.
Tns error struct:
nr err code: 12203
TNS-12203: TNS:unable to connect to destination
ns main err code: 12560
TNS-12560: TNSrotocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 0
nt OS err code: 0
***********************************************************************
Fatal NI connect error 12203, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=S:\Common\BIN\tmr010.exe)(HOST=ONLINE)(USER=Administrator))))VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.0.5.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - Production
Time: 12-NOV-07 11:07:54
Tracing not turned on.
Tns error struct:
nr err code: 12203
TNS-12203: TNS:unable to connect to destination
ns main err code: 12560
TNS-12560: TNSrotocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 0
nt OS err code: 0
******************************************************************************************************************************************************************************
tnsname.ora配置如下:
# D:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configuration File:\orant\net80\admin\tnsnames.ora
# Generated by Oracle Net8 AssistantINSP3.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=168.60.1.169)(PORT=1521))(CONNECT_DATA=(SID=insp)))CMEXAMPLE.WORLD=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=CM_SERVER)(PORT=1610))(ADDRESS=(PROTOCOL=TCP)(HOST=LSNR_SERVER)(PORT=1521)))(CONNECT_DATA=(SID=ORCL))(SOURCE_ROUTE=YES))TCPEXAMPLE.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Production1)(PORT=1521))(CONNECT_DATA=(SID=ORCL)))INSPT.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=online)(PORT=1521))(CONNECT_DATA=(SID=INSP)))NMPEXAMPLE.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SID=INSP)))EXTPROC_CONNECTION_DATA.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(Key=EXTPROC0))(CONNECT_DATA=(SID=extproc)))BEQ-LOCAL.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))'))(CONNECT_DATA=(SID=ORCL)))INSP.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.1.1.4)(PORT=1521))(CONNECT_DATA=(SID=JHY)))SPXEXAMPLE.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=SPX)(Service=Server_lsnr))(CONNECT_DATA=(SID=ORCL)))TCP-LOOPBACK.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SID=ORCL)))
请各位大侠帮帮忙.