Home » RDBMS Server » Server Administration » oracle hangs (9.2.0.1,xp)
oracle hangs [message #295424] Tue, 22 January 2008 05:27 Go to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
I can not login as any of the users who have default tablespace "treas".The sqlprompt/TOAD just hangs.
I can login as sysdba.

I doubt that the tablespace has run out of space.
I tried to query free space as sysdba but it hanged.

The alert file shows no error message.

Re: oracle hangs [message #295435 is a reply to message #295424] Tue, 22 January 2008 05:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SQL*Plus and locally connect.
If it "hangs", trace the process.

Regards
Michel
Re: oracle hangs [message #295537 is a reply to message #295424] Tue, 22 January 2008 11:19 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
I am connecting locally.
WHat is the cause of this error?
How to trace a process?
I am sorry but i haven't touched the tuning part of oracle yet.
Re: oracle hangs [message #295538 is a reply to message #295537] Tue, 22 January 2008 11:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Pete Finnigan, How to set trace for others sessions, for your own session and at instance level

Regards
Michel
Re: oracle hangs [message #295544 is a reply to message #295424] Tue, 22 January 2008 12:04 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Following the link given, i can't see the required user "treas"
SELECT S.SID,
       S.SERIAL#,
       S.USERNAME,
       S.OSUSER
FROM   V$SESSION S,
       V$PROCESS P
WHERE  S.PADDR = P.ADDR

SQL> col sid for 999999
SQL> /

    SID    SERIAL# USERNAME                       OSUSER
------- ---------- ------------------------------ ------------------------------
      1          1                                SYSTEM
      2          1                                SYSTEM
      3          1                                SYSTEM
      4          1                                SYSTEM
      5          1                                SYSTEM
      6          1                                SYSTEM
      7          1                                SYSTEM
      8          1                                SYSTEM
      9        648 SYS                            SUPERCOMP\Administrator

9 rows selected.

Re: oracle hangs [message #295549 is a reply to message #295544] Tue, 22 January 2008 12:27 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i can't see the required user "treas"

Didn't you say it is the name of the tablespace?
Anyway, if it is not there then it is not connected and then you are not waiting for what you think.

Regards
Michel
Previous Topic: Database starts automatically
Next Topic: Question about Problems with DBCA
Goto Forum:
  


Current Time: Tue Dec 06 12:03:03 CST 2016

Total time taken to generate the page: 0.08388 seconds