Moving SPFILE from file system to ASM (+DATA)
[oracle@oraasm11g ~]$ srvctl config database -d anuj
Database unique name: anuj
Database name: anuj
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: ------- No spfile in configration
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Database instance: anuj
Disk Groups: DATA
Services:
[oracle@oraasm11g ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Dec 27 19:43:16 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/app/oracle/product/11.2.0
/dbhome_1/dbs/spfileanuj.ora
full path !!
/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileanuj.ora
SQL> create spfile='+DATA' from spfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileanuj.ora'
*
ERROR at line 1:
ORA-00922: missing or invalid option
SQL> create spfile='+DATA' from pfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileanuj.ora'; ----this is not a pfile
create spfile='+DATA' from pfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileanuj.ora'
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00123: invalid character 0 found in the input file
This error was expected !!!! ( there is no command to create from spfile to spfile )
SQL> create pfile from spfile;
File created.
SQL> !ls -ltr /u01/app/oracle/product/11.2.0/dbhome_1/dbs/
total 40
-rw-r--r--. 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r-----. 1 oracle asmadmin 24 Jun 12 2016 lkVIHAAN
-rw-r-----. 1 oracle oinstall 1536 Jun 12 2016 orapwvihaan
-rw-r-----. 1 oracle oinstall 39 Jun 12 2016 initvihaan.ora
-rw-r----- 1 oracle oinstall 1536 Dec 25 16:27 orapwanuj
-rw-r----- 1 oracle oinstall 24 Dec 25 16:28 lkANUJ
-rw-rw---- 1 oracle oinstall 1544 Dec 27 18:59 hc_anuj.dat
-rw-rw----. 1 oracle asmadmin 1544 Dec 27 19:40 hc_vihaan.dat
-rw-r----- 1 oracle oinstall 2560 Dec 27 19:41 spfileanuj.ora
-rw-r--r-- 1 oracle asmadmin 917 Dec 27 19:48 initanuj.ora <<<<<---
Now creating pfile to spfile in diskgroup ...
SQL> create spfile='+DATA' from pfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initanuj.ora' ;
File created.
to check the path !! go to diskgroup
[root@oraasm11g ~]# su - grid
[grid@oraasm11g ~]$ asmcmd -p
ASMCMD [+] > pwd
+
ASMCMD [+] > ls -s
Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
512 4096 1048576 15358 11438 0 11438 0 N DATA/
ASMCMD [+] > cd data
ASMCMD [+data] > ls -s
Block_Size Blocks Bytes Space Name
ANUJ/
ASM/
VIHAAN/
ASMCMD [+data] > cd ANUJ
ASMCMD [+data/ANUJ] > ls -s
Block_Size Blocks Bytes Space Name
BACKUPSET/
CONTROLFILE/
DATAFILE/
ONLINELOG/
PARAMETERFILE/
TEMPFILE/
ASMCMD [+data/ANUJ] > cd PA*
ASMCMD [+data/ANUJ/PARAMETERFILE] > pwd
+data/ANUJ/PARAMETERFILE
ASMCMD [+data/ANUJ/PARAMETERFILE] > ls -s
Block_Size Blocks Bytes Space Name
512 5 2560 1048576 spfile.278.931722561
or
from find command
ASMCMD [+] > find +data sp*
+data/ANUJ/PARAMETERFILE/spfile.278.931722561
su - oracle
[oracle@oraasm11g ~]$ srvctl modify database -d anuj -p +DATA/ANUJ/PARAMETERFILE/spfile.278.931722561
[oracle@oraasm11g ~]$ srvctl config database -d anuj
Database unique name: anuj
Database name: anuj
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/ANUJ/PARAMETERFILE/spfile.278.931722561
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Database instance: anuj
Disk Groups: DATA
Services:
===============
http://anuj-singh.blogspot.com/2023/ --- Oracle Create spfile from memory
