DBCS: VMBM - DCS-10121:Shape scaling operation cannot proceed due to DB instance XXXXX start/mount failure
(Doc ID 2853349.1)
Last updated on AUGUST 10, 2023
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and laterLinux x86-64
Symptoms
Shape change failed
# dbcli describe-job -i 5e41bb9e-04f8-4f68-ae26-caefde5b0339
Job details
----------------------------------------------------------------
ID: 5e41bb9e-04f8-4f68-ae26-caefde5b0339
Description: Scale ftscondg1 VM from VM.Standard2.4 to VM.Standard2.2 [pre_action]
Status: Failure
Created: February 23, 2022 3:04:26 PM EST
Progress: 3%
Message: DCS-10121:Shape scaling operation cannot proceed due to DB instance <DB_NAME> start/mount failure.
Manually start the DB before retry. DB start message was: PRCR-1004 : Resource ora.<db_unique_name>.db is already running
PRCR-1079 : Failed to start resource ora.<db_unique_name>.db
Cause: Database instance is down and unable to start.
Action: Manually start the Database instance before retry.
$ srvctl status database -d $ORACLE_UNQNAME -v
Instance <db_name> is running on node <hostname>. Instance status: Open,Readonly.
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string <db_name>
db_unique_name string <db_unique_name>
INSTANCE_NAME HOST_NAME STATUS STARTUP_TIME OPEN_MODE DATABASE_ROLE
-------------------- ---------------- -------- ------------------------ ------------------------------ ----------------------
<instance_name> <hostname> OPEN 23-FEB-2022 16:13 READ ONLY WITH APPLY PHYSICAL STANDBY <<--------------
$ srvctl config database -d $ORACLE_UNQNAME -all
Database unique name: <db_unique_name>
Database name: <db_name>
Oracle home: /u01/app/oracle/product/19.0.0.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/<db_unique_name>/PARAMETERFILE/spfile.267.1094902707
Password file:
Domain: subnet.vcn.oraclevcn.com
Start options: open
Stop options: immediate
Database role: PRIMARY <<--------------
Management policy: AUTOMATIC
Server pools:
Disk Groups: RECO,DATA
Mount point paths:
Services:
Type: SINGLE
Database is enabled
Database is individually enabled on nodes:
Database is individually disabled on nodes:
OSDBA group: dba
OSOPER group: dbaoper
Database instance: <db_name>
Configured nodes: <hostname>
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
Changes
The database is a Physical Standby and was created manually within a normal DB System, not by enabling a Dataguard via UI Console.
There isn't Dataguard Association
# dbcli list-dataguardstatus
DCS-10032:Resource dg config is not found.
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 |
Changes |
Cause |
Solution |
References |