iis security: I am running windows 2003 enterprise edition sp1 with IIS 6.0 and Oracle
client 9.2.0.1.0

When I run an application that connects to a web service located on this
machine I receive intermittent failures. CPU usage will spike to 100% and
the web service will not return control to the client program. I will then
have to kill w3wp.exe in task manager.

The following entry appeared in the System event log about 12 minutes before
the problem occurred. DRS is the application pool that the web service runs
in. However, the program accessed the web service successfully many times
after that event ID occurred.

Event ID 1011

A process serving application pool 'DRS' suffered a fatal communication
error with the World Wide Web Publishing Service. The process id was '3736'.
The data field contains the error number.


The log below was created from IISState.I am running windows 2003 enterprise
edition sp1 with IIS 6.0 and Oracle client 9.2.0.1.0

When I run an application that connects to a web service located on this
machine I receive intermittent failures. CPU usage will spike to 100% and
the web service will not return control to the client program. I will then
have to kill w3wp.exe in task manager.

The following entry appeared in the System event log about 12 minutes before
the problem occurred. DRS is the application pool that the web service runs
in. However, the program accessed the web service successfully many times
after that event ID occurred.

Event ID 1011

A process serving application pool 'DRS' suffered a fatal communication
error with the World Wide Web Publishing Service. The process id was '3736'.
The data field contains the error number.


The log below was created from IISState.
--------------------------------------------------------------------------------------------

Opened log file 'C:\iisstate\output\IISState-3544.log'

***********************
Starting new log output
IISState version 3.4

Thu Oct 20 13:14:16 2005

OS = Windows 2003 Server
Executable: w3wp.exe
PID = 3544

Note: Thread times are formatted as HH:MM:SS.ms

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


IIS has crashed...
Beginning Analysis
*** ERROR: Symbol file could not be found. Defaulted to export symbols for
C:\oracle\ora92\bin\orantcp9.dll -
DLL (!FunctionName) that failed: orantcp9!nttini




Thread ID: 21
System Thread ID: a44
Kernel Time: 0:0:1.890
User Time: 0:0:0.828
Thread Type: Managed Thread. Possible ASP.Net page or other .Net worker
succeeded
Loaded Son of Strike data table version 5 from
"C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\mscorwks.dll"
Thread 21
ESP EIP
01f8f000 619156c4 [FRAME: ECallMethodFrame] [DEFAULT] Boolean
System.Threading.WaitHandle.WaitOneNative(I,UI4,Boolean)
01f8f014 799e4bb1 [DEFAULT] [hasThis] Boolean
System.Threading.WaitHandle.WaitOne(I4,Boolean)
01f8f048 04552de3 [DEFAULT] [hasThis] Class System.Net.WebResponse
System.Net.HttpWebRequest.GetResponse()
01f8f070 04223e7d [DEFAULT] [hasThis] String
DRSInterface.configurationInformation.GetURLContents(String)
at [+0xf5] [+0x4f]
C:\Inetpub\wwwroot\apps\plnt\appl\DRS\getMQSeriesDocument\DRSInterface\configurationInformation.vb:453
PARAM: this: 0x023deb38 (DRSInterface.configurationInformation)
PARAM: unsigned int8 url: 0x2204c48
01f8f0b4 04221c54 [DEFAULT] [hasThis] Void
DRSInterface.configurationInformation..ctor(String,String)
at [+0xdc] [+0x73]
C:\Inetpub\wwwroot\apps\plnt\appl\DRS\getMQSeriesDocument\DRSInterface\configurationInformation.vb:79
PARAM: this: 0x023deb38 (DRSInterface.configurationInformation)
PARAM: class System.String caller: 0x02203d60 (System.String)
PARAM: unsigned int8 myenvironment: 0x2091228
01f8f4ac 04221a39 [DEFAULT] [hasThis] Void
DRSInterface.DRSInterface..ctor(String,String)
at [+0x239] [+0x10b]
C:\Inetpub\wwwroot\apps\plnt\appl\DRS\getMQSeriesDocument\DRSInterface\DRSInterface.vb:170
PARAM: this: 0x023de398 (DRSInterface.DRSInterface)
PARAM: class System.String caller: 0x02203d60 (System.String)
PARAM: unsigned int8 environment: 0x2091228
01f8f4dc 042217d2 [DEFAULT] [hasThis] Void WebSvr.document..ctor()
at [+0x32] [+0x8]
PARAM: this: 0x023de37c (WebSvr.document)
01f8f5ec 7923c069 [FRAME: GCFrame]
01f8f72c 7923c069 [FRAME: ECallMethodFrame] [DEFAULT] [hasThis] Object
System.RuntimeType.CreateInstanceImpl(Boolean)
01f8f73c 799b31bb [DEFAULT] Object System.Activator.CreateInstance(Class
System.Type,Boolean)
01f8f760 044eea34 [DEFAULT] [hasThis] Void
System.Web.Services.Protocols.ServerProtocol.CreateServerInstance()
01f8f768 044ee9db [DEFAULT] [hasThis] Void
System.Web.Services.Protocols.SoapServerProtocol.CreateServerInstance()
01f8f770 044ebe91 [DEFAULT] [hasThis] Void
System.Web.Services.Protocols.WebServiceHandler.Invoke()
01f8f7a8 044ebe12 [DEFAULT] [hasThis] Void
System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
01f8f7d0 044ebcb6 [DEFAULT] [hasThis] Void
System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(Class
System.Web.HttpContext)
01f8f7d4 044ebc9c [DEFAULT] [hasThis] Void
System.Web.HttpApplication/CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
01f8f7e4 04268738 [DEFAULT] [hasThis] Class System.Exception
System.Web.HttpApplication.ExecuteStep(Class IExecutionStep,ByRef Boolean)
01f8f82c 042681a2 [DEFAULT] [hasThis] Void
System.Web.HttpApplication.ResumeSteps(Class System.Exception)
01f8f874 0421a04a [DEFAULT] [hasThis] Class System.IAsyncResult
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(Class System.Web.HttpContext,Class System.AsyncCallback,Object)
01f8f890 01d29fe7 [DEFAULT] [hasThis] Void
System.Web.HttpRuntime.ProcessRequestInternal(Class
System.Web.HttpWorkerRequest)
01f8f8cc 01d29b98 [DEFAULT] Void
System.Web.HttpRuntime.ProcessRequest(Class System.Web.HttpWorkerRequest)
01f8f8d8 01d267b5 [DEFAULT] [hasThis] I4
System.Web.Hosting.ISAPIRuntime.ProcessRequest(I,I4)
01f8f9a0 79201e42 [FRAME: ContextTransitionFrame]
01f8fa80 79201e42 [FRAME: ComMethodFrame]


