Here are the steps to do it.
1. Keep the attached file dev001.dbt in $ORACLE_HOME/assistants/dbca/templates
2. Execute the following commands
a) $ export ORACLE_SID=<database name that you want to create>
b) $ cd $ORACLE_HOME/assistants/dbca/templates
c) $ sed s/dev001/$ORACLE_SID/g dev001.dbt > $ORACLE_SID.dbt
d) $ dbca -silent -createDatabase -templateName $ORACLE_SID -gdbName $ORACLE_SID -sid $ORACLE_SID -emConfiguration NONE
All the CRD files will be stored in /u01 location by default. you can modify the attached resposnse file as per your requirement.
Attached file:
Copy this lines to a notepad and save it with the name dev001.dbt
<DatabaseTemplate name="dev001" description="" version="11.2.0.1.0">
<CommonAttributes>
<option name="ISEARCH" value="false"/>
<option name="OMS" value="false"/>
<option name="JSERVER" value="true"/>
<option name="SPATIAL" value="false"/>
<option name="ODM" value="false">
<tablespace id="SYSAUX"/>
</option>
<option name="IMEDIA" value="true"/>
<option name="XDB_PROTOCOLS" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="ORACLE_TEXT" value="false">
<tablespace id="SYSAUX"/>
</option>
<option name="SAMPLE_SCHEMA" value="false"/>
<option name="CWMLITE" value="false">
<tablespace id="SYSAUX"/>
</option>
<option name="EM_REPOSITORY" value="false">
<tablespace id="SYSAUX"/>
</option>
<option name="HTMLDB" value="false"/>
</CommonAttributes>
<Variables/>
<CustomScripts Execute="false"/>
<InitParamAttributes>
<InitParams>
<initParam name="pga_aggregate_target" value="100" unit="MB"/>
<initParam name="sort_area_size" value="10485760"/>
<initParam name="sort_area_retained_size" value="524288"/>
<initParam name="session_max_open_files" value="30"/>
<initParam name="dg_broker_config_file2" value=""/>
<initParam name="dg_broker_config_file1" value=""/>
<initParam name="processes" value="300"/>
<initParam name="control_files" value="("/u01/db001/control_{DB_NAME}_001.dbf", "/u01/db002/control_{DB_NAME}_002.dbf")"/>
<initParam name="sga_target" value="500" unit="MB"/>
<initParam name="timed_statistics" value="TRUE"/>
<initParam name="tape_asynch_io" value="false"/>
<initParam name="streams_pool_size" value="50" unit="MB"/>
<initParam name="sql92_security" value="false"/>
<initParam name="standby_archive_dest" value=""/>
<initParam name="compatible" value="10.2.0.4.0"/>
<initParam name="remote_os_authent" value="false"/>
<initParam name="global_names" value="false"/>
<initParam name="db_writer_processes" value="2"/>
<initParam name="disk_asynch_io" value="false"/>
<initParam name="log_archive_dest" value="/{DB_NAME}/archive001"/>
<initParam name="log_checkpoints_to_alert" value="TRUE"/>
<initParam name="sessions" value="335"/>
<initParam name="background_dump_dest" value="/logs/oracle/{DB_NAME}/system_trace"/>
<initParam name="job_queue_processes" value="3"/>
<initParam name="db_name" value="dev001"/>
<initParam name="dml_locks" value="200"/>
<initParam name="max_dump_file_size" value="10m"/>
<initParam name="user_dump_dest" value="/logs/oracle/{DB_NAME}/user_trace"/>
<initParam name="utl_file_dir" value="/logs/oracle/{DB_NAME}/logs, /logs/oracle/{DB_NAME}/logminer"/>
<initParam name="dispatchers" value=""/>
<initParam name="resource_limit" value="true"/>
<initParam name="log_buffer" value="1048576"/>
<initParam name="audit_file_dest" value="/logs/oracle/{DB_NAME}/audit"/>
<initParam name="shared_pool_reserved_size" value="40" unit="MB"/>
<initParam name="db_domain" value="uprr.com"/>
<initParam name="undo_retention" value="10800"/>
<initParam name="lock_sga" value="FALSE"/>
<initParam name="open_cursors" value="500"/>
<initParam name="db_block_size" value="8" unit="KB"/>
<initParam name="undo_tablespace" value="UNDTS001"/>
<initParam name="core_dump_dest" value="/logs/oracle/{DB_NAME}/system_trace"/>
<initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>
<initParam name="undo_management" value="AUTO"/>
<initParam name="db_files" value="150"/>
<initParam name="db_file_multiblock_read_count" value="16"/>
<initParam name="audit_trail" value="db"/>
<initParam name="standby_file_management" value="MANUAL"/>
<initParam name="_kgl_large_heap_warning_threshold" value="16777216"/>
</InitParams>
<MiscParams>
<databaseType>MULTIPURPOSE</databaseType>
<maxUserConn>20</maxUserConn>
<percentageMemTOSGA>30</percentageMemTOSGA>
<customSGA>true</customSGA>
<characterSet>UTF8</characterSet>
<nationalCharacterSet>AL16UTF16</nationalCharacterSet>
<archiveLogMode>false</archiveLogMode>
<initParamFileName>{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/pfile/init.ora</initParamFileName>
</MiscParams>
<SPfile useSPFile="true">{ORACLE_HOME}/dbs/spfile{SID}.ora</SPfile>
</InitParamAttributes>
<StorageAttributes>
<ControlfileAttributes id="Controlfile">
<maxDatafiles>1024</maxDatafiles>
<maxLogfiles>16</maxLogfiles>
<maxLogMembers>3</maxLogMembers>
<maxLogHistory>1</maxLogHistory>
<maxInstances>8</maxInstances>
<image name="control_{DB_NAME}_001.dbf" filepath="/u01/db001/"/>
<image name="control_{DB_NAME}_002.dbf" filepath="/u01/db002/"/>
</ControlfileAttributes>
<DatafileAttributes id="/u01/db001/sysaux_{DB_NAME}_001.dbf">
<tablespace>SYSAUX</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">501</size>
<reuse>true</reuse>
<autoExtend>false</autoExtend>
<increment unit="KB">10240</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="/u01/db001/system_{DB_NAME}_001.dbf">
<tablespace>SYSTEM</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">625</size>
<reuse>true</reuse>
<autoExtend>false</autoExtend>
<increment unit="KB">10240</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="/u01/db001/tlsts001_{DB_NAME}_001.dbf">
<tablespace>TLSTS001</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">551</size>
<reuse>false</reuse>
<autoExtend>false</autoExtend>
<increment unit="KB">-2</increment>
<maxSize unit="KB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="/u01/db001/tmpts001_{DB_NAME}_001.dbf">
<tablespace>TMPTS001</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">900</size>
<reuse>true</reuse>
<autoExtend>false</autoExtend>
<increment unit="KB">640</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="/u01/db001/undts001_{DB_NAME}_001.dbf">
<tablespace>UNDTS001</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">900</size>
<reuse>true</reuse>
<autoExtend>false</autoExtend>
<increment unit="KB">5120</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="/u01/db001/usrts001_{DB_NAME}_001.dbf">
<tablespace>USRTS001</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">175</size>
<reuse>true</reuse>
<autoExtend>false</autoExtend>
<increment unit="KB">1280</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<TablespaceAttributes id="SYSAUX">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>false</temporary>
<defaultTemp>false</defaultTemp>
<undo>false</undo>
<local>true</local>
<blockSize>-1</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">64</initSize>
<increment unit="KB">64</increment>
<incrementPercent>50</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>4096</maxExtends>
<minExtendsSize unit="KB">64</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="/u01/db001/sysaux_{DB_NAME}_001.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="SYSTEM">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>false</temporary>
<defaultTemp>false</defaultTemp>
<undo>false</undo>
<local>true</local>
<blockSize>-1</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">64</initSize>
<increment unit="KB">64</increment>
<incrementPercent>50</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>-1</maxExtends>
<minExtendsSize unit="KB">64</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="/u01/db001/system_{DB_NAME}_001.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="TLSTS001">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>false</temporary>
<defaultTemp>false</defaultTemp>
<undo>false</undo>
<local>true</local>
<blockSize>-1</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">-1</initSize>
<increment unit="KB">-1</increment>
<incrementPercent>-1</incrementPercent>
<minExtends>-1</minExtends>
<maxExtends>-2</maxExtends>
<minExtendsSize unit="KB">-1</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="/u01/db001/tlsts001_{DB_NAME}_001.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="TMPTS001">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>true</temporary>
<defaultTemp>true</defaultTemp>
<undo>false</undo>
<local>true</local>
<blockSize>-1</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">64</initSize>
<increment unit="KB">64</increment>
<incrementPercent>0</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>0</maxExtends>
<minExtendsSize unit="KB">64</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="/u01/db001/tmpts001_{DB_NAME}_001.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="UNDTS001">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>false</temporary>
<defaultTemp>false</defaultTemp>
<undo>true</undo>
<local>true</local>
<blockSize>-1</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">512</initSize>
<increment unit="KB">512</increment>
<incrementPercent>50</incrementPercent>
<minExtends>8</minExtends>
<maxExtends>4096</maxExtends>
<minExtendsSize unit="KB">512</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="/u01/db001/undts001_{DB_NAME}_001.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="USRTS001">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>false</temporary>
<defaultTemp>false</defaultTemp>
<undo>false</undo>
<local>true</local>
<blockSize>-1</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">128</initSize>
<increment unit="KB">128</increment>
<incrementPercent>0</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>4096</maxExtends>
<minExtendsSize unit="KB">128</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="/u01/db001/usrts001_{DB_NAME}_001.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<RedoLogGroupAttributes id="1">
<reuse>false</reuse>
<fileSize unit="KB">204800</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="log_{DB_NAME}_101.dbf" filepath="/u01/redo001/"/>
<member ordinal="4" memberName="log_{DB_NAME}_102.dbf" filepath="/u01/redo002/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="2">
<reuse>false</reuse>
<fileSize unit="KB">204800</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="log_{DB_NAME}_201.dbf" filepath="/u01/redo001/"/>
<member ordinal="3" memberName="log_{DB_NAME}_202.dbf" filepath="/u01/redo002/"/>
</RedoLogGroupAttributes>
</StorageAttributes>
</DatabaseTemplate>
No comments:
Post a Comment