Re: ORA-12641! Please Help

Looks like you've either installed ANO and not configured it properly or you've enabled it in your sqlnet.ora without having installed it.

MEYOU_at_ComPorts.com wrote:

> 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 - 19:31:04 CDT