Re: ORA-12641! Please Help

It looks like the Advanced Networking Option authentication service is installed but can't initialize itself for some reason. Anyway, since you don't want to use ANO, what you need to do is add this line to sqlnet.ora:

sqlnet.authentication_services=(beq,none)

                                        Rick
                                        Rick Wessman
                                        Distributed Data Security
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com

MEYOU_at_ComPorts.com writes:

>
> 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
>

--

                                        Rick
                                        Rick Wessman
                                        Distributed Data Security
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com