You are currently browsing the tag archive for the ‘spfile’ tag.

How we can check Our Dbs is running with spfile or pfile. Here is the some method to can find your file locations etc.
1. By using SqlPlus, Let us check your db started via spfile or pfile
$ sqlplus / as sysdba

 Read the rest of this entry »

In this post, I am going to explain how we can create Recreating the Spfile for RAC Instances.

We had issue on our EBS R12.1.3 system with 11.2.0.1 2 node RAC system on AIX 6.1. We need to recreate our spfile on ASM. So here is the steps:

By default init<SID>.ora file represent at $ORACLE_HOME/dbs path.

In this case the parameter file was saved to /u01/app/oracle/11.2.0/dbs/initPROD001.ora

1. Using this text based format of the parameter file after having corrected the parameters that have caused the issue, start one of the RAC instances to the mount phase.

SQL> startup mount pfile=’/u01/app/oracle/11.2.0/home/oracle/initPROD01.ora’;

2. The current location for spfile is; +oradata/PROD00/spfilePROD00.ora so the new file will need to replace with this file. ASM itself stores the spfile in +oradata/PROD00/PARAMETERFILE/spfile.267.737949031 and links or aliases the spfile in the location +oradata/PROD00/spfilePROD00.ora

Read the rest of this entry »