My Oracle Support Banner

DBCA Silent Creates Control Files And Online Log Files In Different Locations And Named Differently Than Specified In The Template (Doc ID 2859918.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database Configuration Assistant - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

With the DBCA template configured with:

<DatabaseTemplate name="ora 19.3 dbca template" description="" version="19.0.0.0.0">
...
   <InitParamAttributes>
      <InitParams>
         <initParam name="sga_max_size" value="5368709120"/>
         ...
         <initParam name="db_create_online_log_dest_1" value="/u01/user/ORCLTEST/redo_01/"/>
         <initParam name="db_create_online_log_dest_2" value="/u01/user/ORCLTEST/redo_02/"/>
         <initParam name="log_archive_dest_1" value="LOCATION=/u01/user/ORCLTEST"/>
         <initParam name="log_archive_dest_state_1" value="enable"/>
         <initParam name="log_archive_format" value="ORCLTEST_%t_%s_%r.arc"/>
         <initParam name="log_checkpoint_timeout" value="1800"/>
         <initParam name="log_checkpoints_to_alert" value="TRUE"/>
         <initParam name="processes" value="2000"/>
         <initParam name="shared_pool_reserved_size" value="26843545"/>
         <initParam name="core_dump_dest" value="/u01/user/ORCLTEST/admin"/>
         <initParam name="control_files" value="(&quot;/u01/user/ORCLTEST/redo_01/ORCLTEST_control01.ctl&quot;,&quot;/u01/user/ORCLTEST/redo_02/ORCLTEST_control02.ctl&quot;)"/>
         <initParam name="diagnostic_dest" value="/u01/app/oracle"/>
         <initParam name="audit_trail" value="DB"/>
         ...
      </InitParams>
      <MiscParams>
         ...
      </MiscParams>
      <SPfile useSPFile="true">/u01/app/oracle/product/19.3.0.0/dbs/spfile{SID}.ora</SPfile>
</InitParamAttributes>
<StorageAttributes>
      <ControlfileAttributes id="Controlfile">
         <maxDatafiles>1000</maxDatafiles>
         <maxLogfiles>16</maxLogfiles>
         <maxLogMembers>3</maxLogMembers>
         <maxLogHistory>292</maxLogHistory>
         <maxInstances>8</maxInstances>
         <image name="ORCLTEST_control01.ctl" filepath="/u01/user/ORCLTEST/redo_01/"/>
         <image name="ORCLTEST_control02.ctl" filepath="/u01/user/ORCLTEST/redo_02/"/>
      </ControlfileAttributes>
      ...
      ...
      <RedoLogGroupAttributes id="3">
         <reuse>false</reuse>
         <fileSize unit="KB">512000</fileSize>
         <Thread>1</Thread>
         <member ordinal="0" memberName="ORCLTEST_redo03a.log" filepath="/u01/user/ORCLTEST/redo_01/"/>
         <member ordinal="1" memberName="ORCLTEST_redo03b.log" filepath="/u01/user/ORCLTEST/redo_02/"/>
      </RedoLogGroupAttributes>
    </StorageAttributes>
</DatabaseTemplate>

And DBCA is called with the following parameters:

 

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.