asked on

ORA 01033 ORACLE initilization or shutdown in progress

I have loin to oracle

but show below error :-

ORA 01033 ORACLE initialization or shutdown in progress.

i have connect also toad :-

Error :- ORA-12528: TNS:listener: all appropriate instances are blocking new connections

Please give me solution..

Thanks in advance.....

Shaju Kumbalath

sqlplus /nolog

connect / as sysdba

startup

ajaygund

ASKER

connect / as sysdba

startup

But show error :-

ORA -24324 service handle not initialized

ORA :- 01041 internal error host def extension doesn't exit ....

ajaygund

ASKER

ORA :- 01081 cannot star already running ORACLE shut it down first....

Shaju Kumbalath

sqlplus /nolog

connect / as sysdba
SHUTDOWN IMMEDIATE
THEN TRY

sqlplus /nolog

connect / as sysdba

startup

ajaygund

ASKER

Try this

sqlplus /nolog

connect / as sysdba

SHUTDOWN IMMEDIATE

But show error :-

ORA 01034 : ORACLE not available.
ORA 27101 : shared memory realm does not exit.

ajaygund

ASKER

i am also try this

sqlplus /nolog

connect / as sysdba

startup

But show Error :-

ORA-00204: error in reading (block 3, # blocks 8) of control file
ORA-00202: control file: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 23) Data error (cyclic redundancy check).

Please give me solution...

Thanks in Advance..................

ASKER CERTIFIED SOLUTION

Shaju Kumbalath

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Shaju Kumbalath

Please cut and paste control file 2 to some other location
and create a copy of control file 1 and rename as control file 2.
and follow the instructions

ajaygund

ASKER

I have done this :-

sqlplus /nolog

connect / as sysdba
SHUTDOWN IMMEDIATE

But show error:-

ORA 01507 :- database not mount...

oracle instance shut down.

Shaju Kumbalath

try this
sqlplus /nolog

connect / as sysdba

startup MOUNT;
RECOVER;
ALTER DATABASE OPEN;

shalowfast

if you are using windows y guess you can find and kill the smon process in the task manager, the name of the process would be something like this "ora_smon_DOPGEMEX" then yo could copy the controlfile01.ctl into the controlfile02.ctl and the controlfile03.ctl to ensure they are the same (backup the other controlfiles first) and then you can try to startup the database.

i wouldnt recomend to move a controlfile to another location to make the instance abort, it may become a controlfile corrupt

If you where on a unix based operating system you could kill the smon process like this
oracle - - oracle > ps -fea | grep smon
oracle 23296 1 0 Dec 28 ? 0:01 ora_smon_DOPGEMEX
oracle 21606 21604 0 18:21:48 pts/1 0:00 grep smon

where DOPGEMEX would be the name of your database Instance
oracle - - oracle > kill -9 23296

and then start the database, the recovery is automatic

SQL> startup

ajaygund

ASKER