Shulou(Shulou.com)06/01 Report--

[failure phenomenon]

On February 8, 2015, oracle10.2.0.4 single instance database, suddenly CRASH, but entered the restart to run recovery. Check the alert.log log and find 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]

The dual-machine switch was performed in October 2014. Spfile is a shared volume bare device. Before the switch, there is no spfile file on the slave that cleans up the root permission that should not exist. After the switch, an exception occurs. The file permission of the oracle data bare device file is 301, and the user is not oracle. These errors cause the database to report ORA-27072 errors continuously.

[problem solving]

Change spfile to 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 17 Jun 08 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 starting the instance with pfile, the attempt to alter system set spfile failed and the error message "ORA-02095: specified initialization parameter cannot be modified" was reported.

The crux of the problem is that after starting with pfile, there is no need to modify the spfile parameter and cannot be modified without spfile. You should delete the spfile file, write the pfile content into spfile='xxxx', and modify the spfile only after starting the instance.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.