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
algotubeAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
tangchunfengConnect With a Mentor Commented:
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
 
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:
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
All Courses

From novice to tech pro — start learning today.