How to make automated Oracle 11gR2/12c installer for Linux CentOS and RHEL 6.5

 The text below is a step-by-step instruction - how to build full automated silent offline setup of Oracle11gR2 (or Oracle12c) on Linux (RHEL6.5 or CentOS6.5).

feel free to send comments and questions https://www.linkedin.com/in/eisenstark

 Oracle Data Base version: 11g Release 2 (11.2.0.4) I used the Oracle Database patch set, release 11.2.0.4  (is a full installation of the Oracle Database software).  You can also run installation remotely by telnet or SSH (no need to X-session). If you going to install other Oracle DB version, say, Oracle12c, you should use respected Oracl12c installation package and oracle-rdbms-server-12cR1-preinstall rpm, respectively. The other steps and resources are supposed to remained same as described below.   

I faced this task as I had to provide some kind of simple “single click offline setup” for customers, intended to install Oracle11R2 DB on their (probably not connected to internet) Linux stations.  Everyone, who tried to install Oracle DB on Linux – knows how many boring steps need to pass through. As result of my job I got a directory “orainst” with all need resources (files, scripts and directory with  optionally needed RPMs) inside. All you need is to save it on DVD (or ISO) and use it on your target station. Just enter into “orainst” and run “./setup.sh”… and vuala! – it installs Oracle DB, doing all preinstall steps and finishing by creating oracle service.

 [oracle@CentOS6 ~]$ cd /orainst

[oracle@CentOS6 orainst]$ ls -F

database/                                  oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64.rpm        orapatchesx86_64/                    setup.sh

db-MYDB.rsp                             ora-local-patch.repo

ora_start.sh                               init_db.sql                                          

ora-local-patch.repo.templ           ora_stop.sh

ora-local-patch.repo.upd              postInstall.sh

[oracle@CentOS6 orainst]$

As you see above, there are two subdirectories: “database” – original Oracle installation . You need to download Oracle Database 11g Release 2 (11.2.0.4) from My Oracle Support website:  https://support.oracle.com . After unzip downloaded chunks you will get “database” folder with installation software. Optional “orapatchesx86_64” folder will be described later. “oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64.rpm”   - package, issued by Oracle to simplify installation process (download page https://oss.oracle.com/ol6/SRPMS-updates/ ). “db-MYDB.rsp” – response file, contained installation parameters (Db name, SGA size etc), and may be edited according to certain needs. Other files – are some scripts and templates.  Full listings are presented below.

