My Oracle Support Banner

ExaCS|ExaCC: DB provisioning fails with "Failed to create USER C##CLOUD$SERVICE in CDB" (Doc ID 2790270.1)

Last updated on NOVEMBER 16, 2022

Applies to:

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



Customer is creating a DB using dbaasapi and it fails with "Failed to create USER C##CLOUD$SERVICE in CDB" during TDE execution

input json file:

"object": "db",
"action": "start",
"operation": "createdb",
"params": {
"nodelist": "node1 node2",
"dbname": "TESTCTR6",
"edition": "EE_EP",
"version": "",
"adminPassword": "***,
"sid": "TESTCTR6",
"pdbName": "TESTPDB6",
"charset": "AL32UTF8",
"ncharset": "AL16UTF16",
"backupDestination": "NONE",
"cloudStorageContainer": "",
"cloudStorageUser": "",
"cloudStoragePwd": ""
"outputfile": "/home/oracle/output/createdb_TESTCTR6.out",
"FLAGS": ""

 Error seen in /var/opt/oracle/<dbname>/tde/tde_<timestamp>.log


21-06-24 00:29:45.883605 - USER C##CLOUD$SERVICE does not exist in the CDB. <<<<<
Trying to create it
2021-06-24 00:29:46.643800 - DEBUG: SQL Executing set hea off set pagesize
5000 set linesize 400 set newpage none set feedback off set define off set
verify off prompt =START= grant sysoper,sysdba,dba,all privileges to
C##CLOUD$SERVICE identified by "********" container=all; quit
2021-06-24 00:29:47.401666 - Error Pushed:
2021-06-24 00:29:47.401991 - Failed to create USER C##CLOUD$SERVICE in CDB <<<<
2021-06-24 00:29:47.402309 - Error Pushed:
2021-06-24 00:29:47.402447 - Prereq checks for PDB creation failed





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

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