Hi,
I have install Oracle 9i initialy it works fine but after some days it displays this Idiot msg.

ORA-01033: ORACLE initialization or shutdown in progress

I have win2k with SP3, I have installed three time this stuppid software but this problem occurs every time, starting every service (in control panel->Administrative-> services )
after waiting a long time I am unable to log on. I am runing simple commands/statements and do not amend any thing in database.

PLZ help me, I am begginer so plz give me answer in a simple way, and quickly b/c tommorow my OCP class is due.
Thanks in advance

Check the alert log...

Hi,
Where can I find ALERT LOG, I have found this

E:\oracle\admin\orcl2\bdump\orcl2ALRT.LOG

" Not sure but log file display this problem"

E:\oracle\admin\orcl2\bdump\orcl2ALRT.LOG

Tue Feb 10 12:41:35 2004
alter database open
ORA-1113 signalled during: alter database open...
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 2096
Dump file E:\oracle\admin\orcl2\bdump\orcl2ALRT.LOG

ok, try to do following:
open sqlplus an logon "/ as sysdba"
then try execute shutdown abort.
Next try start database step by step:
startup nomount
alter database mount
alter database open

If there will be some errors let me know...

P.S. when you start the instance execute the "show parameters background_dump_dest" and you'll see the path where is alertlog located.

SQL> show parameters background_dump_dest

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest string E:\oracle\admin\orcl2\bdump


Exucuted command no & o/p are listed here.


1- SQL> shutdown abort
O/P- ORACLE instance shut down.



2- SQL> start database step by step
O/P- SP2-0310: unable to open file "database.sql"



3- SQL> startup nomount
ORACLE instance started.

Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes


4- SQL> alter database mount;

Database altered.



5- SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\ORCL2\SYSTEM01.DBF'

"start database step by step" - this is not a command its only phrase

Following error "ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\ORCL2\SYSTEM01.DBF'" says the datafile need recovery because of unclean shutdown or media failure etc.
Is your DB in ARCHIVELOG mode or not?
If not do you have backup of DB?

Here is link to backup, restore and recovery related documentation http://download-west.oracle.com/docs...a96519/toc.htm

Hi,
I am very thankful to you for your help and sharp response, now my problem is solved by by visiting your given web address.
Thanks again.
Khawar

Following is the commands which I have used to restore media

RMAN Restore and Recovery

The basic RMAN recovery commands are RESTORE and RECOVER. Use RESTORE to restore datafiles from backup sets or from image copies on disk, either to their current location or to a new location. You can also restore backup sets containing archived redo logs. Use the RMAN RECOVER command to perform media recovery and apply archived logs or incremental backups.

RMAN automates the procedure for recovering and restoring your backups and copies. For example, run the following commands from within RMAN to restore and recover the database to its current time:
SHUTDOWN IMMEDIATE; # shuts down database
STARTUP MOUNT; # starts and mounts database
RESTORE DATABASE; # restores all datafiles
RECOVER DATABASE; # recovers database using all available redo
ALTER DATABASE OPEN; # reopens the database

Hi all,
I was using Oracle 10g, when I was operating in the sqlclient the power was down suddenly. When I start the system again and try to login to the sqlclient, I got this error ORA 01033 initialization or shutdown in progress.
I restarted the system few times but the same problem. Please anyone help me...
Thank you in advance

Regards,
Vijay Reddy

open command window while logged onto OS as owner of Oracle software

CUT lines below

sqlplus
/ as sysdba
shutdown abort
startup
SELECT * FROM V$VERSION;
EXIT

PASTE into Command Window

CUT & PASTE commands & results back here

I am sorry I didn't get you... Where should I paste them. Is it the command line of windows? If so how should I enter... One by one in order or at a time.?

Post Operating System (OS) name & version for DB server system.
Post Oracle version to 4 decimal place of database s/w.

I have the same problem
here is my result

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 234883972 bytes
Database Buffers 369098752 bytes
Redo Buffers 7135232 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],
[], [], []


SQL> SELECT * FROM V$VERSION;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> EXIT
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options

Anybody can help?

>Anybody can help?
Submit a Service Request with Oracle Tech. Support. They can assist with debugging ORA-00600

Hello all,

This is my version of story,


SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1250452 bytes
Variable Size 192940908 bytes
Database Buffers 415236096 bytes
Redo Buffers 2940928 bytes
SQL> alter database mount;

Database altered.

SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01172: recovery of thread 1 stuck at block 73 of file 2
ORA-01151: use media recovery to recover block, restore backup if needed

SQL> startup
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1250452 bytes
Variable Size 192940908 bytes
Database Buffers 415236096 bytes
Redo Buffers 2940928 bytes
Database mounted.
ORA-01172: recovery of thread 1 stuck at block 73 of file 2
ORA-01151: use media recovery to recover block, restore backup if needed


SQL> SELECT * FROM V$VERSION;

BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.1.0 - Production
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production


....................

The log file last few lines..

alter database dismount
Completed: alter database dismount
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active


.............

And the recovery option


SQL> recover datafile 2;
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [3020], [2], [73], [1], [102],
[62974], [16], []
ORA-10567: Redo is inconsistent with data block (file# 2, block# 73)
ORA-10564: tablespace UNDOTBS1
ORA-01110: data file 2: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.D BF'
ORA-10560: block type 'KTU SMU HEADER BLOCK'