Oracle 19 (19.3) Client Installation

Overview

What follows is the most common way to install the Oracle 19 client.

Prerequisites

1. Download install file to /tmp/LINUX.X64_193000_client.zip
2. Install Oracle PreinstallRpm
   This makes most of the required OS changes and also create an oracle accounts.

Prep Environment

 -- Set oracle User Password
 su -
 passwd oracle

 -- Init Dirs
 mkdir -p /u01/app/oracle
 mkdir /u01/sw
 mkdir /u01/oraInventory
 chown -R oracle:oinstall /u01/app
 chown -R oracle:oinstall /u01/sw
 chown -R oracle:oinstall /u01/oraInventory

 su - oracle

 mkdir /u01/sw/OraCl19c
 chmod -R 765 /u01

 cp /tmp/LINUX.X64_193000_client.zip /u01/sw/OraCl19c/
 cd /u01/sw/OraCl19c/
 unzip LINUX.X64_193000_client.zip

Configure Shell

 su - oracle
 vi .bashrc  🠊 Example Shell

 source .bashrc 
 printenv|grep ORA

Procedure

Run Installer

 Log Into GUI as "oracle" user.
 cd /u01/sw/OraCl19c/client
 ./runInstaller

Select Installation Type

 For DBA: (x) Administrator
 Developer: (x) Runtime
 Application: (x) Instance Client

Specify Installation Location

 Oracle base: /u01/app
 Software location: /u01/app/product/19.3.0.0.0/client_1

Create Inventory

 /u01/oraInventory

Perform Prerequisite Checks - Summary

 Select [Install] if everything looks OK.
 You will be prompted to run root scripts.

Post Install Tasks

 -- Configure tnsnames.ora
 cd /u01/app/product/19.3.0.0.0/client_1/network/admin
 vi tnsnames.ora 🠊 Example 

 -- Test
 tnsping MYDB1 10

 export ORACLE_SID=MYDB1
 sqlplus 'scott/tiger@MYDB1'

 export ORACLE_SID=MYDB2
 sqlplus 'sys/********@MYDB2 as sysdba'

APPENDIX

.bashrc

# .bashrc

# Source global definitions
if [ -f /etc/bashrc ]; then
   . /etc/bashrc
fi

# User specific aliases and functions
export ORACLE_SID=oradb
export ORACLE_BASE=/u01/app
export ORACLE_HOME=$ORACLE_BASE/product/19.3.0.0.0/client_1
export PATH=$ORACLE_HOME/bin:/usr/bin:/bin:/usr/local/bin:.local/bin:$HOME/bin
export TMP=/tmp
export TMPDIR=/tmp

# Aliases - Common
alias cl='crontab -l'
alias l9='ls -alt | head -9' 
alias l20='ls -alt | head -20'
alias l50='ls -alt | head -50'
alias tf='date;ls -l|wc -l'

# DBA Aliases
ORACLE_DB=oradb
alias cdbin='cd $ORACLE_HOME/bin;pwd'
alias cdtrace='cd $ORACLE_BASE/diag/rdbms/$ORACLE_DB\/$ORACLE_SID\/trace;pwd'
alias cdnet='cd $ORACLE_HOME/network/admin;pwd'

alias oslog='tail -f /var/log/messages'
alias sqp='rlwrap sqlplus sys/mypw@oradb as sysdba'
alias sqldev='cd $ORACLE_HOME/sqldeveloper/sqldeveloper/bin;./sqldeveloper &'
alias src='source $HOME/.bashrc'

tnsnames.ora

MYDB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.51)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = mydb1)
    )
  )

MYDB2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.52)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = mydb2)
    )
  )