[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1986
  • Last Modified:

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.....
0
ajaygund
Asked:
ajaygund
  • 6
  • 5
1 Solution
 
Shaju KumbalathCommented:
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
 
ajaygundAuthor Commented:
ORA :- 01081 cannot star already running ORACLE shut it down first....
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Shaju KumbalathCommented:

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 KumbalathCommented:
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 KumbalathCommented:
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 KumbalathCommented:
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now