Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    Join Date
    Jan 2004
    Location
    karachi
    Posts
    13

    Question Unanswered: ERROR: ORA-01033: ORACLE initialization or shutdown in progress

    Hi,
    I have install Oracle 9i initialy it works fine but after some days it displays this Idiot msg.

    ORA-01033: ORACLE initialization or shutdown in progress

    I have win2k with SP3, I have installed three time this stuppid software but this problem occurs every time, starting every service (in control panel->Administrative-> services )
    after waiting a long time I am unable to log on. I am runing simple commands/statements and do not amend any thing in database.

    PLZ help me, I am begginer so plz give me answer in a simple way, and quickly b/c tommorow my OCP class is due.
    Thanks in advance
    ske

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: ERROR: ORA-01033: ORACLE initialization or shutdown in progress

    Originally posted by century2001us
    Hi,
    I have install Oracle 9i initialy it works fine but after some days it displays this Idiot msg.

    ORA-01033: ORACLE initialization or shutdown in progress

    I have win2k with SP3, I have installed three time this stuppid software but this problem occurs every time, starting every service (in control panel->Administrative-> services )
    after waiting a long time I am unable to log on. I am runing simple commands/statements and do not amend any thing in database.

    PLZ help me, I am begginer so plz give me answer in a simple way, and quickly b/c tommorow my OCP class is due.
    Thanks in advance
    Check the alert log...

  3. #3
    Join Date
    Jan 2004
    Location
    karachi
    Posts
    13

    Lightbulb logged Problem

    Hi,
    Where can I find ALERT LOG, I have found this

    E:\oracle\admin\orcl2\bdump\orcl2ALRT.LOG

    " Not sure but log file display this problem"

    E:\oracle\admin\orcl2\bdump\orcl2ALRT.LOG

    Tue Feb 10 12:41:35 2004
    alter database open
    ORA-1113 signalled during: alter database open...
    Shutting down instance (abort)
    License high water mark = 1
    Instance terminated by USER, pid = 2096
    Dump file E:\oracle\admin\orcl2\bdump\orcl2ALRT.LOG
    Last edited by century2001us; 02-10-04 at 05:10.
    ske

  4. #4
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: logged Problem

    Originally posted by century2001us
    Hi,
    Where can I find ALERT LOG, I have found this

    E:\oracle\admin\orcl2\bdump\orcl2ALRT.LOG

    " Not sure but log file display this problem"

    E:\oracle\admin\orcl2\bdump\orcl2ALRT.LOG

    Tue Feb 10 12:41:35 2004
    alter database open
    ORA-1113 signalled during: alter database open...
    Shutting down instance (abort)
    License high water mark = 1
    Instance terminated by USER, pid = 2096
    Dump file E:\oracle\admin\orcl2\bdump\orcl2ALRT.LOG
    ok, try to do following:
    open sqlplus an logon "/ as sysdba"
    then try execute shutdown abort.
    Next try start database step by step:
    startup nomount
    alter database mount
    alter database open

    If there will be some errors let me know...

    P.S. when you start the instance execute the "show parameters background_dump_dest" and you'll see the path where is alertlog located.

  5. #5
    Join Date
    Jan 2004
    Location
    karachi
    Posts
    13

    Question your replied answer -Thanks

    SQL> show parameters background_dump_dest

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    background_dump_dest string E:\oracle\admin\orcl2\bdump


    Exucuted command no & o/p are listed here.


    1- SQL> shutdown abort
    O/P- ORACLE instance shut down.



    2- SQL> start database step by step
    O/P- SP2-0310: unable to open file "database.sql"



    3- SQL> startup nomount
    ORACLE instance started.

    Total System Global Area 118255568 bytes
    Fixed Size 282576 bytes
    Variable Size 83886080 bytes
    Database Buffers 33554432 bytes
    Redo Buffers 532480 bytes


    4- SQL> alter database mount;

    Database altered.



    5- SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: 'D:\ORACLE\ORADATA\ORCL2\SYSTEM01.DBF'
    ske

  6. #6
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: your replied answer -Thanks

    Originally posted by century2001us
    SQL> show parameters background_dump_dest

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    background_dump_dest string E:\oracle\admin\orcl2\bdump


    Exucuted command no & o/p are listed here.


    1- SQL> shutdown abort
    O/P- ORACLE instance shut down.



    2- SQL> start database step by step
    O/P- SP2-0310: unable to open file "database.sql"



    3- SQL> startup nomount
    ORACLE instance started.

    Total System Global Area 118255568 bytes
    Fixed Size 282576 bytes
    Variable Size 83886080 bytes
    Database Buffers 33554432 bytes
    Redo Buffers 532480 bytes


    4- SQL> alter database mount;

    Database altered.



    5- SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: 'D:\ORACLE\ORADATA\ORCL2\SYSTEM01.DBF'

    "start database step by step" - this is not a command its only phrase

    Following error "ERROR at line 1:
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: 'D:\ORACLE\ORADATA\ORCL2\SYSTEM01.DBF'" says the datafile need recovery because of unclean shutdown or media failure etc.
    Is your DB in ARCHIVELOG mode or not?
    If not do you have backup of DB?

  7. #7
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: your replied answer -Thanks

    Originally posted by ika
    "start database step by step" - this is not a command its only phrase

    Following error "ERROR at line 1:
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: 'D:\ORACLE\ORADATA\ORCL2\SYSTEM01.DBF'" says the datafile need recovery because of unclean shutdown or media failure etc.
    Is your DB in ARCHIVELOG mode or not?
    If not do you have backup of DB?
    Here is link to backup, restore and recovery related documentation http://download-west.oracle.com/docs...a96519/toc.htm
    Last edited by ika; 02-10-04 at 19:29.

  8. #8
    Join Date
    Jan 2004
    Location
    karachi
    Posts
    13

    Talking Thanks for your cooperation ika

    Hi,
    I am very thankful to you for your help and sharp response, now my problem is solved by by visiting your given web address.
    Thanks again.
    Khawar

    Following is the commands which I have used to restore media

    RMAN Restore and Recovery

    The basic RMAN recovery commands are RESTORE and RECOVER. Use RESTORE to restore datafiles from backup sets or from image copies on disk, either to their current location or to a new location. You can also restore backup sets containing archived redo logs. Use the RMAN RECOVER command to perform media recovery and apply archived logs or incremental backups.

    RMAN automates the procedure for recovering and restoring your backups and copies. For example, run the following commands from within RMAN to restore and recover the database to its current time:
    SHUTDOWN IMMEDIATE; # shuts down database
    STARTUP MOUNT; # starts and mounts database
    RESTORE DATABASE; # restores all datafiles
    RECOVER DATABASE; # recovers database using all available redo
    ALTER DATABASE OPEN; # reopens the database
    ske

  9. #9
    Join Date
    Jun 2009
    Posts
    2

    Red face ORA 01033 initialization or shutdown in progress

    Hi all,
    I was using Oracle 10g, when I was operating in the sqlclient the power was down suddenly. When I start the system again and try to login to the sqlclient, I got this error ORA 01033 initialization or shutdown in progress.
    I restarted the system few times but the same problem. Please anyone help me...
    Thank you in advance

    Regards,
    Vijay Reddy

  10. #10
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    open command window while logged onto OS as owner of Oracle software

    CUT lines below

    sqlplus
    / as sysdba
    shutdown abort
    startup
    SELECT * FROM V$VERSION;
    EXIT

    PASTE into Command Window

    CUT & PASTE commands & results back here
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  11. #11
    Join Date
    Jun 2009
    Posts
    2
    I am sorry I didn't get you... Where should I paste them. Is it the command line of windows? If so how should I enter... One by one in order or at a time.?

  12. #12
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Post Operating System (OS) name & version for DB server system.
    Post Oracle version to 4 decimal place of database s/w.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  13. #13
    Join Date
    Jun 2009
    Posts
    1
    I have the same problem
    here is my result

    SQL> shutdown abort
    ORACLE instance shut down.
    SQL> startup
    ORACLE instance started.

    Total System Global Area 612368384 bytes
    Fixed Size 1250428 bytes
    Variable Size 234883972 bytes
    Database Buffers 369098752 bytes
    Redo Buffers 7135232 bytes
    Database mounted.
    ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],
    [], [], []


    SQL> SELECT * FROM V$VERSION;

    BANNER
    ----------------------------------------------------------------
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
    PL/SQL Release 10.2.0.1.0 - Production
    CORE 10.2.0.1.0 Production
    TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
    NLSRTL Version 10.2.0.1.0 - Production

    SQL> EXIT
    Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
    oduction
    With the Partitioning, OLAP and Data Mining options

    Anybody can help?

  14. #14
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Anybody can help?
    Submit a Service Request with Oracle Tech. Support. They can assist with debugging ORA-00600
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  15. #15
    Join Date
    Jan 2010
    Posts
    1
    Hello all,

    This is my version of story,


    SQL> shutdown abort;
    ORACLE instance shut down.
    SQL> startup nomount
    ORACLE instance started.

    Total System Global Area 612368384 bytes
    Fixed Size 1250452 bytes
    Variable Size 192940908 bytes
    Database Buffers 415236096 bytes
    Redo Buffers 2940928 bytes
    SQL> alter database mount;

    Database altered.

    SQL> alter database open
    2 ;
    alter database open
    *
    ERROR at line 1:
    ORA-01172: recovery of thread 1 stuck at block 73 of file 2
    ORA-01151: use media recovery to recover block, restore backup if needed

    SQL> startup
    ORACLE instance started.

    Total System Global Area 612368384 bytes
    Fixed Size 1250452 bytes
    Variable Size 192940908 bytes
    Database Buffers 415236096 bytes
    Redo Buffers 2940928 bytes
    Database mounted.
    ORA-01172: recovery of thread 1 stuck at block 73 of file 2
    ORA-01151: use media recovery to recover block, restore backup if needed


    SQL> SELECT * FROM V$VERSION;

    BANNER
    ----------------------------------------------------------------
    Oracle Database 10g Release 10.2.0.1.0 - Production
    PL/SQL Release 10.2.0.1.0 - Production
    CORE 10.2.0.1.0 Production
    TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
    NLSRTL Version 10.2.0.1.0 - Production


    ....................

    The log file last few lines..

    alter database dismount
    Completed: alter database dismount
    ARCH: Archival disabled due to shutdown: 1089
    Shutting down archive processes
    Archiving is disabled
    Archive process shutdown avoided: 0 active
    ARCH: Archival disabled due to shutdown: 1089
    Shutting down archive processes
    Archiving is disabled
    Archive process shutdown avoided: 0 active


    .............

    And the recovery option


    SQL> recover datafile 2;
    ORA-00283: recovery session canceled due to errors
    ORA-00600: internal error code, arguments: [3020], [2], [73], [1], [102],
    [62974], [16], []
    ORA-10567: Redo is inconsistent with data block (file# 2, block# 73)
    ORA-10564: tablespace UNDOTBS1
    ORA-01110: data file 2: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.D BF'
    ORA-10560: block type 'KTU SMU HEADER BLOCK'

Posting Permissions

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