new Spfile creation
Two node RAC on ODA running 11.2.0.3
The old spfile was removed by someone and we trying to recreate the spfile, but it is not working.
Here is what that was done:
1. created a init.ora file in the node1 and did a startup mount of the database and created a spfile in the shared ASM location:
SYS@cubprd1>create spfile='+DATA/CUBPRD/spfilecubprd.ora' from pfile='initcubprd.ora';
File created.
In ASM
ASMCMD> pwd
+DATA/CUBPRD
ASMCMD> ls -lrt
Type Redund Striped Time Sys Name
N DATAFILE/
Y PARAMETERFILE/
N TEMPFILE/
N spfilecubprd.ora => +DATA/CUBPRD/PARAMETERFILE/spfile.1935.837652261
> srvctl config database -d cubprd
The old spfile was removed by someone and we trying to recreate the spfile, but it is not working.
Here is what that was done:
1. created a init.ora file in the node1 and did a startup mount of the database and created a spfile in the shared ASM location:
SYS@cubprd1>create spfile='+DATA/CUBPRD/spfilecubprd.ora' from pfile='initcubprd.ora';
File created.
In ASM
ASMCMD> pwd
+DATA/CUBPRD
ASMCMD> ls -lrt
Type Redund Striped Time Sys Name
N DATAFILE/
Y PARAMETERFILE/
N TEMPFILE/
N spfilecubprd.ora => +DATA/CUBPRD/PARAMETERFILE/spfile.1935.837652261
> srvctl config database -d cubprd
0