DB Version:11.2.0.4
OS : Oracle Linux 6.6
The CREATE DATABASE command creates the control file.
CREATE DATABASE command is executed once you start the instance in NOMOUNT state as shown below.
SQL > startup nomount pfile=$ORACLE_HOME/dbs/initBRCPRD.ora
SQL > create database "BRCPRD"
maxinstances 32
maxloghistory 1
maxlogfiles 192
maxlogmembers 3
..
.
.
<snipped>
When creating the database manually we can set control_files parameter in the init.ora like below and control file will be created in this location. Right ?
control_files = ("/u01/oradata/BRCPRD/BRCPRD_control01.ctl","/u01/oradata/BRCPRD/BRCPRD_control02.ctl")
When I was generating DB creation scripts using DBCA GUI, it prompted to enter the location for control files and Online redo logs.
I entered my desired location. But, I couldn't find CONTROL_FILES parameter in the init.ora file the DBCA has generated. Hence I got confused. I think DBCA is setting it internally somehow. Hence thought of posting it here.