Database - RAC/Scalability (MOSC)

MOSC Banner

new Spfile creation

edited Jul 2, 2015 1:40PM in Database - RAC/Scalability (MOSC) 3 commentsAnswered ✓
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center