Make SPFILE to an ASM Environment

Objective :


During Startup of the database and for memory parameter misconfigured I got the below error :

[oracle@ol5-112-rac2 ~]$ srvctl  start database -d isldb
PRCR-1079 : Failed to start resource ora.isldb.db
ORA-27102: out of memory
CRS-2674: Start of 'ora.isldb.db' on 'ol5-112-rac1' failed
CRS-2632: There are no more servers to try to place resource 'ora.isldb.db' on that would satisfy its placement policy
ORA-27102: out of memory
CRS-2674: Start of 'ora.isldb.db' on 'ol5-112-rac2' failed

Solution :

>  Delete all the default 'spfile'  from default  '/dbs'  location .

  

  1) Remove the present 'spfile'  from the ASM location .

 ASMCMD> pwd
+DATA/ISLDB/PARAMETERFILE

ASMCMD> ls
spfile.339.864311263
spfile.641.859222679
spfile.657.864311045
spfile.681.864305249

ASMCMD> rm *
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD> ls
ASMCMD-08002: entry 'PARAMETERFILE' does not exist in directory '+DATA/ISLDB/'

2) 

Now, create spfile on ASM location :

SQL> startup pfile=initISL.ora

ORACLE instance started.

Total System Global Area 1653518336 bytes

Fixed Size                  2213896 bytes

Variable Size            1040189432 bytes

Database Buffers          603979776 bytes

Redo Buffers                7135232 bytes

Database mounted.

Database opened.

SQL> create spfile='+DATA' from pfile='/home/oracle/initISL.ora';

File created.

ASMCMD> pwd

+DATA/ISLDB/PARAMETERFILE

ASMCMD> ls

spfile.339.864311475

ASMCMD> 

3) Start the database but got error again  :

  SQL> startup

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file '+DATA/isldb/spfileisldb.ora'

ORA-17503: ksfdopn:2 Failed to open file +DATA/isldb/spfileisldb.ora

ORA-15056: additional error message

ORA-17503: ksfdopn:DGOpenFile05 Failed to open file +DATA/isldb/spfileisldb.ora

ORA-17503: ksfdopn:2 Failed to open file +DATA/isldb/spfileisldb.ora

ORA-15173: entry 'spfileisldb.ora' does not exist in directory 'isldb'

ORA-06512: at line 4

That means .. it searches the spfile to another location rather than '+DATA/ISLDB/PARAMETERFILE' location .

Then run the below command :

 ASMCMD>  mkalias +DATA/ISLDB/PARAMETERFILE/spfile.339.864311831  +DATA/isldb/spfileisldb.ora

Thats ok ...

Now startup the database .

For the Second database . simply restart the database .. it got the 'default ASM spfile '  automatically .

 site