重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 78|回复: 0

[Oracle] DBCA using Database Templete for EM repository returns ORA-1537

[复制链接]
发表于 2024-7-7 17:43:41 | 显示全部楼层 |阅读模式
现象:
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;

回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2024-7-22 13:26 , Processed in 0.095722 second(s), 21 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表