Discover Top Posts Tagged with #oracle linux 7

Install Oracle Database 12c Release 1 Software on Oracle Linux 7 - Part 3

Install Oracle Database 12c Release 1 on Oracle Linux 7

Start Database Creation Assistance

# dbca -silent -responseFile dbca.rsp

DISPLAY not set. Set DISPLAY environment variable, then re-run. [oracle@oakland ~]$ dbca -silent -responseFile /home/oracle/dbca.rsp Copying database files 1% complete 2% complete 8% complete 13% complete 27% complete Creating and starting Oracle instance 29% complete 32% complete 33% complete 34% complete 38% complete 42% complete 43% complete 45% complete Completing Database Creation 48% complete 51% complete 53% complete 62% complete 64% complete 72% complete Creating Pluggable Databases 78% complete 100% complete Look at the log file "/home/oracle/app/oracle/cfgtoollogs/dbca/orcl12c/orcl12c.log" for further details.

dbca.rsp

############################################################################## ## ## ## DBCA response file ## ## ------------------ ## ## Copyright 1998, 2014, Oracle Corporation. All Rights Reserved. ## ## ## ## Specify values for the variables listed below to customize Oracle ## ## Database Configuration installation. ## ## ## ## Each variable is associated with a comment. The comment identifies the ## ## variable type. ## ## ## ## Please specify the values in the following format : ## ## Type : Example ## ## String : "<value>" ## ## Boolean : True or False ## ## Number : <numeric value> ## ## StringList : {"<value1>","<value2>"} ## ## ## ## 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. ## ##############################################################################

#----------------------------------------------------------------------------- # 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 = true

#----------------------------------------------------------------------------- # Name : NUMBEROFPDBS # Datatype : Number # Description : Specify the number of pdb to be created # Valid values : 0 to 252 # Default value : 0 # Mandatory : No #----------------------------------------------------------------------------- NUMBEROFPDBS = 1

#----------------------------------------------------------------------------- # 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 = pdborcl12c

#----------------------------------------------------------------------------- # Name : PDBADMINPASSWORD # Datatype : String # Description : PDB Administrator user password # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : No #----------------------------------------------------------------------------- PDBADMINPASSWORD = "oracle"

#----------------------------------------------------------------------------- # 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 = "oracle"

#----------------------------------------------------------------------------- # Name : SYSTEMPASSWORD # Datatype : String # Description : Password for SYSTEM user # Valid values : Check Oracle12c Administrator's Guide # Default value : None # Mandatory : Yes #----------------------------------------------------------------------------- SYSTEMPASSWORD = "oracle"

#----------------------------------------------------------------------------- # 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 = "DBEXPRESS"

#----------------------------------------------------------------------------- # 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 = "5500"

#----------------------------------------------------------------------------- # 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 = "oracle"

#----------------------------------------------------------------------------- # 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 = /home/oracle/app/oracle/oradata

#----------------------------------------------------------------------------- # 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=/home/oracle/app/flash_recovery_area

#----------------------------------------------------------------------------- # 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 = "AL32UTF8"

#----------------------------------------------------------------------------- # 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= "AL16UTF16"

#----------------------------------------------------------------------------- # 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 = "LISTENER"

#----------------------------------------------------------------------------- # 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=FALSE

#----------------------------------------------------------------------------- # 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 = "3072"

#-----------------------*** 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 : 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 : 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"

#-----------------------*** 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 : 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"

#-----------------------*** 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 : SYSDBAPASSWORD # Datatype : String # Description : The password of the DBA user. # Default value : none # Mandatory : YES #----------------------------------------------------------------------------- #SYSDBAPASSWORD = "password"

#-----------------------*** End of ADDINSTANCE section ***------------------------

#----------------------------------------------------------------------------- # DELETEINSTANCE section is used when OPERATION_TYPE is defined as "deleteInstance". #----------------------------------------------------------------------------- [DELETEINSTANCE]

#----------------------------------------------------------------------------- # 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 : 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 : 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 = ""

#-----------------------*** 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 : 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 : 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"

#-----------------------*** 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 : 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"

#-----------------------*** End of configurePluggableDatabase section ***------------------------

#oracle database 12c #oracle linux 7 #runInstaller #dbca

Install Oracle Database 12c Release 1 Software on Oracle Linux 7 - Part 1

Prepare Oracle Linux 7.1 for Oracle Database 12c installation

Change file open descriptor limit

Open /etc/security/limits.conf.

Append the following lines to the file.

oracle soft nofile 4096 oracle hard nofile 65536

Using the response file

# ./runInstaller -silent -responseFile db_install.rsp