Begin System Thread Information

# ChildEBP RetAddr
WARNING: Stack unwind information not available. Following frames may be
wrong.
00 01f8eb28 71b296e3 orantcp9!nttini+0x46a4
01 01f8eb74 7c82ec2d mswsock!SockIoCompletion+0xcb
02 01f8ef04 7929a834 ntdll!KiUserApcDispatcher+0x25
03 01f8ef34 7929ad95 mscorwks!Thread::DoAppropriateWaitWorker+0xc1
04 01f8ef88 79339ff6 mscorwks!Thread::DoAppropriateWait+0x46
05 01f8efd0 01d057a0 mscorwks!WaitHandleNative::CorWaitOneNative+0x6f
06 01f8f03c 04552de3 0x1d057a0
07 01f8f068 04223e7d 0x4552de3
08 01f8f0ac 04221c54 0x4223e7d
09 01f8f4a0 04221a39 0x4221c54
0a 01f8f4d0 042217d2 0x4221a39
0b 01f8f4e8 7923c069 0x42217d2
0c 01f8f4f0 7923db49 mscorwks!CallDescrWorker+0x30

I found the discussion below on the metalink web site that solved my problem.

------------------------------------------------------------------------------------------------

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FOR&p_id=609785.993

Displayed below are the messages of the selected thread.
Thread Status: Active
From: Gianluigi Goglio 12-Oct-05 16:54
Subject: orantcp9.dll generating fault


orantcp9.dll generating fault


I am using a 91 client to query on a Oracle Db 9.2.0.6 from an ASP page, via
ADODB connection.
Microsoft environment hosting my web application is OS win2003/IIS 6.0

Sometimes IIS often hung or simply loses current session, so user need to
login again: in this case, the dump contains the phrase:
"orantcp9.dll from Oracle Corporation has caused an access violation
exception (0xC0000005) when trying to read from memory location 0x00000000 on
thread .."


Event viewer on Microsoft OS gives following message:
------
Source: W3SVC
Event ID: 1009
A process serving application pool 'DefaultAppPool' terminated unexpectedly.
The process id was '2476'. The process exit code was '0xc0000005'.
------

My email is gianluigi.goglio@nervianoms.com

Thanks in advance,
Gianluigi


From: Oracle, Saravanan Gurunathan 13-Oct-05 04:37
Subject: Re : orantcp9.dll generating fault

Hi,

What is the 5 digit version of Oracle CLient?
What is the 5 digit version of Oracle ODBC Driver?

Regards,
Saravanan, OSS


From: Gianluigi Goglio 13-Oct-05 09:26
Subject: Re : orantcp9.dll generating fault

Oracle Client is 9.2.0.1.0

I use ADODB.Connection via OLE DB Provider for Oracle (MSDAORA.DLL) version
is 2.80.1022.0

Thanks for your assistance
Gianluigi


From: Oracle, Saravanan Gurunathan 14-Oct-05 03:46
Subject: Re : orantcp9.dll generating fault

Hi,

Pleaes note that MSDAORA (Microsoft OLE DB Provider for Oracle) is a
microsoft product.

You can also upgrade Oracle Client to 9.2.0.6.0 which can be downloaded as
part of patch 3948480.

Regards,
Saravanan, OSS


From: Gianluigi Goglio 14-Oct-05 12:29
Subject: Re : Re : orantcp9.dll generating fault

Correct, MSDAORA is a microsoft product, but Oracle client is Oracle.

I indeed queried Microsoft support team:
They gave us reference to Oracle bug 2994441.
Following their suggestions our Oracle DBA has upgraded Oracle Names to from
8.1.6.x.x to 9.2.x.x.x and until now everything seems to work.



From: Oracle, Saravanan Gurunathan 17-Oct-05 03:11
Subject: Re : orantcp9.dll generating fault

Hi,

Do you mean that after upgrading Oracle Names to 9.2, it works fine?
Because Bug 2994441 has not been fixed as Oracle Names 8.1.6 has become
obsolete.

Regards,
Saravanan, OSS


From: Gianluigi Goglio 20-Oct-05 12:12
Subject: Re : orantcp9.dll generating fault

Yes,
it seems to work fine.
until now no more errores appeared.

GG