RE: Could only connect via SVRMGR

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-----
From: Michael Ray [mailto:Michael.Ray_at_trw.com] Sent: Wednesday, January 10, 2001 8:15 AM To: Multiple recipients of list ORACLE-L Subject: Could only connect via SVRMGR

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
Oracle DBA
TRW, Marshall, IL Received on Wed Jan 10 2001 - 11:06:22 CST