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="("/oracle/{DB_UNIQUE_NAME}/datafile/control01.ctl", "/oracle/{DB_UNIQUE_NAME}/redo01/control02.ctl")"/>
<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