If you follow the installation guide ( http://docs.oracle.com/cd/E11882_01/install.112/e24321/toc.htm ) , you can see that  there are few different  tasks, which needed to be done during Oracle installation on Linux platform.

  1. Relevant Linux related patches and packages installation
  2. OS kernel configuration
  3. Create oracle OS user and relevant group
  4. Create Oracle Home directory
  5. Run oracle installer
  6. Run postinstall scripts (as super user)
  7. Run optional postinstall vendor\customer specific scripts
  8. Create “oracle” service for automated startup on boot (and with start/stop/monitor commands)

 

As you see, we have a rather not simple task list to do. The our goal – to build installation package, included all needed files and directories which need to successful Oracle setup in Linux station, disconnected from internet. First of all, we already have a great helper for our job. As Oracle installation process became more and more complex Oracle decided to lunch Oracle Preinstall RPM, with name of intended- to-install product contained into RPM’s name. In our case - oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64.rpm

This product dramatically simplifies installation process, since it performs all preinstallation tasks, including patches installation. But there are two problems

  1. The new Oracle-Preinstall RPM has a dependency on kernel-uek, which is of course the Oracle Unbreakable Enterprise Kernel.  This problem is thoroughly reviewed by “flashdba” at his brilliant article at http://flashdba.com/install-cookbooks/using-oracle-preinstall-rpm-w...   “… So if you install the Oracle-Preinstall package you will likely find that next time you reboot your machine you are running a different kernel. And that sort of thing tends to come as a shock to those that weren’t expecting it…”  This article describes step-by-step how to open original rpm file and remove this optional package from dependencies list and let to install Oracle DB without installation (actually, optional) of  Unbreakable Enterprise Kernel. As result, you’ll get the updated oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64.rpm, which is suitable for our setup. Again, if you thinking to install unbreakable kernel – you can ignore this clause and use Oracle-Preinstall RPM as is.
  2. 2.       The oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64.rpm is intended to use “yum” program which in turn, should provide the dependencies resolution by installing missed patches and packages. If you intend to deal only with internet connected machines with properly configured yum, this clause is not relevant for you. But if the target station has not internet connection (some kind of intranet) for some reasons, you need to organize some kind of “local yum repository” with all needed rpm files inside in order to successfully run the Oracle-Preinstall RPM.  In other case you can ignore this clause and not boring with all these rpm files.

Let’s consider how to create a local yum repository for our setup.  First of all, we have to bring all rpms, which our setup need. The great helper here is “yumdownloader”. It brings desired package to your destination directory regardless whether this package already installed at your computer or not.

Firstly, you need to install yum-utils package:

# yum install yum-utils

       And run the command followed by the desired package:

# yumdownloader <package>

Example:

# yumdownloader libgcc

Note:

  • The package is saved in the current working directly by default; use the --destdir option to specify an alternate location.
  • Be sure to add --resolve if you need to download dependencies.

I’ve composed full rpm repository by experimenting with offline machine (both RHEL6.5 and Centos6.5) and by adding missed packages, referenced by Oracle-Preinstall RPM’s error  messages (see list below). I also suppose that some packages may be redundant and some other ones may be missed for certain Linux configuration. In case you get dependency resolution error – you can just download missed package and rebuild repository as described below.

 

[oracle@CentOS6 orainst]$ cd orapatchesx86_64/

[oracle@CentOS6 orapatchesx86_64]$ ls

audit-libs-2.2-2.el6.i686.rpm                                               libgcc-4.4.7-3.el6.i686.rpm

bc-1.06.95-1.el6.x86_64.rpm                                               libgcc-4.4.7-3.el6.x86_64.rpm

bind-utils-9.8.2-0.17.rc1.el6.x86_64.rpm                        libgomp-4.4.7-4.el6.i686.rpm

binutils-2.20.51.0.2-5.36.el6.x86_64.rpm                        libgomp-4.4.7-4.el6.x86_64.rpm

cloog-ppl-0.15.7-1.2.el6.i686.rpm                                      libselinux-2.0.94-5.3.el6.i686.rpm

cloog-ppl-0.15.7-1.2.el6.x86_64.rpm                                libsepol-2.0.41-4.el6.i686.rpm

compat-libcap1-1.10-1.i686.rpm                                        libstdc++-4.4.7-3.el6.i686.rpm

compat-libcap1-1.10-1.x86_64.rpm                                   libstdc++-4.4.7-3.el6.x86_64.rpm

compat-libstdc++-33-3.2.3-69.el6.i686.rpm                  libstdc++-4.4.7-4.el6.i686.rpm

compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm            libstdc++-4.4.7-4.el6.x86_64.rpm

cpp-4.4.7-3.el6.x86_64.rpm                                                 libstdc++-devel-4.4.7-3.el6.i686.rpm

cpp-4.4.7-4.el6.x86_64.rpm                                                  libstdc++-devel-4.4.7-3.el6.x86_64.rpm

cracklib-2.8.16-4.el6.i686.rpm                                              libstdc++-devel-4.4.7-4.el6.i686.rpm

db4-4.7.25-17.el6.i686.rpm                                                   libstdc++-devel-4.4.7-4.el6.x86_64.rpm

ethtool-3.5-1.el6.x86_64.rpm                                              libutempter-1.1.5-4.1.el6.i686.rpm

gcc-4.4.7-3.el6.x86_64.rpm                                                   libuuid-2.17.2-12.9.el6.i686.rpm

gcc-4.4.7-4.el6.x86_64.rpm                                                   make-3.81-20.el6.x86_64.rpm

gcc-c++-4.4.7-3.el6.x86_64.rpm                                         module-init-tools-3.9-21.el6.x86_64.rpm

gcc-c++-4.4.7-4.el6.x86_64.rpm                                          mpfr-2.4.1-6.el6.x86_64.rpm

glibc-2.12-1.107.el6_4.5.i686.rpm                                       ncurses-libs-5.7-3.20090208.el6.i686.rpm

glibc-2.12-1.107.el6_4.5.x86_64.rpm                               nfs-utils-1.2.3-36.el6.x86_64.rpm

glibc-2.12-1.107.el6.i686.rpm                                               nss-softokn-freebl-3.12.9-11.el6.i686.rpm

glibc-2.12-1.107.el6.x86_64.rpm                                        nss-softokn-freebl-3.12.9-11.el6.x86_64.rpm

glibc-2.12-1.132.el6.i686.rpm                                              nss-softokn-freebl-3.14.3-3.el6_4.i686.rpm

glibc-2.12-1.132.el6.x86_64.rpm                                        nss-softokn-freebl-3.14.3-3.el6_4.x86_64.rpm

glibc-common-2.12-1.107.el6_4.5.x86_64.rpm            openssh-clients-5.3p1-84.1.el6.x86_64.rpm

glibc-common-2.12-1.107.el6.x86_64.rpm                     pam-1.1.1-13.el6.i686.rpm

glibc-devel-2.12-1.107.el6.i686.rpm                                 pam-1.1.1-13.el6.x86_64.rpm

glibc-devel-2.12-1.107.el6.x86_64.rpm                           popt-1.13-7.el6.i686.rpm

glibc-headers-2.12-1.107.el6_4.5.x86_64.rpm             ppl-0.10.2-11.el6.i686.rpm

glibc-headers-2.12-1.107.el6.x86_64.rpm                    ppl-0.10.2-11.el6.x86_64.rpm

gmp-4.3.1-7.el6_2.2.i686.rpm                                              procps-3.2.8-25.el6.i686.rpm

initscripts-9.03.38-1.el6.centos.x86_64.rpm                procps-3.2.8-25.el6.x86_64.rpm

kernel-headers-2.6.32-358.18.1.el6.centos.plus.x86_64.rpm  /repodata

ksh-20100621-19.el6.x86_64.rpm                                      sysstat-9.0.4-20.el6.x86_64.rpm

libaio-0.3.107-10.el6.i686.rpm                                             util-linux-ng-2.17.2-12.9.el6.i686.rpm

libaio-0.3.107-10.el6.x86_64.rpm                                      util-linux-ng-2.17.2-12.9.el6.x86_64.rpm

libaio-devel-0.3.107-10.el6.i686.rpm                                xorg-x11-utils-7.5-6.el6.x86_64.rpm

libaio-devel-0.3.107-10.el6.x86_64.rpm                         xorg-x11-xauth-1.0.2-7.1.el6.x86_64.rpm

libblkid-2.17.2-12.9.el6.i686.rpm                                         zlib-1.2.3-29.el6.i686.rpm

In order to organize yum repository , I put all rpm files into orapatchesx86_64 folder and rebuild yum repo:

  • Install “createrepo” package  by   “yum install createrepo”.
  • >cd orapatchesx86_64
  • >createrepo   ./

The last command creates “repodata” subfolder into orapatchesx86_64 directory with yum specific metadata.

 

Now, a few words about installation script – “setup.sh”. It performs the following actions:

  1. Checks if hostname exists into /etc/hosts and exits with error message if not. I noticed, that installation fails un case of hostname is not presented into /etc/hosts file.  May be, there is some other solution? I would like to get any other opinions.
  2. Configure yum local repository , which contained all needed packages to be installed by   oracle-rdbms-server-11gR2-preinstall rpm as part of preinstallation tasks. It also will clean this configuration after preinstall ended. If you intend to use regular yum configuration (say web repository) and not need this local repository, you can remove all yum-related statements from script.
  3. Run   oracle-rdbms-server-11gR2-preinstall rpm, which do all difficult staff – configure OS kernel, install patches and packages and creates oracle user and group.
  4. Run Oracle installer.  Oracle installer uses response file db-MYDB.rsp, which contained db installation parameters (in example supposed that SID chosen as “MYDB”).
  5. Run postinstall scripts as root user.
  6. Update /etc/oratab file and create “oracle” service for automated startup on boot (and with start/stop/monitor commands)

 

Usage:

Script setup.sh   should be run as “root” user from the “orainst” directory (do “cd /orainst” before run)

>./setup.sh  [optional additional key for Oracle universal installer]

Example:  >./setup.sh  -p

At example above, “ –p”  is an additional key (ignore prerequisites), which will be used by Oracle installer. Before packages installation (by oracle preinstall rpm) you’ll need to answer “yes” for confirmation. This is a single point of interaction. I would like to make this setup totally silent, so if you have ideas, please send comments.  Hope, you’ll find this article useful and.. ENJOY !

 

 

listings of scripts:

setup.sh

#!/bin/bash

INST_DIR=`pwd`

#put here your DB name

ORA_SID=MYDB

ORA_BASE=/opt/oracle

ORA_HOME=$ORA_BASE/ora11

TMP=/tmp

HOSTNAME=`hostname`

#"/home/orainst"

if [ "$(whoami)" != 'root' ]; then

        echo "You have no permission to run $0 as non-root user."

        exit 1;

fi

 

if grep  -q $HOSTNAME /etc/hosts

then

    echo $HOSTNAME is found into /etc/hosts, tested OK

else

    # code if not found

    echo The Hostname $HOSTNAME is not found in /etc/hosts, please append it.

    exit 1;

fi

 

echo installation directory is  $INST_DIR

cp $INST_DIR/ora-local-patch.repo.templ $TMP/ora-local-patch.repo.upd

echo baseurl=file://$INST_DIR/orapatchesx86_64 >> $TMP/ora-local-patch.repo.upd

echo enabled=1 >> $TMP/ora-local-patch.repo.upd

echo gpgcheck=0 >> $TMP/ora-local-patch.repo.upd

 

cp $TMP/ora-local-patch.repo.upd /etc/yum.repos.d/ora-local-patch.repo

yum clean all

 

echo yum is updated: ora-local-patch.repo is copied to /etc/yum.repos.d

echo starting localinstall of oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64.rpm........

yum localinstall $INST_DIR/oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64.rpm

echo install of oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64.rpm ended!

 

rm -f /etc/yum.repos.d/ora-local-patch.repo

yum clean all

 

echo yum repository is cleaned from oracle staff

mkdir $ORA_BASE

chown oracle:oinstall $ORA_BASE

echo starting silent DB installation, optional key is $1 , be patient, it may take a while...........

su - oracle -c "cd ~;echo cd to ~ ; $INST_DIR/database/runInstaller  -silent  -force  -waitforcompletion $1 -responseFile $INST_DIR/db-MYDB.rsp" >> /var/log/oracle.log

if [ $? -gt 6 ];

then

 echo Oracle Installer failed, see log at /var/log/oracle.log; exit 1;

fi

echo runInstaller returns   $?

echo Oracle installer run ended!

 

echo Postinstallation actions: run postinstall scripts...

$ORA_BASE/oraInventory/orainstRoot.sh

$ORA_HOME/root.sh

echo Postinstallation actions: run postinstall scripts - done!

sed -i -e 's/:N/:Y/g' /etc/oratab

echo update /etc/oratab is done

echo creating oracle automated startup scripts and register service...

su - oracle -c "cd ~; mkdir scripts; cp $INST_DIR/ora_start.sh $INST_DIR/ora_stop.sh ~/scripts; chmod u+x ~/scripts/ora_*"

cp $INST_DIR/oracle /etc/init.d/.

chkconfig --add oracle

echo creating oracle automated startup is done

 

su - oracle -c " echo ORACLE_SID=$ORA_SID >> ~/.bash_profile; echo ORAENV_ASK=NO >> ~/.bash_profile; echo . oraenv >> ~/.bash_profile "

echo update .bash_profile  of 'oracle' user  is done

echo starting postinstall SQL script....

su - oracle -c "cd $INST_DIR; ./postInstall.sh"

echo postinstal SQL script is done

echo Data Base Installation completed.

 

ora-local-patch.repo                                      

[ora-local-patches]

name=Oracle Local Patches for Red Hat Enterprise Linux 6.x x86-64

baseurl=file:///orainst/orapatchesx86_64

enabled=1

gpgcheck=0

 

ora-local-patch.repo.templ

[ora-local-patches]

name=Oracle Local Patches for Red Hat Enterprise Linux 6.x x86-64

 

ora_start.sh

#!/bin/bash

# script to start the Oracle database, listener and dbconsole

 

. ~/.bash_profile

# start the listener and the database

$ORACLE_HOME/bin/dbstart $ORACLE_HOME

# start the Enterprise Manager db console

#$ORACLE_HOME/bin/emctl start dbconsole

exit 0

 

ora_stop.sh

#!/bin/bash

# script to stop the Oracle database, listener and dbconsole

 

. ~/.bash_profile

# stop the Enterprise Manager db console

#$ORACLE_HOME/bin/emctl stop dbconsole

# stop the listener and the database

$ORACLE_HOME/bin/dbshut $ORACLE_HOME

exit 0

 

postInstall.sh

#!/bin/bash

RETVAL=`sqlplus -silent / as sysdba EOF

SET PAGESIZE 0 FEEDBACK OFF VERIFY OFF HEADING OFF ECHO OFF

@./init_db.sql;

EXIT;

EOF`

if [ -z "$RETVAL" ]; then

  echo "DB init script ended OK"

  exit 0

else

  echo $RETVAL

  exit 1

fi

 

 init_db.sql

-- Put here whatever you need to do after db creation. For example:

-- Create users

create user foo identified by bar

/

grant dba to foo

/

exit;

 

db-MYDB.rsp

 

 

####################################################################

## Copyright(c) Oracle Corporation 1998, 2013. All rights reserved.##

##                                                                ##

## Specify values for the variables listed below to customize     ##

## your installation.                                             ##

##                                                                ##

## Each variable is associated with a comment. The comment        ##

## can help to populate the variables with the appropriate        ##

## values.                                                        ##

##                                                                ##

## IMPORTANT NOTE: This file contains plain text passwords and    ##

## should be secured to have read permission only by oracle user  ##

## or db administrator who owns this installation.                ##

##                                                                ##

####################################################################

 

#-------------------------------------------------------------------------------

# Do not change the following system generated value.

#-------------------------------------------------------------------------------

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

 

#-------------------------------------------------------------------------------

# Specify the installation option.

# It can be one of the following:

#   - INSTALL_DB_SWONLY

#   - INSTALL_DB_AND_CONFIG

#   - UPGRADE_DB

#-------------------------------------------------------------------------------

oracle.install.option=INSTALL_DB_AND_CONFIG

 

#-------------------------------------------------------------------------------

# 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=nms-l-lior

 

#-------------------------------------------------------------------------------

# 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=/opt/oracle/oraInventory

#-------------------------------------------------------------------------------

# Specify the languages in which the components will be installed.            

#

# en   : English                  ja   : Japanese                 

# fr   : French                   ko   : Korean                    

# ar   : Arabic                   es   : Latin American Spanish   

# bn   : Bengali                  lv   : Latvian                  

# pt_BR: Brazilian Portuguese     lt   : Lithuanian               

# bg   : Bulgarian                ms   : Malay                    

# fr_CA: Canadian French          es_MX: Mexican Spanish          

# ca   : Catalan                  no   : Norwegian                

# hr   : Croatian                 pl   : Polish                   

# cs   : Czech                    pt   : Portuguese               

# da   : Danish                   ro   : Romanian                 

# nl   : Dutch                    ru   : Russian                  

# ar_EG: Egyptian                 zh_CN: Simplified Chinese       

# en_GB: English (Great Britain)  sk   : Slovak                   

# et   : Estonian                 sl   : Slovenian                

# fi   : Finnish                  es_ES: Spanish                  

# de   : German                   sv   : Swedish                   

# el   : Greek                    th   : Thai                     

# iw   : Hebrew                   zh_TW: Traditional Chinese      

# hu   : Hungarian                tr   : Turkish                  

# is   : Icelandic                uk   : Ukrainian                

# in   : Indonesian               vi   : Vietnamese               

# it   : Italian                                                  

#

# all_langs   : All languages

#

# Specify value as the following to select any of the languages.

# Example : SELECTED_LANGUAGES=en,fr,ja

#

# Specify value as the following to select all the languages.

# Example : SELECTED_LANGUAGES=all_langs 

#-------------------------------------------------------------------------------

SELECTED_LANGUAGES=en

 

#-------------------------------------------------------------------------------

# Specify the complete path of the Oracle Home.

#-------------------------------------------------------------------------------

ORACLE_HOME=/opt/oracle/ora11

 

#-------------------------------------------------------------------------------

# Specify the complete path of the Oracle Base.

#-------------------------------------------------------------------------------

ORACLE_BASE=/opt/oracle

 

#-------------------------------------------------------------------------------

# Specify the installation edition of the component.                    

#                                                            

# The value should contain only one of these choices.       

#   - EE     : Enterprise Edition                               

#   - SE     : Standard Edition                                 

#   - SEONE  : Standard Edition One

#   - PE     : Personal Edition (WINDOWS ONLY)

#-------------------------------------------------------------------------------

oracle.install.db.InstallEdition=SE

 

#-------------------------------------------------------------------------------

# This variable is used to enable or disable custom install and is considered

# only if InstallEdition is EE.

#

#   - true  : Components mentioned as part of 'optionalComponents' property

#             are considered for install.

#   - false : Value for 'optionalComponents' is not considered.

#-------------------------------------------------------------------------------

oracle.install.db.EEOptionsSelection=false

 

#-------------------------------------------------------------------------------

# This property is considered only if 'EEOptionsSelection' is set to true

#

# Description: List of Enterprise Edition Options you would like to enable.

#

#              The following choices are available. You may specify any

#              combination of these choices.  The components you choose should

#              be specified in the form "internal-component-name:version"

#              Below is a list of components you may specify to enable.

#       

#              oracle.oraolap:11.2.0.4.0 - Oracle OLAP

#              oracle.rdbms.dm:11.2.0.4.0 - Oracle Data Mining RDBMS Files

#              oracle.rdbms.dv:11.2.0.4.0- Oracle Database Vault option

#              oracle.rdbms.lbac:11.2.0.4.0 - Oracle Label Security

#              oracle.rdbms.partitioning:11.2.0.4.0 - Oracle Partitioning

#              oracle.rdbms.rat:11.2.0.4.0 - Oracle Real Application Testing

#-------------------------------------------------------------------------------

oracle.install.db.optionalComponents=

 

###############################################################################

#                                                                             #

# PRIVILEGED OPERATING SYSTEM GROUPS                                          #

# ------------------------------------------                                  #

# Provide values for the OS groups to which OSDBA and OSOPER privileges       #

# needs to be granted. If the install is being performed as a member of the   #

# group "dba", then that will be used unless specified otherwise below.       #

#                                                                             #

# The value to be specified for OSDBA and OSOPER group is only for UNIX based #

# Operating System.                                                           #

#                                                                             #

###############################################################################

 

#------------------------------------------------------------------------------

# The DBA_GROUP is the OS group which is to be granted OSDBA privileges.

#-------------------------------------------------------------------------------

oracle.install.db.DBA_GROUP=dba

 

#------------------------------------------------------------------------------

# The OPER_GROUP is the OS group which is to be granted OSOPER privileges.

# The value to be specified for OSOPER group is optional.

#------------------------------------------------------------------------------

oracle.install.db.OPER_GROUP=dba

 

#-------------------------------------------------------------------------------

# Specify the cluster node names selected during the installation.                                     

# Example : oracle.install.db.CLUSTER_NODES=node1,node2

#-------------------------------------------------------------------------------

oracle.install.db.CLUSTER_NODES=

 

#------------------------------------------------------------------------------

# This variable is used to enable or disable RAC One Node install.

#

#   - true  : Value of RAC One Node service name is used.

#   - false : Value of RAC One Node service name is not used.

#

# If left blank, it will be assumed to be false.

#------------------------------------------------------------------------------

oracle.install.db.isRACOneInstall=false

 

#------------------------------------------------------------------------------

# Specify the name for RAC One Node Service.

#------------------------------------------------------------------------------

oracle.install.db.racOneServiceName=

 

#-------------------------------------------------------------------------------

# Specify the type of database to create.

# It can be one of the following:

#   - GENERAL_PURPOSE/TRANSACTION_PROCESSING                      

#   - DATA_WAREHOUSE                               

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.type=GENERAL_PURPOSE

 

#-------------------------------------------------------------------------------

# Specify the Starter Database Global Database Name.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.globalDBName=MYDB

 

#-------------------------------------------------------------------------------

# Specify the Starter Database SID.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.SID=MYDB

 

#-------------------------------------------------------------------------------

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

 

#------------------------------------------------------------------------------

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

 

#-------------------------------------------------------------------------------

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

 

#-------------------------------------------------------------------------------

# This variable controls whether to load Example Schemas onto

# the starter database or not.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.installExampleSchemas=false

 

#-------------------------------------------------------------------------------

# This variable includes enabling audit settings, configuring password profiles

# and revoking some grants to public. These settings are provided by default.

# These settings may also be disabled.     

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.enableSecuritySettings=false

 

###############################################################################

#                                                                             #

# Passwords can be supplied for the following four schemas in the                #

# starter database:                                                                                                #

#   SYS                                                                       #

#   SYSTEM                                                                    #

#   SYSMAN (used by Enterprise Manager)                                       #

#   DBSNMP (used by Enterprise Manager)                                       #

#                                                                             #

# Same password can be used for all accounts (not recommended)                               #

# or different passwords for each account can be provided (recommended)       #

#                                                                             #

###############################################################################

 

#------------------------------------------------------------------------------

# This variable holds the password that is to be used for all schemas in the

# starter database.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.password.ALL=oracle

 

#-------------------------------------------------------------------------------

# Specify the SYS password for the starter database.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.password.SYS=

 

#-------------------------------------------------------------------------------

# Specify the SYSTEM password for the starter database.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.password.SYSTEM=

 

#-------------------------------------------------------------------------------

# Specify the SYSMAN password for the starter database.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.password.SYSMAN=

 

#-------------------------------------------------------------------------------

# Specify the DBSNMP password for the starter database.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.password.DBSNMP=

 

#-------------------------------------------------------------------------------

# Specify the management option to be selected for the starter database.

# It can be one of the following:

#   - GRID_CONTROL

#   - DB_CONTROL

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.control=DB_CONTROL

 

#-------------------------------------------------------------------------------

# Specify the Management Service to use if Grid Control is selected to manage

# the database.     

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=

 

###############################################################################

#                                                                             #

# SPECIFY BACKUP AND RECOVERY OPTIONS                                            #

# ------------------------------------                                                              #

# Out-of-box backup and recovery options for the database can be mentioned    #

# using the entries below.                                                                                                 #      

#                                                                             #

###############################################################################

 

#------------------------------------------------------------------------------

# This variable is to be set to false if automated backup is not required. Else

# this can be set to true.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.automatedBackup.enable=false

 

#------------------------------------------------------------------------------

# Regardless of the type of storage that is chosen for backup and recovery, if

# automated backups are enabled, a job will be scheduled to run daily to backup

# the database. This job will run as the operating system user that is

# specified in this variable.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.automatedBackup.osuid=

 

#-------------------------------------------------------------------------------

# Regardless of the type of storage that is chosen for backup and recovery, if

# automated backups are enabled, a job will be scheduled to run daily to backup

# the database. This job will run as the operating system user specified by the

# above entry. The following entry stores the password for the above operating

# system user.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.automatedBackup.ospwd=

 

#-------------------------------------------------------------------------------

# Specify the type of storage to use for the database.

# It can be one of the following:

#   - FILE_SYSTEM_STORAGE

#   - ASM_STORAGE

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE

 

#-------------------------------------------------------------------------------

# 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=/opt/oracle/data

 

#-------------------------------------------------------------------------------

# Specify the backup and recovery location.

#

# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=

 

#-------------------------------------------------------------------------------

# Specify the existing ASM disk groups to be used for storage.

#

# Applicable only when oracle.install.db.config.starterdb.storageType=ASM_STORAGE

#-------------------------------------------------------------------------------

oracle.install.db.config.asm.diskGroup=

 

#-------------------------------------------------------------------------------

# Specify the password for ASMSNMP user of the ASM instance.                

#

# Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE

#-------------------------------------------------------------------------------

oracle.install.db.config.asm.ASMSNMPPassword=

 

#------------------------------------------------------------------------------

# Specify the My Oracle Support Account Username.

#

#  Example   : MYORACLESUPPORT_USERNAME=abc@oracle.com

#------------------------------------------------------------------------------

MYORACLESUPPORT_USERNAME=

 

#------------------------------------------------------------------------------

# Specify the My Oracle Support Account Username password.

#

# Example    : MYORACLESUPPORT_PASSWORD=password

#------------------------------------------------------------------------------

MYORACLESUPPORT_PASSWORD=

 

#------------------------------------------------------------------------------

# Specify whether to enable the user to set the password for

# My Oracle Support credentials. The value can be either true or false.

# If left blank it will be assumed to be false.

#

# Example    : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true

#------------------------------------------------------------------------------

SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

 

#------------------------------------------------------------------------------

# Specify whether user doesn't want to configure Security Updates.

# The value for this variable should be true if you don't want to configure

# Security Updates, false otherwise.

#

# The value can be either true or false. If left blank it will be assumed

# to be false.

#

# Example    : DECLINE_SECURITY_UPDATES=false

#------------------------------------------------------------------------------

DECLINE_SECURITY_UPDATES=true

 

#------------------------------------------------------------------------------

# Specify the Proxy server name. Length should be greater than zero.

#

# Example    : PROXY_HOST=proxy.domain.com

#------------------------------------------------------------------------------

PROXY_HOST=

 

#------------------------------------------------------------------------------

# Specify the proxy port number. Should be Numeric and at least 2 chars.

#

# Example    : PROXY_PORT=25

#------------------------------------------------------------------------------

PROXY_PORT=

 

#------------------------------------------------------------------------------

# Specify the proxy user name. Leave PROXY_USER and PROXY_PWD

# blank if your proxy server requires no authentication.

#

# Example    : PROXY_USER=username

#------------------------------------------------------------------------------

PROXY_USER=

 

#------------------------------------------------------------------------------

# Specify the proxy password. Leave PROXY_USER and PROXY_PWD 

# blank if your proxy server requires no authentication.

#

# Example    : PROXY_PWD=password

#------------------------------------------------------------------------------

PROXY_PWD=

 

#------------------------------------------------------------------------------

# Specify the proxy realm.

#

# Example    : PROXY_REALM=metalink

#------------------------------------------------------------------------------

PROXY_REALM=

#------------------------------------------------------------------------------

# Specify the Oracle Support Hub URL.

#

# Example    : COLLECTOR_SUPPORTHUB_URL=https://orasupporthub.company.com:8080/

#------------------------------------------------------------------------------

COLLECTOR_SUPPORTHUB_URL=

 

#------------------------------------------------------------------------------

# Specify the auto-updates option. It can be one of the following:

#   - MYORACLESUPPORT_DOWNLOAD

#   - OFFLINE_UPDATES

#   - SKIP_UPDATES

#------------------------------------------------------------------------------

oracle.installer.autoupdates.option=SKIP_UPDATES

#------------------------------------------------------------------------------

# In case MYORACLESUPPORT_DOWNLOAD option is chosen, specify the location where

# the updates are to be downloaded.

# In case OFFLINE_UPDATES option is chosen, specify the location where the updates

# are present.

#------------------------------------------------------------------------------

oracle.installer.autoupdates.downloadUpdatesLoc=

#------------------------------------------------------------------------------

# Specify the My Oracle Support Account Username which has the patches download privileges 

# to be used for software updates.

#  Example   : AUTOUPDATES_MYORACLESUPPORT_USERNAME=abc@oracle.com

#------------------------------------------------------------------------------

AUTOUPDATES_MYORACLESUPPORT_USERNAME=

 

#------------------------------------------------------------------------------

# Specify the My Oracle Support Account Username password which has the patches download privileges 

# to be used for software updates.

#

# Example    : AUTOUPDATES_MYORACLESUPPORT_PASSWORD=password

#------------------------------------------------------------------------------

AUTOUPDATES_MYORACLESUPPORT_PASSWORD=

 

 

Views: 13441

Comment

You need to be a member of Oracle Community to add comments!

Join Oracle Community

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Do What You Do Best and Outsource the Rest

One of the most valuable assets of an organization, data lies at the heart of business. It impacts everything from customer service to email deliverability and ultimately revenue generation. If the data that you have is not accurate, it will have a direct impact on your company’s ability to meet…

Continue

Posted by Alvaro Dee on February 7, 2017 at 2:07am

Draw Actionable Insights and Make Better Decisions with Data Mining Services

Data Mining is the process of analyzing and extracting crucial information from a database and presenting the same in an appropriate way to help business cut cost and boost revenue. In simple words it is the process of drawing crucial and actionable insights, which is imperative for better decision making.

Data mining is crucial for effective management of your business. It is also used for verifying whether or not the strategies are going as planned so as to provide desired results.…

Continue

Posted by Alvaro Dee on February 1, 2017 at 4:02am

Attain Data Accuracy, Competitive Pricing, and Quick Turnaround Time by Outsourcing Data Entry Services

In order to focus on crucial business activities, organizations worldwide prefer outsourcing data entry services to reliable service providers. Though redundant but highly crucial, data entry still remains an important component of document management and requires vigorous quality checks. Outsourcing data entry tasks to experts ensures affordable and quality output while saving time and resources that can be…

Continue

Posted by Alvaro Dee on January 31, 2017 at 4:49am

Present and Exchange Documents Reliably With Portable Document Format

Are you having data in large volumes that needs to be converted from hard copy to PDF format? Can you imagine how much time it would take you to manually convert this data? Well, if you know, then what’s the point of putting in lot of efforts and time?

With the help of PDF data entry services, this task can be made a lot easier. Data entry experts can help you save time and efforts…

Continue

Posted by Alvaro Dee on January 25, 2017 at 3:38am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service