Home » RDBMS Server » Server Administration » Ora-01033:Oracle Startup/Shutdown Problem on Win2K Pro
icon9.gif  Ora-01033:Oracle Startup/Shutdown Problem on Win2K Pro [message #124406] Sat, 18 June 2005 02:44 Go to next message
HABIB MEMON
Messages: 5
Registered: September 2004
Junior Member
Hi
im using Oracle 9i Ver: 9.0.1.0.1.
Last day i run SQL Loader for loading data of apporx 1.93 GB into various tables and suddenly power failure occurs and at next startup i met following error:
Ora-01033: Oracle initialization or shutdown in progress..
for its solution i checked user dump files n found that due to following errors the above error is coming:
ORA-00396: error 397 required fallback to single-pass recovery
ORA-00397: lost write detected for file 2, block 214364

please help me out for rectification of all this

Thanx

Habib
Note: Alrt File is attached for diagnosis. Embarassed

[Updated on: Sat, 18 June 2005 07:22]

Report message to a moderator

Re: Ora-01033:Oracle Startup/Shutdown Problem on Win2K Pro [message #138609 is a reply to message #124406] Thu, 22 September 2005 11:50 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

You posted question on june 18th it high time i think u had solved your issue and to be very honest i had seen your post now so .... can you tell us that u had solve this problem or it still remains unsolved ?

Regard
Always Friend sunilkumar
Re: Ora-01033:Oracle Startup/Shutdown Problem on Win2K Pro [message #138867 is a reply to message #138609] Sat, 24 September 2005 14:42 Go to previous message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

http://www.orafaq.com/forum/t/47769/0/
Check that

-Sai jeedigunta
Previous Topic: Telnet query buffer restriction?
Next Topic: size of the sga
Goto Forum:
  


Current Time: Fri Jan 10 10:22:37 CST 2025