My Oracle Support Banner

Create Pluggable Database creation from OCI console failed with DCS-10115 after database upgrade to 19c. (Doc ID 2800331.1)

Last updated on AUGUST 27, 2021

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

The Create Pluggable Database from OCI console failed after the database is upgraded from 12c to 19c.

dbcli describe-job -i d6cfa381-e3ff-41b5-a9eb-544ff31024f7

Job details
----------------------------------------------------------------
ID: d6cfa381-e3ff-41b5-a9eb-544ff31024f7
Description: Create Pluggable Database :PDBTEST in database:DB0806
Status: Failure
Created: August 6, 2021 6:08:20 PM UTC
Progress: 98%
Message: DCS-10115:Failed to run sql in method : encryptTablespacesFailed to encrypt tablespace(s): [SYSTEM,
SYSAUX]Error:
Session altered.

ALTER TABLESPACE "SYSTEM" encryption encrypt
*
ERROR at line 1:
ORA-00406: COMPATIBLE parameter needs to be 12.2.0.0
Cause: An attempt to execute a query in the database failed
Action: Evaluate the cause and action for error and contact Oracle Support Services for assistance if the problem is still not resolved.

Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
task:TaskServiceRequest_2728 August 6, 2021 6:08:21 PM UTC August 6, 2021 6:09:48 PM UTC Failure
task:TaskSequential_2729 August 6, 2021 6:08:21 PM UTC August 6, 2021 6:09:48 PM UTC Failure
Create pluggable Database:PDBTEST August 6, 2021 6:08:21 PM UTC August 6, 2021 6:09:39 PM UTC SuccessWithWarning
Configure init params August 6, 2021 6:09:39 PM UTC August 6, 2021 6:09:41 PM UTC Success
Encrypt all tablespaces if 19.6 or higher db version August 6, 2021 6:09:41 PM UTC August 6, 2021 6:09:48 PM UTC Failure

 

Changes

 The database is upgrade to 19c from the OCI console 

[root@orl12 ~]# dbcli list-jobs

ID Description Created Status
---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------

81cc4322-b896-4059-a163-d56e016482f0 Database upgrade precheck with dbResId : e2a6150f-3b5c-448e-aef2-9a304d533dd2 Friday, August 06, 2021, 13:54:58 UTC Success
4e8f890b-2cd1-47dd-8562-c00b26dbaed0 Database upgrade with resource Id : e2a6150f-3b5c-448e-aef2-9a304d533dd2 Friday, August 06, 2021, 14:03:36 UTC Success

 

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


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