My Oracle Support Banner

DB provisioning fails on existing home:ORA-01804,but succeeds from new home with same RU. (Doc ID 2911014.1)

Last updated on APRIL 29, 2024

Applies to:

Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A to N/A
Information in this document applies to any platform.


DB provisioning on an existing home with other running databases, fails with the following error in dbda execution


2022-10-17 08:50:04.585146 - DEBUG: SQL Executing set hea off set pagesize 5000 set linesize 400 set feedback off alter system set encrypt_new_tablespaces=dd
l; create temporary tablespace temp1 tempfile size 100m; alter database default temporary tablespace temp1; shutdown abort; startup; alter system set encrypt
_new_tablespaces=ddl; drop tablespace temp INCLUDING CONTENTS AND DATAFILES; create bigfile temporary tablespace temp tempfile '+DATAC1/cp1xyz/TEMPFILE/temp'
size 1000M autoextend on next 16g maxsize 512g; alter database default temporary tablespace temp; select name from v$tempfile; create spfile='+DATAC1/cp1xyz
/spfilecp1xyz.ora' from pfile='/u02/app/oracle/product/'; quit
2022-10-17 08:50:40.242869 - ORACLE instance shut down.
ORACLE instance started.

Total System Global Area 7969176000 bytes
Fixed Size 9157056 bytes
Variable Size 1409286144 bytes
Database Buffers 6476005376 bytes
Redo Buffers 74727424 bytes
Database mounted.
Database opened.
ERROR at line 1:
ORA-04088: error during execution of trigger 'SYS.DELETE_ENTRIES'
ORA-00604: error occurred at recursive SQL level 1
ORA-01804: failure to initialize timezone information


+ As a test, customer tried provisioning a new home with same RU and tried provisioning a database in it and it succeeds.


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.