Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is there anyway to create a database with dbca(silent mode) without installing all of the spatial, i

HesipesiSep 2 2020 — edited Sep 10 2020

Hi,

I'm trying to do a silent mode installation of oracle 19c and i just don't want to include many of the oracle features which are listed in (select * from dba_registry) like spatial or oracle_text,etc...

Even thought I mark them as FALSE in my template file they get installed anyway!!!!!

Is there a way to not just install them here in dbca silent?!?!

here is the part of the template file I'm changing to false:

   <CommonAttributes>

      <option name="OMS" value="true" includeInPDBs="true"/>

      <option name="JSERVER" value="true" includeInPDBs="true"/>

      <option name="SPATIAL" value="false" includeInPDBs="false"/>

      <option name="IMEDIA" value="false" includeInPDBs="false"/>

      <option name="ORACLE_TEXT" value="false" includeInPDBs="false">

         <tablespace id="SYSAUX"/>

      </option>

      <option name="SAMPLE_SCHEMA" value="false" includeInPDBs="false"/>

      <option name="CWMLITE" value="true" includeInPDBs="true">

         <tablespace id="SYSAUX"/>

      </option>

      <option name="APEX" value="false" includeInPDBs="false"/>

      <option name="DV" value="true" includeInPDBs="true"/>

   </CommonAttributes>

to make sure you understand my problem i copy both my dbca command and the template file here:

dbca_template_1.dbc file is:

*********

<?xml version = '1.0'?>

