Scribd
Upload
195 views7 pages

Oracle 19C Client Installation

The document provides a step-by-step guide for reinstalling Oracle Database Client 19c, including prerequisites, environment variable setup, and installation instructions. It details commands for removing old installations, creating necessary directories, and configuring network files like tnsnames.ora and sqlnet.ora. Additionally, it addresses common errors related to permissions and inventory paths during the installation process.

Uploaded by

aliraza
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
195 views7 pages

Oracle 19C Client Installation

The document provides a step-by-step guide for reinstalling Oracle Database Client 19c, including prerequisites, environment variable setup, and installation instructions. It details commands for removing old installations, creating necessary directories, and configuring network files like tnsnames.ora and sqlnet.ora. Additionally, it addresses common errors related to permissions and inventory paths during the installation process.

Uploaded by

aliraza
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

If reinstalling then delete Old home

dbshut $ORACLE_HOME
# cd $ORACLE_HOME
# rm -Rf *
# cd $ORACLE_BASE
# rm -Rf admin doc jre o*
# rm /etc/oratab /etc/emtab
# rm -Rf /u01/app/oraInventory /etc/orainst.loc

Pre-requisite

All OS related packages should be installed.

yum install -y oracle-database-preinstall-19c -- Packages installation for 19C

.bash_profile

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_HOME=/data01/app/oracle/product/19.0.0/client_1

export PATH=/usr/sbin:/usr/local/bin:$PATH

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

export PATH=$ORACLE_HOME/OPatch:$PATH

mkdir -p /data1/app/oracle/product/19.0.0/client_1

Unzip media at any directory

unzip LINUX.X64_193000_client.zip -d /home/oracle/app/oracle

cd /data01/app/oracle/client
Click on NEXT
Giving OS Check error Ignore it

Click on YES
Change path according to available directories.
Admin us group in other case it may be oinstall
After installation it will ask you for scripts execution from ROOT user, just run that scripts.

Create tnsnames.ora file at client Network Path:

/data01/app/oracle/product/19.0.0/client_1/network/admin

ADD below entry and IP,Port, Service_Name accordingly.

DATAMART=

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.93.67)(PORT = 1555))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = DATAMART )

)
# sqlnet.ora Network Configuration File:

Add below petameters in sqlnet.ora for transit encryption

/data01/app/oracle/product/19.0.0/client_1/network/admin/sqlnet.ora

# Generated by Oracle configuration tools.

SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT= (SHA512)

SQLNET.ENCRYPTION_CLIENT = required

SQLNET.CRYPTO_SEED = '123456789'

SQLNET.ENCRYPTION_TYPES_CLIENT= (AES256)

SQLNET.CRYPTO_CHECKSUM_CLIENT = required

ADR_BASE = /home/oracle/app/oracle

Verify Client

source .bash_profile

sqlplus sys@swdb as sysdba

Pakistan_12345$$

Error of old path when reinstalling

You do not have sufficient permissions to access the inventory '/data01/app/oraInventory'. Installation
cannot continue. It is required that the primary group of the install user is same as the inventory owner
group. Make sure that the install user is part of the inventory owner group and restart the installer.

Solution:

rename /etc/oratab

rename /etc/oracle

mv /etc/oraInst.loc /etc/oraInst.loc_old

rename Inventory directory

cat /etc/oraInst.loc

inventory_loc=/home/oracle/app/oraInventory

inst_group=oinstall

You might also like