RE: Could only connect via SVRMGR

From: Michael Ray <Michael.Ray_at_trw.com>
Date: Wed, 10 Jan 2001 09:47:46 -0800
Message-Id: <10737.126293@fatcity.com>

--=_7C2717D0.B4D5B8D1

Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

No errors anywhere to be found. Listener log showed a connection being = made.

Michael Ray
Oracle DBA
TRW, Marshall, IL
217-826-3011 x2438

>>> kimberly.smith_at_gmd.fujitsu.com 01/10/01 11:05AM >>> Where there any errors in the alert log? Its always the first place I look. Check where you actually put the alert log but there is a bug in Oracle that causes ORA-600 errors to also be logged in $ORACLE_HOME/rdbms/log. Sometimes they only occur in there. This is in quite a few versions of Oracle, that one included.

-----Original Message-----
Sent: Wednesday, January 10, 2001 8:15 AM To: Multiple recipients of list ORACLE-L

Had fun this morning where our most critical plant database would not = allow
new connections, but those already in were running just fine. I had a similar issue a couple months ago where moving the tnsnames file into the BIN directory solved the problem (I still don't know why!), but that = wasn't
the case this time.

I could tnsping the db but SQLPlus would hang from my desk. From the = server,
I could connect internal via svrmgr, but SQLPlus would still just hang = using
sys. I ended up crossing my fingers and bouncing the db, which worked = thank
goodness.

NT4 running 7.3.4 (I know, I know).

Any ideas?

Michael Ray

--=_7C2717D0.B4D5B8D1
Content-Type: text/plain
Content-Disposition: attachment; filename="TEXT.htm"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2919.6307" name=GENERATOR></HEAD>
<BODY style="FONT: 8pt MS Sans Serif; MARGIN-LEFT: 2px; MARGIN-TOP: 2px">
<DIV>No errors anywhere to be found. Listener log showed a connection being
made.</DIV>
<DIV> </DIV>
<DIV>Michael Ray Oracle DBA TRW, Marshall, IL 217-826-3011
x2438 >>> kimberly.smith_at_gmd.fujitsu.com 01/10/01 11:05AM >>> Where there any errors in the alert log?  Its always the first place I look.  Check where you actually put the alert log but there is a bug in Oracle that causes ORA-600 errors to also be logged in $ORACLE_HOME/rdbms/log.  Sometimes they only occur in there.  This is in quite a few versions of Oracle, that one included. -----Original Message----- Sent: Wednesday, January 10, 2001 8:15 AM To: Multiple recipients of list ORACLE-L Had fun this morning where our most critical plant database would not allow new connections, but those already in were running just fine. I had a similar issue a couple months ago where moving the tnsnames file into the BIN directory solved the problem (I still

don't know why!), but that wasn't<BR>the case this time.<BR><BR>I could tnsping 
the db but SQLPlus would hang from my desk. From the server,<BR>I could connect 
internal via svrmgr, but SQLPlus would still just hang using<BR>sys. I ended up

crossing my fingers and bouncing the db, which worked thank goodness. NT4 running 7.3.4 (I know, I know). Any Received on Wed Jan 10 2001 - 11:47:46 CST