ORA-01565: error in identifying file '?/dbs/spfile@.ora'
QL> startup
ORA-01261: Parameter
db_recovery_file_dest destination string cannot be translated
SQL> create pfile
from spfile;
create pfile from
spfile
*
ERROR at line 1:
ORA-01565: error in
identifying file '?/dbs/spfile@.ora'
ORA-27037: unable to
obtain file status
Linux-x86_64 Error:
2: No such file or directory
Additional
information: 3
SQL> shut abort
SQL> create
pfile='/home/oracle/initORA11G.ora' from
spfile='+DATA/ORA11G/spfileORA11G.ora';
File created.
oracle@rac1.localdomain:/home/oracle
[ORA11G1] >dba
SQL*Plus: Release
11.2.0.3.0 Production on Wed Apr 6 20:15:29 2016
Copyright (c) 1982,
2011, Oracle. All rights reserved.
Connected to an idle
instance.
SQL> startup
pfile='/home/oracle/initORA11G.ora';
ORACLE instance
started.
Total System Global
Area 1653518336 bytes
Fixed Size 2228904 bytes
Variable Size 956304728 bytes
Database
Buffers 687865856 bytes
Redo Buffers 7118848 bytes
Database mounted.
Database opened.
SQL>
SQL> shut abort
SQL> create spfile='+DATA/ORA11G/spfileORA11G.ora' from pfile='/home/oracle/initORA11G.ora';
File created.
SQL> startup
ORACLE instance
started.
Total System Global
Area 1653518336 bytes
Fixed Size 2228904 bytes
Variable Size 956304728 bytes
Database
Buffers 687865856 bytes
Redo Buffers 7118848 bytes
Database mounted.
Database opened.
SQL> sho
parameter spfile
NAME TYPE VALUE
------------------------------------
----------- ------------------------------
spfile string /ora01/app/oracle/product/11.2
.0/db_1/dbs/spfileORA11G1.ora
SQL>
Hello Srinivas,
ReplyDeleteI am having issues in creating these files for oracle 19c. It gives me below error:
SQL> ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
ORA-01262: Stat failed on a file destination directory
I see below files in /opt/oracle/product/19c/dbhome_1/dbs.
drwxr-xr-x 1 oracle dba 4096 May 20 08:31 .
drwxr-xr-x 1 oracle dba 4096 May 19 11:12 ..
-rw-r--r-- 1 oracle dba 3079 May 14 2015 init.ora
lrwxrwxrwx 1 oracle dba 49 May 19 11:12 orapwORCLCDB -> /opt/oracle/oradata/dbconfig/ORCLCDB/orapwORCLCDB
lrwxrwxrwx 1 oracle dba 54 May 19 11:12 spfileORCLCDB.ora -> /opt/oracle/oradata/dbconfig/ORCLCDB/spfileORCLCDB.or
But, when I try to create spfile after setting export ORACLE_SID=ORCLCDB. it gives me below error
SQL> CREATE PFILE FROM SPFILE='/opt/oracle/oradata/dbconfig/ORCLCDB/spfileORCLCDB.ora';
CREATE PFILE FROM SPFILE='/opt/oracle/oradata/dbconfig/ORCLCDB/spfileORCLCDB.ora'
*
ERROR at line 1:
ORA-01565: error in identifying file
'/opt/oracle/oradata/dbconfig/ORCLCDB/spfileORCLCDB.ora'
Or
SQL> create pfile='/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora' from spfile;
create pfile='/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora' from spfile
ERROR at line 1:
ORA-01565: error in identifying file '?=/dbs/spfile@.ora'