标题: DBCA using Database Templete for EM repository returns ORA-1537 [打印本页] 作者: 刘泽宇 时间: 2024-7-7 17:43 标题: 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;