Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> unable to log to a database

unable to log to a database

From: Vincent Boucheau <V.Boucheau_at_frcl.bull.fr>
Date: 1997/09/05
Message-ID: <340FB4A6.446B@frcl.bull.fr>#1/1

Inside a process, we can't log to a database.

If we relaunch the process from a restart point located just before the login step, the connection is OK and the treatment works fine.

During the dead-lock of the process, we can connect via sqlplus the same user to this database.

Unfortunately, I haven't been able to extract the part of the treatment which is the cause of this problem.

debugging of this process shows that sqlcex doesn't end:

#0 0xef3394f0 in _libc_wait ()
#1 0x1934bc in sntpreap ()
#2 <signal handler called>
#3 0xef3387e8 in _libc_read ()
#4 0x1907dc in ntpcon ()
#5 0x12f9bc in ntconn ()
#6 0x127704 in nsopen ()
#7 0x11c0a4 in nscall1 ()
#8 0x11b934 in nscall ()
#9 0x11871c in nricdt ()
#10 0x117e58 in nricall ()
#11 0xfe808 in osntns1 ()
#12 0x1c90b8 in osncon ()
#13 0x1aa9f8 in upiini ()
#14 0x1a7ca8 in upiahs ()
#15 0xea53c in sqllam ()
#16 0xea0cc in sqllo3 ()
#17 0xd6dfc in sqlcnt ()
#18 0xdcc6c in sqlexp ()
#19 0xe5c88 in sqlcex ()
#20 0xef792894 in sql_ora_login () at sql_ora_mon.c:413

Context:

         Oracle  7.2.3 or 7.3.2
         Solaris 2.5.1 ( It's OK on AIX)

Has anybody had a similar problem and solved it ?

Thank you for your help.

 Vincent.                                    V.Boucheau_at_frcl.bull.fr
=====================================================================
Received on Fri Sep 05 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US