spfile and pfile errors
SQL> create pfile='/home/oracle/karan/admin/pfile/initclone.ora' from spfile;
create pfile='/home/oracle/karan/admin/pfile/initclone.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
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> create spfile=
2
SQL> create spfile='/home/oracle/karan/admin/pfile/initclone.ora' from pfile;
create spfile='/home/oracle/karan/admin/pfile/initclone.ora' from pfile
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'/oraeng/app/oracle/product/11.2.0/dbs/initkiruba.ora'
SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'/oraeng/app/oracle/product/11.2.0/dbs/initkiruba.ora'
SQL> create spfile from pfile='/home/oracle/karan/admin/pfile/initclone.ora;
create spfile from pfile='/home/oracle/karan/admin/pfile/initclone.ora
*
ERROR at line 1:
ORA-01756: quoted string not properly terminated
SQL> create spfile from pfile='/home/oracle/karan/admin/pfile/initclone.ora';
create spfile from pfile='/home/oracle/karan/admin/pfile/initclone.ora'
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'/home/oracle/karan/admin/pfile/initclone.ora'
SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'/oraeng/app/oracle/product/11.2.0/dbs/initkiruba.ora'
SQL> crecreate spfile from pfile;
SP2-0734: unknown command beginning "crecreate ..." - rest of line ignored.
SQL> create spfile from pfile='/home/oracle/karan/admin/pfile/initclone.ora';
create spfile from pfile='/home/oracle/karan/admin/pfile/initclone.ora'
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'/home/oracle/karan/admin/pfile/initclone.ora'
SQL>
SQL>
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oraeng/app/oracle/product/11.2.0/dbs/initkiruba.ora'
SQL> startup pfile='/home/oracle/kiruba/admin/pfile/initkiruba.ora';
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> /home/oracle/kiruba/admin/pfile/initkiruba.ora
SP2-0734: unknown command beginning "/home/orac..." - rest of line ignored.
SQL> startup pfile='/home/oracle/kiruba/admin/pfile/initkiruba.ora force;
LRM-00109: could not open parameter file '/home/oracle/kiruba/admin/pfile/initkiruba.ora force'
ORA-01078: failure in processing system parameters
SQL> startup pfile='/home/oracle/kiruba/admin/pfile/initkiruba.ora'force;
LRM-00109: could not open parameter file '/home/oracle/kiruba/admin/pfile/initkiruba.oraforce'
ORA-01078: failure in processing system parameters
SQL> startup pfile='/home/oracle/kiruba/admin/pfile/initkiruba.ora' force;;
SP2-0714: invalid combination of STARTUP options
solution:-
SQL> !
[oracle@localhost ~]$ locate initkiruba.or
/home/oracle/kiruba/admin/pfile/initkiruba.ora
[oracle@localhost ~]$ exit
exit
SQL> startup pfile='/home/oracle/kiruba/admin/pfile/initkiruba.ora' force;ORACLE instance started.
Total System Global Area 941600768 bytes
Fixed Size 1340440 bytes
Variable Size 549456872 bytes
Database Buffers 385875968 bytes
Redo Buffers 4927488 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile='/home/oracle/kiruba/admin/pfile/initkiruba.ora';
File created.
Comments
Post a Comment