Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ORA-12641! Please Help

132 views
Skip to first unread message

ME...@comports.com

unread,
Apr 26, 1998, 3:00:00 AM4/26/98
to

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


Richard Woods

unread,
Apr 26, 1998, 3:00:00 AM4/26/98
to ME...@comports.com

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.

rwes...@us.oracle.com

unread,
Apr 28, 1998, 3:00:00 AM4/28/98
to

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
rwes...@us.oracle.com

ME...@ComPorts.com writes:

--
Rick
Rick Wessman
Distributed Data Security
Oracle Corporation
rwes...@us.oracle.com

ME...@comports.com

unread,
May 1, 1998, 3:00:00 AM5/1/98
to

On 28 Apr 1998 08:54:42 -0400, rwes...@us.oracle.com wrote:

Thanks for your reply, the problem is now solved.

0 new messages