RE: Urgent: Can connect internal but hangs when connecting as oth

Do you have audit enabled?
If yes stop all auditing.
Also check the alert file and bdump files.

Waleed

-----Original Message-----
From: Cherie_Machler_at_gelco.com [mailto:Cherie_Machler_at_gelco.com] Sent: Thursday, August 03, 2000 10:57 AM To: Multiple recipients of list ORACLE-L Subject: Urgent: Can connect internal but hangs when connecting as other

Listers,

Here's something I've never seen before:

I have a 7.3.4 database on Unix Solaris. I can connect internal from svrmgrl.
I can successfully query v$database table. However, I can not query dba_data_files or other dba_ views. I cannot connect
as system or any other login id other
than internal. My connect just hangs when I do that. Seems as if I'm out of
room on the system tablespace or something like that but I can't query anything to see.

How can I diagnose this problem. If I am out of space in the SYSTEM tablespace,
how can I fix the problem given
that I seem to have very few commands at my disposal.

Thanks for any quick replies,

Cherie

-- 
Author: 
  INET: Cherie_Machler_at_gelco.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).