DBCA using Database Templete for EM repository returns ORA-1537

刘泽宇

现象：
On : 19.3.0.0.0 version, Database Assistant

DBCA using Database Templete for EM repository returns ORA-1537.

Download the following Database Templete.
Database Template (with EM 13.5.0.0.0 repository pre-configured)
19.11 PDB Templates
19_11_0_0_0_Database_Template_with_cdbpdb_for_EM13_5_0_0_0_Small_deployment

After ORA-1537, Database creation ended with "continue".
But  TEMP tablespace of PDB has no tempfiles.

ERROR
-----------------------
ORA-01537


改动：
Create Database of EM repository with Database templete from Oracle provided.

原因：
Bug:31145525 DBCA FAILED TO CREATE DB USING DB TEMPLATE WITH ERROR ORA-01537

DBCA executes ALTER TABLESPACE TEMP ADD TEMPFILE '/.../oradata/EMREP/<EMREPPDB>/temp01.dbf' for PDB$SEED.
This is incorrect operation. It should be  ALTER TABLESPACE TEMP ADD TEMPFILE '/.../oradata/pdbseed/<EMREPPDB>/temp01.dbf'
After this operation, DBCA executes ALTER TABLESPACE TEMP ADD TEMPFILE '/.../oradata/EMREP/<EMREPPDB>/temp01.dbf' for EMREP PDB.
The file path is same, so ORA-1537 occurs.

This bug fixed in RU 19.13.


处理方法：
Apply RU 19.13 later, and execute DBCA.


If you already executed DBCA on 19.3 and error occurred, the following steps:

1. Confirm  PDB$SEED's TEMPFILE.
You can see wrong path of TEMPFILE

alter session set container=pdb$seed;
select * from v$tempfile;

2. Connect to PDB$SEED, and add new TEMPFILE and drop old TEMPFILE.

alter session set container=pdb$seed;
select * from v$tempfile;
alter tablespace temp add tempfile '/.../oradata/<EMREP>/pdbseed/temp01.dbf' SIZE 38912K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED;
alter tablespace temp drop tempfile '/.../oradata/<EMREP>/<EMREP PDBNAME>/temp01.dbf';
select * from v$tempfile;


3. Connect to PDB EMREP and add new TEMPFILE.

alter session set container=<EMREP PDB>;
select * from v$tempfile;
alter tablespace temp add tempfile '/app/oracle/oradata/EMREP/EMPDBREPOS/temp01.dbf' SIZE 38912K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED;
select * from v$tempfile;