Oracle instance crash, error messages ORA-00600, ORA-27091, ORA-27072

"Failure Phenomenon"

February 8, 2015, oracle10.2.0.4 Single instance database, suddenly crash, but into the reboot run recovery. Check Alert.log log found the following "ORA-00600, ORA-27091, ORA-27072" error message.

Errors in FILE/HOME/DB/ORACLE/ADMIN/DB1/BDUMP/DB1_MMON_22544442.TRC:

Ora-00600:internal error code, arguments: [kmgs_parameter_update_timeout_1], [27091], [], [], [], [], [], []

Ora-27091:unable to queue I/O

Ora-27072:file I/O error

IBM AIX RISC system/6000 error:9: Bad file number

Additional Information:7

Additional Information:4

Additional Information:-1

"Problem Analysis"

October 2014 for the dual-machine switch, spfile for shared volume bare device, before switching, the standby machine does not clean the root permissions should not exist in the SPFile file, after switching, an exception occurs, Oracle data bare device file permissions of 301, and the user is not Oracle. These errors make the database persistent ORA-27072 error

"Problem Solving"

Modify SPFile as a bare device

# su-oracle

$ Export ORACLE_SID=DB1

--Create a PFILE from your current SPFILE:

sql> create pfile= '/tmp/init.ora ' from SPFile;

Sql> Ho More/tmp/init.ora

sql> shutdown Immediate

sql> startup pfile= '/tmp/init.ora ';

Sql> Ho ls-l/home/db/oracle/oradata/db1/rspfile_db1

lrwxrwxrwx 1 Oracle DBA 2013/HOME/DB/ORACLE/ORADATA/DB1/RSPFILE_DB1-/dev/recsv01l3110

sql> create spfile= '/home/db/oracle/oradata/db1/rspfile_db1 ' from pfile;

sql> shutdown Immediate

$ mv Spfiledb1.ora Spfiledb1.ora_old

$ VI Initdb1.ora

Add spfile= "/HOME/DB/ORACLE/ORADATA/DB1/RSPFILE_DB1"

Sql> Startup

Sql> Show parameter SPFile;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

SPFile STRING/HOME/DB/ORACLE/ORADATA/DB1/RSPFILE_DB1

Summary

During the implementation, after launching the instance with Pfile, an attempt was made to alter the system set SPFile failure, error message "Ora-02095:specified initialization parameter cannot be modified".

The point is that when you start with pfile, you don't need to modify the SPFile parameter without spfile, and you can't modify it. Should delete the SPFile file, pfile content written spfile= ' xxxx ', after the instance is launched, modify the SPFile to allow.

This article is from the "All the Way" blog, please be sure to keep this source http://702410.blog.51cto.com/692410/1615920

Oracle instance crash, error messages ORA-00600, ORA-27091, ORA-27072