How to move a spfile from ASM to filesystem

Posted on by

First create copy the spfile from ASM to filesystem

ASMCMD> cd DATA/KAKAROTO/PARAMETERFILE
ASMCMD> ls
spfile.286.1075371377
ASMCMD> cp spfile.286.1075371377 /databases/ee/product/18x/dbhome_1/dbs/spfilekakaroto.ora

Update the spfile location in the server config, before

[oracle@node1 dbs]$ srvctl config database -d kakaroto
Database unique name: kakaroto
Database name: kakaroto
Oracle home: /databases/ee/product/18x/dbhome_1
Oracle user: oracle
Spfile: +DATA/KAKAROTO/PARAMETERFILE/spfile.286.1075371377  <---------
Password file: 
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: 
Disk Groups: DATA
Mount point paths: 
Services: 
Type: SINGLE
OSDBA group: oinstall
OSOPER group: oinstall
Database instance: kakaroto
Configured nodes: node1
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services: 
Database is administrator managed

Doping the update

srvctl modify database -d kakaroto -p /databases/ee/product/18x/dbhome_1/dbs/spfilekakaroto.ora

After

[oracle@node1 dbs]$ srvctl config database -d kakaroto
Database unique name: kakaroto
Database name: kakaroto
Oracle home: /databases/ee/product/18x/dbhome_1
Oracle user: oracle
Spfile: /databases/ee/product/18x/dbhome_1/dbs/spfilekakaroto.ora  <---------
Password file: 
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: 
Disk Groups: DATA
Mount point paths: 
Services: 
Type: SINGLE
OSDBA group: oinstall
OSOPER group: oinstall
Database instance: kakaroto
Configured nodes: node1
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services: 
Database is administrator managed