Fatal NI connect error 12537的解决

症状描述:

listener在oracle未启动前,status,start,stop 正常;EM正常。 oracle启动后,status,start,stop超慢(近5分钟每个命令);EM几乎无法使用(速度超慢)

解决:

注释掉 /etc/resolve.conf 配置文件中对 DNS 的解析

 

 

alter.log里报大量的错误

 

***********************************************************************

Fatal NI connect error 12537, connecting to:
 (LOCAL=NO)

  VERSION INFORMATION:
        TNS for Linux: Version 11.2.0.1.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
  Time: 17-5ÔÂ -2011 10:58:35
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12537

TNS-12537: TNS:connection closed
    ns secondary err code: 12560
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
opiodr aborting process unknown ospid (5608) as a result of ORA-609
Tue May 17 10:58:55 2011


***********************************************************************

Fatal NI connect error 12537, connecting to:
 (LOCAL=NO)

  VERSION INFORMATION:
        TNS for Linux: Version 11.2.0.1.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
  Time: 17-5ÔÂ -2011 10:58:55
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12537

TNS-12537: TNS:connection closed
    ns secondary err code: 12560
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
opiodr aborting process unknown ospid (5606) as a result of ORA-609
Tue May 17 10:59:15 2011


***********************************************************************

阅读更多

数据库连接不稳定,出错Fatal NI connect error 12203

11-12

数据库服务器采用Oracle 10g,Windows 2003系统.rn应用程序运行在另外一台Oralce 8i 的数据库服务器上.应用程序通过insp连接字符串访问oracle 10g数据库服务器.rn应用程序用Pro*C写的程序以用户clengzha/clengzha@insp访问Oracle 10g数据库.但是程序启动并且运行OK,但是有时应用程序就莫名奇妙的退出.rn程序日志没有发现异常的地方.应用程序所在目录下有sqlnet.log如下:rn***********************************************************************rnFatal NI connect error 12203, connecting to:rn(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))))rnrnVERSION INFORMATION:rnTNS for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnOracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnTime: 12-NOV-07 11:07:51rnTracing not turned on.rnTns error struct:rnnr err code: 12203rnTNS-12203: TNS:unable to connect to destinationrnns main err code: 12560rnTNS-12560: TNSrotocol adapter errorrnns secondary err code: 0rnnt main err code: 530rnTNS-00530: Protocol adapter errorrnnt secondary err code: 0rnnt OS err code: 0rnrnrn***********************************************************************rnFatal NI connect error 12203, connecting to:rn(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))))rnrnVERSION INFORMATION:rnTNS for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnOracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnTime: 12-NOV-07 11:07:52rnTracing not turned on.rnTns error struct:rnnr err code: 12203rnTNS-12203: TNS:unable to connect to destinationrnns main err code: 12560rnTNS-12560: TNSrotocol adapter errorrnns secondary err code: 0rnnt main err code: 530rnTNS-00530: Protocol adapter errorrnnt secondary err code: 0rnnt OS err code: 0rnrnrn***********************************************************************rnFatal NI connect error 12203, connecting to:rn(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))))rnrnVERSION INFORMATION:rnTNS for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnOracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnTime: 12-NOV-07 11:07:54rnTracing not turned on.rnTns error struct:rnnr err code: 12203rnTNS-12203: TNS:unable to connect to destinationrnns main err code: 12560rnTNS-12560: TNSrotocol adapter errorrnns secondary err code: 0rnnt main err code: 530rnTNS-00530: Protocol adapter errorrnnt secondary err code: 0rnnt OS err code: 0rnrnrn***********************************************************************rnFatal NI connect error 12203, connecting to:rn(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))))rnrnVERSION INFORMATION:rnTNS for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnOracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnTime: 12-NOV-07 11:07:54rnTracing not turned on.rnTns error struct:rnnr err code: 12203rnTNS-12203: TNS:unable to connect to destinationrnns main err code: 12560rnTNS-12560: TNSrotocol adapter errorrnns secondary err code: 0rnnt main err code: 530rnTNS-00530: Protocol adapter errorrnnt secondary err code: 0rnnt OS err code: 0rnrnrn***********************************************************************rnFatal NI connect error 12203, connecting to:rn(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))))rnrnVERSION INFORMATION:rnTNS for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnOracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnTime: 12-NOV-07 11:07:54rnTracing not turned on.rnTns error struct:rnnr err code: 12203rnTNS-12203: TNS:unable to connect to destinationrnns main err code: 12560rnTNS-12560: TNSrotocol adapter errorrnns secondary err code: 0rnnt main err code: 530rnTNS-00530: Protocol adapter errorrnnt secondary err code: 0rnnt OS err code: 0rnrnrn******************************************************************************************************************************************************************************rntnsname.ora配置如下:rn# D:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configuration File:\orant\net80\admin\tnsnames.orarn# Generated by Oracle Net8 AssistantrnrnINSP3.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=168.60.1.169)(PORT=1521))(CONNECT_DATA=(SID=insp)))rnrnCMEXAMPLE.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))rnrnTCPEXAMPLE.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Production1)(PORT=1521))(CONNECT_DATA=(SID=ORCL)))rnrnINSPT.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=online)(PORT=1521))(CONNECT_DATA=(SID=INSP)))rnrnNMPEXAMPLE.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SID=INSP)))rnrnEXTPROC_CONNECTION_DATA.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(Key=EXTPROC0))(CONNECT_DATA=(SID=extproc)))rnrnBEQ-LOCAL.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))'))(CONNECT_DATA=(SID=ORCL)))rnrnINSP.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.1.1.4)(PORT=1521))(CONNECT_DATA=(SID=JHY)))rnrnSPXEXAMPLE.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=SPX)(Service=Server_lsnr))(CONNECT_DATA=(SID=ORCL)))rnrnTCP-LOOPBACK.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SID=ORCL)))rnrnrn请各位大侠帮帮忙.rnrn

没有更多推荐了,返回首页