Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

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

Popular posts from this blog

PostgreSQL Pgbadger Installation On Linux

PostgreSQL pgBadger

How to configure Replication Manager (repmgr) ?

7 Steps to configure BDR replication in postgresql

PostgreSQL Sequence