Message-Id: <10737.126293@fatcity.com> From: "Michael Ray" Date: Wed, 10 Jan 2001 09:47:46 -0800 Subject: RE: Could only connect via SVRMGR --=_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@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"
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@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