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 laterInformation 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="("/u01/user/ORCLTEST/redo_01/ORCLTEST_control01.ctl","/u01/user/ORCLTEST/redo_02/ORCLTEST_control02.ctl")"/>
<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>
...
<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="("/u01/user/ORCLTEST/redo_01/ORCLTEST_control01.ctl","/u01/user/ORCLTEST/redo_02/ORCLTEST_control02.ctl")"/>
<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 |