Install Oracle software, run netca and dbca without gui (silent option)
From dbawiki
- Pythian
- Create a database - manually / dbca / templated - Oracle Corp.
- Manually Creating a RAC Database ( RAC Database Creation without DBCA)
Contents
- 1 Install the software
- 2 Create the listener and tns entries (netca)
- 3 Create a template from an existing database
- 4 Create the database (dbca)
- 5 Release 11, shared binaries, custom sga, custom variables
- 6 Release 11, dedicated binaries
- 7 Release 11, shared binaries
- 8 Create RAC database on ASM for Enterprise Manager Repository (OMR) using silent option
- 9 Install Oracle 12c software with dedicated binaries
- 10 Release 12, shared binaries
- 11 Fully automated version
Install the software[edit]
Prerequisites[edit]
- create oraInst.loc file
On Solaris, it should be created in /var/opt/oracle. On AIX, Linux, etc., it should be created in /etc
Here we are keeping one inventory per home...
vi /var/opt/oracle/oraInst.loc.TDPOTEST inventory_loc=/oracle/product/11.2.0.1/oraInventory inst_group=dba cp /var/opt/oracle/oraInst.loc.TDPOTEST /var/opt/oracle/oraInst.loc
Another way is create the oraInst.loc inside the ORACLE_HOME
vi $ORACLE_HOME/oraInst.loc inventory_loc=/oracle/product/11.2.0.4/oraInventory inst_group=dba
Create a response file[edit]
Use one of the predefined .rsp files in [stage]/database/response or copy, paste and modify this one for 11.2.0.1 (shared product code, Enterprise Edition)...
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 oracle.install.option=INSTALL_DB_SWONLY ORACLE_HOSTNAME=egnim UNIX_GROUP_NAME=dba INVENTORY_LOCATION=/oracle/product/11.2.0.1/ SELECTED_LANGUAGES=all_langs ORACLE_HOME=/oracle/product/11.2.0.1 ORACLE_BASE=/oracle/product oracle.install.db.InstallEdition=EE oracle.install.db.isCustomInstall=false oracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11.2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms.partitioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1.0,oracle.rdbms.rat:11.2.0.1.0 oracle.install.db.DBA_GROUP=dba oracle.install.db.OPER_GROUP=dba oracle.install.db.CLUSTER_NODES= oracle.install.db.config.starterdb.type= oracle.install.db.config.starterdb.globalDBName= oracle.install.db.config.starterdb.SID= oracle.install.db.config.starterdb.characterSet= oracle.install.db.config.starterdb.memoryOption=true oracle.install.db.config.starterdb.memoryLimit= oracle.install.db.config.starterdb.installExampleSchemas=false oracle.install.db.config.starterdb.enableSecuritySettings=true oracle.install.db.config.starterdb.password.ALL= oracle.install.db.config.starterdb.password.SYS= oracle.install.db.config.starterdb.password.SYSTEM= oracle.install.db.config.starterdb.password.SYSMAN= oracle.install.db.config.starterdb.password.DBSNMP= oracle.install.db.config.starterdb.control=DB_CONTROL oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL= oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false oracle.install.db.config.starterdb.dbcontrol.emailAddress= oracle.install.db.config.starterdb.dbcontrol.SMTPServer= oracle.install.db.config.starterdb.automatedBackup.enable=false oracle.install.db.config.starterdb.automatedBackup.osuid= oracle.install.db.config.starterdb.automatedBackup.ospwd= oracle.install.db.config.starterdb.storageType= oracle.install.db.config.starterdb.fileSystemStorage.dataLocation= oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation= oracle.install.db.config.asm.diskGroup= oracle.install.db.config.asm.ASMSNMPPassword= MYORACLESUPPORT_USERNAME= MYORACLESUPPORT_PASSWORD= SECURITY_UPDATES_VIA_MYORACLESUPPORT= DECLINE_SECURITY_UPDATES=true PROXY_HOST= PROXY_PORT= PROXY_USER= PROXY_PWD=
Here's one for 11.2.0.4 (dedicated product code, Enterprise Edition)...
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 oracle.install.option=INSTALL_DB_SWONLY ORACLE_HOSTNAME=solax002 UNIX_GROUP_NAME=dba INVENTORY_LOCATION=/oracle/QN7/product/11.2.0.4/ SELECTED_LANGUAGES=all_langs ORACLE_HOME=/oracle/product/11.2.0.4 ORACLE_BASE=/oracle/product oracle.install.db.InstallEdition=EE oracle.install.db.EEOptionsSelection=false oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.dv:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0 oracle.install.db.DBA_GROUP=dba oracle.install.db.OPER_GROUP=dba oracle.install.db.CLUSTER_NODES= oracle.install.db.isRACOneInstall= oracle.install.db.racOneServiceName= oracle.install.db.config.starterdb.type= oracle.install.db.config.starterdb.globalDBName= oracle.install.db.config.starterdb.SID= oracle.install.db.config.starterdb.characterSet= oracle.install.db.config.starterdb.memoryOption=true oracle.install.db.config.starterdb.memoryLimit= oracle.install.db.config.starterdb.installExampleSchemas=false oracle.install.db.config.starterdb.enableSecuritySettings=true oracle.install.db.config.starterdb.password.ALL= oracle.install.db.config.starterdb.password.SYS= oracle.install.db.config.starterdb.password.SYSTEM= oracle.install.db.config.starterdb.password.SYSMAN= oracle.install.db.config.starterdb.password.DBSNMP= oracle.install.db.config.starterdb.control=DB_CONTROL oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL= oracle.install.db.config.starterdb.automatedBackup.enable=false oracle.install.db.config.starterdb.automatedBackup.osuid= oracle.install.db.config.starterdb.automatedBackup.ospwd= oracle.install.db.config.starterdb.storageType= oracle.install.db.config.starterdb.fileSystemStorage.dataLocation= oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation= oracle.install.db.config.asm.diskGroup= oracle.install.db.config.asm.ASMSNMPPassword= MYORACLESUPPORT_USERNAME= MYORACLESUPPORT_PASSWORD= SECURITY_UPDATES_VIA_MYORACLESUPPORT= DECLINE_SECURITY_UPDATES=true PROXY_HOST= PROXY_PORT= PROXY_USER= PROXY_PWD= PROXY_REALM= COLLECTOR_SUPPORTHUB_URL= oracle.installer.autoupdates.option= oracle.installer.autoupdates.downloadUpdatesLoc= AUTOUPDATES_MYORACLESUPPORT_USERNAME= AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
One for 11.2.0.4.(Standard Edition)[edit]
#################################################################### ## Copyright(c) Oracle Corporation 1998, 2013. All rights reserved.## ## ## ## Specify values for the variables listed below to customize ## ## your installation. ## ## ## ## Each variable is associated with a comment. The comment ## ## can help to populate the variables with the appropriate ## ## values. ## ## ## ## IMPORTANT NOTE: This file contains plain text passwords and ## ## should be secured to have read permission only by oracle user ## ## or db administrator who owns this installation. ## ## ## #################################################################### #------------------------------------------------------------------------------- # Do not change the following system generated value. #------------------------------------------------------------------------------- oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 #------------------------------------------------------------------------------- # Specify the installation option. # It can be one of the following: # - INSTALL_DB_SWONLY # - INSTALL_DB_AND_CONFIG # - UPGRADE_DB #------------------------------------------------------------------------------- oracle.install.option=INSTALL_DB_SWONLY #------------------------------------------------------------------------------- # Specify the hostname of the system as set during the install. It can be used # to force the installation to use an alternative hostname rather than using the # first hostname found on the system. (e.g., for systems with multiple hostnames # and network interfaces) #------------------------------------------------------------------------------- ORACLE_HOSTNAME=solax124 #------------------------------------------------------------------------------- # Specify the Unix group to be set for the inventory directory. #------------------------------------------------------------------------------- UNIX_GROUP_NAME=dba #------------------------------------------------------------------------------- # Specify the location which holds the inventory files. # This is an optional parameter if installing on # Windows based Operating System. #------------------------------------------------------------------------------- INVENTORY_LOCATION=/oracle/oraInventory #------------------------------------------------------------------------------- # Specify the languages in which the components will be installed. # # en : English ja : Japanese # fr : French ko : Korean # ar : Arabic es : Latin American Spanish # bn : Bengali lv : Latvian # pt_BR: Brazilian Portuguese lt : Lithuanian # bg : Bulgarian ms : Malay # fr_CA: Canadian French es_MX: Mexican Spanish # ca : Catalan no : Norwegian # hr : Croatian pl : Polish # cs : Czech pt : Portuguese # da : Danish ro : Romanian # nl : Dutch ru : Russian # ar_EG: Egyptian zh_CN: Simplified Chinese # en_GB: English (Great Britain) sk : Slovak # et : Estonian sl : Slovenian # fi : Finnish es_ES: Spanish # de : German sv : Swedish # el : Greek th : Thai # iw : Hebrew zh_TW: Traditional Chinese # hu : Hungarian tr : Turkish # is : Icelandic uk : Ukrainian # in : Indonesian vi : Vietnamese # it : Italian # # all_langs : All languages # # Specify value as the following to select any of the languages. # Example : SELECTED_LANGUAGES=en,fr,ja # # Specify value as the following to select all the languages. # Example : SELECTED_LANGUAGES=all_langs #------------------------------------------------------------------------------- SELECTED_LANGUAGES=ar,bn,pt_BR,bg,fr_CA,ca,hr,cs,da,nl,ar_EG,en,en_GB,et,fi,fr,de,el,iw,hu,is,in,it,ja,ko,es,lv,lt,ms,es_MX,no,pl,pt,ro,ru,zh_CN,sk,sl,es_ES,sv,th,zh_TW,tr,uk,vi #------------------------------------------------------------------------------- # Specify the complete path of the Oracle Home. #------------------------------------------------------------------------------- ORACLE_HOME=/oracle/product/11.2.0.4 #------------------------------------------------------------------------------- # Specify the complete path of the Oracle Base. #------------------------------------------------------------------------------- ORACLE_BASE=/oracle/product #------------------------------------------------------------------------------- # Specify the installation edition of the component. # # The value should contain only one of these choices. # - EE : Enterprise Edition # - SE : Standard Edition # - SEONE : Standard Edition One # - PE : Personal Edition (WINDOWS ONLY) #------------------------------------------------------------------------------- oracle.install.db.InstallEdition=SE #------------------------------------------------------------------------------- # This variable is used to enable or disable custom install and is considered # only if InstallEdition is EE. # # - true : Components mentioned as part of 'optionalComponents' property # are considered for install. # - false : Value for 'optionalComponents' is not considered. #------------------------------------------------------------------------------- oracle.install.db.EEOptionsSelection=false #------------------------------------------------------------------------------- # This property is considered only if 'EEOptionsSelection' is set to true # # Description: List of Enterprise Edition Options you would like to enable. # # The following choices are available. You may specify any # combination of these choices. The components you choose should # be specified in the form "internal-component-name:version" # Below is a list of components you may specify to enable. # # oracle.oraolap:11.2.0.4.0 - Oracle OLAP # oracle.rdbms.dm:11.2.0.4.0 - Oracle Data Mining RDBMS Files # oracle.rdbms.dv:11.2.0.4.0- Oracle Database Vault option # oracle.rdbms.lbac:11.2.0.4.0 - Oracle Label Security # oracle.rdbms.partitioning:11.2.0.4.0 - Oracle Partitioning # oracle.rdbms.rat:11.2.0.4.0 - Oracle Real Application Testing #------------------------------------------------------------------------------- oracle.install.db.optionalComponents= ############################################################################### # # # PRIVILEGED OPERATING SYSTEM GROUPS # # ------------------------------------------ # # Provide values for the OS groups to which OSDBA and OSOPER privileges # # needs to be granted. If the install is being performed as a member of the # # group "dba", then that will be used unless specified otherwise below. # # # # The value to be specified for OSDBA and OSOPER group is only for UNIX based # # Operating System. # # # ############################################################################### #------------------------------------------------------------------------------ # The DBA_GROUP is the OS group which is to be granted OSDBA privileges. #------------------------------------------------------------------------------- oracle.install.db.DBA_GROUP=dba #------------------------------------------------------------------------------ # The OPER_GROUP is the OS group which is to be granted OSOPER privileges. # The value to be specified for OSOPER group is optional. #------------------------------------------------------------------------------ oracle.install.db.OPER_GROUP=oper #------------------------------------------------------------------------------- # Specify the cluster node names selected during the installation. # Example : oracle.install.db.CLUSTER_NODES=node1,node2 #------------------------------------------------------------------------------- oracle.install.db.CLUSTER_NODES= #------------------------------------------------------------------------------ # This variable is used to enable or disable RAC One Node install. # # - true : Value of RAC One Node service name is used. # - false : Value of RAC One Node service name is not used. # # If left blank, it will be assumed to be false. #------------------------------------------------------------------------------ oracle.install.db.isRACOneInstall=false #------------------------------------------------------------------------------ # Specify the name for RAC One Node Service. #------------------------------------------------------------------------------ oracle.install.db.racOneServiceName= #------------------------------------------------------------------------------- # Specify the type of database to create. # It can be one of the following: # - GENERAL_PURPOSE/TRANSACTION_PROCESSING # - DATA_WAREHOUSE #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.type=GENERAL_PURPOSE #------------------------------------------------------------------------------- # Specify the Starter Database Global Database Name. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.globalDBName= #------------------------------------------------------------------------------- # Specify the Starter Database SID. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.SID= #------------------------------------------------------------------------------- # Specify the Starter Database character set. # # One of the following # AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2, # EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257, # BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6, # AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8, # IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE, # KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950, # ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258 #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.characterSet= #------------------------------------------------------------------------------ # This variable should be set to true if Automatic Memory Management # in Database is desired. # If Automatic Memory Management is not desired, and memory allocation # is to be done manually, then set it to false. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.memoryOption=false #------------------------------------------------------------------------------- # Specify the total memory allocation for the database. Value(in MB) should be # at least 256 MB, and should not exceed the total physical memory available # on the system. # Example: oracle.install.db.config.starterdb.memoryLimit=512 #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.memoryLimit= #------------------------------------------------------------------------------- # This variable controls whether to load Example Schemas onto # the starter database or not. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.installExampleSchemas=false #------------------------------------------------------------------------------- # This variable includes enabling audit settings, configuring password profiles # and revoking some grants to public. These settings are provided by default. # These settings may also be disabled. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.enableSecuritySettings=true ############################################################################### # # # Passwords can be supplied for the following four schemas in the # # starter database: # # SYS # # SYSTEM # # SYSMAN (used by Enterprise Manager) # # DBSNMP (used by Enterprise Manager) # # # # Same password can be used for all accounts (not recommended) # # or different passwords for each account can be provided (recommended) # # # ############################################################################### #------------------------------------------------------------------------------ # This variable holds the password that is to be used for all schemas in the # starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.ALL= #------------------------------------------------------------------------------- # Specify the SYS password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYS= #------------------------------------------------------------------------------- # Specify the SYSTEM password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYSTEM= #------------------------------------------------------------------------------- # Specify the SYSMAN password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYSMAN= #------------------------------------------------------------------------------- # Specify the DBSNMP password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.DBSNMP= #------------------------------------------------------------------------------- # Specify the management option to be selected for the starter database. # It can be one of the following: # - GRID_CONTROL # - DB_CONTROL #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.control=DB_CONTROL #------------------------------------------------------------------------------- # Specify the Management Service to use if Grid Control is selected to manage # the database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL= ############################################################################### # # # SPECIFY BACKUP AND RECOVERY OPTIONS # # ------------------------------------ # # Out-of-box backup and recovery options for the database can be mentioned # # using the entries below. # # # ############################################################################### #------------------------------------------------------------------------------ # This variable is to be set to false if automated backup is not required. Else # this can be set to true. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.automatedBackup.enable=false #------------------------------------------------------------------------------ # Regardless of the type of storage that is chosen for backup and recovery, if # automated backups are enabled, a job will be scheduled to run daily to backup # the database. This job will run as the operating system user that is # specified in this variable. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.automatedBackup.osuid= #------------------------------------------------------------------------------- # Regardless of the type of storage that is chosen for backup and recovery, if # automated backups are enabled, a job will be scheduled to run daily to backup # the database. This job will run as the operating system user specified by the # above entry. The following entry stores the password for the above operating # system user. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.automatedBackup.ospwd= #------------------------------------------------------------------------------- # Specify the type of storage to use for the database. # It can be one of the following: # - FILE_SYSTEM_STORAGE # - ASM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.storageType= #------------------------------------------------------------------------------- # Specify the database file location which is a directory for datafiles, control # files, redo logs. # # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.fileSystemStorage.dataLocation= #------------------------------------------------------------------------------- # Specify the backup and recovery location. # # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation= #------------------------------------------------------------------------------- # Specify the existing ASM disk groups to be used for storage. # # Applicable only when oracle.install.db.config.starterdb.storageType=ASM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.asm.diskGroup= #------------------------------------------------------------------------------- # Specify the password for ASMSNMP user of the ASM instance. # # Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.asm.ASMSNMPPassword= #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username. # # Example : [email protected] #------------------------------------------------------------------------------ MYORACLESUPPORT_USERNAME= #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username password. # # Example : MYORACLESUPPORT_PASSWORD=password #------------------------------------------------------------------------------ MYORACLESUPPORT_PASSWORD= #------------------------------------------------------------------------------ # Specify whether to enable the user to set the password for # My Oracle Support credentials. The value can be either true or false. # If left blank it will be assumed to be false. # # Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true #------------------------------------------------------------------------------ SECURITY_UPDATES_VIA_MYORACLESUPPORT=false #------------------------------------------------------------------------------ # Specify whether user doesn't want to configure Security Updates. # The value for this variable should be true if you don't want to configure # Security Updates, false otherwise. # # The value can be either true or false. If left blank it will be assumed # to be false. # # Example : DECLINE_SECURITY_UPDATES=false #------------------------------------------------------------------------------ DECLINE_SECURITY_UPDATES=true #------------------------------------------------------------------------------ # Specify the Proxy server name. Length should be greater than zero. # # Example : PROXY_HOST=proxy.domain.com #------------------------------------------------------------------------------ PROXY_HOST= #------------------------------------------------------------------------------ # Specify the proxy port number. Should be Numeric and at least 2 chars. # # Example : PROXY_PORT=25 #------------------------------------------------------------------------------ PROXY_PORT= #------------------------------------------------------------------------------ # Specify the proxy user name. Leave PROXY_USER and PROXY_PWD # blank if your proxy server requires no authentication. # # Example : PROXY_USER=username #------------------------------------------------------------------------------ PROXY_USER= #------------------------------------------------------------------------------ # Specify the proxy password. Leave PROXY_USER and PROXY_PWD # blank if your proxy server requires no authentication. # # Example : PROXY_PWD=password #------------------------------------------------------------------------------ PROXY_PWD= #------------------------------------------------------------------------------ # Specify the proxy realm. # # Example : PROXY_REALM=metalink #------------------------------------------------------------------------------ PROXY_REALM= #------------------------------------------------------------------------------ # Specify the Oracle Support Hub URL. # # Example : COLLECTOR_SUPPORTHUB_URL=https://orasupporthub.company.com:8080/ #------------------------------------------------------------------------------ COLLECTOR_SUPPORTHUB_URL= #------------------------------------------------------------------------------ # Specify the auto-updates option. It can be one of the following: # - MYORACLESUPPORT_DOWNLOAD # - OFFLINE_UPDATES # - SKIP_UPDATES #------------------------------------------------------------------------------ oracle.installer.autoupdates.option=SKIP_UPDATES #------------------------------------------------------------------------------ # In case MYORACLESUPPORT_DOWNLOAD option is chosen, specify the location where # the updates are to be downloaded. # In case OFFLINE_UPDATES option is chosen, specify the location where the updates # are present. #------------------------------------------------------------------------------ oracle.installer.autoupdates.downloadUpdatesLoc= #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username which has the patches download privileges # to be used for software updates. # Example : [email protected] #------------------------------------------------------------------------------ AUTOUPDATES_MYORACLESUPPORT_USERNAME= #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username password which has the patches download privileges # to be used for software updates. # # Example : AUTOUPDATES_MYORACLESUPPORT_PASSWORD=password #------------------------------------------------------------------------------
Do the install[edit]
cd [installation media]/database and type (case-sensitive!)
./runInstaller -silent -invPtrLoc /var/opt/oracle/oraInst.loc.TDPOTEST -ignoreSysPrereqs -responseFile <path to above file>
another way overriding certain parameters...
cd [installation media]/database and type (case-sensitive!) ./runInstaller -silent \ -responseFile <path to above file> \ oracle.install.option=INSTALL_DB_SWONLY \ UNIX_GROUP_NAME=oinstall \ INVENTORY_LOCATION=/u01/app/oraInventory \ SELECTED_LANGUAGES=all_langs \ ORACLE_HOME=/oracle/product/12.1.0.2 \ ORACLE_BASE=/oracle \ oracle.install.db.InstallEdition=EE \ oracle.install.db.isCustomInstall=false \ oracle.install.db.DBA_GROUP=dba \ oracle.install.db.OPER_GROUP=dba \ oracle.install.db.BACKUPDBA_GROUP=dba \ oracle.install.db.DGDBA_GROUP=dba \ oracle.install.db.KMDBA_GROUP=dba \ SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \ DECLINE_SECURITY_UPDATES=true
Got these errors?[edit]
[oracle@egnim database]$ ./runInstaller -silent -ignoreSysPrereqs -responseFile /home/oracle/database/response/oracle_EE_SWONLY.rsp Starting Oracle Universal Installer... Checking Temp space: must be greater than 120 MB. Actual 33277 MB Passed Checking swap space: must be greater than 150 MB. Actual 1983 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-06-22_02-07-54AM. Please wait ...[oracle@egnim database]$ No protocol specified Exception in thread "main" java.lang.NoClassDefFoundError at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:164) at java.awt.Toolkit$2.run(Toolkit.java:821) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Toolkit.getDefaultToolkit(Toolkit.java:804) at javax.swing.UIManager.initialize(UIManager.java:1262) at javax.swing.UIManager.maybeInitialize(UIManager.java:1245) at javax.swing.UIManager.getUI(UIManager.java:851) at javax.swing.JPanel.updateUI(JPanel.java:104) at javax.swing.JPanel.<init>(JPanel.java:64) at javax.swing.JPanel.<init>(JPanel.java:87) at javax.swing.JPanel.<init>(JPanel.java:95) at oracle.sysman.oii.oiif.oiifo.OiifoOCMUI.<init>(OiifoOCMUI.java:125) at oracle.sysman.oii.oiif.oiifo.OiifoOCMInterfaceManager.<init>(OiifoOCMInterfaceManager.java:79) at oracle.sysman.oii.oiif.oiifo.OiifoOCMInterfaceManager.getInstance(OiifoOCMInterfaceManager.java:124) at oracle.install.ivw.db.driver.DBInstaller.run(DBInstaller.java:123) at oracle.install.commons.util.Application.startup(Application.java:869) at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:164) at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:181) at oracle.install.commons.base.driver.common.Installer.startup(Installer.java:265) at oracle.install.ivw.db.driver.DBInstaller.startup(DBInstaller.java:114) at oracle.install.ivw.db.driver.DBInstaller.main(DBInstaller.java:132)
exit the oracle session and from the root session, type
xhost +
then su back in to oracle and try again...
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 180 MB. Actual 4026 MB Passed
Checking swap space: must be greater than 150 MB. Actual 131098 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-08-11_09-28-18PM. Please wait ...
[WARNING] [INS-32016] The selected Oracle home contains directories or files.
CAUSE: The selected Oracle home contained directories or files.
ACTION: To start with an empty Oracle home, either remove its contents or choose another location.
You can find the log of this install session at:
/oracle/product/11.2.0.1/logs/installActions2014-08-11_09-28-18PM.log
The following configuration scripts need to be executed as the "root" user.
#!/bin/sh
#Root scripts to run
/oracle/product/11.2.0.1/root.sh
To execute the configuration scripts:
1. Open a terminal window
2. Log in as "root"
3. Run the scripts
4. Return to this window and hit "Enter" key to continue
Successfully Setup Software.
Create the listener and tns entries (netca)[edit]
Create the listener and setup TNS using netca in silent mode with a response file Create netca_DEV1.rsp and put this in it
[GENERAL]
RESPONSEFILE_VERSION="11.2"
CREATE_TYPE="CUSTOM"
SHOW_GUI=false
LOG_FILE=""/oracle/DEV1/product/11.2.0.1/network/tools/log/netca.log""
[oracle.net.ca]
INSTALLED_COMPONENTS={"server","net8","javavm"}
INSTALL_TYPE=""custom""
LISTENER_NUMBER=1
LISTENER_NAMES={"LISTENER_DEV1"}
LISTENER_PROTOCOLS={"TCP;1522"}
LISTENER_START=""LISTENER_DEV1""
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
NSN_NUMBER=2
NSN_NAMES={"EXTPROC_CONNECTION_DATA","DEV1"}
NSN_SERVICE={"PLSExtProc","DEV1"}
NSN_PROTOCOLS={"TCP;HOSTNAME;1521","TCP;egnim;1522"}
and run the command
export DISPLAY=localhost:0.0 ORACLE_BASE=/oracle/DEV1 ORACLE_HOME=$ORACLE_BASE/product/11.2.0.1 $ORACLE_HOME/bin/netca -silent -responseFile <path to above file>
Create a template from an existing database[edit]
It won't be perfect. The directory structures will need checking/modifying and the SID may be hardcoded in places when it's done.
This method creates a .dbt file ('t' for template). It will be slower to create a database using this template as it creates the database using scripts instead of a seeded clone.
dbca -silent -createTemplateFromDB -sourceDB KITRYVAL -sysDBAUserName sys -sysDBAPassword change_on_install -templateName 11204_se_template
For my purposes, now looks like this on 11gR2
<DatabaseTemplate name="11204_se_template" description=" " version="11.2.0.0.0">
<CommonAttributes>
<option name="OMS" value="false"/>
<option name="JSERVER" value="true"/>
<option name="SPATIAL" value="true"/>
<option name="IMEDIA" value="true"/>
<option name="XDB_PROTOCOLS" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="ORACLE_TEXT" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="SAMPLE_SCHEMA" value="false"/>
<option name="CWMLITE" value="false"/>
<option name="EM_REPOSITORY" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="APEX" value="true"/>
<option name="OWB" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="DV" value="false"/>
</CommonAttributes>
<Variables/>
<CustomScripts Execute="false"/>
<InitParamAttributes>
<InitParams>
<initParam name="db_name" value=""/>
<initParam name="filesystemio_options" value="SETALL"/>
<initParam name="dispatchers" value="(PROTOCOL=TCP) (SERVICE={SID}XDB)"/>
<initParam name="audit_file_dest" value="/oracle/{SID}/admin/adump"/>
<initParam name="compatible" value="11.2.0.4.0"/>
<initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>
<initParam name="log_archive_dest_1" value="'LOCATION=/oracle/arch/{SID}'"/>
<initParam name="job_queue_processes" value="1000"/>
<initParam name="processes" value="350"/>
<initParam name="undo_tablespace" value="UNDOTBS1"/>
<initParam name="control_files" value="("/oracle/{SID}/oradata1/control01.ctl", "/oracle/{SID}/oradata2/control02.ctl", "/oracle/{SID}/oradata3/control03.ctl")"/>
<initParam name="diagnostic_dest" value="{ORACLE_BASE}"/>
<initParam name="sec_max_failed_login_attempts" value="4"/>
<initParam name="sec_protocol_error_trace_action" value="LOG"/>
<initParam name="db_recovery_file_dest" value="{ORACLE_BASE}/fra"/>
<initParam name="audit_trail" value="DB"/>
<initParam name="audit_sys_operations" value="TRUE"/>
<initParam name="log_archive_format" value="{SID}_t%t_s%s_r%r.dbf"/>
<initParam name="memory_target" value="2097152000"/>
<initParam name="sec_case_sensitive_logon" value="FALSE"/>
<initParam name="sessions" value="472"/>
<initParam name="db_block_size" value="8192"/>
<initParam name="open_cursors" value="300"/>
<initParam name="db_recovery_file_dest_size" value="1468006400"/>
<initParam name="db_flashback_retention_target" value="10800"/>
</InitParams>
<MiscParams>
<characterSet></characterSet>
<nationalCharacterSet></nationalCharacterSet>
<archiveLogMode>true</archiveLogMode>
<initParamFileName>/oracle/{SID}/admin/pfile/init.ora</initParamFileName>
</MiscParams>
<SPfile useSPFile="true">{ORACLE_HOME}/dbs/spfile{SID}.ora</SPfile>
</InitParamAttributes>
<StorageAttributes>
<ControlfileAttributes id="Controlfile">
<maxDatafiles>100</maxDatafiles>
<maxLogfiles>16</maxLogfiles>
<maxLogMembers>3</maxLogMembers>
<maxLogHistory>1</maxLogHistory>
<maxInstances>8</maxInstances>
<image name="control01.ctl" filepath="/oracle/{SID}/oradata1/"/>
<image name="control02.ctl" filepath="/oracle/{SID}/oradata2/"/>
<image name="control03.ctl" filepath="/oracle/{SID}/oradata3/"/>
</ControlfileAttributes>
<DatafileAttributes id="/oracle/{SID}/oradata1/audit_dt01.dbf">
<tablespace>AUDIT_DT</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">1000</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="MB">100</increment>
<maxSize unit="MB">30000</maxSize>
</DatafileAttributes>
<DatafileAttributes id="/oracle/{SID}/oradata1/sysaux01.dbf">
<tablespace>SYSAUX</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">670</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">10240</increment>
<maxSize unit="MB">32767</maxSize>
</DatafileAttributes>
<DatafileAttributes id="/oracle/{SID}/oradata1/system01.dbf">
<tablespace>SYSTEM</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">830</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">10240</increment>
<maxSize unit="MB">32767</maxSize>
</DatafileAttributes>
<DatafileAttributes id="/oracle/{SID}/oradata2/temp01.dbf">
<tablespace>TEMP</tablespace>
<temporary>true</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">175</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">640</increment>
<maxSize unit="MB">32767</maxSize>
</DatafileAttributes>
<DatafileAttributes id="/oracle/{SID}/oradata5/TOOLS_DT01.dbf">
<tablespace>TOOLS</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">10</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">10240</increment>
<maxSize unit="MB">30000</maxSize>
</DatafileAttributes>
<DatafileAttributes id="/oracle/{SID}/oradata3/undotbs01.dbf">
<tablespace>UNDOTBS1</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">1240</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">5120</increment>
<maxSize unit="MB">32767</maxSize>
</DatafileAttributes>
<DatafileAttributes id="/oracle/{SID}/oradata3/users01.dbf">
<tablespace>USERS</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">91</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">1280</increment>
<maxSize unit="MB">32767</maxSize>
</DatafileAttributes>
<TablespaceAttributes id="AUDIT_DT">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>false</temporary>
<defaultTemp>false</defaultTemp>
<undo>false</undo>
<local>true</local>
<blockSize>8192</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">64</initSize>
<increment unit="KB">0</increment>
<incrementPercent>0</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>2147483645</maxExtends>
<minExtendsSize unit="KB">64</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="/oracle/{SID}/oradata1/audit_dt01.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<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>8192</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">64</initSize>
<increment unit="KB">0</increment>
<incrementPercent>0</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>2147483645</maxExtends>
<minExtendsSize unit="KB">64</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="/oracle/{SID}/oradata1/sysaux01.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>8192</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">64</initSize>
<increment unit="KB">0</increment>
<incrementPercent>0</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>2147483645</maxExtends>
<minExtendsSize unit="KB">64</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>false</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="/oracle/{SID}/oradata1/system01.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="TEMP">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>true</temporary>
<defaultTemp>true</defaultTemp>
<undo>false</undo>
<local>true</local>
<blockSize>8192</blockSize>
<allocation>2</allocation>
<uniAllocSize unit="KB">1024</uniAllocSize>
<initSize unit="KB">1024</initSize>
<increment unit="KB">1024</increment>
<incrementPercent>0</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>-1</maxExtends>
<minExtendsSize unit="KB">1024</minExtendsSize>
<logging>false</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>false</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="/oracle/{SID}/oradata2/temp01.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="TOOLS">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>false</temporary>
<defaultTemp>false</defaultTemp>
<undo>false</undo>
<local>true</local>
<blockSize>8192</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">64</initSize>
<increment unit="KB">0</increment>
<incrementPercent>0</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>2147483645</maxExtends>
<minExtendsSize unit="KB">64</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="/oracle/{SID}/oradata5/TOOLS_DT01.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="UNDOTBS1">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>false</temporary>
<defaultTemp>false</defaultTemp>
<undo>true</undo>
<local>true</local>
<blockSize>8192</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">64</initSize>
<increment unit="KB">0</increment>
<incrementPercent>0</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>2147483645</maxExtends>
<minExtendsSize unit="KB">64</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>false</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="/oracle/{SID}/oradata3/undotbs01.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="USERS">
<online>true</online>
<offlineMode>1</offlineMode>
<readOnly>false</readOnly>
<temporary>false</temporary>
<defaultTemp>false</defaultTemp>
<undo>false</undo>
<local>true</local>
<blockSize>8192</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">64</initSize>
<increment unit="KB">0</increment>
<incrementPercent>0</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>2147483645</maxExtends>
<minExtendsSize unit="KB">64</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="/oracle/{SID}/oradata3/users01.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<RedoLogGroupAttributes id="1">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo01.log" filepath="/oracle/{SID}/oradata1/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="2">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo02.log" filepath="/oracle/{SID}/oradata2/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="3">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo03.log" filepath="/oracle/{SID}/oradata3/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="4">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo04.log" filepath="/oracle/{SID}/oradata4/"/>
</RedoLogGroupAttributes>
</StorageAttributes>
</DatabaseTemplate>
Create the database (dbca)[edit]
[edit]
This is built for a dev system as redo, controlfiles and datafiles are all in the same place. Modify as necessary.
$ORACLE_HOME/bin/dbca -silent \
-createDatabase \
-templateName $ORACLE_HOME/assistants/dbca/templates/dbca_custom_no_options.dbt \
-gdbName appli2a \
-Sid appli2a \
-sysPassword qwertyuiop \
-systemPassword asdfghjkl \
-dbsnmpPassword zxcvbnm \
-sysmanPassword qazwsxedc
<?xml version = '1.0'?>
<DatabaseTemplate name="Custom build - all options removed" description="Check variables CLN_ORADATA and CLN_ORAARCH" version="11.2.0.0.0">
<CommonAttributes>
<option name="OMS" value="false"/>
<option name="JSERVER" value="false"/>
<option name="SPATIAL" value="false"/>
<option name="IMEDIA" value="false"/>
<option name="XDB_PROTOCOLS" value="false">
<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="APEX" value="false"/>
<option name="OWB" value="false"/>
<option name="DV" value="false"/>
</CommonAttributes>
<Variables>
<variable name="CLN_ORADATA" value="/crelan/exp/ora_data4"/>
<variable name="CLN_ORAARCH" value="/crelan/exp/ora_data2/archivelog"/>
</Variables>
<CustomScripts Execute="false"/>
<InitParamAttributes>
<InitParams>
<initParam name="db_name" value="{SID}"/>
<initParam name="db_domain" value=""/>
<initParam name="audit_file_dest" value="{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump"/>
<initParam name="compatible" value="11.2.0.4.0"/>
<initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>
<initParam name="log_archive_dest_1" value="'LOCATION={CLN_ORAARCH}/{SID}'"/>
<initParam name="sga_target" value="3072" unit="MB"/>
<initParam name="processes" value="300"/>
<initParam name="local_listener" value="LISTENER_{SID}"/>
<initParam name="undo_tablespace" value="UNDOTBS1"/>
<initParam name="control_files" value="("{CLN_ORADATA}/{SID}/control01.ctl", "{CLN_ORADATA}/{SID}/control02.ctl", "{CLN_ORADATA}/{SID}/control03.ctl")"/>
<initParam name="diagnostic_dest" value="{ORACLE_BASE}"/>
<initParam name="audit_trail" value="db"/>
<initParam name="log_archive_format" value="{SID}_%t_%s_%r.dbf"/>
<initParam name="sessions" value="335"/>
<initParam name="db_block_size" value="8" unit="KB"/>
<initParam name="open_cursors" value="300"/>
<initParam name="pga_aggregate_target" value="1200" unit="MB"/>
</InitParams>
<MiscParams>
<databaseType>MULTIPURPOSE</databaseType>
<maxUserConn>20</maxUserConn>
<customSGA>true</customSGA>
<characterSet>WE8MSWIN1252</characterSet>
<nationalCharacterSet>AL16UTF16</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>
<ControlfileAttributes id="Controlfile">
<maxDatafiles>300</maxDatafiles>
<maxLogfiles>16</maxLogfiles>
<maxLogMembers>3</maxLogMembers>
<maxLogHistory>1</maxLogHistory>
<maxInstances>8</maxInstances>
<image name="control01.ctl" filepath="{CLN_ORADATA}/{SID}/"/>
<image name="control02.ctl" filepath="{CLN_ORADATA}/{SID}/"/>
<image name="control03.ctl" filepath="{CLN_ORADATA}/{SID}/"/>
</ControlfileAttributes>
<DatafileAttributes id="{CLN_ORADATA}/{SID}/sysaux01.dbf">
<tablespace>SYSAUX</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">600</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">10240</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="{CLN_ORADATA}/{SID}/system01.dbf">
<tablespace>SYSTEM</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">700</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">10240</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="{CLN_ORADATA}/{SID}/temp01.dbf">
<tablespace>TEMP</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">20</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">640</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="{CLN_ORADATA}/{SID}/undotbs01.dbf">
<tablespace>UNDOTBS1</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">200</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">5120</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="{CLN_ORADATA}/{SID}/users01.dbf">
<tablespace>USERS</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">5</size>
<reuse>true</reuse>
<autoExtend>true</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="{CLN_ORADATA}/{SID}/sysaux01.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>3</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="{CLN_ORADATA}/{SID}/system01.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="TEMP">
<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="{CLN_ORADATA}/{SID}/temp01.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="UNDOTBS1">
<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="{CLN_ORADATA}/{SID}/undotbs01.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="USERS">
<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="{CLN_ORADATA}/{SID}/users01.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<RedoLogGroupAttributes id="1">
<reuse>false</reuse>
<fileSize unit="MB">500</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo01.log" filepath="{CLN_ORADATA}/{SID}/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="2">
<reuse>false</reuse>
<fileSize unit="MB">500</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo02.log" filepath="{CLN_ORADATA}/{SID}/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="3">
<reuse>false</reuse>
<fileSize unit="MB">500</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo03.log" filepath="{CLN_ORADATA}/{SID}/"/>
</RedoLogGroupAttributes>
</StorageAttributes>
</DatabaseTemplate>
Release 11, dedicated binaries[edit]
ORACLE_BASE=/oracle/PN7 ORACLE_HOME=$ORACLE_BASE/product/11.2.0.3
$ORACLE_HOME/bin/dbca -silent -createDatabase -templateName /oracle/PN7/product/11.2.0.3/assistants/dbca/templates/dedicated_home.dbc -gdbName PN7 -Sid PN7 -sysPassword qwertyuiop -systemPassword asdfghjkl -dbsnmpPassword zxcvbnm -sysmanPassword qazwsxedc - characterSet AL32UTF8 -nationalCharacterSet AL16UTF16
This template is for databases that will have a dedicated set of oracle product binaries
It is built this way so that, in the event of failover to another host, everything works if the /oracle/PN7 resource group (mount point) is moved.
<?xml version = '1.0'?>
<DatabaseTemplate name="dedicated_home" description="oracle_home in /oracle/SID/product/11.2.0.3, archivelogs in /oracle/SID/arch, 4 redo log groups" version="11.1.0.0.0">
<CommonAttributes>
<option name="OMS" value="false"/>
<option name="JSERVER" value="true"/>
<option name="SPATIAL" value="true"/>
<option name="IMEDIA" value="true"/>
<option name="XDB_PROTOCOLS" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="ORACLE_TEXT" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="SAMPLE_SCHEMA" value="false"/>
<option name="CWMLITE" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="EM_REPOSITORY" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="APEX" value="true"/>
<option name="OWB" value="true"/>
<option name="DV" value="false"/>
</CommonAttributes>
<Variables/>
<CustomScripts Execute="false"/>
<InitParamAttributes>
<InitParams>
<initParam name="db_name" value="{SID}"/>
<initParam name="db_domain" value=""/>
<initParam name="dispatchers" value="(PROTOCOL=TCP) (SERVICE={SID}XDB)"/>
<initParam name="audit_file_dest" value="{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump"/>
<initParam name="compatible" value="11.2.0.0.0"/>
<initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>
<initParam name="log_archive_dest_1" value="'LOCATION={ORACLE_BASE}/arch/{SID}'"/>
<initParam name="processes" value="300"/>
<initParam name="local_listener" value="LISTENER_{SID}"/>
<initParam name="undo_tablespace" value="UNDOTBS1"/>
<initParam name="control_files" value="('{ORACLE_BASE}/oradata1/control01.ctl', '{ORACLE_BASE}/oradata2/control02.ctl', '{ORACLE_BASE}/oradata3/control03.ctl')"/>
<initParam name="diagnostic_dest" value="{ORACLE_BASE}"/>
<initParam name="db_recovery_file_dest" value="{ORACLE_BASE}/fra"/>
<initParam name="audit_trail" value="db"/>
<initParam name="log_archive_format" value="{SID}_t%t_s%s_r%r.dbf"/>
<initParam name="memory_target" value="3276" unit="MB"/>
<initParam name="sessions" value="335"/>
<initParam name="db_block_size" value="8" unit="KB"/>
<initParam name="open_cursors" value="300"/>
<initParam name="db_recovery_file_dest_size" value="1400" unit="MB"/>
</InitParams>
<MiscParams>
<databaseType>MULTIPURPOSE</databaseType>
<maxUserConn>20</maxUserConn>
<percentageMemTOSGA>40</percentageMemTOSGA>
<customSGA>false</customSGA>
<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>
<Location>{ORACLE_HOME}/assistants/dbca/templates/Seed_Database.dfb</Location>
<SourceDBName>seeddata</SourceDBName>
<Name id="1" Tablespace="SYSTEM" Contents="PERMANENT" Size="700" autoextend="true" blocksize="8192">/oracle/{SID}/oradata1/system01.dbf</Name>
<Name id="2" Tablespace="SYSAUX" Contents="PERMANENT" Size="490" autoextend="true" blocksize="8192">/oracle/{SID}/oradata1/sysaux01.dbf</Name>
<Name id="3" Tablespace="UNDOTBS1" Contents="UNDO" Size="25" autoextend="true" blocksize="8192">/oracle/{SID}/oradata3/undotbs01.dbf</Name>
<Name id="4" Tablespace="USERS" Contents="PERMANENT" Size="5" autoextend="true" blocksize="8192">/oracle/{SID}/oradata3/users01.dbf</Name>
</DataFiles>
<TempFiles>
<Name id="1" Tablespace="TEMP" Contents="TEMPORARY" Size="20">/oracle/{SID}/oradata2/temp01.dbf</Name>
</TempFiles>
<ControlfileAttributes id="Controlfile">
<maxDatafiles>256</maxDatafiles>
<maxLogfiles>16</maxLogfiles>
<maxLogMembers>3</maxLogMembers>
<maxLogHistory>1</maxLogHistory>
<maxInstances>8</maxInstances>
<image name="control01.ctl" filepath="/oracle/{SID}/oradata1/"/>
<image name="control02.ctl" filepath="/oracle/{SID}/oradata2/"/>
<image name="control03.ctl" filepath="/oracle/{SID}/oradata3/"/>
</ControlfileAttributes>
<RedoLogGroupAttributes id="1">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo01a.log" filepath="/oracle/{SID}/oradata1/"/>
<member ordinal="1" memberName="redo01b.log" filepath="/oracle/{SID}/oradata2/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="2">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo02a.log" filepath="/oracle/{SID}/oradata3/"/>
<member ordinal="1" memberName="redo02b.log" filepath="/oracle/{SID}/oradata4/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="3">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo03a.log" filepath="/oracle/{SID}/oradata1/"/>
<member ordinal="0" memberName="redo03b.log" filepath="/oracle/{SID}/oradata2/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="4">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="1" memberName="redo04a.log" filepath="/oracle/{SID}/oradata3/"/>
<member ordinal="2" memberName="redo04b.log" filepath="/oracle/{SID}/oradata4/"/>
</RedoLogGroupAttributes>
</StorageAttributes>
</DatabaseTemplate>
[edit]
The following template is for databases that will have a shared shared set of oracle product binaries
There could be many databases using the same ORACLE_HOME
ORACLE_BASE=/oracle ORACLE_HOME=$ORACLE_BASE/product/11.2.0.3
$ORACLE_HOME/bin/dbca -silent -createDatabase -templateName /oracle/product/11.2.0.3/assistants/dbca/templates/shared_home.dbc \ -gdbName PN7 -Sid PN7 -sysPassword qwertyuiop -systemPassword asdfghjkl -dbsnmpPassword zxcvbnm -sysmanPassword qazwsxedc \ -characterSet AL32UTF8 -nationalCharacterSet AL16UTF16
<?xml version = '1.0'?>
<DatabaseTemplate name="shared_binaries" description="home in /oracle/product/11.2.0.4, archivelogs in /oracle/arch/SID, 4 redo log groups" version="11.1.0.0.0">
<CommonAttributes>
<option name="OMS" value="false"/>
<option name="JSERVER" value="true"/>
<option name="SPATIAL" value="true"/>
<option name="IMEDIA" value="true"/>
<option name="XDB_PROTOCOLS" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="ORACLE_TEXT" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="SAMPLE_SCHEMA" value="false"/>
<option name="CWMLITE" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="EM_REPOSITORY" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="APEX" value="true"/>
<option name="OWB" value="true"/>
<option name="DV" value="false"/>
</CommonAttributes>
<Variables/>
<CustomScripts Execute="false"/>
<InitParamAttributes>
<InitParams>
<initParam name="db_name" value="{SID}"/>
<initParam name="db_domain" value=""/>
<initParam name="dispatchers" value="(PROTOCOL=TCP) (SERVICE={SID}XDB)"/>
<initParam name="audit_file_dest" value="/oracle/admin/{DB_UNIQUE_NAME}/adump"/>
<initParam name="compatible" value="11.2.0.4.0"/>
<initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>
<initParam name="log_archive_dest_1" value="'LOCATION=/oracle/arch/{SID}'"/>
<initParam name="processes" value="300"/>
<initParam name="local_listener" value="LISTENER_{SID}"/>
<initParam name="undo_tablespace" value="UNDOTBS1"/>
<initParam name="control_files" value="('/oracle/{SID}/oradata1/control01.ctl', '/oracle/{SID}/oradata2/control02.ctl', '/oracle/{SID}/oradata3/control03.ctl')"/>
<initParam name="diagnostic_dest" value="{ORACLE_BASE}"/>
<initParam name="db_recovery_file_dest" value="{ORACLE_BASE}/fra"/>
<initParam name="audit_trail" value="db"/>
<initParam name="log_archive_format" value="{SID}_t%t_s%s_r%r.dbf"/>
<initParam name="memory_target" value="3276" unit="MB"/>
<initParam name="sessions" value="335"/>
<initParam name="db_block_size" value="8" unit="KB"/>
<initParam name="open_cursors" value="300"/>
<initParam name="db_recovery_file_dest_size" value="1400" unit="MB"/>
</InitParams>
<MiscParams>
<databaseType>MULTIPURPOSE</databaseType>
<maxUserConn>20</maxUserConn>
<percentageMemTOSGA>40</percentageMemTOSGA>
<customSGA>false</customSGA>
<archiveLogMode>true</archiveLogMode>
<initParamFileName>/oracle/admin/{DB_UNIQUE_NAME}/pfile/init.ora</initParamFileName>
</MiscParams>
<SPfile useSPFile="true">{ORACLE_HOME}/dbs/spfile{SID}.ora</SPfile>
</InitParamAttributes>
<StorageAttributes>
<DataFiles>
<Location>{ORACLE_HOME}/assistants/dbca/templates/Seed_Database.dfb</Location>
<SourceDBName>seeddata</SourceDBName>
<Name id="1" Tablespace="SYSTEM" Contents="PERMANENT" Size="700" autoextend="true" blocksize="8192">/oracle/{SID}/oradata1/system01.dbf</Name>
<Name id="2" Tablespace="SYSAUX" Contents="PERMANENT" Size="490" autoextend="true" blocksize="8192">/oracle/{SID}/oradata1/sysaux01.dbf</Name>
<Name id="3" Tablespace="UNDOTBS1" Contents="UNDO" Size="25" autoextend="true" blocksize="8192">/oracle/{SID}/oradata3/undotbs01.dbf</Name>
<Name id="4" Tablespace="USERS" Contents="PERMANENT" Size="5" autoextend="true" blocksize="8192">/oracle/{SID}/oradata3/users01.dbf</Name>
</DataFiles>
<TempFiles>
<Name id="1" Tablespace="TEMP" Contents="TEMPORARY" Size="20">/oracle/{SID}/oradata2/temp01.dbf</Name>
</TempFiles>
<ControlfileAttributes id="Controlfile">
<maxDatafiles>256</maxDatafiles>
<maxLogfiles>16</maxLogfiles>
<maxLogMembers>3</maxLogMembers>
<maxLogHistory>1</maxLogHistory>
<maxInstances>8</maxInstances>
<image name="control01.ctl" filepath="/oracle/{SID}/oradata1/"/>
<image name="control02.ctl" filepath="/oracle/{SID}/oradata2/"/>
<image name="control03.ctl" filepath="/oracle/{SID}/oradata3/"/>
</ControlfileAttributes>
<RedoLogGroupAttributes id="1">
<reuse>false</reuse>
<fileSize unit="MB">1024</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo01.log" filepath="/oracle/{SID}/oradata1/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="2">
<reuse>false</reuse>
<fileSize unit="MB">1024</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo02.log" filepath="/oracle/{SID}/oradata2/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="3">
<reuse>false</reuse>
<fileSize unit="MB">1024</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo03.log" filepath="/oracle/{SID}/oradata3/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="4">
<reuse>false</reuse>
<fileSize unit="MB">1024</fileSize>
<Thread>1</Thread>
<member ordinal="1" memberName="redo04.log" filepath="/oracle/{SID}/oradata4/"/>
</RedoLogGroupAttributes>
</StorageAttributes>
</DatabaseTemplate>
clone template with extra additions for our standards, setup just the way we like it![edit]
Using a clone template (.dbc extension, 'c' for clone) allows for a quicker db creation as it uses RMAN to create the db from a seeded database and applies the alterations.
SHB - best one so far...
<?xml version = '1.0'?>
<DatabaseTemplate name="dedicated_home" description="oracle_home in /oracle/SID/product/11.2.0.4, archivelogs in /oracle/SID/arch, 4 redo log groups" version="11.1.0.0.0">
<CommonAttributes>
<option name="OMS" value="false"/>
<option name="JSERVER" value="true"/>
<option name="SPATIAL" value="true"/>
<option name="IMEDIA" value="true"/>
<option name="XDB_PROTOCOLS" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="ORACLE_TEXT" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="SAMPLE_SCHEMA" value="false"/>
<option name="CWMLITE" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="EM_REPOSITORY" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="APEX" value="true"/>
<option name="OWB" value="true"/>
<option name="DV" value="false"/>
</CommonAttributes>
<Variables/>
<CustomScripts Execute="false"/>
<InitParamAttributes>
<InitParams>
<initParam name="large_pool_size" value="0"/>
<initParam name="db_name" value="{SID}"/>
<initParam name="db_domain" value=""/>
<initParam name="dispatchers" value="(PROTOCOL=TCP) (SERVICE={SID}XDB)"/>
<initParam name="memory_max_target" value="2147483648"/>
<initParam name="audit_file_dest" value="{ORACLE_BASE}/admin/{SID}/adump"/>
<initParam name="compatible" value="11.2.0.4.0"/>
<initParam name="shared_pool_size" value="0"/>
<initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>
<initParam name="log_archive_dest_1" value="'LOCATION={ORACLE_BASE}/arch/{SID}'"/>
<initParam name="sga_target" value="0"/>
<initParam name="processes" value="300"/>
<initParam name="undo_tablespace" value="UNDOTBS1"/>
<initParam name="control_files" value="('{ORACLE_BASE}/oradata1/control01.ctl', '{ORACLE_BASE}/oradata2/control02.ctl', '{ORACLE_BASE}/oradata3/control03.ctl')"/>
<initParam name="diagnostic_dest" value="{ORACLE_BASE}"/>
<initParam name="sec_max_failed_login_attempts" value="4"/>
<initParam name="sec_protocol_error_trace_action" value="LOG"/>
<initParam name="db_recovery_file_dest" value="{ORACLE_BASE}/fra"/>
<initParam name="audit_trail" value="DB"/>
<initParam name="audit_sys_operations" value="TRUE"/>
<initParam name="log_archive_format" value="{SID}_t%t_s%s_r%r.dbf"/>
<initParam name="memory_target" value="3276" unit="MB"/>
<initParam name="sec_case_sensitive_logon" value="FALSE"/>
<initParam name="sessions" value="472"/>
<initParam name="streams_pool_size" value="32" unit="MB"/>
<initParam name="db_block_size" value="8192"/>
<initParam name="java_pool_size" value="0"/>
<initParam name="open_cursors" value="300"/>
<initParam name="db_recovery_file_dest_size" value="1400" unit="MB"/>
<initParam name="db_flashback_retention_target" value="10800"/>
<initParam name="pga_aggregate_target" value="0"/>
</InitParams>
<MiscParams>
<databaseType>MULTIPURPOSE</databaseType>
<maxUserConn>20</maxUserConn>
<archiveLogMode>true</archiveLogMode>
<initParamFileName>{ORACLE_BASE}/admin/{SID}/pfile/init.ora</initParamFileName>
</MiscParams>
<SPfile useSPFile="true">{ORACLE_HOME}/dbs/spfile{SID}.ora</SPfile>
</InitParamAttributes>
<StorageAttributes>
<DataFiles>
<Location>{ORACLE_HOME}/assistants/dbca/templates/Seed_Database.dfb</Location>
<SourceDBName>seeddata</SourceDBName>
<Name id="1" Tablespace="SYSTEM" Contents="PERMANENT" Size="700" autoextend="true" blocksize="8192">/{ORACLE_BASE}/oradata1/system01.dbf</Name>
<Name id="2" Tablespace="SYSAUX" Contents="PERMANENT" Size="490" autoextend="true" blocksize="8192">/{ORACLE_BASE}/oradata1/sysaux01.dbf</Name>
<Name id="3" Tablespace="UNDOTBS1" Contents="UNDO" Size="25" autoextend="true" blocksize="8192">/{ORACLE_BASE}/oradata3/undotbs01.dbf</Name>
<Name id="4" Tablespace="USERS" Contents="PERMANENT" Size="5" autoextend="true" blocksize="8192">/{ORACLE_BASE}/oradata3/users01.dbf</Name>
</DataFiles>
<TempFiles>
<Name id="1" Tablespace="TEMP" Contents="TEMPORARY" Size="20">/{ORACLE_BASE}/oradata2/temp01.dbf</Name>
</TempFiles>
<ControlfileAttributes id="Controlfile">
<maxDatafiles>256</maxDatafiles>
<maxLogfiles>16</maxLogfiles>
<maxLogMembers>3</maxLogMembers>
<maxLogHistory>1</maxLogHistory>
<maxInstances>8</maxInstances>
<image name="control01.ctl" filepath="/{ORACLE_BASE}/oradata1/"/>
<image name="control02.ctl" filepath="/{ORACLE_BASE}/oradata2/"/>
<image name="control03.ctl" filepath="/{ORACLE_BASE}/oradata3/"/>
</ControlfileAttributes>
<RedoLogGroupAttributes id="1">
<reuse>false</reuse>
<fileSize unit="MB">100</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo01.log" filepath="{ORACLE_BASE}/oradata1/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="2">
<reuse>false</reuse>
<fileSize unit="MB">100</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo02.log" filepath="{ORACLE_BASE}/oradata2/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="3">
<reuse>false</reuse>
<fileSize unit="MB">100</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo03.log" filepath="{ORACLE_BASE}/oradata3/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="4">
<reuse>false</reuse>
<fileSize unit="MB">100</fileSize>
<Thread>1</Thread>
<member ordinal="1" memberName="redo04.log" filepath="{ORACLE_BASE}/oradata4/"/>
</RedoLogGroupAttributes>
</StorageAttributes>
</DatabaseTemplate>
Create RAC database on ASM for Enterprise Manager Repository (OMR) using silent option[edit]
#!/bin/sh
WHOAMI=`/usr/bin/whoami`
ID=/usr/bin/id
USER=`/usr/bin/id -u oracle`
CURRID=`/usr/bin/id -u`
if [ "X$USER" != "X$CURRID" ]; then
echo "This should be run as oracle ($USER) but is being run by $WHOAMI - $CURRID"
exit 1
fi
ORACLE_SID=OEMREP;export ORACLE_SID
ORACLE_BASE=/u01/app/oracle;export ORACLE_BASE
ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1;export ORACLE_HOME
PATH=/u01/app/11.2.0.4/grid/tfa/sdtcsynoda01-rac/tfa_home/bin:/opt/oracle/oak/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/opt/oracle/oak/lib/oaklib:/opt/oracle/oak/lib/oaklib:$ORACLE_HOME/bin;export PATH
/u01/app/oracle/product/11.2.0.4/dbhome_1/bin/dbca -createDatabase -silent \
-gdbName OEMREP \
-sid OEMREP \
-sysPassword g43u5fwf \
-systemPassword wer4fr4c \
-emConfiguration LOCAL \
-dbsnmpPassword vgwreybv \
-sysmanPassword aw3vrv44 \
-diskGroupName 'DATA' \
-recoveryGroupName 'RECO' \
-storageType ASM \
-asmSysPassword bwr6yb65 \
-nodelist 'sdtcsynoda01-rac,sdtcsynoda02-rac' \
-characterSet AL32UTF8 \
-nationalCharacterSet AL16UTF16 \
-databaseType MULTIPURPOSE \
-responseFile NO_VALUE \
-templateName odadbtmp_32625.dbt
Install Oracle 12c software with dedicated binaries[edit]
After going through the GUI and saving the response file, this is what it looks like
(0) RMANV12@benouora001:/oracle/RMANV12> cat db.rsp #################################################################### ## Copyright(c) Oracle Corporation 1998,2013. All rights reserved.## ## ## ## Specify values for the variables listed below to customize ## ## your installation. ## ## ## ## Each variable is associated with a comment. The comment ## ## can help to populate the variables with the appropriate ## ## values. ## ## ## ## IMPORTANT NOTE: This file contains plain text passwords and ## ## should be secured to have read permission only by oracle user ## ## or db administrator who owns this installation. ## ## ## #################################################################### #------------------------------------------------------------------------------- # Do not change the following system generated value. #------------------------------------------------------------------------------- oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.1.0 #------------------------------------------------------------------------------- # Specify the installation option. # It can be one of the following: # - INSTALL_DB_SWONLY # - INSTALL_DB_AND_CONFIG # - UPGRADE_DB #------------------------------------------------------------------------------- oracle.install.option=INSTALL_DB_SWONLY #------------------------------------------------------------------------------- # Specify the hostname of the system as set during the install. It can be used # to force the installation to use an alternative hostname rather than using the # first hostname found on the system. (e.g., for systems with multiple hostnames # and network interfaces) #------------------------------------------------------------------------------- ORACLE_HOSTNAME=benouora001 #------------------------------------------------------------------------------- # Specify the Unix group to be set for the inventory directory. #------------------------------------------------------------------------------- UNIX_GROUP_NAME=dba #------------------------------------------------------------------------------- # Specify the location which holds the inventory files. # This is an optional parameter if installing on # Windows based Operating System. #------------------------------------------------------------------------------- INVENTORY_LOCATION=/oracle/RMANV12/oraInventory/12.1.0.1 #------------------------------------------------------------------------------- # Specify the languages in which the components will be installed. # # en : English ja : Japanese # fr : French ko : Korean # ar : Arabic es : Latin American Spanish # bn : Bengali lv : Latvian # pt_BR: Brazilian Portuguese lt : Lithuanian # bg : Bulgarian ms : Malay # fr_CA: Canadian French es_MX: Mexican Spanish # ca : Catalan no : Norwegian # hr : Croatian pl : Polish # cs : Czech pt : Portuguese # da : Danish ro : Romanian # nl : Dutch ru : Russian # ar_EG: Egyptian zh_CN: Simplified Chinese # en_GB: English (Great Britain) sk : Slovak # et : Estonian sl : Slovenian # fi : Finnish es_ES: Spanish # de : German sv : Swedish # el : Greek th : Thai # iw : Hebrew zh_TW: Traditional Chinese # hu : Hungarian tr : Turkish # is : Icelandic uk : Ukrainian # in : Indonesian vi : Vietnamese # it : Italian # # all_langs : All languages # # Specify value as the following to select any of the languages. # Example : SELECTED_LANGUAGES=en,fr,ja # # Specify value as the following to select all the languages. # Example : SELECTED_LANGUAGES=all_langs #------------------------------------------------------------------------------- SELECTED_LANGUAGES=ar,bn,pt_BR,bg,fr_CA,ca,hr,cs,da,nl,ar_EG,en,en_GB,et,fi,fr,de,el,iw,hu,is,in,it,ja,ko,es,lv,lt,ms,es_MX,no,pl,pt,ro,ru,zh_CN,sk,sl,es_ES,sv,th,zh_TW,tr,uk,vi #------------------------------------------------------------------------------- # Specify the complete path of the Oracle Home. #------------------------------------------------------------------------------- ORACLE_HOME=/oracle/RMANV12/product/12.1.0.1/ #------------------------------------------------------------------------------- # Specify the complete path of the Oracle Base. #------------------------------------------------------------------------------- ORACLE_BASE=/oracle/RMANV12 #------------------------------------------------------------------------------- # Specify the installation edition of the component. # # The value should contain only one of these choices. # - EE : Enterprise Edition # - SE : Standard Edition # - SEONE : Standard Edition One # - PE : Personal Edition (WINDOWS ONLY) #------------------------------------------------------------------------------- oracle.install.db.InstallEdition=EE ############################################################################### # # # PRIVILEGED OPERATING SYSTEM GROUPS # # ------------------------------------------ # # Provide values for the OS groups to which OSDBA and OSOPER privileges # # needs to be granted. If the install is being performed as a member of the # # group "dba", then that will be used unless specified otherwise below. # # # # The value to be specified for OSDBA and OSOPER group is only for UNIX based # # Operating System. # # # ############################################################################### #------------------------------------------------------------------------------ # The DBA_GROUP is the OS group which is to be granted OSDBA privileges. #------------------------------------------------------------------------------- oracle.install.db.DBA_GROUP=dba #------------------------------------------------------------------------------ # The OPER_GROUP is the OS group which is to be granted OSOPER privileges. # The value to be specified for OSOPER group is optional. #------------------------------------------------------------------------------ oracle.install.db.OPER_GROUP=dba #------------------------------------------------------------------------------ # The BACKUPDBA_GROUP is the OS group which is to be granted OSBACKUPDBA privileges. #------------------------------------------------------------------------------ oracle.install.db.BACKUPDBA_GROUP=dba #------------------------------------------------------------------------------ # The DGDBA_GROUP is the OS group which is to be granted OSDGDBA privileges. #------------------------------------------------------------------------------ oracle.install.db.DGDBA_GROUP=dba #------------------------------------------------------------------------------ # The KMDBA_GROUP is the OS group which is to be granted OSKMDBA privileges. #------------------------------------------------------------------------------ oracle.install.db.KMDBA_GROUP=dba ############################################################################### # # # Grid Options # # # ############################################################################### #------------------------------------------------------------------------------ # Specify the type of Real Application Cluster Database # # - ADMIN_MANAGED: Admin-Managed # - POLICY_MANAGED: Policy-Managed # # If left unspecified, default will be ADMIN_MANAGED #------------------------------------------------------------------------------ oracle.install.db.rac.configurationType= #------------------------------------------------------------------------------ # Value is required only if RAC database type is ADMIN_MANAGED # # Specify the cluster node names selected during the installation. # Leaving it blank will result in install on local server only (Single Instance) # # Example : oracle.install.db.CLUSTER_NODES=node1,node2 #------------------------------------------------------------------------------ oracle.install.db.CLUSTER_NODES= #------------------------------------------------------------------------------ # This variable is used to enable or disable RAC One Node install. # # - true : Value of RAC One Node service name is used. # - false : Value of RAC One Node service name is not used. # # If left blank, it will be assumed to be false. #------------------------------------------------------------------------------ oracle.install.db.isRACOneInstall=false #------------------------------------------------------------------------------ # Value is required only if oracle.install.db.isRACOneInstall is true. # # Specify the name for RAC One Node Service #------------------------------------------------------------------------------ oracle.install.db.racOneServiceName= #------------------------------------------------------------------------------ # Value is required only if RAC database type is POLICY_MANAGED # # Specify a name for the new Server pool that will be configured # Example : oracle.install.db.rac.serverpoolName=pool1 #------------------------------------------------------------------------------ oracle.install.db.rac.serverpoolName= #------------------------------------------------------------------------------ # Value is required only if RAC database type is POLICY_MANAGED # # Specify a number as cardinality for the new Server pool that will be configured # Example : oracle.install.db.rac.serverpoolCardinality=2 #------------------------------------------------------------------------------ oracle.install.db.rac.serverpoolCardinality=0 ############################################################################### # # # Database Configuration Options # # # ############################################################################### #------------------------------------------------------------------------------- # Specify the type of database to create. # It can be one of the following: # - GENERAL_PURPOSE/TRANSACTION_PROCESSING # - DATA_WAREHOUSE #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.type=GENERAL_PURPOSE #------------------------------------------------------------------------------- # Specify the Starter Database Global Database Name. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.globalDBName= #------------------------------------------------------------------------------- # Specify the Starter Database SID. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.SID= #------------------------------------------------------------------------------- # Specify whether the database should be configured as a Container database. #------------------------------------------------------------------------------- oracle.install.db.ConfigureAsContainerDB=false #------------------------------------------------------------------------------- # Specify the Pluggable Database name for the pluggable database in Container Database. #------------------------------------------------------------------------------- oracle.install.db.config.PDBName= #------------------------------------------------------------------------------- # Specify the Starter Database character set. # # One of the following # AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2, # EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257, # BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6, # AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8, # IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE, # KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950, # ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258 #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.characterSet= #------------------------------------------------------------------------------ # This variable should be set to true if Automatic Memory Management # in Database is desired. # If Automatic Memory Management is not desired, and memory allocation # is to be done manually, then set it to false. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.memoryOption=false #------------------------------------------------------------------------------- # Specify the total memory allocation for the database. Value(in MB) should be # at least 256 MB, and should not exceed the total physical memory available # on the system. # Example: oracle.install.db.config.starterdb.memoryLimit=512 #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.memoryLimit= #------------------------------------------------------------------------------- # This variable controls whether to load Example Schemas onto # the starter database or not. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.installExampleSchemas=false ############################################################################### # # # Passwords can be supplied for the following four schemas in the # # starter database: # # SYS # # SYSTEM # # DBSNMP (used by Enterprise Manager) # # # # Same password can be used for all accounts (not recommended) # # or different passwords for each account can be provided (recommended) # # # ############################################################################### #------------------------------------------------------------------------------ # This variable holds the password that is to be used for all schemas in the # starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.ALL= #------------------------------------------------------------------------------- # Specify the SYS password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYS= #------------------------------------------------------------------------------- # Specify the SYSTEM password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYSTEM= #------------------------------------------------------------------------------- # Specify the DBSNMP password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.DBSNMP= #------------------------------------------------------------------------------- # Specify the PDBADMIN password required for creation of Pluggable Database in the Container Database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.PDBADMIN= #------------------------------------------------------------------------------- # Specify the management option to use for managing the database. # Options are: # 1. CLOUD_CONTROL - If you want to manage your database with Enterprise Manager Cloud Control along with Database Express. # 2. DEFAULT -If you want to manage your database using the default Database Express option. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.managementOption=DEFAULT #------------------------------------------------------------------------------- # Specify the OMS host to connect to Cloud Control. # Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.omsHost= #------------------------------------------------------------------------------- # Specify the OMS port to connect to Cloud Control. # Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.omsPort=0 #------------------------------------------------------------------------------- # Specify the EM Admin user name to use to connect to Cloud Control. # Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.emAdminUser= #------------------------------------------------------------------------------- # Specify the EM Admin password to use to connect to Cloud Control. # Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.emAdminPassword= ############################################################################### # # # SPECIFY RECOVERY OPTIONS # # ------------------------------------ # # Recovery options for the database can be mentioned using the entries below # # # ############################################################################### #------------------------------------------------------------------------------ # This variable is to be set to false if database recovery is not required. Else # this can be set to true. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.enableRecovery=false #------------------------------------------------------------------------------- # Specify the type of storage to use for the database. # It can be one of the following: # - FILE_SYSTEM_STORAGE # - ASM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.storageType= #------------------------------------------------------------------------------- # Specify the database file location which is a directory for datafiles, control # files, redo logs. # # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.fileSystemStorage.dataLocation= #------------------------------------------------------------------------------- # Specify the recovery location. # # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation= #------------------------------------------------------------------------------- # Specify the existing ASM disk groups to be used for storage. # # Applicable only when oracle.install.db.config.starterdb.storageType=ASM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.asm.diskGroup= #------------------------------------------------------------------------------- # Specify the password for ASMSNMP user of the ASM instance. # # Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.asm.ASMSNMPPassword= #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username. # # Example : [email protected] #------------------------------------------------------------------------------ MYORACLESUPPORT_USERNAME= #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username password. # # Example : MYORACLESUPPORT_PASSWORD=password #------------------------------------------------------------------------------ MYORACLESUPPORT_PASSWORD= #------------------------------------------------------------------------------ # Specify whether to enable the user to set the password for # My Oracle Support credentials. The value can be either true or false. # If left blank it will be assumed to be false. # # Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true #------------------------------------------------------------------------------ SECURITY_UPDATES_VIA_MYORACLESUPPORT=false #------------------------------------------------------------------------------ # Specify whether user doesn't want to configure Security Updates. # The value for this variable should be true if you don't want to configure # Security Updates, false otherwise. # # The value can be either true or false. If left blank it will be assumed # to be false. # # Example : DECLINE_SECURITY_UPDATES=false #------------------------------------------------------------------------------ DECLINE_SECURITY_UPDATES=true #------------------------------------------------------------------------------ # Specify the Proxy server name. Length should be greater than zero. # # Example : PROXY_HOST=proxy.domain.com #------------------------------------------------------------------------------ PROXY_HOST= #------------------------------------------------------------------------------ # Specify the proxy port number. Should be Numeric and atleast 2 chars. # # Example : PROXY_PORT=25 #------------------------------------------------------------------------------ PROXY_PORT= #------------------------------------------------------------------------------ # Specify the proxy user name. Leave PROXY_USER and PROXY_PWD # blank if your proxy server requires no authentication. # # Example : PROXY_USER=username #------------------------------------------------------------------------------ PROXY_USER= #------------------------------------------------------------------------------ # Specify the proxy password. Leave PROXY_USER and PROXY_PWD # blank if your proxy server requires no authentication. # # Example : PROXY_PWD=password #------------------------------------------------------------------------------ PROXY_PWD= #------------------------------------------------------------------------------ # Specify the proxy realm. # # Example : PROXY_REALM=metalink #------------------------------------------------------------------------------ PROXY_REALM= #------------------------------------------------------------------------------ # Specify the Oracle Support Hub URL. # # Example : COLLECTOR_SUPPORTHUB_URL=https://orasupporthub.company.com:8080/ #------------------------------------------------------------------------------ COLLECTOR_SUPPORTHUB_URL= #------------------------------------------------------------------------------ # Specify the auto-updates option. It can be one of the following: # - MYORACLESUPPORT_DOWNLOAD # - OFFLINE_UPDATES # - SKIP_UPDATES #------------------------------------------------------------------------------ oracle.installer.autoupdates.option=SKIP_UPDATES #------------------------------------------------------------------------------ # In case MYORACLESUPPORT_DOWNLOAD option is chosen, specify the location where # the updates are to be downloaded. # In case OFFLINE_UPDATES option is chosen, specify the location where the updates # are present. #------------------------------------------------------------------------------ oracle.installer.autoupdates.downloadUpdatesLoc= #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username which has the patches download privileges # to be used for software updates. # Example : [email protected] #------------------------------------------------------------------------------ AUTOUPDATES_MYORACLESUPPORT_USERNAME= #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username password which has the patches download privileges # to be used for software updates. # # Example : AUTOUPDATES_MYORACLESUPPORT_PASSWORD=password #------------------------------------------------------------------------------
[edit]
- see https://docs.oracle.com/database/121/ADMIN/create.htm#ADMIN14036 for all dbca options
The following template is for databases that will have a shared shared set of oracle product binaries (version 12)
There could be many databases using the same ORACLE_HOME
export ORACLE_BASE=/oracle export ORACLE_HOME=$ORACLE_BASE/product/12.1.0.2 export PATH=$ORACLE_HOME/bin:$PATH
$ORACLE_HOME/bin/dbca -silent \
-createdatabase \
-createAsContainerDatabase false \
-templatename ${ORACLE_HOME}/assistants/dbca/templates/shared_code.dbc \
-gdbname RMANV12 \
-sid RMANV12 \
-syspassword qwertyuiop \
-systempassword asdfghjkl \
-characterset AL32UTF8 \
-nationalcharacterset AL16UTF16 \
-automaticMemoryManagement true \
-totalMemory 3000000000 \
-initparams processes=400 \
-initparams enable_pluggable_database=false
Generated by dbca and saved just before creation...
<?xml version = '1.0'?>
<DatabaseTemplate name="SHARED_BINARIES" description="Shared binaries - General Purpose." version="12.1.0.0.0">
<CommonAttributes>
<option name="OMS" value="true"/>
<option name="JSERVER" value="true"/>
<option name="SPATIAL" value="true"/>
<option name="IMEDIA" value="true"/>
<option name="XDB_PROTOCOLS" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="ORACLE_TEXT" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="SAMPLE_SCHEMA" value="false"/>
<option name="CWMLITE" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="APEX" value="true"/>
<option name="DV" value="true"/>
</CommonAttributes>
<Variables/>
<CustomScripts Execute="false"/>
<InitParamAttributes>
<InitParams>
<initParam name="db_name" value="{SID}"/>
<initParam name="db_domain" value=""/>
<initParam name="dispatchers" value="(PROTOCOL=TCP) (SERVICE={DB_NAME}XDB)"/>
<initParam name="audit_file_dest" value="/oracle/{DB_NAME}/admin/adump"/>
<initParam name="compatible" value="12.1.0.0.0"/>
<initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>
<initParam name="log_archive_dest_1" value="'LOCATION=/oracle/{DB_NAME}/arch'"/>
<initParam name="processes" value="300"/>
<initParam name="local_listener" value="LISTENER_{DB_NAME}"/>
<initParam name="undo_tablespace" value="UNDOTBS1"/>
<initParam name="control_files" value="("/oracle/{DB_NAME}/oradata1/control01.ctl", "/oracle/{DB_NAME}/oradata2/control02.ctl", "/oracle/{DB_NAME}/oradata3/control03.ctl")"/>
<initParam name="diagnostic_dest" value="/oracle"/>
<initParam name="db_recovery_file_dest" value="/oracle/{DB_NAME}/fra"/>
<initParam name="audit_trail" value="db"/>
<initParam name="log_archive_format" value="{DB_NAME}_t%t_s%s_r%r.dbf"/>
<initParam name="memory_target" value="2000" unit="MB"/>
<initParam name="db_block_size" value="8" unit="KB"/>
<initParam name="open_cursors" value="300"/>
<initParam name="db_recovery_file_dest_size" value="4800" unit="MB"/>
</InitParams>
<MiscParams>
<databaseType>MULTIPURPOSE</databaseType>
<maxUserConn>20</maxUserConn>
<percentageMemTOSGA>2</percentageMemTOSGA>
<customSGA>false</customSGA>
<archiveLogMode>true</archiveLogMode>
<initParamFileName>/oracle/{DB_NAME}/admin/pfile/init.ora</initParamFileName>
</MiscParams>
<SPfile useSPFile="true">{ORACLE_HOME}/dbs/spfile{DB_NAME}.ora</SPfile>
</InitParamAttributes>
<StorageAttributes>
<DataFiles>
<Location>{ORACLE_HOME}/assistants/dbca/templates/Seed_Database.dfb</Location>
<SourceDBName cdb="true">seeddata</SourceDBName>
<Name id="1" Tablespace="SYSTEM" Contents="PERMANENT" Size="770" autoextend="true" blocksize="8192" con_id="1">/oracle/{DB_NAME}/oradata1/system01.dbf</Name>
<Name id="3" Tablespace="SYSAUX" Contents="PERMANENT" Size="650" autoextend="true" blocksize="8192" con_id="1">/oracle/{DB_NAME}/oradata1/sysaux01.dbf</Name>
<Name id="4" Tablespace="UNDOTBS1" Contents="UNDO" Size="25" autoextend="true" blocksize="8192" con_id="1">/oracle/{DB_NAME}/oradata3/undotbs01.dbf</Name>
<Name id="6" Tablespace="USERS" Contents="PERMANENT" Size="5" autoextend="true" blocksize="8192" con_id="1">/oracle/{DB_NAME}/oradata3/users01.dbf</Name>
</DataFiles>
<TempFiles>
<Name id="1" Tablespace="TEMP" Contents="TEMPORARY" Size="64" con_id="1">/oracle/{DB_NAME}/oradata2/temp01.dbf</Name>
</TempFiles>
<ControlfileAttributes id="Controlfile">
<maxDatafiles>256</maxDatafiles>
<maxLogfiles>16</maxLogfiles>
<maxLogMembers>3</maxLogMembers>
<maxLogHistory>1</maxLogHistory>
<maxInstances>8</maxInstances>
<image name="control01.ctl" filepath="/oracle/{DB_NAME}/oradata1/"/>
<image name="control02.ctl" filepath="/oracle/{DB_NAME}/oradata2/"/>
<image name="control03.ctl" filepath="/oracle/{DB_NAME}/oradata3/"/>
</ControlfileAttributes>
<RedoLogGroupAttributes id="1">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo01.dbf" filepath="/oracle/{DB_NAME}/oradata1/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="2">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo02.dbf" filepath="/oracle/{DB_NAME}/oradata2/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="3">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo03.dbf" filepath="/oracle/{DB_NAME}/oradata3/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="4">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo04.dbf" filepath="/oracle/{DB_NAME}/oradata4/"/>
</RedoLogGroupAttributes>
</StorageAttributes>
</DatabaseTemplate>
Hand-rolled
<?xml version = '1.0'?>
<DatabaseTemplate name="IBM_dedicated_product_code" description="home in /oracle/SID/product/12.1.0.1, archivelogs in /oracle/SID/arch, 4 redo log groups, 1 member of 1G each" version="12.1.0.0.0">
<CommonAttributes>
<option name="OMS" value="true"/>
<option name="JSERVER" value="true"/>
<option name="SPATIAL" value="true"/>
<option name="IMEDIA" value="true"/>
<option name="XDB_PROTOCOLS" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="EM_REPOSITORY" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="ORACLE_TEXT" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="SAMPLE_SCHEMA" value="false"/>
<option name="CWMLITE" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="APEX" value="true"/>
<option name="DV" value="true"/>
</CommonAttributes>
<Variables/>
<CustomScripts Execute="false"/>
<InitParamAttributes>
<InitParams>
<initParam name="db_name" value="{SID}"/>
<initParam name="dispatchers" value="(PROTOCOL=TCP) (SERVICE={SID}XDB)"/>
<initParam name="audit_file_dest" value="/oracle/{SID}/admin/adump"/>
<initParam name="compatible" value="12.1.0.0.0"/>
<initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>
<initParam name="processes" value="300"/>
<initParam name="undo_tablespace" value="UNDOTBS1"/>
<initParam name="control_files" value="("/oracle/oradata1/{SID}/control01.ctl", "/oracle/oradata2/{SID}/control02.ctl", "/oracle/oradata3/{SID}/control03.ctl")"/>
<initParam name="diagnostic_dest" value="/oracle/{SID}"/>
<initParam name="db_recovery_file_dest" value="/oracle/{SID}/fra"/>
<initParam name="audit_trail" value="db"/>
<initParam name="memory_target" value="2500" unit="MB"/>
<initParam name="db_block_size" value="8" unit="KB"/>
<initParam name="open_cursors" value="300"/>
<initParam name="db_recovery_file_dest_size" value="1400" unit="MB"/>
<initParam name="log_archive_dest_1" value="'LOCATION=/oracle/{SID}/arch'"/>
<initParam name="local_listener" value="LISTENER_{SID}"/>
<initParam name="log_archive_format" value="{SID}_t%t_s%s_r%r.dbf"/>
<initParam name="memory_target" value="3276" unit="MB"/>
<initParam name="sessions" value="335"/>
</InitParams>
<MiscParams>
<databaseType>MULTIPURPOSE</databaseType>
<maxUserConn>20</maxUserConn>
<percentageMemTOSGA>40</percentageMemTOSGA>
<customSGA>false</customSGA>
<archiveLogMode>true</archiveLogMode>
<initParamFileName>/oracle/{SID}/admin/pfile/init.ora</initParamFileName>
</MiscParams>
<SPfile useSPFile="true">{ORACLE_HOME}/dbs/spfile{SID}.ora</SPfile>
</InitParamAttributes>
<StorageAttributes>
<DataFiles>
<Location>{ORACLE_HOME}/assistants/dbca/templates/Seed_Database.dfb</Location>
<SourceDBName cdb="true">seeddata</SourceDBName>
<Name id="1" Tablespace="SYSTEM" Contents="PERMANENT" Size="770" autoextend="true" blocksize="8192" con_id="1">/oracle/{SID}/oradata1/system01.dbf</Name>
<Name id="3" Tablespace="SYSAUX" Contents="PERMANENT" Size="650" autoextend="true" blocksize="8192" con_id="1">/oracle/{SID}/oradata1/sysaux01.dbf</Name>
<Name id="4" Tablespace="UNDOTBS1" Contents="UNDO" Size="25" autoextend="true" blocksize="8192" con_id="1">/oracle/{SID}/oradata3/undotbs01.dbf</Name>
<Name id="6" Tablespace="USERS" Contents="PERMANENT" Size="5" autoextend="true" blocksize="8192" con_id="1">/oracle/{SID}/oradata2/users01.dbf</Name>
</DataFiles>
<TempFiles>
<Name id="1" Tablespace="TEMP" Contents="TEMPORARY" Size="60" con_id="1">/oracle/{SID}/oradata3/temp01.dbf</Name>
</TempFiles>
<ControlfileAttributes id="Controlfile">
<maxDatafiles>256</maxDatafiles>
<maxLogfiles>16</maxLogfiles>
<maxLogMembers>3</maxLogMembers>
<maxLogHistory>1</maxLogHistory>
<maxInstances>8</maxInstances>
<image name="control01.ctl" filepath="/oracle/{SID}/oradata1/"/>
<image name="control02.ctl" filepath="/oracle/{SID}/oradata2/"/>
<image name="control03.ctl" filepath="/oracle/{SID}/oradata3/"/>
</ControlfileAttributes>
<RedoLogGroupAttributes id="1">
<reuse>false</reuse>
<fileSize unit="MB">1024</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo01.log" filepath="/oracle/{SID}/oradata1/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="2">
<reuse>false</reuse>
<fileSize unit="MB">1024</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo02.log" filepath="/oracle/{SID}/oradata2/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="3">
<reuse>false</reuse>
<fileSize unit="MB">1024</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo03.log" filepath="/oracle/{SID}/oradata3/"/>
</RedoLogGroupAttributes>
</StorageAttributes>
</DatabaseTemplate>
and one generated using the "Custom" database type[edit]
<DatabaseTemplate name="RMANV12" description="This is a template created from an existing template - New Database." version="12.1.0.2.0">
<CommonAttributes>
<option name="OMS" value="false"/>
<option name="JSERVER" value="true"/>
<option name="SPATIAL" value="true"/>
<option name="IMEDIA" value="true"/>
<option name="XDB_PROTOCOLS" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="ORACLE_TEXT" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="SAMPLE_SCHEMA" value="false"/>
<option name="CWMLITE" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="APEX" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="DV" value="false">
<tablespace id="SYSAUX"/>
</option>
</CommonAttributes>
<Variables/>
<CustomScripts Execute="false"/>
<InitParamAttributes>
<InitParams>
<initParam name="sga_max_size" value="0"/>
<initParam name="db_name" value="RMANV12"/>
<initParam name="db_domain" value=""/>
<initParam name="dispatchers" value="(PROTOCOL=TCP) (SERVICE={SID}XDB)"/>
<initParam name="memory_max_target" value="2200"/>
<initParam name="audit_file_dest" value="{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump"/>
<initParam name="compatible" value="12.1.0.2.0"/>
<initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>
<initParam name="log_archive_dest_1" value="'LOCATION=/oracle/{SID}/arch'"/>
<initParam name="sga_target" value="2000" unit="MB"/>
<initParam name="processes" value="300"/>
<initParam name="local_listener" value="LISTENER_RMANV12"/>
<initParam name="undo_tablespace" value="UNDOTBS1"/>
<initParam name="control_files" value="("{ORACLE_BASE}/{SID}/{DB_UNIQUE_NAME}/control01.ctl", "{ORACLE_BASE}/fra/{DB_UNIQUE_NAME}/control02.ctl")"/>
<initParam name="diagnostic_dest" value="{ORACLE_BASE}"/>
<initParam name="db_recovery_file_dest" value="{ORACLE_BASE}/fra"/>
<initParam name="audit_trail" value="db"/>
<initParam name="log_archive_format" value="{SID}_%t_%s_%r.dbf"/>
<initParam name="memory_target" value="2200" unit="MB"/>
<initParam name="sessions" value="350"/>
<initParam name="db_block_size" value="8" unit="KB"/>
<initParam name="open_cursors" value="300"/>
<initParam name="db_recovery_file_dest_size" value="3000" unit="MB"/>
<initParam name="pga_aggregate_target" value="600" unit="MB"/>
</InitParams>
<MiscParams>
<databaseType>MULTIPURPOSE</databaseType>
<maxUserConn>20</maxUserConn>
<percentageMemTOSGA>40</percentageMemTOSGA>
<customSGA>true</customSGA>
<characterSet>WE8MSWIN1252</characterSet>
<nationalCharacterSet>AL16UTF16</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>
<ControlfileAttributes id="Controlfile">
<maxDatafiles>100</maxDatafiles>
<maxLogfiles>16</maxLogfiles>
<maxLogMembers>3</maxLogMembers>
<maxLogHistory>1</maxLogHistory>
<maxInstances>8</maxInstances>
<image name="control01.ctl" filepath="{ORACLE_BASE}/{SID}/{DB_UNIQUE_NAME}/"/>
<image name="control02.ctl" filepath="{ORACLE_BASE}/fra/{DB_UNIQUE_NAME}/"/>
</ControlfileAttributes>
<DatafileAttributes id="{ORACLE_BASE}/{SID}/oradata1/sysaux01.dbf" con_id="1">
<tablespace>SYSAUX</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">550</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">10240</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="{ORACLE_BASE}/{SID}/oradata1/system01.dbf" con_id="1">
<tablespace>SYSTEM</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">700</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">10240</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="{ORACLE_BASE}/{SID}/oradata2/temp01.dbf" con_id="1">
<tablespace>TEMP</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">20</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">640</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="{ORACLE_BASE}/{SID}/oradata3/undotbs01.dbf" con_id="1">
<tablespace>UNDOTBS1</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">200</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">5120</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="{ORACLE_BASE}/{SID}/oradata3/users01.dbf" con_id="1">
<tablespace>USERS</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">5</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">1280</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<TablespaceAttributes id="SYSAUX" con_id="1">
<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="{ORACLE_BASE}/{SID}/oradata1/sysaux01.dbf"/>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="SYSTEM" con_id="1">
<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>false</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="{ORACLE_BASE}/{SID}/oradata1/system01.dbf"/>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="TEMP" con_id="1">
<temporary>true</temporary>
<defaultTemp>true</defaultTemp>
<undo>false</undo>
<local>true</local>
<blockSize>-1</blockSize>
<allocation>2</allocation>
<uniAllocSize unit="MB">100</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>false</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="{ORACLE_BASE}/{SID}/oradata2/temp01.dbf"/>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="UNDOTBS1" con_id="1">
<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="{ORACLE_BASE}/{SID}/oradata3/undotbs01.dbf"/>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="USERS" con_id="1">
<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="{ORACLE_BASE}/{SID}/oradata3/users01.dbf"/>
</datafilesList>
</TablespaceAttributes>
<RedoLogGroupAttributes id="1">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo01.log" filepath="{ORACLE_BASE}/{SID}/oradata1/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="2">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo02.log" filepath="{ORACLE_BASE}/{SID}/oradata2/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="3">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo03.log" filepath="{ORACLE_BASE}/{SID}/oradata3/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="4">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo04.log" filepath="{ORACLE_BASE}/{SID}/oradata4/"/>
</RedoLogGroupAttributes>
</StorageAttributes>
</DatabaseTemplate>
...another custom one generated from dbca on 11.2.0.4
<DatabaseTemplate name="shared_product_code" description=" " version="11.2.0.0.0">
<CommonAttributes>
<option name="OMS" value="false"/>
<option name="JSERVER" value="true"/>
<option name="SPATIAL" value="true"/>
<option name="IMEDIA" value="true"/>
<option name="XDB_PROTOCOLS" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="ORACLE_TEXT" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="SAMPLE_SCHEMA" value="false"/>
<option name="CWMLITE" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="EM_REPOSITORY" value="true">
<tablespace id="SYSAUX"/>
</option>
<option name="APEX" value="true"/>
<option name="OWB" value="true"/>
<option name="DV" value="false"/>
</CommonAttributes>
<Variables/>
<CustomScripts Execute="false"/>
<InitParamAttributes>
<InitParams>
<initParam name="audit_file_dest" value="/oracle/{DB_NAME}/admin/adump"/>
<initParam name="audit_trail" value="db"/>
<initParam name="compatible" value="11.2.0.4.0"/>
<initParam name="control_files" value="("/oracle/{DB_NAME}/oradata1/control01.ctl", "/oracle/{DB_NAME}/oradata2/control02.ctl", "/oracle/{DB_NAME}/oradata3/control03.ctl")"/>
<initParam name="db_block_size" value="8" unit="KB"/>
<initParam name="db_domain" value=""/>
<initParam name="db_name" value="MARS01TD"/>
<initParam name="db_recovery_file_dest" value="{ORACLE_BASE}/fra"/>
<initParam name="db_recovery_file_dest_size" value="4000" unit="MB"/>
<initParam name="diagnostic_dest" value="{ORACLE_BASE}"/>
<initParam name="dispatchers" value="(PROTOCOL=TCP) (SERVICE={SID}XDB)"/>
<initParam name="local_listener" value="LISTENER_{DB_NAME}"/>
<initParam name="log_archive_dest_1" value="'LOCATION=/oracle/{DB_NAME}/arch'"/>
<initParam name="log_archive_format" value="{DB_NAME}_t%t_s%s_r%r.dbf"/>
<initParam name="memory_target" value="2000" unit="MB"/>
<initParam name="open_cursors" value="300"/>
<initParam name="processes" value="350"/>
<initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>
<initParam name="sga_max_size" value="0"/>
<initParam name="shared_pool_reserved_size" value="0"/>
<initParam name="shared_servers" value="0"/>
<initParam name="undo_retention" value="10800"/>
<initParam name="undo_tablespace" value="UNDOTBS1"/>
</InitParams>
<MiscParams>
<databaseType>MULTIPURPOSE</databaseType>
<maxUserConn>20</maxUserConn>
<percentageMemTOSGA>10</percentageMemTOSGA>
<customSGA>false</customSGA>
<characterSet>AL32UTF8</characterSet>
<nationalCharacterSet>AL16UTF16</nationalCharacterSet>
<archiveLogMode>true</archiveLogMode>
<initParamFileName>/oracle/{DB_NAME}/admin/pfile/init.ora</initParamFileName>
</MiscParams>
<SPfile useSPFile="true">{ORACLE_HOME}/dbs/spfile{SID}.ora</SPfile>
</InitParamAttributes>
<StorageAttributes>
<ControlfileAttributes id="Controlfile">
<maxDatafiles>256</maxDatafiles>
<maxLogfiles>16</maxLogfiles>
<maxLogMembers>3</maxLogMembers>
<maxLogHistory>1</maxLogHistory>
<maxInstances>8</maxInstances>
<image name="control01.ctl" filepath="/oracle/{DB_NAME}/oradata1/"/>
<image name="control02.ctl" filepath="/oracle/{DB_NAME}/oradata2/"/>
<image name="control03.ctl" filepath="/oracle/{DB_NAME}/oradata3/"/>
</ControlfileAttributes>
<DatafileAttributes id="/oracle/{DB_NAME}/oradata1/sysaux01.dbf">
<tablespace>SYSAUX</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">600</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">10240</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="/oracle/{DB_NAME}/oradata1/system01.dbf">
<tablespace>SYSTEM</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">700</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">10240</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="/oracle/{DB_NAME}/oradata2/temp01.dbf">
<tablespace>TEMP</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">20</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">640</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="/oracle/{DB_NAME}/oradata3/undotbs01.dbf">
<tablespace>UNDOTBS1</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">25</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">5120</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="/oracle/{DB_NAME}/oradata3/users01.dbf">
<tablespace>USERS</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">5</size>
<reuse>true</reuse>
<autoExtend>true</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="/oracle/{DB_NAME}/oradata1/sysaux01.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>3</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="/oracle/{DB_NAME}/oradata1/system01.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="TEMP">
<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="/oracle/{DB_NAME}/oradata2/temp01.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="UNDOTBS1">
<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="/oracle/{DB_NAME}/oradata3/undotbs01.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<TablespaceAttributes id="USERS">
<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="/oracle/{DB_NAME}/oradata3/users01.dbf">
<id>-1</id>
</TablespaceDatafileAttributes>
</datafilesList>
</TablespaceAttributes>
<RedoLogGroupAttributes id="1">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo01.log" filepath="/oracle/{DB_NAME}/oradata1/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="2">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo02.log" filepath="/oracle/{DB_NAME}/oradata2/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="3">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo03.log" filepath="/oracle/{DB_NAME}/oradata3/"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="4">
<reuse>false</reuse>
<fileSize unit="KB">102400</fileSize>
<Thread>1</Thread>
<member ordinal="1" memberName="redo04.log" filepath="/oracle/{DB_NAME}/oradata4/"/>
</RedoLogGroupAttributes>
</StorageAttributes>
</DatabaseTemplate>
Postrequisites[edit]
- run root.sh
- add a line to /etc/oratab
Fully automated version[edit]
su ${ORACLE_USER} -c "umask ${APPS_UMASK}; \
unset ORACLE_SID; unset ORACLE_HOME; unset TNS_ADMIN; \
${MOUNT_POINT}/runInstaller \
-waitforcompletion \
-silent \
-noconfig \
-ignoreSysPrereqs \
-responseFile ${oracle_response_file_dir}/ora11203.rsp \
"FROM_LOCATION=${MOUNT_POINT}/stage/products.xml" \
"ORACLE_HOME=${OHOME}" \
"ORACLE_BASE=${OBASE}" \
"ORACLE_HOSTNAME=${OHOST}" \
"ORACLE_HOME_NAME=${ORACLE_HOME_NAME}"" \
>> ${INSTALL_LOG} 2>&1
