Skip to content

ORA-01565: error in identifying file /dbs/spfile@.ora

When we’re going to create pfile from spfile while spfile running on ASM instance, We can face the below errors,

SQL> create pfile=’/u01/inittest.ora’ from spfile;
create pfile=’/u01/inittest.ora’ from spfile
*
ERROR at line 1:
ORA-01565: error in identifying file ‘?/dbs/spfile@.ora’
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

Solution :

We need to give ASM path of SPFILE.

SQL> create pfile=’/u01/inittest.ora’ from spfile=’+DATA/dbasm/spfiledbasm.ora’;

File created.

About these ads
3 Comments Post a comment
  1. Ramakant #

    Hi Azar,
    i am getting the below error message while creating pfile -
    SQL> create pfile=’/u01/app/oracle/initram1.ora’ from spfile=’+DATA/ram/spfileram.ora’;
    create pfile=’/u01/app/oracle/initram1.ora’ from spfile=’+DATA/ram/spfileram.ora’
    *
    ERROR at line 1:
    ORA-01565: error in identifying file ‘+DATA/ram/spfileram.ora’
    ORA-17503: ksfdopn:2 Failed to open file +DATA/ram/spfileram.ora
    ORA-27140: attach to post/wait facility failed
    ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
    ORA-27301: OS failure message: Operation not permitted
    ORA-27302: failure occurred at: skgpwinit6
    ORA-27303: additional information: startup egid = 1000 (oinstall), current egid
    = 1200 (dba)

    Is anything wrong in the permission. Your advise is must appreciated.

    Thanks
    Rk

    May 7, 2012

Trackbacks & Pingbacks

  1. ORA-01565: error in identifying file /dbs/spfile@.ora | Oracle in Thai | Oracle in Thai | Oracle User Group in Thailand |
  2. what are wiki backlinks

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 139 other followers

%d bloggers like this: