We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Oracle :Initialization Error.

Medium Priority
471 Views
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

Comment
Watch Question

sqlplus
sys / as sysdba
shutdown abort

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
David VanZandtSr Software Engineer
CERTIFIED EXPERT
Commented:
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
 
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

Commented:
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.

Activity-Details.txt
oradim must be executed from the command line prompt not from sqlplus prompt

Try again

Author

Commented:
Thanks guys for helping me out.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.