Re: Urgent: Can connect internal but hangs when connecting as other

From: Ashish Shah <ar_shah_at_yahoo.com>
Date: Thu, 3 Aug 2000 08:33:07 -0700 (PDT)
Message-Id: <10578.113745@fatcity.com>

You can connect as system and query those views!!

sqlplus system/manager

• Cherie_Machler_at_gelco.com wrote:
  > 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).
  

  ---

Ashish
Toronto, Canada

---

Do You Yahoo!?
Kick off your party with Yahoo! Invites. Received on Thu Aug 03 2000 - 10:33:07 CDT