sxg
asked on
ORA-01033: Oracle initialization or shutdown in progress
Hello, precursors, i am newbie in Oracle.
I've played with Oracle 8i for a short period. Everything went smoothly until yesterday i encountered a crucial problem:
ORA-01033: Oracle initialization or shutdown in progress
I tried to do following steps in SQLPLUS(as DBA):
========================== ========== ========== ========== ========== ===
shutdown abort//startup//shutdown// startup
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 25217052 bytes
Fixed Size 75804 bytes
Variable Size 8286208 bytes
Database Buffers 16777216 bytes
Redo Buffers 77824 bytes
Database mounted.
ORA-01110: data file 19: 'C:\ORACLE\DBS\ORADATA\SIM ONDB\OEM_R EPOSITORY. ORA'
ORA-01115: IO error reading block from file 19 (block # 1)
ORA-27070: skgfdisp: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 23) Data error (cyclic redundancy check).
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 25217052 bytes
Fixed Size 75804 bytes
Variable Size 8286208 bytes
Database Buffers 16777216 bytes
Redo Buffers 77824 bytes
Database mounted.
ORA-01110: data file 19: 'C:\ORACLE\DBS\ORADATA\SIM ONDB\OEM_R EPOSITORY. ORA'
ORA-01115: IO error reading block from file 19 (block # 1)
ORA-27070: skgfdisp: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 23) Data error (cyclic redundancy check).
========================== ========== ========== ========== ========== ====
It seems that OEM_REPOSITORY.ORA was corrupt and i cannot start OMS.
but OracleServiceSimondb(my database) was still running and the previously scheduled JOBs were still running!!! After that i recreated another repository before i could start OMS again.
My questions are:
1, Is there any solutions to reenter the database(because i have important data inside)?
2, If the corruption was resulted from a physical failure of HardDrive(because my harddrive "gasp" everytime when i attempt to login or check the OEM_REPOSITORY.ORA), is there remedy?
3, How to kill the previously scheduled JOBs without drop the database?
thanks a million
I've played with Oracle 8i for a short period. Everything went smoothly until yesterday i encountered a crucial problem:
ORA-01033: Oracle initialization or shutdown in progress
I tried to do following steps in SQLPLUS(as DBA):
==========================
shutdown abort//startup//shutdown//
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 25217052 bytes
Fixed Size 75804 bytes
Variable Size 8286208 bytes
Database Buffers 16777216 bytes
Redo Buffers 77824 bytes
Database mounted.
ORA-01110: data file 19: 'C:\ORACLE\DBS\ORADATA\SIM
ORA-01115: IO error reading block from file 19 (block # 1)
ORA-27070: skgfdisp: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 23) Data error (cyclic redundancy check).
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 25217052 bytes
Fixed Size 75804 bytes
Variable Size 8286208 bytes
Database Buffers 16777216 bytes
Redo Buffers 77824 bytes
Database mounted.
ORA-01110: data file 19: 'C:\ORACLE\DBS\ORADATA\SIM
ORA-01115: IO error reading block from file 19 (block # 1)
ORA-27070: skgfdisp: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 23) Data error (cyclic redundancy check).
==========================
It seems that OEM_REPOSITORY.ORA was corrupt and i cannot start OMS.
but OracleServiceSimondb(my database) was still running and the previously scheduled JOBs were still running!!! After that i recreated another repository before i could start OMS again.
My questions are:
1, Is there any solutions to reenter the database(because i have important data inside)?
2, If the corruption was resulted from a physical failure of HardDrive(because my harddrive "gasp" everytime when i attempt to login or check the OEM_REPOSITORY.ORA), is there remedy?
3, How to kill the previously scheduled JOBs without drop the database?
thanks a million
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i know it may not be a big problem for you. but it really stuck me. And i hv searched here on this issue already, but those solutions seem not so detailed to get it over.