The change shape of OCI VMDB system failed to Update DB Parameters for db: XXXX
(Doc ID 2701416.1)
Last updated on AUGUST 17, 2020
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A to N/A [Release 1.0]Information in this document applies to any platform.
Symptoms
The change shape of OCI VMDB system failed to Update DB Parameters for db: XXXX
ID Description Created Status
---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------
235c1290-ceda-4d06-aa39-3e135d778baf Scale VM from VM.Standard2.1 to VM.Standard2.4 [pre_action] August 5, 2020 8:47:42 AM BRT Success
27f21010-3363-4167-aa1a-45f2877e7c20 Scale VM from VM.Standard2.4 to VM.Standard2.4 [post_action] August 5, 2020 9:00:19 AM BRT Failure
dbcli describe-job -i 27f21010-3363-4167-aa1a-45f2877e7c20
Job details
----------------------------------------------------------------
ID: 27f21010-3363-4167-aa1a-45f2877e7c20
Description: Scale VM from VM.Standard2.4 to VM.Standard2.4 [post_action]
Status: Failure
Created: August 5, 2020 9:00:19 AM BRT
Progress: 50%
Message: DCS-10001:Internal error encountered: Unable to update Db params.
Task Name Start Time End Time Status
----------------------------------------- -- ----------------------------------- ----------------------------------- ----------
task:TaskSequential_58 August 5, 2020 9:00:20 AM BRT August 5, 2020 9:03:11 AM BRT Failure
task:TaskZLockWrapper_59 August 5, 2020 9:00:20 AM BRT August 5, 2020 9:03:11 AM BRT Failure
Open DB if down: DB0815 August 5, 2020 9:00:20 AM BRT August 5, 2020 9:03:04 AM BRT Success
ReConfiguring HugePage August 5, 2020 9:03:04 AM BRT August 5, 2020 9:03:04 AM BRT Success
Update DB Parameters for db: DB0815 August 5, 2020 9:03:05 AM BRT August 5, 2020 9:03:11 AM BRT Failure
From the DCS agent log file
2020-08-05 09:03:06,504 DEBUG [Update DB Parameters for db: DB0815 : JobId=27f21010-3363-4167-aa1a-45f2877e7c20] [] c.o.d.c.u.CommonsUtils:
ALTER SYSTEM SET STREAMS_POOL_SIZE = 0 sid='DB0815' ;
2020-08-05 09:03:06,504 DEBUG [Update DB Parameters for db: DB0815 : JobId=27f21010-3363-4167-aa1a-45f2877e7c20] [] c.o.d.c.u.CommonsUtils:
exit ;
2020-08-05 09:03:06,505 DEBUG [Update DB Parameters for db: DB0815 : JobId=27f21010-3363-4167-aa1a-45f2877e7c20] [] c.o.d.c.u.CommonsUtils:
run: cmd= '[su,
-,
oracle,
-c,
export NLS_LANG=AMERICAN;
export ORACLE_SID=DB0815;
export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1;
export ORACLE_UNQNAME=cdbprd01_gru134;
/u01/app/oracle/product/19.0.0.0/dbhome_1/bin/sqlplus -S -L -n / as sysdba @ /tmp/dcsserver/sqlplus/sqlplus2020-08-05_09-03-06-7340316292476530511.sql]'
2020-08-05 09:03:11,076 DEBUG [Update DB Parameters for db: DB0815 : JobId=27f21010-3363-4167-aa1a-45f2877e7c20] [] c.o.d.c.u.c.CommandExecutor: Return code: 0
2020-08-05 09:03:11,077 DEBUG [Update DB Parameters for db: DB0815 : JobId=27f21010-3363-4167-aa1a-45f2877e7c20] [] c.o.d.c.u.CommonsUtils: Output :
ALTER SYSTEM SET SHARED_POOL_SIZE = 0 sid='DB0815'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-04034: unable to shrink pool to specified size
System altered.
System altered.
ALTER SYSTEM SET DB_CACHE_SIZE = 0 sid='DB0815'
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-00383: DEFAULT cache for blocksize 8192 cannot be reduced to zero
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |