1 2 Previous Next 25 Replies Latest reply on Aug 27, 2013 12:27 PM by Nicolas.Gasparotto

ORACLE Initialization or shutdown in progress

407048 Nov 7, 2005 8:27 AM

I run an Oracle 10g database on windows 2000 OS.

I have never had problems before starting the database and using it.

Today, as usual, I started the database by going into Services and starting the OracleServiceORCL . Strange enough it gave me the STARTED status a little faster than it usually does. But when I tried to log in into SQL * PLUS, I am getting

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

I am just not able to log into my database. I tried to stop and start oracle but no luck yet. The service says that oracle is started. I also see Oracle.exe running in my Task Manager

Any ideas ?

Thanks

1. Re: ORACLE Initialization or shutdown in progress

99427 Nov 7, 2005 11:34 AM (in response to 407048)

It may be the case, the database did not stop correctly.
Try out following.
Open Dos command Prompt
c:> sqlplus /nolog
sql> connect sys/manager as sysdba
sql>shutdown immediate
sql> startup
sql> exit
While startup it may show error message like some of the parameter is missing. Note down that parameter and update in initSID.ora file.

Nikhil
Like Show 2 Likes(2)

Actions
2. Re: ORACLE Initialization or shutdown in progress

460544 Nov 7, 2005 12:51 PM (in response to 407048)

Please check the alert file and post the message in alert file.
Like Show 0 Likes(0)

Actions
3. Re: ORACLE Initialization or shutdown in progress

407048 Nov 7, 2005 3:11 PM (in response to 460544)

SQL> connect sys/manager as sysdba
Connected.
SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145750508 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: 'C:\ORADATA\PRODUCT_DAT1.DBF'

I now realized what happened and how this happened. It's all my fault. During a clean-up effort this file was accidentally deleted. I have no backups too.
I am willing to lose the data in this datafile. Is there something I can do so that the startup does not try to open this file ?
All I am able to do now is to mount the database but not open it.

Thanks
Like Show 0 Likes(0)

Actions
4. Re: ORACLE Initialization or shutdown in progress

464041 Nov 7, 2005 4:02 PM (in response to 407048)

Hi

Mount the database and drop the datafile using
alter database datafile '<<file_name>>' offline drop;

and then open the database

alter database open;

Regards
Like Show 0 Likes(0)

Actions
5. Re: ORACLE Initialization or shutdown in progress

407048 Nov 7, 2005 4:15 PM (in response to 464041)

Thanks..I am in now.
Like Show 0 Likes(0)

Actions
6. Re: ORACLE Initialization or shutdown in progress

318789 Nov 7, 2005 4:26 PM (in response to 407048)

Hi,

Check the tablespaces that was created on that dropped file.
You still need to to "drop tablespace <name> including contents;" after the "alter database open"

Regards.
Like Show 0 Likes(0)

Actions
7. Re: ORACLE Initialization or shutdown in progress

505462 Jan 22, 2007 8:00 AM (in response to 407048)

Hi, as stated that the data file is locked, is it possible to unlock the file?
Like Show 0 Likes(0)

Actions
8. Re: ORACLE Initialization or shutdown in progress

Mohammed Taj Jan 22, 2007 8:04 AM (in response to 505462)

Hi,

Can you post complete error ?

regards
Taj
Like Show 0 Likes(0)

Actions
9. Re: ORACLE Initialization or shutdown in progress

Nicolas.Gasparotto Jan 22, 2007 8:38 AM (in response to 505462)

Have you seen that the thread was more than one years old.
Please create your own thread with a little bit more explanation about your problem.

Nicolas.
Like Show 0 Likes(0)

Actions
10. Re: ORACLE Initialization or shutdown in progress

Mohammed Taj Jan 22, 2007 8:45 AM (in response to Nicolas.Gasparotto)

Hi Nicolas,

I didn't notice. about thread date...
anyway this thread again remember your 'BETWEEN DATE QUERY".;-)

regards
Taj
Like Show 0 Likes(0)

Actions
11. Re: ORACLE Initialization or shutdown in progress

477388 Oct 26, 2007 6:14 AM (in response to Mohammed Taj)

ora-01033 error
any way to correct it
Like Show 0 Likes(0)

Actions
12. Re: ORACLE Initialization or shutdown in progress

247514 Oct 26, 2007 6:20 AM (in response to 477388)
asico,
you better start your own thread instead of appending on a more than two years old post. When you post please also include your Oracle version and OS and a brief description of how you got the error.
You need to make sure your database is up and running.
ORA-01033: ORACLE initialization or shutdown in progress
Cause: An attempt was made to log on while Oracle is being started up or shutdown.
Action: Wait a few minutes. Then retry the operation.
Like Show 0 Likes(0)

Actions
13. Re: ORACLE Initialization or shutdown in progress

577207 Oct 26, 2007 6:21 AM (in response to 477388)

Have you read the last post of Nicolas?

Adith
Like Show 0 Likes(0)

Actions
14. Re: ORACLE Initialization or shutdown in progress

629530 Mar 20, 2008 9:04 AM (in response to 99427)

Thanks Nikhil...
The steps provided by you were very helpful.
Basically there was no space in my root partition.
So I tried to free up those space, thinking that with this I may be able to access database using sqlplus. But still faced the same error.
So jst followed ur step of accessing as "sqlplus /nolog" and performed the steps mentioned.
The database got started without any error.
Thanks again
Like Show 0 Likes(0)

Actions