ORA-01078: failure in processing system parameters

ORA-01078: failure in processing system parameters

Below are steps for ORA-01078

[test@linux ~]$ sqlplus

SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 2 09:21:55 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter user-name: sys as sysdba

Enter password:

Connected to an idle instance.

SQL> startup

ORA-01078: failure in processing systemparameters

LRM-00109: could not open parameter file'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initORCL.ora'

SQL> exit

Disconnected

/u01/app/oracle/oradata/orcl/axpert01.dbf

[test@linux pfile]$/u01/app/oracle/product/11.2.0/dbhome_1/dbs/sqlplus

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jun21 09:28:58 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter user-name: sys as sysdba

Enter password:

Connected to an idle instance.

SQL> startup nomount pfile=/u01/app/oracle/admin/ORCL/pfile/init.ora

ORACLE instance started.

Total System Global Area  835104768 bytes

Fixed Size                  2232960 bytes

Variable Size             490737024 bytes

Database Buffers          335544320 bytes

Redo Buffers                6590464 bytes

SQL> create spfile from pfile;

create spfile from pfile

*

ERROR at line 1:

ORA-01078: failure in processing systemparameters

LRM-00109: could not open parameter file

'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initORCL.ora'

SQL> create spfile frompfile='/u01/app/oracle/admin/ORCL/pfile/init.ora';

File created.

SQL> create pfile from spfile;

File created.

SQL> EXIT

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Check whether new Spfile & Pfile created ot not with recent time stamp.

[test@linux pfile]$ ls -ltr $ORACLE_HOME/dbs

[test@linux pfile]$ sqlplus

SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 2 09:46:23 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter user-name: sys as sysdba

Enter password:

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$database;

select name from v$database

*

ERROR at line 1:

ORA-01507: database not mounted

SQL> startup

ORA-01081: cannot start already-running ORACLE -shut it down first

SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  835104768 bytes

Fixed Size                  2232960 bytes

Variable Size             490737024 bytes

Database Buffers          335544320 bytes

Redo Buffers                6590464 bytes

Database mounted.

Database opened.

SQL> select name from v$database;

NAME

---------

ORCL

SQL>

pfile