Starting Oracle Universal Installer... Checking Temp space: must be greater than 500 MB. Actual 27756 MB Passed Checking swap space: must be greater than 150 MB. Actual 3967 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-09-11_08-20-45PM. Please wait ...[oracle@miami database]$ You can find the log of this install session at: /home/oracle/app/oraInventory/logs/installActions2015-09-11_08-20-45PM.log The installation of Oracle Database 12c was successful. Please check '/home/oracle/app/oraInventory/logs/silentInstall2015-09-11_08-20-45PM.log' for more details. As a root user, execute the following script(s): 1. /home/oracle/app/oraInventory/orainstRoot.sh 2. /home/oracle/app/oracle/product/12.1.0/dbhome_1/root.sh

Successfully Setup Software.

db_install.rsp

#################################################################### ## 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=INSTALL_DB_SWONLY

#------------------------------------------------------------------------------- # Specify the hostname of the system as set during the install. It can be used # to force the installation to use an alternative hostname rather than using the # first hostname found on the system. (e.g., for systems with multiple hostnames # and network interfaces) #------------------------------------------------------------------------------- ORACLE_HOSTNAME=hostname.domain.local

#------------------------------------------------------------------------------- # Specify the Unix group to be set for the inventory directory. #------------------------------------------------------------------------------- UNIX_GROUP_NAME=oinstall

#------------------------------------------------------------------------------- # Specify the location which holds the inventory files. # This is an optional parameter if installing on # Windows based Operating System. #------------------------------------------------------------------------------- INVENTORY_LOCATION=/home/oracle/app/oraInventory #------------------------------------------------------------------------------- # Specify the languages in which the components will be installed. # # en : English ja : Japanese # fr : French ko : Korean # ar : Arabic es : Latin American Spanish # bn : Bengali lv : Latvian # pt_BR: Brazilian Portuguese lt : Lithuanian # bg : Bulgarian ms : Malay # fr_CA: Canadian French es_MX: Mexican Spanish # ca : Catalan no : Norwegian # hr : Croatian pl : Polish # cs : Czech pt : Portuguese # da : Danish ro : Romanian # nl : Dutch ru : Russian # ar_EG: Egyptian zh_CN: Simplified Chinese # en_GB: English (Great Britain) sk : Slovak # et : Estonian sl : Slovenian # fi : Finnish es_ES: Spanish # de : German sv : Swedish # el : Greek th : Thai # iw : Hebrew zh_TW: Traditional Chinese # hu : Hungarian tr : Turkish # is : Icelandic uk : Ukrainian # in : Indonesian vi : Vietnamese # it : Italian # # all_langs : All languages # # Specify value as the following to select any of the languages. # Example : SELECTED_LANGUAGES=en,fr,ja # # Specify value as the following to select all the languages. # Example : SELECTED_LANGUAGES=all_langs #------------------------------------------------------------------------------- SELECTED_LANGUAGES=en

#------------------------------------------------------------------------------- # Specify the complete path of the Oracle Home. #------------------------------------------------------------------------------- ORACLE_HOME=/home/oracle/app/oracle/product/12.1.0/dbhome_1

#------------------------------------------------------------------------------- # Specify the complete path of the Oracle Base. #------------------------------------------------------------------------------- ORACLE_BASE=/home/oracle/app/oracle

#------------------------------------------------------------------------------- # Specify the installation edition of the component. # # The value should contain only one of these choices.

# - EE : Enterprise Edition

#------------------------------------------------------------------------------- oracle.install.db.InstallEdition=EE

############################################################################### # # # PRIVILEGED OPERATING SYSTEM GROUPS # # ------------------------------------------ # # Provide values for the OS groups to which OSDBA and OSOPER privileges # # needs to be granted. If the install is being performed as a member of the # # group "dba", then that will be used unless specified otherwise below. # # # # The value to be specified for OSDBA and OSOPER group is only for UNIX based # # Operating System. # # # ###############################################################################

#------------------------------------------------------------------------------ # The DBA_GROUP is the OS group which is to be granted OSDBA privileges. #------------------------------------------------------------------------------- oracle.install.db.DBA_GROUP=dba

#------------------------------------------------------------------------------ # The OPER_GROUP is the OS group which is to be granted OSOPER privileges. # The value to be specified for OSOPER group is optional. #------------------------------------------------------------------------------ oracle.install.db.OPER_GROUP=oper

#------------------------------------------------------------------------------ # The BACKUPDBA_GROUP is the OS group which is to be granted OSBACKUPDBA privileges. #------------------------------------------------------------------------------ oracle.install.db.BACKUPDBA_GROUP=dba

#------------------------------------------------------------------------------ # The DGDBA_GROUP is the OS group which is to be granted OSDGDBA privileges. #------------------------------------------------------------------------------ oracle.install.db.DGDBA_GROUP=dba

