ORA-07391: sftopn: fopen error, unable to open text file.
bmpatilSep 19 2011 — edited Sep 19 2011HI ,
From last 3 days we are getting the below error in the alert log.
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
I check the same related to it in metalink i found solution check permission on the directory.(DOC ID367619.1)
I set the permission of $ORACLE_HOME\dbs to 777 ,but still m getting same error.
also i try to recreate spfile for that first i try to create pfile
create pfile from spfile
i get the below error.
ORA-07391: sftopn: fopen error, unable to open text file.
ls -lrt sp* in the $ORACLE_HOME is showing below output
-rwxrwxrwx 1 ora10g dba10 3584 Sep 20 05:42 spfile<SID>.ora
Please help.
Thanks in advance