shutdown abort
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: shutdown abort

  1. #1
    Join Date
    Apr 2001
    Posts
    151

    Angry

    Hi

    prod db hung. I have to shutdown abort,
    but it won't shutdown and it has been 5 mins

    any suggestion
    Elin@trend

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Did you try issuing shutdown immediate. The shutdown abort has to be your last option. you have to wait for some time for oracle to close the transactions.

    Check your alert logs before you start the database to see what had caused the problem.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Apr 2001
    Posts
    151
    now i cant connect svrmgr30

    Elin@trend

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    ctrl C / ctrl D the process window that hangs and then try connecting to svrmgrl and try issueing the abort option.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Apr 2001
    Posts
    151
    Thanks Sam.

    What scared me was I did ctl-c to kill cmd prompt and started a new cmd prompt, then I lost all control of database. svrmgr no responds at all. I tried for 20 mins, then I take a risk to reboot server and this time DB is luck to back to normal. I am working with oracle tech support to see what happened to cause db became unaccessable at all.

    Elin@trend

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Did you check the alert log file. That would have logged the information on the cause. One of them could have been that you might have run out of sessions or the processes. That could be why your db looked like it had hung.

    Every thing would have been revealed in the alert log file for this db instance. Check your alert log and try to make the fix.

    If you need any help let us know. We would be happy to help and learn.


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  7. #7
    Join Date
    Apr 2001
    Posts
    151
    Hi Sam,

    thank you for your help.

    Mon May 07 10:50:59 2001
    Completed checkpoint up to RBA [0x32a0.2.10], SCN: 0x0000.01d340fc
    Mon May 07 11:08:13 2001
    Errors in file F:\Orant\rdbms80\trace\ORA04175.TRC:
    ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [], []

    Mon May 07 11:44:20 2001
    Shutting down instance (abort)
    License high water mark = 737
    Mon May 07 11:49:20 2001
    USER: terminating instance due to error 1092
    Mon May 07 11:49:20 2001
    USER: terminating instance due to error 1092
    Mon May 07 11:49:21 2001
    Errors in file F:\Orant\rdbms80\trace\ORA04175.TRC:
    ORA-01092: ORACLE instance terminated. Disconnection forced

    Mon May 07 11:49:21 2001
    USER: terminating instance due to error 1092
    Mon May 07 11:49:21 2001
    USER: terminating instance due to error 1092
    Mon May 07 11:49:21 2001
    USER: terminating instance due to error 1092
    Mon May 07 11:49:21 2001
    CKPT: terminating instance due to error 1092
    Mon May 07 11:49:21 2001
    LGWR: terminating instance due to error 1092
    Mon May 07 11:49:22 2001
    USER: terminating instance due to error 1092
    Mon May 07 11:49:22 2001
    USER: terminating instance due to error 1092
    Mon May 07 11:49:22 2001
    USER: terminating instance due to error 1092
    Mon May 07 11:49:22 2001
    PMON: terminating instance due to error 1092
    Mon May 07 11:49:23 2001
    USER: terminating instance due to error 1092
    Mon May 07 11:49:23 2001
    USER: terminating instance due to error 1092
    Mon May 07 11:49:23 2001
    DBW0: terminating instance due to error 1092
    Mon May 07 11:49:23 2001
    USER: terminating instance due to error 1092
    Mon May 07 11:49:24 2001
    USER: terminating instance due to error 1092
    Mon May 07 11:49:50 2001
    Instance terminated by PMON, pid = 383
    Dump file F:\Orant\rdbms80\trace\berpALRT.LOG


    I also noticed that before db hung, I issued the cmd
    "select ... from v$pwfile_users" and get error then it was about the same time my db hung..... Could this cause the problem?

    If you need to see .trc file, I will send it over to you.

    Thanks in advance.

    Elin@trend

  8. #8
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    The ORA-1092 was due to the abort that you had issued. The problem could have been very much due to the select on the password file.

    Wasn't there a thread earlier today, that discussed about the functionality problems on this select option?


    Here is that thread for your reference:
    http://dbasupport.com/forums/showthr...threadid=10301

    Check the trace file and it would give you some information on what caused exactly the problem, but it i sonly oracle who can analyze the trace dump F:\Orant\rdbms80\trace\ORA04175.TRC


    Sam

    [Edited by sambavan on 05-07-2001 at 05:36 PM]
    Thanx
    Sam



    Life is a journey, not a destination!


  9. #9
    Join Date
    Apr 2001
    Posts
    151
    Hi sam,

    it is funny, I asked the question "how to check who has sysdba privs" and I become a vicitim.........

    Elin@trend

  10. #10
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Make sure that you don't make the mistake again.


    Watch out in the future

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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