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.....
ajaygundAsked:
Who is Participating?
 
Shaju KumbalathConnect With a Mentor Deputy General Manager - ITCommented:
SHUTDOWN THE DATABASE
sqlplus /nolog

connect / as sysdba
SHUTDOWN IMMEDIATE
 
MOVE  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL' TO SOME OTHER LOCATION
RENAME 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL'  TO  'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL'


sqlplus /nolog

connect / as sysdba

startup MOUNT;
RECOVER;
ALTER DATABASE OPEN;
 
0
 
Shaju KumbalathDeputy General Manager - ITCommented:
sqlplus /nolog

connect / as sysdba

startup
 
0
 
ajaygundAuthor Commented:
connect / as sysdba

startup

But show error :-

ORA -24324 service handle not initialized

ORA :-  01041 internal error host def extension doesn't  exit ....
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
ajaygundAuthor Commented:
ORA :- 01081 cannot star already running ORACLE shut it down first....
0
 
Shaju KumbalathDeputy General Manager - ITCommented:

sqlplus /nolog

connect / as sysdba
SHUTDOWN IMMEDIATE
THEN TRY


sqlplus /nolog

connect / as sysdba

startup

 
0
 
ajaygundAuthor Commented:
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.

0
 
ajaygundAuthor Commented:
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..................
0
 
Shaju KumbalathDeputy General Manager - ITCommented:
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
0
 
ajaygundAuthor Commented:
I have done this  :-

sqlplus /nolog

connect / as sysdba
SHUTDOWN IMMEDIATE

But show error:-

ORA 01507 :- database not mount...

oracle instance shut down.


0
 
Shaju KumbalathDeputy General Manager - ITCommented:
try this
sqlplus /nolog

connect / as sysdba

startup MOUNT;
RECOVER;
ALTER DATABASE OPEN;
 
0
 
shalowfastCommented:

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
 
0
 
ajaygundAuthor Commented:
ok
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.