- 26 Oct, 2023
- 0 Comments
- 1 Min Read
How Srvctl Modify Database SPFILE
In this post, we didn’t move the actual SPFILE, we just make a link to redirect it to the actual location.
Follow the below steps :
-
-
1. Make File Alias for Spfile.
-
1 2 3 4 5 6 7 8 9 10 | ASMCMD> cd +DATA/PRIM/PARAMETERFILEASMCMD> ls -lType Redund Striped Time Sys NamePARAMETERFILE UNPROT COARSE OCT 30 14:00:00 Y spfile.271.1055166363ASMCMD> cd ..ASMCMD> mkalias PARAMETERFILE/spfile.271.1055166363 spfileASMCMD> ls -l spfileType Redund Striped Time Sys NamePARAMETERFILE UNPROT COARSE OCT 30 14:00:00 N spfile => +DATA/PRIM/PARAMETERFILE/spfile.271.1055166363ASMCMD> exit |
Modify SFILE Location for Database :
1 | [oracle@node1 ~]$ srvctl modify database -d PRIM -spfile +DATA/PRIM/spfile |
Let’s check the result.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | [oracle@node1 ~]$ srvctl config database -d PRIMDatabase unique name: PRIMDatabase name: PRIMOracle home: /u01/app/oracle/product/19c/db_1Oracle user: oracleSpfile: +DATA/PRIM/spfilePassword file: +DATA/PRIM/pwfileDomain:Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools:Disk Groups: DATAMount point paths:Services:Type: RACStart concurrency:Stop concurrency:OSDBA group: dbaOSOPER group: operDatabase instances: PRIM1Configured nodes: node1CSS critical: noCPU count: 0Memory target: 0Maximum memory: 0Default network number for database services:Database is administrator managed |
Let’s restart the database to verify the new file.
1 2 3 4 5 6 7 8 9 | [oracle@node1 ~]$ srvctl stop database -d PRIM[oracle@node1 ~]$ srvctl start database -d PRIM[oracle@node1 ~]$ sqlplus / as sysdba...SQL> show parameter spfile;NAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string +DATA/PRIM/spfile |
Please Note :
if you want to remove the alias files, don’t use rm, use rmalias command in ASMCMD to remove the links instead.