Silent install of Oracle 12c RDBMS

Details
Category: DBA

User Rating: 3 / 5

Star ActiveStar ActiveStar ActiveStar InactiveStar Inactive
 

Quick article to show how to install Oracle 12c RDBMS software in silent mode.

Before starting, you need :
- Oracle Linux 7 installed
    (Check how to Install Oracle Linux 7 on VirtualBox)
- Oracle Linux configured for Oracle
    (Check how to Configure Oracle Linux for Oracle Database 12c)
- Oracle Grid Infrastructure installed
    (Optional but recommended, check how to Install Oracle Grid Infrastructure)
- Oracle 12c rdbms installation files downloaded (Available on OTN)
- at least 8GB free disk space

Install Oracle 12c

Uncompress installation files

# Go to folder containing installation zip files first
[oracle]$ cd /mnt/nfs/ora_instfiles/Oracle12c/
# Then unzip
[oracle]$ unzip /mnt/nfs/ora_instfiles/Oracle12c/linuxx64_12201_database.zip

Manual silent install

# Create directories
[oracle]$ ORACLE_INVENTORY_LOC=/u01/app/oraInventory
[oracle]$ ORACLE_BASE=/u01/app/oracle
[oracle]$ ORACLE_HOME=$ORACLE_BASE/product/12.2.0/db1

[oracle]$ mkdir -p $ORACLE_INVENTORY_LOC
[oracle]$ mkdir -p $ORACLE_HOME

# Run silent installer
[oracle]$ cd /mnt/nfs/ora_instfiles/Oracle12c/database
[oracle]$ ./runInstaller -silent                \
  -responseFile $PWD/response/db_install.rsp    \
  SELECTED_LANGUAGES=en                         \
  UNIX_GROUP_NAME=oinstall                      \
  ORACLE_BASE=$ORACLE_BASE                      \
  ORACLE_HOME=$ORACLE_HOME                      \
  oracle.install.option=INSTALL_DB_SWONLY       \
  oracle.install.db.CLUSTER_NODES=oralab01      \
  oracle.install.db.InstallEdition=EE           \
  oracle.install.db.isCustomInstall=false       \
  oracle.install.db.OSDBA_GROUP=dba             \
  oracle.install.db.OSOPER_GROUP=oper           \
  oracle.install.db.OSBACKUPDBA_GROUP=backupdba \
  oracle.install.db.OSDGDBA_GROUP=dgdba         \
  oracle.install.db.OSKMDBA_GROUP=kmdba         \
  oracle.install.db.OSRACDBA_GROUP=racdba       \
  SECURITY_UPDATES_VIA_MYORACLESUPPORT=false    \
  DECLINE_SECURITY_UPDATES=true                 \
  -waitForCompletion

    Starting Oracle Universal Installer...

    Checking Temp space: must be greater than 500 MB.   Actual 9107 MB    Passed
    Checking swap space: must be greater than 150 MB.   Actual 9208 MB    Passed
    Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-10-07_01-04-23PM. Please wait ...You can find the log of this install session at:
     /u01/app/oraInventory/logs/installActions2017-10-07_01-04-23PM.log
    The installation of Oracle Database 12c was successful.
    Please check '/u01/app/oraInventory/logs/silentInstall2017-10-07_01-04-23PM.log' for more details.

    As a root user, execute the following script(s):
            1. /u01/app/oracle/product/12.2.0/db1/root.sh

    Execute /u01/app/oracle/product/12.2.0/db1/root.sh on the following nodes:
    [oralab01]


    Successfully Setup Software.

Then execute /u01/app/oracle/product/12.2.0/db1/root.sh as root as asked.
Oracle 12c is now installed.

Post Installation

Disable database options

If you don't have some additional licenses and you want to make sure you don't use it, You can disable/enable database option as follow :

[oracle]$ cd $ORACLE_HOME

# Disable Oracle Data Mining RDBMS
[oracle]$ chopt disable dm

    Writing to /u01/app/oracle/product/11.2.0/db_1/install/disable_dm.log...
    %s_unixOSDMakePath% -f /u01/app/oracle/product/12.2.0/db_1/rdbms/lib/ins_rdbms.mk dm_off
    %s_unixOSDMakePath% -f /u01/app/oracle/product/12.2.0/db_1/rdbms/lib/ins_rdbms.mk ioracle

# Disable Oracle OLAP
[oracle]$ chopt disable olap

    Writing to /u01/app/oracle/product/12.2.0/db_1/install/disable_olap.log...
    %s_unixOSDMakePath% -f /u01/app/oracle/product/12.2.0/db_1/rdbms/lib/ins_rdbms.mk olap_off
    %s_unixOSDMakePath% -f /u01/app/oracle/product/12.2.0/db_1/rdbms/lib/ins_rdbms.mk ioracle

# Disable Oracle Real Application Testing
[oracle]$ chopt disable rat

    Writing to /u01/app/oracle/product/12.2.0/db_1/install/disable_rat.log...
    %s_unixOSDMakePath% -f /u01/app/oracle/product/12.2.0/db_1/rdbms/lib/ins_rdbms.mk rat_off
    %s_unixOSDMakePath% -f /u01/app/oracle/product/12.2.0/db_1/rdbms/lib/ins_rdbms.mk ioracle

# Disable Oracle Partitioning
[oracle]$ chopt disable partitioning

    Writing to /u01/app/oracle/product/12.2.0/db_1/install/disable_partitioning.log...
    %s_unixOSDMakePath% -f /u01/app/oracle/product/12.2.0/db_1/rdbms/lib/ins_rdbms.mk part_off
    %s_unixOSDMakePath% -f /u01/app/oracle/product/12.2.0/db_1/rdbms/lib/ins_rdbms.mk ioracle

Sqlplus prompt

To set SQLPLUS prompt, add to $ORACLE_HOME/sqlplus/admin/glogin.sql or login.sql

set sqlprompt "_USER'@'_CONNECT_IDENTIFIER _PRIVILEGE> "
define _editor=vi

Deinstallation

# Oracle rdbms deinstallation
[oracle]$ cd $ORACLE_HOME/deinstall
[oracle]$ ./deinstall

What next

HTH,
Michel.

Reference
Oracle Database Quick Installation Guide for Linux x86-64 (docs.oracle.com)
Enabling and Disabling Database Options (docs.oracle.com)
Silent install of Oracle 11g RDBMS (uxora.com)

Enjoyed this article? Please like it or share it.

Add comment

Please connect with one of social login below (or fill up name and email)

     


Security code
Refresh