Software
Microsoft
Apple
Hardware
Network
Shareware
Games Online
Live Scores - TV
Software FAQ
»
Database
»
Miscellaneous
»
ORA-01033: Oracle initialization or shutdown in progress
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
Solution: ORA-01033: Oracle initialization or shutdown in progress
BACKUP, BACKUP, BACKUP, BACKUP, BACKUP
In fact, if you have crutial data, you need to ensure
1) the best & fault-tolerant hardware to avoid any I/O errors
2) use the db_block_checksum and db_block_checking database parameters to protect even more
3) backup the database regulary, and even have the database in Archivelog mode so you can restore up to any point in time.
Regarding your questions:
1) Only if you can restore the database (see above), or if you can alter the database to remove this OEM data file.
2) see above
3) DBMS_JOB package should help you to do this job also
CHeers
Active
Click an Hyperlink in Internet Explorer Using an Excel Macro
IE7 ! Error On Page and/or ! Done
Increasing simutaneous downloads
Torrrent and Newsgroup downloader and searcher
Does (or can) Mozilla Thunderbird download email to your computer and off the server?
Random missing text in email
Auditing Exchange Appointment Calendar Edits.
Antivirus Software Alert
Antivirus and Antispyware Protection definitions are out of date
Can someone suggest good anti-malware software?
How to update LONG column in Oracle 9i
Putting Javascript in a Wordpress file (not a post) in the Body (not the head)
ETL for HL7 data into Microsoft SQL Server
browser not sending HTTP_REFERER headers to website
Problem: How can I disable the caching of EJB 3.0 datasources?
PHPmyadmin
Installation of Logitech WebCam software
Problem: Wildcard for datapump import
.bat file to copy zip and unzip files
XHTML: there is no attribute "name"
Crystal Lawson Report Error
Recover deleted vm esx
Net Stop /Net start command syntax
Using PHP on webserver, to retrieve a file from a remote PC with ftp server installed
Regarding Popen in python
SBS Shutting itself down! It says I have multiple domain controllers when I don't!
Sendmail seems to be relaying using localhost 127.0.0.1 to send mail out
Explanation of RSS
Text-Diff in RUBY
Problem: Mysql ODBC