Re: Could only connect via SVRMGR

If you are running in archivelog mode check to see if your archive log destination is full.

Just a thot,
Ruth
it is more important to be human than to be important ----- Original Message -----
From: "Kimberly Smith" <kimberly.smith_at_gmd.fujitsu.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, January 10, 2001 12:05 PM Subject: 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-----
> 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
> Oracle DBA
> TRW, Marshall, IL
> 217-826-3011 x2438
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kimberly Smith
> INET: kimberly.smith_at_gmd.fujitsu.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jan 10 2001 - 11:59:38 CST