[VMDB] Scaling down shape failed by DCS-10085, ORA-01078
(Doc ID 2940865.1)
Last updated on APRIL 11, 2023
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and laterInformation in this document applies to any platform.
Symptoms
Scaling down shape from VM.Standard2.16 to VM.Standard2.4 failed by DCS-10085, ORA-01078.
Job details
----------------------------------------------------------------
ID: <job id>
Description: Scale xxx VM from VM.Standard2.16 to VM.Standard2.4 [pre_action]
Status: Failure
Created: April 3, 2023 10:12:07 AM UTC
Progress: 2%
Message: DCS-10085:Database startup failed. xxx - PRCD-1332 : failed to start database xxx
PRCR-1079 : Failed to start resource ora.xxx.db
CRS-5017: The resource action "ora.xxx.db start" encountered the following error:
ORA-01078: failure in pr
Cause: Connection to the database failed
Action: Check connection to the database.
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
task:TaskSequential_74 April 3, 2023 10:12:08 AM UTC April 3, 2023 10:23:31 AM UTC Failure
task:TaskZLockWrapper_75 April 3, 2023 10:12:08 AM UTC April 3, 2023 10:23:31 AM UTC Failure
Update limits conf: xxx April 3, 2023 10:12:08 AM UTC April 3, 2023 10:12:08 AM UTC Success
Open DB if down: xxx: xxx April 3, 2023 10:12:08 AM UTC April 3, 2023 10:23:31 AM UTC Failure
Then implemented startup manually but failed as well.
ORA-00821: Specified value of sga_target 29184M is too small, needs to be at least 67456M
ORA-01078: failure in processing system parameters
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 |