<DatabaseTemplate name="dbca_template_1" description="" version="19.0.0.0.0">

   <CommonAttributes>

      <option name="OMS" value="true" includeInPDBs="true"/>

      <option name="JSERVER" value="true" includeInPDBs="true"/>

      <option name="SPATIAL" value="false" includeInPDBs="false"/>

      <option name="IMEDIA" value="false" includeInPDBs="false"/>

      <option name="ORACLE_TEXT" value="false" includeInPDBs="false">

         <tablespace id="SYSAUX"/>

      </option>

      <option name="SAMPLE_SCHEMA" value="false" includeInPDBs="false"/>

      <option name="CWMLITE" value="true" includeInPDBs="true">

         <tablespace id="SYSAUX"/>

      </option>

      <option name="APEX" value="false" includeInPDBs="false"/>

      <option name="DV" value="true" includeInPDBs="true"/>

   </CommonAttributes>

   <Variables/>

   <CustomScripts Execute="false"/>

   <InitParamAttributes>

      <InitParams>

         <initParam name="db_name" value="TEST"/>

         <initParam name="db_unique_name" value="TEST_A1"/>

         <initParam name="audit_file_dest" value="/opt/oracle/admin/{DB_UNIQUE_NAME}/adump"/>

         <initParam name="compatible" value="19.0.0"/>

         <initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>

         <initParam name="sga_target" value="38460" unit="MB"/>

         <initParam name="processes" value="600"/>

         <initParam name="local_listener" value="LISTENER_TEST"/>

         <initParam name="undo_tablespace" value="UNDOTBS1"/>

         <initParam name="control_files" value="(&quot;/oracle/{DB_UNIQUE_NAME}/datafile/control01.ctl&quot;, &quot;/oracle/{DB_UNIQUE_NAME}/redo01/control02.ctl&quot;)"/>

         <initParam name="diagnostic_dest" value="/opt/oracle"/>

         <initParam name="db_recovery_file_dest" value="/oracle/flash"/>

         <initParam name="audit_trail" value="db"/>

         <initParam name="log_archive_format" value="%t_%s_%r.arc"/>

         <initParam name="nls_territory" value="AMERICA"/>

         <initParam name="db_block_size" value="8192"/>

         <initParam name="open_cursors" value="400"/>

         <initParam name="nls_language" value="AMERICAN"/>

         <initParam name="db_recovery_file_dest_size" value="1900" unit="GB"/>

         <initParam name="pga_aggregate_target" value="12821" unit="MB"/>

      </InitParams>

      <MiscParams>

         <databaseType>MULTIPURPOSE</databaseType>

         <maxUserConn>20</maxUserConn>

         <percentageMemTOSGA>40</percentageMemTOSGA>

         <customSGA>false</customSGA>

         <dataVaultEnabled>false</dataVaultEnabled>

         <characterSet>WE8ISO8859P15</characterSet>

         <nationalCharacterSet>UTF8</nationalCharacterSet>

         <archiveLogMode>true</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>

      <DataFiles>

         <SourceDBName cdb="true">seeddata</SourceDBName>

         <Name id="3" Tablespace="SYSAUX" Contents="PERMANENT" Size="400" autoextend="true" blocksize="8192" con_id="1">/oracle/{DB_UNIQUE_NAME}/datafile/sysaux01.dbf</Name>

         <Name id="1" Tablespace="SYSTEM" Contents="PERMANENT" Size="880" autoextend="true" blocksize="8192" con_id="1">/oracle/{DB_UNIQUE_NAME}/datafile/system01.dbf</Name>

         <Name id="4" Tablespace="UNDOTBS1" Contents="UNDO" Size="25" autoextend="true" blocksize="8192" con_id="1">/oracle/{DB_UNIQUE_NAME}/datafile/undotbs01.dbf</Name>

         <Name id="7" Tablespace="USERS" Contents="PERMANENT" Size="5" autoextend="true" blocksize="8192" con_id="1">/oracle/{DB_UNIQUE_NAME}/datafile/users01.dbf</Name>

      </DataFiles>

      <TempFiles>

         <Name id="1" Tablespace="TEMP" Contents="TEMPORARY" Size="20" con_id="1">/oracle/{DB_UNIQUE_NAME}/datafile/temp01.dbf</Name>

      </TempFiles>

      <ControlfileAttributes id="Controlfile">

         <maxDatafiles>100</maxDatafiles>

         <maxLogfiles>16</maxLogfiles>

         <maxLogMembers>3</maxLogMembers>

         <maxLogHistory>1</maxLogHistory>

         <maxInstances>8</maxInstances>

         <image name="control01.ctl" filepath="/oracle/{DB_UNIQUE_NAME}/datafile/"/>

         <image name="control02.ctl" filepath="/oracle/{DB_UNIQUE_NAME}/redo01/"/>

      </ControlfileAttributes>

      <RedoLogGroupAttributes id="1">

         <reuse>false</reuse>

         <fileSize unit="KB">512000</fileSize>

         <Thread>1</Thread>

         <member ordinal="0" memberName="redo01a.log" filepath="/oracle/{DB_UNIQUE_NAME}/redo01/"/>

         <member ordinal="0" memberName="redo01b.log" filepath="/oracle/{DB_UNIQUE_NAME}/redo02/"/>

      </RedoLogGroupAttributes>

      <RedoLogGroupAttributes id="2">

         <reuse>false</reuse>

         <fileSize unit="KB">512000</fileSize>

         <Thread>1</Thread>

         <member ordinal="0" memberName="redo02a.log" filepath="/oracle/{DB_UNIQUE_NAME}/redo01/"/>

         <member ordinal="0" memberName="redo02b.log" filepath="/oracle/{DB_UNIQUE_NAME}/redo02/"/>

      </RedoLogGroupAttributes>

      <RedoLogGroupAttributes id="3">

         <reuse>false</reuse>

         <fileSize unit="KB">512000</fileSize>

         <Thread>1</Thread>

         <member ordinal="0" memberName="redo03a.log" filepath="/oracle/{DB_UNIQUE_NAME}/redo01/"/>

         <member ordinal="0" memberName="redo03b.log" filepath="/oracle/{DB_UNIQUE_NAME}/redo02/"/>

      </RedoLogGroupAttributes>

   </StorageAttributes>

</DatabaseTemplate>

**********

dbca -silent -createDatabase -templateName dbca_template_1.dbc -gdbname TEST_A1 -sid TEST -responseFile NO_VALUE -characterSet WE8ISO8859P15 -nationalCharacterSet AL16UTF16 -sysPassword abc -systemPassword abc -createAsContainerDatabase false -pdbAdminPassword abc -memoryMgmtType auto_sga -databaseType MULTIPURPOSE -archiveLogMode auto -enableArchive true -useOMF false -datafileDestination /oracle/TEST_A1/oradata/ -emConfiguration NONE -ignorePreReqs

I appreciate your answers!

Thanks!

/Hesipesi

Comments
Post Details
Added on Sep 2 2020
5 comments
2,359 views