#------------------------------------------------------------------------------ # The KMDBA_GROUP is the OS group which is to be granted OSKMDBA privileges. #------------------------------------------------------------------------------ oracle.install.db.KMDBA_GROUP=dba

############################################################################### # # # Grid Options # # # ############################################################################### #------------------------------------------------------------------------------ # Specify the type of Real Application Cluster Database # # - ADMIN_MANAGED: Admin-Managed # - POLICY_MANAGED: Policy-Managed # # If left unspecified, default will be ADMIN_MANAGED #------------------------------------------------------------------------------ oracle.install.db.rac.configurationType=

#------------------------------------------------------------------------------ # Value is required only if RAC database type is ADMIN_MANAGED # # Specify the cluster node names selected during the installation. # Leaving it blank will result in install on local server only (Single Instance) # # Example : oracle.install.db.CLUSTER_NODES=node1,node2 #------------------------------------------------------------------------------ oracle.install.db.CLUSTER_NODES=

#------------------------------------------------------------------------------ # This variable is used to enable or disable RAC One Node install. # # - true : Value of RAC One Node service name is used. # - false : Value of RAC One Node service name is not used. # # If left blank, it will be assumed to be false. #------------------------------------------------------------------------------ oracle.install.db.isRACOneInstall=false

#------------------------------------------------------------------------------ # Value is required only if oracle.install.db.isRACOneInstall is true. # # Specify the name for RAC One Node Service #------------------------------------------------------------------------------ oracle.install.db.racOneServiceName=

#------------------------------------------------------------------------------ # Value is required only if RAC database type is POLICY_MANAGED # # Specify a name for the new Server pool that will be configured # Example : oracle.install.db.rac.serverpoolName=pool1 #------------------------------------------------------------------------------ oracle.install.db.rac.serverpoolName=

#------------------------------------------------------------------------------ # Value is required only if RAC database type is POLICY_MANAGED # # Specify a number as cardinality for the new Server pool that will be configured # Example : oracle.install.db.rac.serverpoolCardinality=2 #------------------------------------------------------------------------------ oracle.install.db.rac.serverpoolCardinality=0

############################################################################### # # # Database Configuration Options # # # ###############################################################################

#------------------------------------------------------------------------------- # Specify the type of database to create. # It can be one of the following: # - GENERAL_PURPOSE # - 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=GENERAL_PURPOSE

#------------------------------------------------------------------------------- # Specify the Starter Database Global Database Name. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.globalDBName=

#------------------------------------------------------------------------------- # Specify the Starter Database SID. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.SID=

#------------------------------------------------------------------------------- # Specify whether the database should be configured as a Container database. # The value can be either "true" or "false". If left blank it will be assumed # to be "false". #------------------------------------------------------------------------------- oracle.install.db.ConfigureAsContainerDB=false

#------------------------------------------------------------------------------- # Specify the Pluggable Database name for the pluggable database in Container Database. #------------------------------------------------------------------------------- oracle.install.db.config.PDBName=

#------------------------------------------------------------------------------- # Specify the Starter Database character set. # # One of the following # AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2, # EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257, # BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6, # AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8, # IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE, # KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950, # ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258 #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.characterSet=

#------------------------------------------------------------------------------ # This variable should be set to true if Automatic Memory Management # in Database is desired. # If Automatic Memory Management is not desired, and memory allocation # is to be done manually, then set it to false. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.memoryOption=false

#------------------------------------------------------------------------------- # Specify the total memory allocation for the database. Value(in MB) should be # at least 256 MB, and should not exceed the total physical memory available # on the system. # Example: oracle.install.db.config.starterdb.memoryLimit=512 #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.memoryLimit=

#------------------------------------------------------------------------------- # This variable controls whether to load Example Schemas onto # the starter database or not. # The value can be either "true" or "false". If left blank it will be assumed # to be "false". #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.installExampleSchemas=false

############################################################################### # # # Passwords can be supplied for the following four schemas in the # # starter database: # # SYS # # SYSTEM # # DBSNMP (used by Enterprise Manager) # # # # Same password can be used for all accounts (not recommended) # # or different passwords for each account can be provided (recommended) # # # ###############################################################################

#------------------------------------------------------------------------------ # This variable holds the password that is to be used for all schemas in the # starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.ALL=

#------------------------------------------------------------------------------- # Specify the SYS password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYS=

#------------------------------------------------------------------------------- # Specify the SYSTEM password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYSTEM=

#------------------------------------------------------------------------------- # Specify the DBSNMP password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.DBSNMP=

#------------------------------------------------------------------------------- # Specify the PDBADMIN password required for creation of Pluggable Database in the Container Database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.PDBADMIN=

