All kind of installations and configurations for Oracle RAC or Database, can be performed either using GUI or Silent mode. GUI mode is more easier as it shows all option (with details) step by step but it may not possible for all the cases or may not support on environment or may need to install bulk number of databases. So we can use all oracle provided tools/utility with silent mode which is more faster and you will able to do by using putty only.
Benefits to use oracle tool/utility in silent mode:
- Extra Software is not required to run with GUI mode
- Faster and minimal user interaction
- Run as script by nohup or cron job so no Internet issue between server and client
runInstaller -silent # for GI and Database Software deinstall -silent # for GI and Database Software dbca -silent asmca -silent netca -silent dbua -silent
Option 1. GI / RAC Software Installation with Silent mode:
Option 2. Oracle RDBMS Software Installation with Silent mode:
Response File Details for Oracle RDBMS Software Installation:
[oracle@ocmnode1 database]$ pwd /backup/software/database [oracle@ocmnode1 database]$ ls install response rpm runInstaller sshsetup stage welcome.html [oracle@ocmnode1 database]$ cd response/ [oracle@ocmnode1 response]$ ls dbca.rsp db_install.rsp netca.rsp [oracle@ocmnode1 response]$ cat db_install.rsp
Response File for RDBMS Software Installation. (Click Me for Details)
#################################################################### ## Copyright(c) Oracle Corporation 1998,2014. 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= #------------------------------------------------------------------------------- # 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= #------------------------------------------------------------------------------- # Specify the Unix group to be set for the inventory directory. #------------------------------------------------------------------------------- UNIX_GROUP_NAME= #------------------------------------------------------------------------------- # Specify the location which holds the inventory files. # This is an optional parameter if installing on # Windows based Operating System. #------------------------------------------------------------------------------- INVENTORY_LOCATION= #------------------------------------------------------------------------------- # Specify the languages in which the components will be installed. # # en : English ja : Japanese # # 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=en #------------------------------------------------------------------------------- # Specify the complete path of the Oracle Home. #------------------------------------------------------------------------------- ORACLE_HOME= #------------------------------------------------------------------------------- # Specify the complete path of the Oracle Base. #------------------------------------------------------------------------------- ORACLE_BASE= #------------------------------------------------------------------------------- # Specify the installation edition of the component. # # The value should contain only one of these choices. # - EE : Enterprise Edition #------------------------------------------------------------------------------- oracle.install.db.InstallEdition= ############################################################################### # # # 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= #------------------------------------------------------------------------------ # 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= #------------------------------------------------------------------------------ # The BACKUPDBA_GROUP is the OS group which is to be granted OSBACKUPDBA privileges. #------------------------------------------------------------------------------ oracle.install.db.BACKUPDBA_GROUP= #------------------------------------------------------------------------------ # The DGDBA_GROUP is the OS group which is to be granted OSDGDBA privileges. #------------------------------------------------------------------------------ oracle.install.db.DGDBA_GROUP= #------------------------------------------------------------------------------ # The KMDBA_GROUP is the OS group which is to be granted OSKMDBA privileges. #------------------------------------------------------------------------------ oracle.install.db.KMDBA_GROUP= ############################################################################### # # # 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= #------------------------------------------------------------------------------ # 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= ############################################################################### # # # Database Configuration Options # # # ############################################################################### #------------------------------------------------------------------------------- # Specify the type of database to create. # It can be one of the following: # - GENERAL_PURPOSE # - DATA_WAREHOUSE # GENERAL_PURPOSE: A starter database designed for general purpose use or transaction-heavy applications. # DATA_WAREHOUSE : A starter database optimized for data warehousing applications. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.type= #------------------------------------------------------------------------------- # 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. # The value can be either "true" or "false". If left blank it will be assumed # to be "false". #------------------------------------------------------------------------------- oracle.install.db.ConfigureAsContainerDB= #------------------------------------------------------------------------------- # 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= #------------------------------------------------------------------------------- # 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. # The value can be either "true" or "false". If left blank it will be assumed # to be "false". #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.installExampleSchemas= ############################################################################### # # # 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= #------------------------------------------------------------------------------- # 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= #------------------------------------------------------------------------------- # 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= #------------------------------------------------------------------------------- # 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= #------------------------------------------------------------------------------ # 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= #------------------------------------------------------------------------------ # 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 Oracle Support Hub URL. # # Example : COLLECTOR_SUPPORTHUB_URL=https://orasupporthub.company.com:8080/ #------------------------------------------------------------------------------ COLLECTOR_SUPPORTHUB_URL=
Perform following changes to the response file: These options for installing Software Only [without database configuration]
oracle.install.option=INSTALL_DB_SWONLY UNIX_GROUP_NAME=dba INVENTORY_LOCATION=/u01/app/oraInventory ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 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 oracle.install.db.OPER_GROUP=oper SELECTED_LANGUAGES=en DECLINE_SECURITY_UPDATES=yes #FOR GI/RAC oracle.install.db.CLUSTER_NODES=ocmnode1,ocmnode2 oracle.install.db.isRACOneInstall=false
Triggers runInstaller with Silent Mode.
[oracle@ocmnode1 database]$ pwd
/backup/software/database
[oracle@ocmnode1 database]$ ./runInstaller -silent -ignorePrereq -ignoreSysPrereqs -responseFile /home/oracle/db.rsp -ignoreInternalDriverError
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 500 MB. Actual 1836 MB Passed
Checking swap space: must be greater than 150 MB. Actual 3574 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2020-06-27_01-22-55PM. Please wait ...[oracle@ocmnode1 database]$ You can find the log of this install session at:
/u001/app/oraInventory/logs/installActions2020-06-27_01-22-55PM.log
The installation of Oracle Database 12c was successful.
Please check '/u001/app/oraInventory/logs/silentInstall2020-06-27_01-22-55PM.log' for more details.
As a root user, execute the following script(s):
1. /u01/app/oracle/product/12.1.0/dbhome_1/root.sh
Execute /u01/app/oracle/product/12.1.0/dbhome_1/root.sh on the following nodes:
[ocmnode1, ocmnode2]
Open new terminal with root user and execute root.sh script on all nodes.
[root@ocmnode1 ~]# /u01/app/oracle/product/12.1.0/dbhome_1/root.sh Check /u001/app/oracle/product/12.1.0/dbhome_1/install/root_ocmnode1.localdomain_2020-06-27_14-01-09.log for the output of root script [root@ocmnode2 dbhome_1]# /u001/app/oracle/product/12.1.0/dbhome_1/root.sh Check /u01/app/oracle/product/12.1.0/dbhome_1/install/root_ocmnode2.localdomain_2020-06-27_14-02-00.log for the output of root script
Create Database in Silent mode using DBCA:
DBCA Command details:
## Examples : ## ## 1. dbca -progress_only -responseFile <response file> ## ## Display a progress bar depicting progress of database creation ## ## process. ## ## ## ## 2. dbca -silent -responseFile <response file> ## ## Creates database silently. No user interface is displayed. ## ## ## ## 3. dbca -silent -createDatabase -cloneTemplate ## ## -responseFile <response file> ## ## Creates database silently with clone template. The template in ## ## responsefile is a clone template. ## ## ## ## 4. dbca -silent -deleteDatabase -responseFile <response file> ## ## Deletes database silently. ## ##############################################################################
Response File for DBCA (Database Creation) – For Details Click on me
#----------------------------------------------------------------------------- # GENERAL section is required for all types of database creations. #----------------------------------------------------------------------------- [GENERAL] #----------------------------------------------------------------------------- # Name : RESPONSEFILE_VERSION # Datatype : String # Description : Version of the database to create # Valid values : "12.1.0" # Default value : None # Mandatory : Yes #----------------------------------------------------------------------------- RESPONSEFILE_VERSION = "12.1.0" #----------------------------------------------------------------------------- # Name : OPERATION_TYPE # Datatype : String # Description : Type of operation # Valid values : "createDatabase" \ "createTemplateFromDB" \ "createCloneTemplate" \ "deleteDatabase" \ "configureDatabase" \ "addInstance" (RAC-only) \ "deleteInstance" (RAC-only) \ "createPluggableDatabase" \ "unplugDatabase" \ "deletePluggableDatabase" \ "configurePluggableDatabase" # Default value : None # Mandatory : Yes #----------------------------------------------------------------------------- OPERATION_TYPE = "createDatabase" #-----------------------*** End of GENERAL section ***------------------------ #----------------------------------------------------------------------------- # CREATEDATABASE section is used when OPERATION_TYPE is defined as "createDatabase". #----------------------------------------------------------------------------- [CREATEDATABASE] #----------------------------------------------------------------------------- # Name : GDBNAME # Datatype : String # Description : Global database name of the database # Valid values : <db_name>.<db_domain> - when database domain isn't NULL # <db_name> - when database domain is NULL # Default value : None # Mandatory : Yes #----------------------------------------------------------------------------- GDBNAME = "orcl12c.us.oracle.com" #----------------------------------------------------------------------------- # Name : DATABASECONFTYPE # Datatype : String # Description : database conf type as Single Instance, Real Application Cluster or Real Application Cluster One Nodes database # Valid values : SI\RAC\RACONENODE # Default value : SI # Mandatory : No #----------------------------------------------------------------------------- #DATABASECONFTYPE = "SI" #----------------------------------------------------------------------------- # Name : RACONENODESERVICENAME # Datatype : String # Description : Service is required by application to connect to RAC One # Node Database # Valid values : Service Name # Default value : None # Mandatory : No [required in case DATABASECONFTYPE is set to RACONENODE ] #----------------------------------------------------------------------------- #RACONENODESERVICENAME = #----------------------------------------------------------------------------- # Name : POLICYMANAGED # Datatype : Boolean # Description : Set to true if Database is policy managed and # set to false if Database is admin managed # Valid values : TRUE\FALSE # Default value : FALSE # Mandatory : No #----------------------------------------------------------------------------- #POLICYMANAGED = "false" #----------------------------------------------------------------------------- # Name : CREATESERVERPOOL # Datatype : Boolean # Description : Set to true if new server pool need to be created for database # if this option is specified then the newly created database # will use this newly created serverpool. # Multiple serverpoolname can not be specified for database # Valid values : TRUE\FALSE # Default value : FALSE # Mandatory : No #----------------------------------------------------------------------------- #CREATESERVERPOOL = "false" #----------------------------------------------------------------------------- # Name : SERVERPOOLNAME # Datatype : String # Description : Only one serverpool name need to be specified # if Create Server Pool option is specified. # Comma-separated list of Serverpool names if db need to use # multiple Server pool # Valid values : ServerPool name # Default value : None # Mandatory : No [required in case of RAC service centric database] #----------------------------------------------------------------------------- #SERVERPOOLNAME = #----------------------------------------------------------------------------- # Name : CARDINALITY # Datatype : Number # Description : Specify Cardinality for create server pool operation # Valid values : any positive Integer value # Default value : Number of qualified nodes on cluster # Mandatory : No [Required when a new serverpool need to be created] #----------------------------------------------------------------------------- #CARDINALITY = #----------------------------------------------------------------------------- # Name : FORCE # Datatype : Boolean # Description : Set to true if new server pool need to be created by force # if this option is specified then the newly created serverpool # will be assigned server even if no free servers are available. # This may affect already running database. # This flag can be specified for Admin managed as well as policy managed db. # Valid values : TRUE\FALSE # Default value : FALSE # Mandatory : No #----------------------------------------------------------------------------- #FORCE = "false" #----------------------------------------------------------------------------- # Name : PQPOOLNAME # Datatype : String # Description : Only one serverpool name needs to be specified # if create server pool option is specified. # Comma-separated list of serverpool names if use # server pool. This is required to # create Parallel Query (PQ) database. Applicable to Big Cluster # Valid values : Parallel Query (PQ) pool name # Default value : None # Mandatory : No [required in case of RAC service centric database] #----------------------------------------------------------------------------- #PQPOOLNAME = #----------------------------------------------------------------------------- # Name : PQCARDINALITY # Datatype : Number # Description : Specify Cardinality for create server pool operation. # Applicable to Big Cluster # Valid values : any positive Integer value # Default value : Number of qualified nodes on cluster # Mandatory : No [Required when a new serverpool need to be created] #----------------------------------------------------------------------------- #PQCARDINALITY = #----------------------------------------------------------------------------- # Name : SID # Datatype : String # Description : System identifier (SID) of the database # Valid values : Check Oracle12c Administrator's Guide # Default value : <db_name> specified in GDBNAME # Mandatory : No #----------------------------------------------------------------------------- SID = "orcl12c" #----------------------------------------------------------------------------- # Name : CREATEASCONTAINERDATABASE # Datatype : boolean # Description : flag to create database as container database # Valid values : Check Oracle12c Administrator's Guide # Default value : false # Mandatory : No #----------------------------------------------------------------------------- #CREATEASCONTAINERDATABASE = #----------------------------------------------------------------------------- # Name : NUMBEROFPDBS # Datatype : Number # Description : Specify the number of pdb to be created # Valid values : 0 to 252 # Default value : 0 # Mandatory : No #----------------------------------------------------------------------------- #NUMBEROFPDBS = #----------------------------------------------------------------------------- # Name : PDBNAME # Datatype : String # Description : Specify the pdbname/pdbanme prefix if one or more pdb need to be created # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : No #----------------------------------------------------------------------------- #PDBNAME = #----------------------------------------------------------------------------- # Name : PDBADMINPASSWORD # Datatype : String # Description : PDB Administrator user password # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : No #----------------------------------------------------------------------------- # PDBADMINPASSWORD = "" #----------------------------------------------------------------------------- # Name : NODELIST # Datatype : String # Description : Comma-separated list of cluster nodes # Valid values : Cluster node names # Default value : None # Mandatory : No (Yes for RAC database-centric database ) #----------------------------------------------------------------------------- #NODELIST= #----------------------------------------------------------------------------- # Name : TEMPLATENAME # Datatype : String # Description : Name of the template # Valid values : Template file name # Default value : None # Mandatory : Yes #----------------------------------------------------------------------------- TEMPLATENAME = "General_Purpose.dbc" #----------------------------------------------------------------------------- # Name : OBFUSCATEDPASSWORDS # Datatype : Boolean # Description : Set to true if passwords are encrypted # Valid values : TRUE\FALSE # Default value : FALSE # Mandatory : No #----------------------------------------------------------------------------- #OBFUSCATEDPASSWORDS = FALSE #----------------------------------------------------------------------------- # Name : SYSPASSWORD # Datatype : String # Description : Password for SYS user # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : Yes #----------------------------------------------------------------------------- #SYSPASSWORD = "password" #----------------------------------------------------------------------------- # Name : SYSTEMPASSWORD # Datatype : String # Description : Password for SYSTEM user # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : Yes #----------------------------------------------------------------------------- #SYSTEMPASSWORD = "password" #----------------------------------------------------------------------------- # Name : SERVICEUSERPASSWORD # Datatype : String # Description : Password for Windows Service user # Default value : None # Mandatory : If Oracle home is installed with windows service user #----------------------------------------------------------------------------- #SERVICEUSERPASSWORD = "password" #----------------------------------------------------------------------------- # Name : EMCONFIGURATION # Datatype : String # Description : Enterprise Manager Configuration Type # Valid values : CENTRAL|DBEXPRESS|ALL|NONE # Default value : NONE # Mandatory : No #----------------------------------------------------------------------------- #EMCONFIGURATION = "NONE" #----------------------------------------------------------------------------- # Name : EMEXPRESSPORT # Datatype : Number # Description : Enterprise Manager Configuration Type # Valid values : Check Oracle12c Administrator's Guide # Default value : NONE # Mandatory : No, will be picked up from DBEXPRESS_HTTPS_PORT env variable # or auto generates a free port between 5500 and 5599 #----------------------------------------------------------------------------- #EMEXPRESSPORT = "" #----------------------------------------------------------------------------- # Name : RUNCVUCHECKS # Datatype : Boolean # Description : Specify whether to run Cluster Verification Utility checks # periodically in Cluster environment # Valid values : TRUE\FALSE # Default value : FALSE # Mandatory : No #----------------------------------------------------------------------------- #RUNCVUCHECKS = FALSE #----------------------------------------------------------------------------- # Name : DBSNMPPASSWORD # Datatype : String # Description : Password for DBSNMP user # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : Yes, if EMCONFIGURATION is specified or # the value of RUNCVUCHECKS is TRUE #----------------------------------------------------------------------------- #DBSNMPPASSWORD = "password" #----------------------------------------------------------------------------- # Name : OMSHOST # Datatype : String # Description : EM management server host name # Default value : None # Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION #----------------------------------------------------------------------------- #OMSHOST = #----------------------------------------------------------------------------- # Name : OMSPORT # Datatype : Number # Description : EM management server port number # Default value : None # Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION #----------------------------------------------------------------------------- #OMSPORT = #----------------------------------------------------------------------------- # Name : EMUSER # Datatype : String # Description : EM Admin username to add or modify targets # Default value : None # Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION #----------------------------------------------------------------------------- #EMUSER = #----------------------------------------------------------------------------- # Name : EMPASSWORD # Datatype : String # Description : EM Admin user password # Default value : None # Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION #----------------------------------------------------------------------------- #EMPASSWORD= #----------------------------------------------------------------------------- # Name : DVCONFIGURATION # Datatype : Boolean # Description : Specify "True" to configure and enable Oracle Database vault # Valid values : True/False # Default value : False # Mandatory : No #----------------------------------------------------------------------------- #DVCONFIGURATION = "false" #----------------------------------------------------------------------------- # Name : DVOWNERNAME # Datatype : String # Description : DataVault Owner # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : Yes, if DataVault option is chosen #----------------------------------------------------------------------------- #DVOWNERNAME = "" #----------------------------------------------------------------------------- # Name : DVOWNERPASSWORD # Datatype : String # Description : Password for DataVault Owner # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : Yes, if DataVault option is chosen #----------------------------------------------------------------------------- #DVOWNERPASSWORD = "" #----------------------------------------------------------------------------- # Name : DVACCOUNTMANAGERNAME # Datatype : String # Description : DataVault Account Manager # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : No #----------------------------------------------------------------------------- #DVACCOUNTMANAGERNAME = "" #----------------------------------------------------------------------------- # Name : DVACCOUNTMANAGERPASSWORD # Datatype : String # Description : Password for DataVault Account Manager # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : No #----------------------------------------------------------------------------- #DVACCOUNTMANAGERPASSWORD = "" #----------------------------------------------------------------------------- # Name : OLSCONFIGURATION # Datatype : Boolean # Description : Specify "True" to configure and enable Oracle Label Security # Valid values : True/False # Default value : False # Mandatory : No #----------------------------------------------------------------------------- #OLSCONFIGURATION = "false" #----------------------------------------------------------------------------- # Name : DATAFILEJARLOCATION # Datatype : String # Description : Location of the data file jar # Valid values : Directory containing compressed datafile jar # Default value : None # Mandatory : No #----------------------------------------------------------------------------- #DATAFILEJARLOCATION = #----------------------------------------------------------------------------- # Name : DATAFILEDESTINATION # Datatype : String # Description : Location of the data file's # Valid values : Directory for all the database files # Default value : $ORACLE_BASE/oradata # Mandatory : No #----------------------------------------------------------------------------- #DATAFILEDESTINATION = #----------------------------------------------------------------------------- # Name : RECOVERYAREADESTINATION # Datatype : String # Description : Location of the data file's # Valid values : Recovery Area location # Default value : $ORACLE_BASE/flash_recovery_area # Mandatory : No #----------------------------------------------------------------------------- #RECOVERYAREADESTINATION= #----------------------------------------------------------------------------- # Name : STORAGETYPE # Datatype : String # Description : Specifies the storage on which the database is to be created # Valid values : FS (CFS for RAC), ASM # Default value : FS # Mandatory : No #----------------------------------------------------------------------------- #STORAGETYPE=FS #----------------------------------------------------------------------------- # Name : DISKGROUPNAME # Datatype : String # Description : Specifies the disk group name for the storage # Default value : DATA # Mandatory : No #----------------------------------------------------------------------------- #DISKGROUPNAME=DATA #----------------------------------------------------------------------------- # Name : ASMSNMP_PASSWORD # Datatype : String # Description : Password for ASM Monitoring # Default value : None # Mandatory : No #----------------------------------------------------------------------------- #ASMSNMP_PASSWORD="" #----------------------------------------------------------------------------- # Name : RECOVERYGROUPNAME # Datatype : String # Description : Specifies the disk group name for the recovery area # Default value : RECOVERY # Mandatory : No #----------------------------------------------------------------------------- #RECOVERYGROUPNAME=RECOVERY #----------------------------------------------------------------------------- # Name : CHARACTERSET # Datatype : String # Description : Character set of the database # Valid values : Check Oracle12c National Language Support Guide # Default value : "US7ASCII" # Mandatory : NO #----------------------------------------------------------------------------- #CHARACTERSET = "US7ASCII" #----------------------------------------------------------------------------- # Name : NATIONALCHARACTERSET # Datatype : String # Description : National Character set of the database # Valid values : "UTF8" or "AL16UTF16". For details, check Oracle12c National Language Support Guide # Default value : "AL16UTF16" # Mandatory : No #----------------------------------------------------------------------------- #NATIONALCHARACTERSET= "UTF8" #----------------------------------------------------------------------------- # Name : REGISTERWITHDIRSERVICE # Datatype : Boolean # Description : Specifies whether to register with Directory Service. # Valid values : TRUE \ FALSE # Default value : FALSE # Mandatory : No #----------------------------------------------------------------------------- #REGISTERWITHDIRSERVICE= TRUE #----------------------------------------------------------------------------- # Name : DIRSERVICEUSERNAME # Datatype : String # Description : Specifies the name of the directory service user # Mandatory : YES, if the value of registerWithDirService is TRUE #----------------------------------------------------------------------------- #DIRSERVICEUSERNAME= "name" #----------------------------------------------------------------------------- # Name : DIRSERVICEPASSWORD # Datatype : String # Description : The password of the directory service user. # You can also specify the password at the command prompt instead of here. # Mandatory : YES, if the value of registerWithDirService is TRUE #----------------------------------------------------------------------------- #DIRSERVICEPASSWORD= "password" #----------------------------------------------------------------------------- # Name : WALLETPASSWORD # Datatype : String # Description : The password for wallet to created or modified. # You can also specify the password at the command prompt instead of here. # Mandatory : YES, if the value of registerWithDirService is TRUE #----------------------------------------------------------------------------- #WALLETPASSWORD= "password" #----------------------------------------------------------------------------- # Name : LISTENERS # Datatype : String # Description : Specifies list of listeners to register the database with. # By default the database is configured for all the listeners specified in the # $ORACLE_HOME/network/admin/listener.ora # Valid values : The list should be comma separated like "listener1,listener2". # Mandatory : NO #----------------------------------------------------------------------------- #LISTENERS = "listener1,listener2" #----------------------------------------------------------------------------- # Name : VARIABLESFILE # Datatype : String # Description : Location of the file containing variable value pair # Valid values : A valid file-system file. The variable value pair format in this file # is <variable>=<value>. Each pair should be in a new line. # Default value : None # Mandatory : NO #----------------------------------------------------------------------------- #VARIABLESFILE = #----------------------------------------------------------------------------- # Name : VARIABLES # Datatype : String # Description : comma separated list of name=value pairs. Overrides variables defined in variablefile and templates # Default value : None # Mandatory : NO #----------------------------------------------------------------------------- #VARIABLES = #----------------------------------------------------------------------------- # Name : INITPARAMS # Datatype : String # Description : comma separated list of name=value pairs. Overrides initialization parameters defined in templates # Default value : None # Mandatory : NO #----------------------------------------------------------------------------- #INITPARAMS = #----------------------------------------------------------------------------- # Name : SAMPLESCHEMA # Datatype : Boolean # Description : Specifies whether or not to add the Sample Schemas to your database # Valid values : TRUE \ FALSE # Default value : FASLE # Mandatory : No #----------------------------------------------------------------------------- #SAMPLESCHEMA=TRUE #----------------------------------------------------------------------------- # Name : MEMORYPERCENTAGE # Datatype : String # Description : percentage of physical memory for Oracle # Default value : None # Mandatory : NO #----------------------------------------------------------------------------- #MEMORYPERCENTAGE = "40" #----------------------------------------------------------------------------- # Name : DATABASETYPE # Datatype : String # Description : used for memory distribution when MEMORYPERCENTAGE specified # Valid values : MULTIPURPOSE|DATA_WAREHOUSING|OLTP # Default value : MULTIPURPOSE # Mandatory : NO #----------------------------------------------------------------------------- #DATABASETYPE = "MULTIPURPOSE" #----------------------------------------------------------------------------- # Name : AUTOMATICMEMORYMANAGEMENT # Datatype : Boolean # Description : flag to indicate Automatic Memory Management is used # Valid values : TRUE/FALSE # Default value : TRUE # Mandatory : NO #----------------------------------------------------------------------------- #AUTOMATICMEMORYMANAGEMENT = "TRUE" #----------------------------------------------------------------------------- # Name : TOTALMEMORY # Datatype : String # Description : total memory in MB to allocate to Oracle # Valid values : # Default value : # Mandatory : NO #----------------------------------------------------------------------------- #TOTALMEMORY = "800" #-----------------------*** End of CREATEDATABASE section ***------------------------ #----------------------------------------------------------------------------- # createTemplateFromDB section is used when OPERATION_TYPE is defined as "createTemplateFromDB". #----------------------------------------------------------------------------- [createTemplateFromDB] #----------------------------------------------------------------------------- # Name : SOURCEDB # Datatype : String # Description : The source database from which to create the template # Valid values : The format is <host>:<port>:<sid> # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- SOURCEDB = "myhost:1521:orcl" #----------------------------------------------------------------------------- # Name : SYSDBAUSERNAME # Datatype : String # Description : A user with DBA role. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- SYSDBAUSERNAME = "system" #----------------------------------------------------------------------------- # Name : SYSDBAPASSWORD # Datatype : String # Description : The password of the DBA user. # You can also specify the password at the command prompt instead of here. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- #SYSDBAPASSWORD = "password" #----------------------------------------------------------------------------- # Name : TEMPLATENAME # Datatype : String # Description : Name for the new template. # Default value : None # Mandatory : Yes #----------------------------------------------------------------------------- TEMPLATENAME = "My Copy TEMPLATE" #-----------------------*** End of createTemplateFromDB section ***------------------------ #----------------------------------------------------------------------------- # createCloneTemplate section is used when OPERATION_TYPE is defined as "createCloneTemplate". #----------------------------------------------------------------------------- [createCloneTemplate] #----------------------------------------------------------------------------- # Name : SOURCEDB # Datatype : String # Description : The source database is the SID from which to create the template. # This database must be local and on the same ORACLE_HOME. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- SOURCEDB = "orcl" #----------------------------------------------------------------------------- # Name : SYSDBAUSERNAME # Datatype : String # Description : A user with DBA role. # Default value : none # Mandatory : YES, if no OS authentication #----------------------------------------------------------------------------- #SYSDBAUSERNAME = "sys" #----------------------------------------------------------------------------- # Name : SYSDBAPASSWORD # Datatype : String # Description : The password of the DBA user. # You can also specify the password at the command prompt instead of here. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- #SYSDBAPASSWORD = "password" #----------------------------------------------------------------------------- # Name : TEMPLATENAME # Datatype : String # Description : Name for the new template. # Default value : None # Mandatory : Yes #----------------------------------------------------------------------------- TEMPLATENAME = "My Clone TEMPLATE" #----------------------------------------------------------------------------- # Name : DATAFILEJARLOCATION # Datatype : String # Description : Location of the data file jar # Valid values : Directory where the new compressed datafile jar will be placed # Default value : $ORACLE_HOME/assistants/dbca/templates # Mandatory : NO #----------------------------------------------------------------------------- #DATAFILEJARLOCATION = #-----------------------*** End of createCloneTemplate section ***------------------------ #----------------------------------------------------------------------------- # DELETEDATABASE section is used when DELETE_TYPE is defined as "deleteDatabase". #----------------------------------------------------------------------------- [DELETEDATABASE] #----------------------------------------------------------------------------- # Name : SOURCEDB # Datatype : String # Description : The source database is the SID # This database must be local and on the same ORACLE_HOME. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- SOURCEDB = "orcl" #----------------------------------------------------------------------------- # Name : SYSDBAUSERNAME # Datatype : String # Description : A user with DBA role. # Default value : none # Mandatory : YES, if no OS authentication #----------------------------------------------------------------------------- #SYSDBAUSERNAME = "sys" #----------------------------------------------------------------------------- # Name : SYSDBAPASSWORD # Datatype : String # Description : The password of the DBA user. # You can also specify the password at the command prompt instead of here. # Default value : none # Mandatory : YES, if no OS authentication #----------------------------------------------------------------------------- #SYSDBAPASSWORD = "password" #-----------------------*** End of deleteDatabase section ***------------------------ #----------------------------------------------------------------------------- # GENERATESCRIPTS section #----------------------------------------------------------------------------- [generateScripts] #----------------------------------------------------------------------------- # Name : TEMPLATENAME # Datatype : String # Description : Name of the template # Valid values : Template name as seen in DBCA # Default value : None # Mandatory : Yes #----------------------------------------------------------------------------- TEMPLATENAME = "New Database" #----------------------------------------------------------------------------- # Name : GDBNAME # Datatype : String # Description : Global database name of the database # Valid values : <db_name>.<db_domain> - when database domain isn't NULL # <db_name> - when database domain is NULL # Default value : None # Mandatory : Yes #----------------------------------------------------------------------------- GDBNAME = "orcl12.us.oracle.com" #----------------------------------------------------------------------------- # Name : SCRIPTDESTINATION # Datatype : String # Description : Location of the scripts # Valid values : Directory for all the scripts # Default value : None # Mandatory : No #----------------------------------------------------------------------------- #SCRIPTDESTINATION = #----------------------------------------------------------------------------- # Name : EMCONFIGURATION # Datatype : String # Description : Enterprise Manager Configuration Type # Valid values : CENTRAL # Default value : NONE # Mandatory : No #----------------------------------------------------------------------------- #EMCONFIGURATION = "NONE" #----------------------------------------------------------------------------- # Name : OMSHOST # Datatype : String # Description : EM management server host name # Default value : None # Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION #----------------------------------------------------------------------------- #OMSHOST = #----------------------------------------------------------------------------- # Name : OMSPORT # Datatype : Number # Description : EM management server port number # Default value : None # Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION #----------------------------------------------------------------------------- #OMSPORT = #----------------------------------------------------------------------------- # Name : EMUSER # Datatype : String # Description : EM Admin username to add or modify targets # Default value : None # Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION #----------------------------------------------------------------------------- #EMUSER = #----------------------------------------------------------------------------- # Name : EMPASSWORD # Datatype : String # Description : EM Admin user password # Default value : None # Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION #----------------------------------------------------------------------------- #EMPASSWORD= #-----------------------*** End of deleteDatabase section ***------------------------ #----------------------------------------------------------------------------- # CONFIGUREDATABASE section is used when OPERATION_TYPE is defined as "configureDatabase". #----------------------------------------------------------------------------- [CONFIGUREDATABASE] #----------------------------------------------------------------------------- # Name : SOURCEDB # Datatype : String # Description : The source database is the SID # This database must be local and on the same ORACLE_HOME. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- #SOURCEDB = "orcl" #----------------------------------------------------------------------------- # Name : SYSDBAUSERNAME # Datatype : String # Description : A user with DBA role. # Default value : none # Mandatory : YES, if no OS authentication #----------------------------------------------------------------------------- #SYSDBAUSERNAME = "sys" #----------------------------------------------------------------------------- # Name : SYSDBAPASSWORD # Datatype : String # Description : The password of the DBA user. # You can also specify the password at the command prompt instead of here. # Default value : none # Mandatory : YES, if no OS authentication #----------------------------------------------------------------------------- #SYSDBAPASSWORD = #----------------------------------------------------------------------------- # Name : REGISTERWITHDIRSERVICE # Datatype : Boolean # Description : Specifies whether to register with Directory Service. # Valid values : TRUE \ FALSE # Default value : FALSE # Mandatory : No #----------------------------------------------------------------------------- #REGISTERWITHDIRSERVICE= TRUE #----------------------------------------------------------------------------- # Name : UNREGISTERWITHDIRSERVICE # Datatype : Boolean # Description : Specifies whether to unregister with Directory Service. # Valid values : TRUE \ FALSE # Default value : FALSE # Mandatory : No #----------------------------------------------------------------------------- #UNREGISTERWITHDIRSERVICE= TRUE #----------------------------------------------------------------------------- # Name : REGENERATEDBPASSWORD # Datatype : Boolean # Description : Specifies whether regenerate database password in OID/Wallet # Valid values : TRUE \ FALSE # Default value : FALSE # Mandatory : No #----------------------------------------------------------------------------- #REGENERATEDBPASSWORD= TRUE #----------------------------------------------------------------------------- # Name : DIRSERVICEUSERNAME # Datatype : String # Description : Specifies the name of the directory service user # Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified #----------------------------------------------------------------------------- #DIRSERVICEUSERNAME= "name" #----------------------------------------------------------------------------- # Name : DIRSERVICEPASSWORD # Datatype : String # Description : The password of the directory service user. # You can also specify the password at the command prompt instead of here. # Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified #----------------------------------------------------------------------------- #DIRSERVICEPASSWORD= "password" #----------------------------------------------------------------------------- # Name : WALLETPASSWORD # Datatype : String # Description : The password for wallet to created or modified. # You can also specify the password at the command prompt instead of here. # Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified #----------------------------------------------------------------------------- #WALLETPASSWORD= "password" #----------------------------------------------------------------------------- # Name : ENABLESECURITYCONFIGURATION # Datatype : String # Description : Database Security Settings # Valid values : true|false # Default value : true # Mandatory : No #----------------------------------------------------------------------------- #ENABLESECURITYCONFIGURATION = "true" #----------------------------------------------------------------------------- # Name : DBSNMPPASSWORD # Datatype : String # Description : Password for DBSNMP user # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : Yes, if EMCONFIGURATION is specified #----------------------------------------------------------------------------- #DBSNMPPASSWORD = "password" #----------------------------------------------------------------------------- # Name : DVCONFIGURATION # Datatype : Boolean # Description : Specify "True" to configure and enable Oracle Database vault # Valid values : True/False # Default value : False # Mandatory : No #----------------------------------------------------------------------------- #DVCONFIGURATION = "false" #----------------------------------------------------------------------------- # Name : DVOWNERNAME # Datatype : String # Description : DataVault Owner # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : Yes, if DataVault option is chosen #----------------------------------------------------------------------------- #DVOWNERNAME = "" #----------------------------------------------------------------------------- # Name : DVOWNERPASSWORD # Datatype : String # Description : Password for DataVault Owner # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : Yes, if DataVault option is chosen #----------------------------------------------------------------------------- #DVOWNERPASSWORD = "" #----------------------------------------------------------------------------- # Name : DVACCOUNTMANAGERNAME # Datatype : String # Description : DataVault Account Manager # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : No #----------------------------------------------------------------------------- #DVACCOUNTMANAGERNAME = "" #----------------------------------------------------------------------------- # Name : DVACCOUNTMANAGERPASSWORD # Datatype : String # Description : Password for DataVault Account Manager # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : No #----------------------------------------------------------------------------- #DVACCOUNTMANAGERPASSWORD = "" #-----------------------*** End of CONFIGUREDATABASE section ***------------------------ #----------------------------------------------------------------------------- # ADDINSTANCE section is used when OPERATION_TYPE is defined as "addInstance". #----------------------------------------------------------------------------- [ADDINSTANCE] #----------------------------------------------------------------------------- # Name : DB_UNIQUE_NAME # Datatype : String # Description : DB Unique Name of the RAC database # Valid values : <db_unique_name> # Default value : None # Mandatory : Yes #----------------------------------------------------------------------------- DB_UNIQUE_NAME = "orcl12c.us.oracle.com" #----------------------------------------------------------------------------- # Name : INSTANCENAME # Datatype : String # Description : RAC instance name to be added # Valid values : Check Oracle12c Administrator's Guide # Default value : <sid_prefix>+<highest_current_thread+1> # Mandatory : No #----------------------------------------------------------------------------- #INSTANCENAME = "orcl1" #----------------------------------------------------------------------------- # Name : NODENAME # Datatype : String # Description : Node on which to add new instance # (in 10gR2, instance addition is supported on 1 node at a time) # Valid values : Cluster node name # Default value : None # Mandatory : Yes #----------------------------------------------------------------------------- NODENAME= #----------------------------------------------------------------------------- # Name : OBFUSCATEDPASSWORDS # Datatype : Boolean # Description : Set to true if passwords are encrypted # Valid values : TRUE\FALSE # Default value : FALSE # Mandatory : No #----------------------------------------------------------------------------- #OBFUSCATEDPASSWORDS = FALSE #----------------------------------------------------------------------------- # Name : SYSDBAUSERNAME # Datatype : String # Description : A user with DBA role. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- SYSDBAUSERNAME = "sys" #----------------------------------------------------------------------------- # Name : SYSDBAPASSWORD # Datatype : String # Description : The password of the DBA user. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- #SYSDBAPASSWORD = "password" #----------------------------------------------------------------------------- # Name : SERVICEUSERPASSWORD # Datatype : String # Description : Password for Windows Service user # Default value : None # Mandatory : If Oracle home is installed with windows service user #----------------------------------------------------------------------------- #SERVICEUSERPASSWORD = "password" #-----------------------*** End of ADDINSTANCE section ***------------------------ #----------------------------------------------------------------------------- # DELETEINSTANCE section is used when OPERATION_TYPE is defined as "deleteInstance". #----------------------------------------------------------------------------- [DELETEINSTANCE] #----------------------------------------------------------------------------- # Name : DB_UNIQUE_NAME # Datatype : String # Description : DB Unique Name of the RAC database # Valid values : <db_unique_name> # Default value : None # Mandatory : Yes #----------------------------------------------------------------------------- DB_UNIQUE_NAME = "orcl12c.us.oracle.com" #----------------------------------------------------------------------------- # Name : INSTANCENAME # Datatype : String # Description : RAC instance name to be deleted # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : Yes #----------------------------------------------------------------------------- INSTANCENAME = "orcl12c" #----------------------------------------------------------------------------- # Name : NODENAME # Datatype : String # Description : Node on which instance to be deleted (SID) is located # Valid values : Cluster node name # Default value : None # Mandatory : No #----------------------------------------------------------------------------- #NODENAME= #----------------------------------------------------------------------------- # Name : OBFUSCATEDPASSWORDS # Datatype : Boolean # Description : Set to true if passwords are encrypted # Valid values : TRUE\FALSE # Default value : FALSE # Mandatory : No #----------------------------------------------------------------------------- #OBFUSCATEDPASSWORDS = FALSE #----------------------------------------------------------------------------- # Name : SYSDBAUSERNAME # Datatype : String # Description : A user with DBA role. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- SYSDBAUSERNAME = "sys" #----------------------------------------------------------------------------- # Name : SYSDBAPASSWORD # Datatype : String # Description : The password of the DBA user. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- #SYSDBAPASSWORD = "password" #-----------------------*** End of DELETEINSTANCE section ***------------------------ #---------------------------------------------------------------------------------- # CREATEPLUGGABLEDATABASE section is used when OPERATION_TYPE is defined as "createPluggableDatabase". #---------------------------------------------------------------------------------- [CREATEPLUGGABLEDATABASE] #---------------------------------------------------------------------------------- # Name : SOURCEDB # Datatype : String # Description : The source database is the SID # This database must be local and on the same ORACLE_HOME. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- SOURCEDB = "orcl" #---------------------------------------------------------------------------------- # Name : PDBNAME # Datatype : String # Description : The name of new pluggable database # This pdb name must not be same as sourcedb name. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- PDBNAME = "PDB1" #---------------------------------------------------------------------------------- # Name : CREATEASCLONE # Datatype : Boolean # Description : specify true or false for PDB to be create as Clone. # : When "true" is passed a new PDB GUID is generated for the plugged in PDB # Default value : true # Mandatory : NO #----------------------------------------------------------------------------- # CREATEASCLONE = "TRUE" #---------------------------------------------------------------------------------- #---------------------------------------------------------------------------------- # Name : CREATEPDBFROM # Datatype : String # Description : specify the source of pdb to be plugged # Valid values : DEFAULT | FILEARCHIVE | RMANBACKUP | USINGXML # Default value : DEFAULT # Mandatory : NO #----------------------------------------------------------------------------- # CREATEPDBFROM = "DEFAULT" #---------------------------------------------------------------------------------- # Name : PDBARCHIVEFILE # Datatype : String # Description : Full path and name for pdbArchive file # Default value : None # Mandatory : Mandatory when creating new PDB using FILEARCHIVE #----------------------------------------------------------------------------- # PDBARCHIVEFILE = "" #---------------------------------------------------------------------------------- # Name : PDBBACKUPFILE # Datatype : String # Description : Full path and name for pdb back up file # Default value : None # Mandatory : Mandatory when creating new PDB using RMANBACKUP #----------------------------------------------------------------------------- # PDBBACKUPFILE = "" #---------------------------------------------------------------------------------- # Name : PDBMETADATAFILE # Datatype : String # Description : Full path and name for pdb metadata file # Default value : None # Mandatory : Mandatory when creating new PDB using RMANBACKUP or USINGXML #----------------------------------------------------------------------------- # PDBMETADATAFILE = "" #---------------------------------------------------------------------------------- # Name : PDBUSEMULTIPLEBACKUP # Datatype : boolean # Description : Flag that can used to create PDB from single or multiple backupsets # Default value : true # Mandatory : Optional when creating new PDB using RMANBACKUP or USINGXML #----------------------------------------------------------------------------- # PDBUSEMULTIPLEBACKUP = #---------------------------------------------------------------------------------- # Name : PDBADMINUSERNAME # Datatype : String # Description : PDB Administrator user name # Default value : None # Mandatory : Mandatory only when creating new DEFAULT PDB #----------------------------------------------------------------------------- # PDBADMINUSERNAME = "" #---------------------------------------------------------------------------------- # Name : PDBADMINPASSWORD # Datatype : String # Description : PDB Administrator user password # Default value : None # Mandatory : Mandatory only when creating new DEFAULT PDB #----------------------------------------------------------------------------- # PDBADMINPASSWORD = "" #---------------------------------------------------------------------------------- # Name : CREATENEWPDBADMINUSER # Datatype : String # Description : When Plugging a pdb from FILEARCHIVE or RMANBACKUP # a new PDB Administrator user can be created using this option # This option should be given along with pdbadmin username and password # Default value : False # Mandatory : NO #----------------------------------------------------------------------------- # CREATENEWPDBADMINUSER = "" #---------------------------------------------------------------------------------- # Name : SOURCEFILENAMECONVERT # Datatype : String # Description : This clause specifies how to locate files listed in an XML file # describing a Pluggable Database if they reside in a location different # from that specified in the XML file. # This clause is valid when creating Pluggable database in USINGXML option # Valid values : (<filename_pattern>, <replacement_filename_pattern>,....) # Default value : "NONE" # Mandatory : NO #----------------------------------------------------------------------------- # SOURCEFILENAMECONVERT = "" #---------------------------------------------------------------------------------- # Name : FILENAMECONVERT # Datatype : String # Description : This clause specifies how to generate names of files # for the Pluggable Database being created using names of existing files # This clause is valid when creating Pluggable database in USINGXML option # Valid values : (<filename_pattern>, <replacement_filename_pattern>,....) # Default value : "NONE" # Mandatory : NO #----------------------------------------------------------------------------- # FILENAMECONVERT = "" #---------------------------------------------------------------------------------- # Name : COPYPDBFILES # Datatype : Boolean # Description : If COPY is specified, it will indicate that datafiles need to be copied. # : This option can be true only when FILENAMECONVERT is specified or # CDB files are Oracle Managed Files(OMF) # Valid values : TRUE \ FALSE # Default value : False # Mandatory : NO #----------------------------------------------------------------------------- # COPYPDBFILES = "" #---------------------------------------------------------------------------------- # Name : PDBDATAFILEDESTINATION # Datatype : String # Description : common location for PDB datafile area # Default value : None # Mandatory : NO #----------------------------------------------------------------------------- # PDBDATAFILEDESTINATION = "" #---------------------------------------------------------------------------------- # Name : USEMETADATAFILELOCATION # Datatype : Boolean # Description : Specify true if datafile path defined in Meta datafile within PDB # archive file is to be used to un-archive datafile. # Valid values : TRUE \ FALSE # Default value : FALSE # Mandatory : NO #----------------------------------------------------------------------------- # USEMETADATAFILELOCATION = "" #----------------------------------------------------------------------------- # Name : REGISTERWITHDIRSERVICE # Datatype : Boolean # Description : Specifies whether to register with Directory Service. # Valid values : TRUE \ FALSE # Default value : FALSE # Mandatory : No #----------------------------------------------------------------------------- #REGISTERWITHDIRSERVICE= TRUE #----------------------------------------------------------------------------- # Name : DIRSERVICEUSERNAME # Datatype : String # Description : Specifies the name of the directory service user # Mandatory : YES, if the value of registerWithDirService is TRUE #----------------------------------------------------------------------------- #DIRSERVICEUSERNAME= "name" #----------------------------------------------------------------------------- # Name : DIRSERVICEPASSWORD # Datatype : String # Description : The password of the directory service user. # You can also specify the password at the command prompt instead of here. # Mandatory : YES, if the value of registerWithDirService is TRUE #----------------------------------------------------------------------------- #DIRSERVICEPASSWORD= "password" #----------------------------------------------------------------------------- # Name : WALLETPASSWORD # Datatype : String # Description : The password for wallet to created or modified. # You can also specify the password at the command prompt instead of here. # Mandatory : YES, if the value of registerWithDirService is TRUE #----------------------------------------------------------------------------- #WALLETPASSWORD= "password" #----------------------------------------------------------------------------- # Name : LBACSYSPASSWORD # Datatype : String # Description : Password for LBACSYS user # You can also specify the password at the command prompt instead of here. # Mandatory : YES, if the value of registerWithDirService are TRUE #----------------------------------------------------------------------------- #LBACSYSPASSWORD= "password" #---------------------------------------------------------------------------------- # Name : CREATEUSERTABLESPACE # Datatype : Boolean # Description : Specify true if a default user tablespace need to be created in new PDB # # Valid values : TRUE \ FALSE # Default value : TRUE # Mandatory : NO #----------------------------------------------------------------------------- # CREATEUSERTABLESPACE = "" #----------------------------------------------------------------------------- # Name : DVCONFIGURATION # Datatype : Boolean # Description : Specify "True" to configure and enable Oracle Database vault # Valid values : True/False # Default value : False # Mandatory : No #----------------------------------------------------------------------------- #DVCONFIGURATION = "false" #----------------------------------------------------------------------------- # Name : DVOWNERNAME # Datatype : String # Description : DataVault Owner # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : Yes, if DataVault option is chosen #----------------------------------------------------------------------------- #DVOWNERNAME = "" #----------------------------------------------------------------------------- # Name : DVOWNERPASSWORD # Datatype : String # Description : Password for DataVault Owner # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : Yes, if DataVault option is chosen #----------------------------------------------------------------------------- #DVOWNERPASSWORD = "" #----------------------------------------------------------------------------- # Name : DVACCOUNTMANAGERNAME # Datatype : String # Description : DataVault Account Manager # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : No #----------------------------------------------------------------------------- #DVACCOUNTMANAGERNAME = "" #----------------------------------------------------------------------------- # Name : DVACCOUNTMANAGERPASSWORD # Datatype : String # Description : Password for DataVault Account Manager # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : No #----------------------------------------------------------------------------- #DVACCOUNTMANAGERPASSWORD = "" #-----------------------*** End of createPluggableDatabase section ***------------------------ #---------------------------------------------------------------------------------- # UNPLUGDATABASE section is used when OPERATION_TYPE is defined as "unplugDatabase". #---------------------------------------------------------------------------------- [UNPLUGDATABASE] #---------------------------------------------------------------------------------- # Name : SOURCEDB # Datatype : String # Description : The source database is the SID # This database must be local and on the same ORACLE_HOME. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- SOURCEDB = "orcl" #---------------------------------------------------------------------------------- # Name : PDBNAME # Datatype : String # Description : The name of new pluggable database # This pdb name must not be same as sourcedb name. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- PDBNAME = "PDB1" #---------------------------------------------------------------------------------- # Name : ARCHIVETYPE # Datatype : String # Description : The unplugged database datafile backup will in tar.gz or rman backup # This pdb name must not be same as sourcedb name. # Valid values : TAR | RMAN # Default value : TAR # Mandatory : NO #----------------------------------------------------------------------------- ARCHIVETYPE = "TAR" #---------------------------------------------------------------------------------- # Name : PDBARCHIVEFILE # Datatype : String # Description : Full path and name for pdbArchive file # Default value : None # Mandatory : NO #----------------------------------------------------------------------------- # PDBARCHIVEFILE = "" #---------------------------------------------------------------------------------- # Name : PDBBACKUPFILE # Datatype : String # Description : Full path and name for pdb back up file # Default value : None # Mandatory : No #----------------------------------------------------------------------------- # PDBBACKUPFILE = "" #---------------------------------------------------------------------------------- # Name : PDBMETADATAFILE # Datatype : String # Description : Full path and name for pdb metadata file # Default value : None # Mandatory : No #----------------------------------------------------------------------------- # PDBMETADATAFILE = "" #----------------------------------------------------------------------------- # Name : UNREGISTERWITHDIRSERVICE # Datatype : Boolean # Description : Specifies whether to unregister with Directory Service. # Valid values : TRUE \ FALSE # Default value : FALSE # Mandatory : No #----------------------------------------------------------------------------- #UNREGISTERWITHDIRSERVICE= TRUE #----------------------------------------------------------------------------- # Name : DIRSERVICEUSERNAME # Datatype : String # Description : Specifies the name of the directory service user # Mandatory : YES, if the value of unregisterWithDirService is TRUE #----------------------------------------------------------------------------- #DIRSERVICEUSERNAME= "name" #----------------------------------------------------------------------------- # Name : DIRSERVICEPASSWORD # Datatype : String # Description : The password of the directory service user. # You can also specify the password at the command prompt instead of here. # Mandatory : YES, if the value of unregisterWithDirService is TRUE #----------------------------------------------------------------------------- #DIRSERVICEPASSWORD= "password" #----------------------------------------------------------------------------- # Name : WALLETPASSWORD # Datatype : String # Description : The password for wallet to created or modified. # You can also specify the password at the command prompt instead of here. # Mandatory : YES, if the value of unregisterWithDirService is TRUE #----------------------------------------------------------------------------- #WALLETPASSWORD= "password" #-----------------------*** End of unplugDatabase section ***------------------------ #---------------------------------------------------------------------------------- # DELETEPLUGGABLEDATABASE section is used when OPERATION_TYPE is defined as "deletePluggableDatabase". #---------------------------------------------------------------------------------- [DELETEPLUGGABLEDATABASE] #---------------------------------------------------------------------------------- # Name : SOURCEDB # Datatype : String # Description : The source database is the SID # This database must be local and on the same ORACLE_HOME. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- SOURCEDB = "orcl" #---------------------------------------------------------------------------------- # Name : PDBNAME # Datatype : String # Description : The name of new pluggable database # This pdb name must not be same as sourcedb name. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- PDBNAME = "PDB1" #-----------------------*** End of deletePluggableDatabase section ***------------------------ #---------------------------------------------------------------------------------- # CONFIGUREPLUGGABLEDATABASE section is used when OPERATION_TYPE is defined as "configurePluggableDatabase". #---------------------------------------------------------------------------------- [CONFIGUREPLUGGABLEDATABASE] #---------------------------------------------------------------------------------- # Name : SOURCEDB # Datatype : String # Description : The source database is the SID # This database must be local and on the same ORACLE_HOME. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- SOURCEDB = "orcl" #---------------------------------------------------------------------------------- # Name : PDBNAME # Datatype : String # Description : The name of new pluggable database # This pdb name must not be same as sourcedb name. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- PDBNAME = "PDB1" #----------------------------------------------------------------------------- # Name : DVCONFIGURATION # Datatype : Boolean # Description : Specify "True" to configure and enable Oracle Database vault # Valid values : True/False # Default value : False # Mandatory : No #----------------------------------------------------------------------------- #DVCONFIGURATION = "false" #----------------------------------------------------------------------------- # Name : DVOWNERNAME # Datatype : String # Description : DataVault Owner # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : Yes, if DataVault option is chosen #----------------------------------------------------------------------------- #DVOWNERNAME = "" #----------------------------------------------------------------------------- # Name : DVOWNERPASSWORD # Datatype : String # Description : Password for DataVault Owner # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : Yes, if DataVault option is chosen #----------------------------------------------------------------------------- #DVOWNERPASSWORD = "" #----------------------------------------------------------------------------- # Name : DVACCOUNTMANAGERNAME # Datatype : String # Description : DataVault Account Manager # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : No #----------------------------------------------------------------------------- #DVACCOUNTMANAGERNAME = "" #----------------------------------------------------------------------------- # Name : DVACCOUNTMANAGERPASSWORD # Datatype : String # Description : Password for DataVault Account Manager # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : No #----------------------------------------------------------------------------- #DVACCOUNTMANAGERPASSWORD = "" #----------------------------------------------------------------------------- # Name : OLSCONFIGURATION # Datatype : Boolean # Description : Specify "True" to configure and enable Oracle Label Security # Valid values : True/False # Default value : False # Mandatory : No #----------------------------------------------------------------------------- #OLSCONFIGURATION = "false" #----------------------------------------------------------------------------- # Name : REGISTERWITHDIRSERVICE # Datatype : Boolean # Description : Specifies whether to register with Directory Service. # Valid values : TRUE \ FALSE # Default value : FALSE # Mandatory : No #----------------------------------------------------------------------------- #REGISTERWITHDIRSERVICE= TRUE #----------------------------------------------------------------------------- # Name : DIRSERVICEUSERNAME # Datatype : String # Description : Specifies the name of the directory service user # Mandatory : YES, if the value of registerWithDirService is TRUE #----------------------------------------------------------------------------- #DIRSERVICEUSERNAME= "name" #----------------------------------------------------------------------------- # Name : DIRSERVICEPASSWORD # Datatype : String # Description : The password of the directory service user. # You can also specify the password at the command prompt instead of here. # Mandatory : YES, if the value of registerWithDirService is TRUE #----------------------------------------------------------------------------- #DIRSERVICEPASSWORD= "password" #----------------------------------------------------------------------------- # Name : WALLETPASSWORD # Datatype : String # Description : The password for wallet to created or modified. # You can also specify the password at the command prompt instead of here. # Mandatory : YES, if the value of registerWithDirService is TRUE #----------------------------------------------------------------------------- #WALLETPASSWORD= "password" #----------------------------------------------------------------------------- # Name : LBACSYSPASSWORD # Datatype : String # Description : Password for LBACSYS user # You can also specify the password at the command prompt instead of here. # Mandatory : YES, if the value of olsConfiguration and registerWithDirService are TRUE #----------------------------------------------------------------------------- #LBACSYSPASSWORD= "password" #----------------------------------------------------------------------------- # Name : EMCONFIGURATION # Datatype : String # Description : Enterprise Manager Configuration Type # Valid values : DBEXPRESS|NONE # Default value : NONE # Mandatory : No #----------------------------------------------------------------------------- #EMCONFIGURATION = "NONE" #----------------------------------------------------------------------------- # Name : EMEXPRESSPORT # Datatype : Number # Description : Enterprise Manager Configuration Type # Valid values : Check Oracle12c Administrator's Guide # Default value : NONE # Mandatory : No, will be picked up from DBEXPRESS_HTTPS_PORT env variable # or auto generates a free port between 5500 and 5599 #----------------------------------------------------------------------------- #EMEXPRESSPORT = "" #-----------------------*** End of configurePluggableDatabase section ***------------------------
Either you can use response file or mention required parameters inline on command. Below are mandatory parameters List.
Only mandatory parameter need to assign values but need to change any parameter if you are not looking for default settings…
# Description : Global database name of the database GDBNAME = "ORCL.us.oracle.com" # Description : System identifier (SID) of the database SID = "ORCL" TEMPLATENAME = "General_Purpose.dbc" # Description : Password for SYS user SYSPASSWORD = "password" # Description : Password for SYSTEM user SYSTEMPASSWORD = "password" #Description : total memory in MB to allocate to Oracle TOTALMEMORY = "1500" # Description : National Character set of the database # Valid values : "UTF8" or "AL16UTF16". For details, check Oracle12c National Language Support Guide NATIONALCHARACTERSET= "AL16UTF16" # FOR RAC NODELIST=ocmnode1,ocmenode2 STORAGETYPE=ASM DISKGROUPNAME=DATA
[oracle@ocmnode1 ~]$ dbca -help
dbca [-silent | -progressOnly] {<command> <options> } | { [<command> [options] ] -responseFile <response file > } [-continueOnNonFatalErrors <true | false>]
<command> : -createDatabase | -configureDatabase | -addInstance | -deleteInstance | -createTemplateFromDB | -createCloneTemplate | -generateScripts | -deleteDatabase | -createPluggableDatabase | -unplugDatabase | -deletePluggableDatabase | -configurePluggableDatabase
Enter "dbca -<command> -help" for more option
For Standalone Database:
[oracle@ocmnode1 oracle]$ dbca -silent -createDatabase -gdbname orcl -sid orcl -templatename General_Purpose.dbc -syspassword orclsys -systempassword orclsys -emConfiguration none -datafileDestination /u02/datafile/orcl -ignorePreReqs
For Creating Database on RAC:
[oracle@ocmnode1 oracle]$ dbca -silent -createDatabase -gdbname orcl -sid orcl -templatename General_Purpose.dbc -syspassword oracle -systempassword oracle -emConfiguration none -nodelist "ocmnode1,ocmnode2" -storagetype asm -diskgroupname +DATA -recoveryGroupName +FRA -ignorePreReqs Copying database files 1% complete 3% complete 9% complete 15% complete 21% complete 27% complete 30% complete Creating and starting Oracle instance 32% complete 36% complete 40% complete 44% complete 45% complete 48% complete 50% complete Creating cluster database views 52% complete 70% complete Completing Database Creation 73% complete 76% complete 85% complete 94% complete 100% complete Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl1.log" for further details.
Validation:
[oracle@ocmnode1 oracle]$ srvctl status database -d orcl Instance orcl1 is running on node ocmnode1 Instance orcl2 is running on node ocmnode2 [oracle@ocmnode1 oracle]$ srvctl config database -d orcl Database unique name: orcl Database name: orcl Oracle home: /u001/app/oracle/product/12.1.0/dbhome_1 Oracle user: oracle Spfile: +DATA/ORCL/PARAMETERFILE/spfile.257.1044207951 Password file: +DATA/ORCL/PASSWORD/pwdorcl.270.1044207789 Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: Disk Groups: FRA,DATA Mount point paths: Services: Type: RAC Start concurrency: Stop concurrency: OSDBA group: dba OSOPER group: oper Database instances: orcl1,orcl2 Configured nodes: ocmnode1,ocmnode2 Database is administrator managed
Manage ASM in silent mode:
[oracle@racdr1 ~]$ . oraenv
ORACLE_SID = [ORCL1] ? +ASM1
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@racdr1 ~]$ asmca -help
asmca [-silent] [-sysAsmPassword <SYS user password>] [-asmsnmpPassword <ASM monitor password>] {<command> <options>}
Please refer to the manual for details.
You can enter one of the following commands:
1. Configure an ASM instance by specifying the following command and parameters:
-configureASM
[-sysAsmPassword <SYS user password>]
[-asmsnmpPassword <ASM monitor password>]
[(-param <paramname=paramvalue>)]
-diskString <disk discovery path>
(-diskGroupName <disk group name>
(-disk <disk path> [-diskName <disk name>] |
-diskList <comma separated disk list>
[-diskSize <disk size in MB>]
[-failuregroup <failure group name>]
[-force|-noforce]
[-quorum|-noquorum])
[-redundancy <HIGH|NORMAL|EXTERNAL>]
[-au_size <2^0 ~ 2^6 (1 ~ 64)>]
[-compatible.asm <10.1 ~ 11.2>]
[-compatible.rdbms <10.1 ~ 11.2>]
[-compatible.advm <11.2>])
2. Upgrade an existing ASM instance by specifying the following command and parameters:
-upgradeASM
[-asmsnmpPassword <ASM monitor password>]
3. Configure ASM parameters by specifying the following command and parameters:
-configureParameter
(-param <paramname=paramvalue>)
[-sysAsmPassword <SYS user password>]
4. Create Disk Groups by specifying the following command and parameters:
-createDiskGroup
[-diskString <disk discovery path>]
(-diskGroupName <disk group name>
(-disk <disk path> [-diskName <disk name>] |
-diskList <comma separated disk list>
[-diskSize <disk size in MB>]
[-failuregroup <failure group name>]
[-force|-noforce]
[-quorum|-noquorum])
[-redundancy <HIGH|NORMAL|EXTERNAL>]
[-au_size <2^0 ~ 2^6 (1 ~ 64)>]
[-compatible.asm <10.1 ~ 11.2>]
[-compatible.rdbms <10.1 ~ 11.2>]
[-compatible.advm <11.2>])
[-sysAsmPassword <SYS user password>]
5. Add disks to Disk Groups by specifying the following command and parameters:
-addDisk
[-diskString <disk discovery path>]
(-diskGroupName <disk group name>
(-disk <disk path> [-diskName <disk name>] |
-diskList <comma separated disk list>
[-diskSize <disk size in MB>]
[-failuregroup <failure group name>]
[-force|-noforce]
[-quorum|-noquorum])
[-sysAsmPassword <SYS user password>]
6. Create volumes by specifying the following command and parameters:
-createVolume
(-volumeName <ASM volume name>
-volumeDiskGroup <ASM disk group name for the volume>
-volumeSizeGB <ASM volume size in GB>
[-volumeRedundancy <INHERIT|MIRROR|HIGH|UNPROTECTED>])
[-sysAsmPassword <SYS user password>]
7. Create ASM Cluster File Systems by specifying the following command and parameters:
-createACFS
(-acfsVolumeDevice <ASM volume device>)
(-acfsMountPoint <existing host file system path>)
[-acfsUserName <ACFS User Name>]
[-acfsGroupName <ACFS Group Name>]
[-sysAsmPassword <SYS user password>]
8. Delete ASM instance(s) by specifying the following command and parameters:
-deleteASM
[-force]
[-dropDiskGroups]
[-sysAsmPassword <SYS user password>]
9. Convert Standard ASM into Oracle Flex ASM by specifying the following command and parameters:
-convertToFlexASM
-asmNetworks <comma separated ASM Networks each network of the form interface name/subnet>
-asmListenerPort <ASM listener port number>
Create ASM Disk Group using asmca in silent mode:
[oracle@racdr1 ~]$ oracleasm listdisks DATADISK1 DATADISK2 DATADISK3 DATADISK4 DATADISK5 DATADISK6 DATADISK7 OCRDISK1 OCRDISK2 OCRDISK3 [oracle@racdr1 ~]$ asmca -silent -creatediskgroup -diskGroupName DATA01 -diskList ORCL:DATADISK6,ORCL:DATADISK7 -redundancy External -compatible.asm '12.1.0.0.0' Disk Group DATA01 created successfully.
[oracle@racdr1 ~]$ asmcmd ASMCMD> lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 4096 1048576 15342 12765 0 12765 0 N DATA/ MOUNTED EXTERN N 512 4096 1048576 10228 10129 0 10129 0 N DATA01/ MOUNTED EXTERN N 512 4096 1048576 10228 10129 0 10129 0 N FRA/ MOUNTED EXTERN N 512 4096 1048576 9201 4723 0 4723 0 Y OCR/
Configure Listener or TNS with Silent mode:
How to use DBUA for Database Upgrades with Silent mode:
