Hi, I have installed oracle9i with my personal PC two years back and it was working until on yesterday. But today i tried to login its giving the below error "ORA-01033: ORACLE initialization or shutdown in progress" i don't what was happen ? yesterday i was working with the same login credentials. i saw the below error message in alert file in (E:\oracle\admin\psiva\bdump) ----------------------- ORA-1507 signalled during: alter database open ... Mon Mar 30 23:31:23 2009 alter database mount ORA-214 signalled during: alter database mount ... Mon Mar 30 23:31:31 2009 alter database open ORA-1507 signalled during: alter database open ---------------------------- Any one please help me on this.

check your services to confirm the expected Oracle services are running ( tnslistener, database ). What do you get when you try to connect with sqlplus ? sqlplus username/password ?

Thanks david, when i tried to connect the database using sqlplus. i got the below error ERROR: ORA-01033: ORACLE initialization or shutdown in progress Pls help me on this to resovle the problem

“The ORA-01033: ORACLE initialization or shutdown in progress” error happens when the database is not open. After you create the control file issue the command: “alter database open” That should stop the ORA-01033 error and make the database available for general use. The “ORA-01033: ORACLE initialization or shutdown in progress.” error can also happen when Oracle is attempting startup or shutdown and is "hanging" on a resource such as a failed disk, writing to redo, etc. See if the following example might help you. F:\oracle\ora92\bin>sqlplus/nolog SQL*Plus: Release 9.2.0.1.0 - Production on Sun Sep 9 19:37:13 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> connect / as sysdba Connected. ------------------------------------------------------------ SQL> shutdown ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 135338868 bytes Fixed Size 453492 bytes Variable Size 109051904 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes Database mounted.

Hi David, When i tried to connect the database in dba mode, its giving the below error username: scott PasswordLtiger Host string: SYSDBA Error: ORA-12154: TNS: could not resolve service name Pls help me on this to resolve the problem.

I did not say to connect to the host sysdba. Change this part to include auth info relevant to your environment sqlplus sys/PASSWORD@SID /nolog http://www.adp-gmbh.ch/ora/admin/co...