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 laterInformation in this document applies to any platform.
Symptoms
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": "19.0.0.0",
"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
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 |
| References |