My Oracle Support Banner

EM 13c : PDBaaS Is Failing With Error : "Exception occured while creating tablespaces" (Doc ID 2732389.1)

Last updated on AUGUST 30, 2021

Applies to:

Enterprise Manager for Cloud - Version and later
Information in this document applies to any platform.


Use case :

1) Create a non-CDB 12.2 database to use as source database.
2) Create a CDB 19.8 to use as destination database
3) Create a temporary tablespace TEMP1 (not TEMP) in source database
4) Make TEMP1 the default temporary tablespace in source database
5) Create a USER that has TEMP1 as their temporary tablespace in source database
6) Create Database Provisioning Profile from Full Export of source of source database
7) Create a Service Template using above profile created in step 6)

6) Deploy PDB fails with the below error during tablespace creation.

Deployment Procedure logs:

Tablespace Creation
Tablespace Name: TEMP1
About to create the tablespace...
The data file location used will be the same as the one configured for SYSTEM tablespace...
About to fetch the data file location of the SYSTEM tablespace...
The SYSTEM tablespace's data file is: <DB_HOME>/oradata/DBT/testtmp/system01.dbf
The data file location that will be used for tablespace creation is: <DB_HOME>/oradata/testtmp
query: ExpressionEvaluationException: Below error message was returned while executing this Computational step.
Exception occured while creating tablespaces.


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.