Hi,
using oracle VM, oracle linux 6, oracle Database EE 12.2 + rac+ encryption + tuning .
I have a database where spfile is in ASM:
SQL> show parameter sga_target
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_target big integer 2G
create pfile='/home/oracle/eztest.txt' from spfile;
srvctl stop database -d EZTESTRUIS
edit file, set
*.sga_target=448m
(and divide all memory requirements by 5)
=>
SQL> create spfile from pfile='/home/oracle/eztest.txt';
File created.
srvctl start database -d EZTESTRUIS
SQL> show parameter sga_target
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_target big integer 2G
A new spfile is created under $ORACLE_HOME/dbs/spfile{sid}.ora. The ASM spfile is NOT updated.
Any command to put it in ASM?????
I tried:
SQL> create spfile='+DATASLOW/EZTEST/PARAMETERFILE/spfile.346.1004709899' from pfile='/home/oracle/eztest.txt';
create spfile='+DATASLOW/EZTEST/PARAMETERFILE/spfile.346.1004709899' from pfile='/home/oracle/eztest.txt'
*
ERROR at line 1:
ORA-32002: cannot create SPFILE already being used by the instance
[oracle@oravmrac02 ~]$ srvctl stop database -d EZTESTRUIS
SQL> create spfile='+DATASLOW/EZTEST/PARAMETERFILE/spfile.346.1004709899' from pfile='/home/oracle/eztest.txt';
create spfile='+DATASLOW/EZTEST/PARAMETERFILE/spfile.346.1004709899' from pfile='/home/oracle/eztest.txt'
*
ERROR at line 1:
ORA-17502: ksfdcre:4 Failed to create file
+DATASLOW/EZTEST/PARAMETERFILE/spfile.346.1004709899
ORA-15046: ASM file name '+DATASLOW/EZTEST/PARAMETERFILE/spfile.346.1004709899'
is not in single-file creation form
SQL> create spfile='+DATASLOW' from pfile='/home/oracle/eztest.txt';
create spfile='+DATASLOW' from pfile='/home/oracle/eztest.txt'
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 0
Session ID: 0 Serial number: 0