Friday, August 6, 2021

ORACLE 19c Software installation using response file -Silent mode


 

Oracle 19c Software installation using Silent mode

 

Step 1.  Add host entry on host file using cat/etc/hosts to edit file using vi connect as root user.

[root@sample ~]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.137.137 sample.localdomain sample

[root@sample ~]#


Step 2Install the "oracle-database-preinstall-19c" package to perform all the prerequisite setup

# yum install -y oracle-database-preinstall-19c

Also install following packages also in the database

yum install -y bc -*  

yum install -y binutils-*

yum install -y compat-libcap1-*

yum install -y compat-libstdc++-33-*

yum install -y dtrace-utils-*

yum install -y elfutils-libelf-*

yum install -y elfutils-libelf-devel-*

yum install -y fontconfig-devel-*

yum install -y glibc-*

yum install -y glibc-devel-*

yum install -y ksh-*

yum install -y libaio-*

yum install -y libaio-devel-*

yum install -y libdtrace-ctf-devel-*

yum install -y libXrender-*

yum install -y libXrender-devel-*

yum install -y libX11-*

yum install -y libXau-*

yum install -y libXi-*

yum install -y libXtst-*

yum install -y libgcc-*

yum install -y librdmacm-devel-*

yum install -y libstdc++-*

yum install -y libstdc++-devel-*

yum install -y libxcb-*

yum install -y make-*

yum install -y net-tools # Clusterware-*

yum install -y nfs-utils-* # ACFS

yum install -y python-* # ACFS

yum install -y python-configshell-* # ACFS

yum install -y python-rtslib-* # ACFS

yum install -y python-six-* # ACFS

yum install -y targetcli-* # ACFS

yum install -y smartmontools-*

yum install -y sysstat-*

yum install -y unixODBC-*

Step 3. Create the new groups and users if it doesn’t exist. 

groupadd -g 54321 oinstall

groupadd -g 54322 dba

Create oracle user:-

useradd -u 54321 -g oinstall -G dba oracle

 

Step 4.  Disable selinux. Set it as disabled in the following file and restart the server to make it effective.

 vi /etc/sysconfig/selinux

 SELINUX=disabled

Disable firewall

 #systemctl stop firewalld

#systemctl disable firewalld

Step 5. Create the directories in which the Oracle software will be installed. 

mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1\

chown -R oracle:oinstall /u01

chmod -R 775 /u01

Step 6.  Modify bash_profile of oracle user.

vi .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

        . ~/.bashrc

fi

 

# User specific environment and startup programs

 

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export ORACLE_BASE=/u01/app/oracle

export ORACLE_SID=sampledb

export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1

export INVENTORY_LOCATION=/u01/app/oraInventory

export ORA_INVENTORY=/u01/app/oraInventory


Step 7. Unzip software.

[oracle@sample ~]$ cd $ORACLE_HOME

 [oracle@sample dbhome_1]$ unzip V982063-01.zip

Step 8. create the response file

[oracle@sample ]$ cd $ORACLE_HOME/install/response

[oracle@sample response]$ vi db_install.rsp

oracle.install.option=INSTALL_DB_SWONLY

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION= /u01/app/oraInventory

ORACLE_HOME= /u01/app/oracle/product/19.0.0/dbhome_1

ORACLE_BASE=/u01/app/oracle

oracle.install.db.InstallEdition=EE

oracle.install.db.OSDBA_GROUP=oracle

oracle.install.db.OSOPER_GROUP=oracle

oracle.install.db.OSBACKUPDBA_GROUP=oracle

oracle.install.db.OSDGDBA_GROUP=oracle

oracle.install.db.OSKMDBA_GROUP=oracle

Step 9. run the response file

 

 [oracle@sample ~]$ cd $ORACLE_HOME

[oracle@sample dbhome_1]$ ./runInstaller -silent -responseFile /u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_install.rsp

Launching Oracle Database Setup Wizard...

The response file for this session can be found at:

 /u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_2021-08-01_11-39-06PM.rsp

You can find the log of this install session at:

 /tmp/InstallActions2021-08-01_11-39-06PM/installActions2021-08-01_11-39-06PM.log

As a root user, execute the following script(s):

            1. /u01/app/oraInventory/orainstRoot.sh

            2. /u01/app/oracle/product/19.0.0/dbhome_1/root.sh

Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes:

[sample]

Execute /u01/app/oracle/product/19.0.0/dbhome_1/root.sh on the following nodes:

[sample]

 


 

Execute root.sh script

Login as root user to execute the following script

-------------------------------------------

 [root@sample ~]# cd /u01/app/oracle/product/19.0.0/dbhome_1/

[root@sample dbhome_1]#  /u01/app/oracle/product/19.0.0/dbhome_1/root.sh

Check /u01/app/oracle/product/19.0.0/dbhome_1/install/root_sample.localdomain_2021-08-01_23-41-26-537455081.log for the output of root script

[root@sample dbhome_1]# cd /u01/app/oracle/product/19.0.0/dbhome_1/install/

 

 [root@sample install]# cd root_sample.localdomain_2021-08-01_23-41-26-537455081.log

[root@sample install]# cat root_sample.localdomain_2021-08-01_23-41-26-537455081.log

Performing root user operation.

 

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u01/app/oracle/product/19.0.0/dbhome_1

   Copying dbhome to /usr/local/bin ...

   Copying oraenv to /usr/local/bin ...

   Copying coraenv to /usr/local/bin ...

 

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Oracle Trace File Analyzer (TFA) is available at : /u01/app/oracle/product/19.0.0/dbhome_1/bin/tfactl

[root@sample install]# sudo su - oracle

Last login: Sun Aug  1 23:24:27 IST 2021 on pts/0

[oracle@sample ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1

[oracle@sample ~]$ export PATH=/u01/app/oracle/product/19.0.0/dbhome_1/bin:$PATH;

[oracle@sample ~]$ cd $ORACLE_HOME

[oracle@sampledbhome_1]$exportORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1

[oracle@sampledbhome_1]$exportPATH=/u01/app/oracle/product/19.0.0/dbhome_1/bin:$PATH;

[oracle@sample dbhome_1]$ which sqlplus

/u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus

[oracle@sample ~]$ . .bash_profile

[oracle@sample ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Aug 2 23:26:58 2021

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL> select name from v$database;

NAME

---------

SAMPLEDB

 

No comments:

Post a Comment

Auto Shutdown and Restart of Oracle DB Systems in OCI Using Functions

  🔹 Introduction Oracle Cloud Infrastructure (OCI) Database Systems incur compute costs even when idle. If you're running non-producti...