• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1062
  • Last Modified:

ORA-27091 - ORA-27070

Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
PL/SQL Release 9.2.0.8.0 - Production
CORE      9.2.0.8.0      Production
TNS for 32-bit Windows: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production

Hello Experts;

         I have just issued this command:
create pfile from spfile;
and I am getting

create pfile from spfile
*
ERROR at line 1:
ORA-27091: skgfqio: unable to queue I/O
ORA-27070: skgfdisp: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 38) Reached the end of the file.

Can anyone shed some light on this error:

Thanks for your time
0
algotube
Asked:
algotube
  • 2
1 Solution
 
Richard OlutolaConsultantCommented:
Are you sure you're using spfile file? To check
SQL> show parameter spfile

If the VALUE column is blank, then you're not using spfile. It is likely you're using pfile in which case, issue

SQL>create spfile form pfile;

You'll now need to restart to start using spfile. Once restarted, try the above check again.

However, if you've confirmed that you're using spfile already, then perhaps the location it's trying to create the pfile in has problems. Make sure $ORACLE_HOME/dbs directory is writeable by the oracle user.

R.
0
 
tangchunfengCommented:
See if there are messages at OS level on /var/log/messages (linux)  /var/adm/syslog/syslog.log (HPUX)
errpt (AIX)
in order to diagnose a hardware/disk failure.

maybe need a db restore
0
 
tangchunfengCommented:
try manually create a new pfile ,maybe will solve the problem
0
 
schwertnerCommented:
The correct syntax is

SQL>CREATE PFILE='c:\init_SID.ora' FROM SPFILE;

as SYS user
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now