Re: ORA-12641! Please Help

On 28 Apr 1998 08:54:42 -0400, rwessman_at_us.oracle.com wrote:

Thanks for your reply, the problem is now solved.

>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
Received on Fri May 01 1998 - 08:03:08 CDT