Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-07391: sftopn: fopen error, unable to open text file.

bmpatilSep 19 2011 — edited Sep 19 2011
HI ,

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
This post has been answered by CKPT on Sep 19 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 17 2011
Added on Sep 19 2011
5 comments
15,971 views