Hi all,
I have error ORA-12641 when connecting to a database in a Pro*C
program.
Can anyone tell me what's happening, below is the trace messages.
Trace1.trc
- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is "/oracle/7.3.3/network/trace/Trace1.trc"
New trace level is 4
- TRACE CONFIGURATION INFORMATION ENDS ---
- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source
/oracle/7.3.3/network/admin/sqlnet.ora
Parameter source loaded successfully
-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
TRACE_LEVEL_SERVER = USER
AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = OFF
TRACE_FILE_SERVER = TEMPTRACE
SQLNET.EXPIRE_TIME = 0
--- PARAMETER SOURCE INFORMATION ENDS ---
- LOG CONFIGURATION INFORMATION FOLLOWS ---
Log stream will be "/oracle/7.3.3/network/log/sqlnet.log
"
Log stream validation not requested
- LOG CONFIGURATION INFORMATION ENDS ---
Unable to get data from navigation file tnsnav.ora
Not enabling dead connection detection.
No process parameters set
connecting...
doing connect handshake...
ADR="(ADDRESS=(PROTOCOL=tcp)(DEV=15)(HOST=192.168.2.2)(PORT=1521))"
bufl=256
(ADDRESS=(PROTOCOL=tcp)(DEV=15)(HOST=192.168.2.2)(PORT=1521))
port resolved to 1521
using host IP address: 192.168.2.2
opening transport...
Validnode Table IN use; err 0x0
transport is open
hoff=0
handshake is complete
(ADDRESS=(PROTOCOL=tcp)(DEV=15)(HOST=192.168.2.2)(PORT=1521))
port resolved to 1521
using host IP address: 192.168.2.2
inheriting the connection...
opening transport...
Validnode Table IN use; err 0x0
getting sockname
getting peername
transport is open
global context check-in (to slot 0) complete
doing connect handshake...
sending NSPTRS packet
doing connect handshake...
got NSPTCN packet
connection inherited
connected
sending NSPTAC packet
connect handshake is complete
nsctxinf[0]=0x1, [1]=0x1
asking transport to enable NTOBROKEN
154 bytes from NS buffer
-<ERROR>- failed
-<FATAL?>- failed with error 12641
-<FATAL?>- failed with error 12641
-<FATAL?>- failed with error 12641
-<FATAL?>- failed with error 12641
-<FATAL?>- failed with error 12641
-<FATAL?>- failed with error 12641
125 bytes to NS buffer
-<FATAL?>- failed with error 12641
-<FATAL?>- failed with error 12641
-<ERROR>- nsres: id=0, op=73, ns=12641, ns2=0; nt[0]=0, nt[1]=0,
nt[2]=0
-<ERROR>- error from osntns: nsaccept failed...
-<ERROR>- nr err code: 0
-<ERROR>- ns main err code: 12641
-<ERROR>- ns (2) err code: 0
-<ERROR>- nt main err code: 0
-<ERROR>- nt (2) err code: 0
-<ERROR>- nt OS err code: 0
No broken-connection function available.
-<ERROR>- Couldn't connect, returning 12641
- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is "/oracle/7.3.3/network/trace/trace2.trc"
New trace level is 4
- TRACE CONFIGURATION INFORMATION ENDS ---
- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source
/oracle/7.3.3/network/admin/sqlnet.ora
Parameter source loaded successfully
-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
TRACE_LEVEL_SERVER = USER
AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = OFF
TRACE_FILE_SERVER = TEMPTRACE
SQLNET.EXPIRE_TIME = 0
--- PARAMETER SOURCE INFORMATION ENDS ---
- LOG CONFIGURATION INFORMATION FOLLOWS ---
Log stream will be "/oracle/7.3.3/network/log/sqlnet.log
"
Log stream validation not requested
- LOG CONFIGURATION INFORMATION ENDS ---
Unable to get data from navigation file tnsnav.ora
Not enabling dead connection detection.
Dead connection detection being turned off.
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
No process parameters set
inheriting the connection...
opening transport...
transport is open
global context check-in (to slot 0) complete
doing connect handshake...
got NSPTCN packet
recving connect data
243 bytes from NS buffer
connection inherited
connected
sending NSPTAC packet
connect handshake is complete
nsctxinf[0]=0x1, [1]=0x1
NTOBROKEN not supported by transport
166 bytes from NS buffer
129 bytes to NS buffer
No broken-connection function available.
-<ERROR>- nsres: id=0, op=76, ns=12534, ns2=12560; nt[0]=504, nt[1]=0,
nt[2]=0
no timer allocated
closing transport
global context check-out (from slot 0) complete
Received on Sun Apr 26 1998 - 03:46:16 CDT