Shutdown is not working
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Shutdown is not working

  1. #1
    Join Date
    Jan 2002
    Posts
    78
    Hi All,

    I tried to drop a tablespace which is Occupied 2 GB at one time. But as it is taking long time, I Killed that session Using DBA studio. It suddenly impacted on my system. My system is taking long time for small queries also. I could not able to open tablespaces related screen in DBA studio.

    At last, I tried to shutdown the instance using shutdown immediate option. And i waited nearly 3 hrs but I could not able to see any single message for this shutdown. Then I connected through another telnet connection and have given shutdown abort. Its worked and I can able to bring the instance up.

    But still i could not able to open the tablespace info related screens through DBA studio. And Still for small transactions it is taking long time. And still it is not allowing me to do the shutdown through immediate option. I checked the alert log. Its showing internal error problem.

    Now at any cost, I have to improve the performance. Please help me how can i achive this. I am working on oracle 8.1.6 version and OS is linux. The DB size is nearly 20 GB.

    Looking for your help

    Sekhar

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    What did the tablespace contain before you dropped?

  3. #3
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    What exact error you got in alert log...can you post here...
    do the following steps and post the results...
    1.select * from v$recover_file
    2.select distinct status from dba_data_files
    3.select that particular tablespace status..
    4.Is it sharing any partition tables...if so first drop those segments before dropping this tablespace.
    Did you offline that tablespace before dropping...(to ensure no users using that tablespace while dropping)..
    Thanks.
    Thanigaivasan.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width