Oracle :Initialization Error.

Posted on 2009-02-14
Last Modified: 2013-11-16
had installed Oracle db on my personal computer and everything was working fine since last year or so. But for the past few days when I try to access the db(I use Toad), I am getting an error "ORA-01033 : Oracle initialization or shutdown in progress" .

Can someone help me on this please.
No code to attach.

Open in new window

Question by:KRISH_N
    LVL 9

    Accepted Solution

    sys / as sysdba
    shutdown abort
    LVL 23

    Assisted Solution

    To explain your error, the database is not mounted and open for users.  May I expand on the prior comment by asking you to:
    1.  Check your listener process:  From a command prompt (run cmd.exe) enter lsnrctl status and post the result.
    2.  You may optionally confirm that the windows service is running through the control panel | services.
    3.  If the shutdown abort works, follow up with "startup"; if that succeeds, do a clean shutdown "shutdown immediate" and then restart.
    4.  If you're still stuck, my preferred approach on a windows host is to do:  oradim -SID <sidname> -STARTUP
    LVL 11

    Expert Comment

    Initialization error can be caused by many events in the database. Therefore, there is no straight answer to your question. Experts here will assist you more effectively if you can paste the contents of database alert.log file. This file can be found under $ORACLE_HOME\admin\<instance_name>\bdump folder.

    Edit alert log file in wordpad and search for string "ora-". Paste error messages here and I or some other expert will take a look.

    Author Comment

    Sorry Crawfordits / DVZ. Followed the suggestion but no luck. When I tried to restart, though I see message stating database mounted,I still could not login to the DB.

    Here are some details of my PC:
    OS : Windows XP Version 2002, SP 2.
    DB Installed : Oracle 9i.

    Please see attached do with the steps that I did.

    LVL 11

    Assisted Solution

    oradim must be executed from the command line prompt not from sqlplus prompt

    Try again


    Author Closing Comment

    Thanks guys for helping me out.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
    Note: You must have administrative privileges in order to create/edit Roles. ( (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales and marke…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This video shows how to recover a database from a user managed backup

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now