#------------------------------------------------------------------------------- # Specify the management option to use for managing the database. # Options are: # 1. CLOUD_CONTROL - If you want to manage your database with Enterprise Manager Cloud Control along with Database Express. # 2. DEFAULT -If you want to manage your database using the default Database Express option. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.managementOption=DEFAULT

#------------------------------------------------------------------------------- # Specify the OMS host to connect to Cloud Control. # Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.omsHost=

#------------------------------------------------------------------------------- # Specify the OMS port to connect to Cloud Control. # Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.omsPort=0

#------------------------------------------------------------------------------- # Specify the EM Admin user name to use to connect to Cloud Control. # Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.emAdminUser=

#------------------------------------------------------------------------------- # Specify the EM Admin password to use to connect to Cloud Control. # Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.emAdminPassword=

############################################################################### # # # SPECIFY RECOVERY OPTIONS # # ------------------------------------ # # Recovery options for the database can be mentioned using the entries below # # # ###############################################################################

#------------------------------------------------------------------------------ # This variable is to be set to false if database recovery is not required. Else # this can be set to true. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.enableRecovery=false

#------------------------------------------------------------------------------- # Specify the type of storage to use for the database. # It can be one of the following: # - FILE_SYSTEM_STORAGE # - ASM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.storageType=

#------------------------------------------------------------------------------- # Specify the database file location which is a directory for datafiles, control # files, redo logs. # # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=

#------------------------------------------------------------------------------- # Specify the recovery location. # # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=

#------------------------------------------------------------------------------- # Specify the existing ASM disk groups to be used for storage. # # Applicable only when oracle.install.db.config.starterdb.storageType=ASM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.asm.diskGroup=

#------------------------------------------------------------------------------- # Specify the password for ASMSNMP user of the ASM instance. # # Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.asm.ASMSNMPPassword=

#------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username. # # Example : [email protected] #------------------------------------------------------------------------------ MYORACLESUPPORT_USERNAME=

#------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username password. # # Example : MYORACLESUPPORT_PASSWORD=password #------------------------------------------------------------------------------ MYORACLESUPPORT_PASSWORD=

#------------------------------------------------------------------------------ # Specify whether to enable the user to set the password for # My Oracle Support credentials. The value can be either true or false. # If left blank it will be assumed to be false. # # Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true #------------------------------------------------------------------------------ SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

#------------------------------------------------------------------------------ # Specify whether user doesn't want to configure Security Updates. # The value for this variable should be true if you don't want to configure # Security Updates, false otherwise. # # The value can be either true or false. If left blank it will be assumed # to be false. # # Example : DECLINE_SECURITY_UPDATES=false #------------------------------------------------------------------------------ DECLINE_SECURITY_UPDATES=true

#------------------------------------------------------------------------------ # Specify the Proxy server name. Length should be greater than zero. # # Example : PROXY_HOST=proxy.domain.com #------------------------------------------------------------------------------ PROXY_HOST=

#------------------------------------------------------------------------------ # Specify the proxy port number. Should be Numeric and 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=

#oracle database 12c #oracle linux 7 #runInstaller

Oracle Linux 7.1 Login Page Resolution

Adjust the screen resolution using System Tools > Settings > Displays.

Apply the changes to the desire resolution.

Copy the ~USER_HOME/.config/monitors.xml to /var/lib/gdm/.config/monitors.xml.

Change the file owner.

chown gdm:gdm /var/lib/gdm/.config/monitors.xml

#oracle linux 7 #resolution

Oracle Linux 7.1 JDK 1.8 Install

Download JDK from Oracle.

Install the RPM package

# rpm -ivh jdk-8u60-linux-x64.rpm

Preparing... ################################# [100%] Updating / installing... 1:jdk1.8.0_60-2000:1.8.0_60-fcs ################################# [100%] Unpacking JAR files... tools.jar... plugin.jar... javaws.jar... deploy.jar... rt.jar... jsse.jar... charsets.jar... localedata.jar... jfxrt.jar...

Setup the Environment Variables in .bash_profile

JAVA_HOME=/usr/java/jdk1.8.0_60 export JAVA_HOME PATH=$JAVA_HOME/bin:$PATH:$HOME/.local/bin:$HOME/bin

Check Java version

# java -version

java version "1.8.0_60" Java(TM) SE Runtime Environment (build 1.8.0_60-b27) Java HotSpot(TM) 64-Bit Server VM (build 25.60-b23, mixed mode)

#oracle linux 7 #oracle #java #jdk #jdk 8 #rpm

Oracle Linux 7.1 Config Hostname

To view hostname

# hostnamectl status

To change hostname

# hostnamectl set-hostname hostname

#oracle linux 7 #oracle #linux