OraFAQ Forum: Server Administration » ORA-01033 oracle initialization or shutdown in progress

Home » RDBMS Server » Server Administration » ORA-01033 oracle initialization or shutdown in progress

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01033 oracle initialization or shutdown in progress [message #463507]

Thu, 01 July 2010 11:31

dhinendra
Messages: 58
Registered: September 2009
Location: Gurgaon,India

Member

hi
when i am using sql prompt and enter username and password
scott and tiger it is giving error
ORA-01033 oracle initialization or shutdown in progress.Please help me out.

Thanks
Dhinendra

Report message to a moderator

Re: ORA-01033 oracle initialization or shutdown in progress [message #463508 is a reply to message #463507]

Thu, 01 July 2010 11:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

sqlplus
/ as sysdba
shutdown abort
startup
connect scott/tiger

Report message to a moderator

Re: ORA-01033 oracle initialization or shutdown in progress [message #463513 is a reply to message #463507]

Thu, 01 July 2010 11:54

dhinendra
Messages: 58
Registered: September 2009
Location: Gurgaon,India

Member

hi
i have done in the same way as you told me

SQL> shutdown abort
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.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\TCS\SYSTEM01.DBF'

now these are the things i am getting.

Thanks
Dhinendra

Report message to a moderator

Re: ORA-01033 oracle initialization or shutdown in progress [message #463515 is a reply to message #463513]

Thu, 01 July 2010 12:00

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>ORA-01110: data file 1: 'C:\ORACLE\ORADATA\TCS\SYSTEM01.DBF'
something BAD happened to your system/DB.
I hope you have a good backup.
I see this is a Windows system. What version of Oracle to 4 decimal places; like V11.2.0.1?
Tell us exactly how you ended up in this hole you now find yourself.

Report message to a moderator

Re: ORA-01033 oracle initialization or shutdown in progress [message #463529 is a reply to message #463507]

Thu, 01 July 2010 12:51

dhinendra
Messages: 58
Registered: September 2009
Location: Gurgaon,India

Member

Release 9.2.0.1.0
this is the oracle database version which i am using
and please tell me what could be the reason behind this error.

Thanks
Dhinendra

Report message to a moderator

Re: ORA-01033 oracle initialization or shutdown in progress [message #463531 is a reply to message #463529]

Thu, 01 July 2010 13:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

When was last time DB was operational?
What happened after that?
Was DB running with archive mode enabled?
post content of alert_SID.log file prior to today's activity

Report message to a moderator

Re: ORA-01033 oracle initialization or shutdown in progress [message #463534 is a reply to message #463529]

Thu, 01 July 2010 13:32

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

please tell me what could be the reason behind this error.

File is not up to date and needs recovery.

ORA-01113: file %s needs media recovery
 *Cause:  An attempt was made to online or open a database with a file that
           is in need of media recovery.
 *Action: First apply media recovery to the file.

Regards
Michel

Report message to a moderator

Re: ORA-01033 oracle initialization or shutdown in progress [message #463536 is a reply to message #463534]

Thu, 01 July 2010 13:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I suggest that you take a cold backup of this system before attempting any type of recovery or restoration.
It can't hurt & might prove valuable in the future; then again it could be just a waste of time.
It is your choice to do or not.

Report message to a moderator

Re: ORA-01033 oracle initialization or shutdown in progress [message #463700 is a reply to message #463513]

Fri, 02 July 2010 11:44

rk44
Messages: 18
Registered: June 2010

Junior Member

your system data file needs media recovery.

now it needs recovery...bcz of incosistent of SCN ,i.e is mismatching of scn.

go to startup mount..
do:
recover database;

after getting o/p and then fire

auto

by this u can over this problem.other wise apply redologs manually to overcome.after it open your database with resetlogs;

Report message to a moderator

Re: ORA-01033 oracle initialization or shutdown in progress [message #463713 is a reply to message #463700]

Fri, 02 July 2010 12:31

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please read OraFAQ Forum Guide and don't use IM/SMS speak.

Regards
Michel

Report message to a moderator

Previous Topic:	how to reclaim space after deleting a data file
Next Topic:	need help on issue of updating statistics

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 10:31:28 CST 2024