error: ORA-03113 intermittently

From: David Maw <davidm_at_s-scape.ca>
Date: 1998/02/19
Message-ID: <34ECB2B7.270548F2@s-scape.ca>#1/1

We have written an application that queries Oracle 7.3.2 on Solaris.

Here is the intermittent problem: the app queries Oracle and I get a cursor back, however when I try to
retreive the first record from the cursor I get the Oracle error ORA-03113. I turned on the admin tracing for the tnslsnr on the server and got the following trace when the error occurs: (note: the hostname as "oranamesrvr0" , this is NOT the host I have specified in my tnsnames.ora file)

Any ideas why this would happen?

---

Getting local community information
Looking for local addresses setup by nrigla No addresses in the preferred address list TNSNAV.ORA is not present. No local communities entry. Getting local address information
Simple address...
No community component so just use straight address Resolving address to use to call destination or next hop Found destination address
Local address
Local destination community found
This is a local community access
Got routable address information
Making call with following address information: (DESCRIPTION=(CONNECT_DATA=(RPC=ON))(ADDRESS=(PROTOCOL=tcp)(HOST=oranamesrvr0)(PORT=1575)))

Calling with outgoing connect data
(DESCRIPTION=(CONNECT_DATA=(RPC=ON))(ADDRESS=(PROTOCOL=tcp)(HOST=oranamesrvr0)(PORT=1575)))

connecting...
(DESCRIPTION=(CONNECT_DATA=(RPC=ON))(ADDRESS=(PROTOCOL=tcp)(HOST=oranamesrvr0)(PORT=1575)))

port resolved to 1575
looking up IP addr for host: oranamesrvr0

-<FATAL?>- *** hostname lookup failure! ***

-<ERROR>- nsres: id=0, op=77, ns=12545, ns2=12560; nt[0]=515, nt[1]=0,
nt[2]=0
Call failed...
Exiting NRICALL with following termination result -1
-<ERROR>- open failure, error stack follows
TNS-12206: TNS:received a TNS error during navigation  TNS-12545: Connect failed because target host or object does not exist   TNS-12560: TNS:protocol adapter error
   TNS-00515: Connect failed because target host or object does not exist

     TNS-01169: The listener has not recognized the password

-<ERROR>- name server request failed, trying next server

---

--

Received on Thu Feb 19 1998 - 00:00:00 CST