SPFILE parameter in local node’s pfile is automatically changed upon db startup

Farhat Zaman All Posts

I manually created an spfile from pfile after some modifications and placed it in directory

+DATA/TESTRAC/spfile.259.858334859


This is not a standard path, instead it should be

+DATA/TESTRAC/PARAMETERFILE/spfile.259.858334859

I recreated spfile by first creating pfile from above spfile and then recreated spfile under direcotry

+DATA/TESTRAC/PARAMETERFILE/spfile.259.858334859

I updated spfile path parameter in initRACTEST1 and initRACTEST2 from

+DATA/TESTRAC/spfile.259.858334859

to
+DATA/TESTRAC/PARAMETERFILE/spfile.259.858334859


but as i started database from

C:\Users\farif> srvctl start database -d ractest

it gave me error that spfile cannot be found. when i checked the initRACTEST1 and 2 on both nodes spfile parameter line is changed again to old path

then i checked database status from using

C:\Users\farif>srvctl config database -d testrac
Database unique name: TESTRAC
Database name: TESTRAC
Oracle home: D:\app\Oracle\product\11.2.0.4.0\dbhome_1
Oracle user: nt authority\system
Spfile: +DATA/TESTRAC/spfileTESTRAC.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: TESTRAC
Database instances: TESTRAC1,TESTRAC2
Disk Groups: DATA,FLASH
Mount point paths:
Services:
Type: RAC
Database is administrator managed

————————————————————————
This is the problem. I changed db configuration and updated spfile path.

C:\Users\farif>srvctl modify database -d testrac -p +DATA/TESTRAC/PARAMETERFILE/spfile.259.858334859

C:\Users\farif>srvctl config database -d testrac
Database unique name: TESTRAC
Database name: TESTRAC
Oracle home: D:\app\Oracle\product\11.2.0.4.0\dbhome_1
Oracle user: nt authority\system
Spfile: +DATA/TESTRAC/PARAMETERFILE/spfile.259.858334859
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: TESTRAC
Database instances: TESTRAC1,TESTRAC2
Disk Groups: DATA,FLASH
Mount point paths:
Services:
Type: RAC
Database is administrator managed

C:\Users\farif>srvctl start database -d testrac

database is started and initTESRAC1 and 2 are not modified this time.

Leave a comment