My Oracle Support Banner

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 later
Linux 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.