ora-01033 oracle initialization or shutdown in process

[abhinavjainpassion]

i m geeting message "ora- 01033 oracle initialization or shutdown in process "
when i m login in sql plus
what wron with it and how can i get rid of this problem please help me
my operating system is windows xp

[fhkhan78]

hi dear
if you are using oracle 8i then type svrmgl in run and press ok
connect internal/oracle
shutdown abort
startup
exit
your problem will be solved
if you r using oracle 9i then type sqlplus in the run press ok
sys/change_on_insta ll as sysdba
shutdown abort
startup
exit
your problem will be solved

reply
thanks

[karpalmera]

hi, FHKHAN78!

what if I am using this version
Oracle7 Server Release 7.2.3.0.0 - Production Release
With the distributed option
PL/SQL Release 2.2.3.0.0 - Production?

what can i try?

thanks!

[subashsavji]

i m geeting message "ora- 01033 oracle initialization or shutdown in process "
when i m login in sql plus
what wron with it and how can i get rid of this problem please help me
my operating system is windows xp

“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.
//

When trying to connect got the error

ORA-01033: ORACLE initialization or shutdown in progress

went to prompt and typed

sqlplus /nolog

tried to connect using sys, got the same error

fired

connect / as sysdba

fired

shutdown

got

ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.

fired

startup

got

ORACLE instance started.
Total System Global Area 276371980 bytes
Fixed Size 453132 bytes
Variable Size 117440512 bytes
Database Buffers 157286400 bytes
Redo Buffers 1191936 bytes
Database mounted.
ORA-01113: file 30 needs media recovery
ORA-01110: data file 30: 'E:ORACLEORADAT AINDEX5_1T.ORA'

fired

alter database recover datafile 30;

got

ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-01114: IO error writing block to file 30 (block # 1)
ORA-01110: data file 30: 'E:ORACLEORADAT AINDEX5_1T.ORA'
ORA-27091: skgfqio: unable to queue I/O
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

E:ORACLEORADATA INDEX5_1T.ORA file was readonly. Unchecked it.

fired

alter database recover datafile 30;

shutdown

startup

Database mounted and opened successfully!
//