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

From: <Winnie_Liu_at_infonet.com>
Date: Thu, 3 Aug 2000 09:35:31 -0700
Message-Id: <10578.113753@fatcity.com>

It sounds to me that your database is only mounted but not open. If the database is in mount mode, you can query most of the V$ views but not the DBA_ views.

Winnie

Ashish Shah <ar_shah_at_yahoo.com> on 08/03/2000 09:56:29 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

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

      other

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. http://invites.yahoo.com/

--
Author: Ashish Shah
  INET: ar_shah_at_yahoo.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

Received on Thu Aug 03 2000 - 11:35:31 CDT