Wednesday, November 6, 2024

Setup Production Oracle 19c Database Client


I've done quite a bit of work with the Oracle database clients lately and decided to write up the workflow that I use for my reference. I hope it is helpful to you as well.


Step 1: Go to eDelivery at https://edelivery.oracle.com/

Step 2: Login with your Oracle credentials

Step 3: Search on: "REL: Oracle Database Client 19.3.0.0.0" and click on Continue


Step 4: Select desired platform and click on Continue


Step 5: Read license terms, check agree checkbox to terms if you agree, and click continue


Step 6: Click on the V982065-01(V982065-01.zip) gold image to download

Step 7: Copy the image to target host


Step 8: Set the environment for the desired ORACLE_HOME

export ORACLE_BASE="/u01/app/oracle/19c"
export ORACLE_HOME="$ORACLE_BASE/client"


Step 9: Extract the software

mkdir -p $ORACLE_HOME
cd 
$ORACLE_HOME
unzip -qo /u01/bits/V982065-01.zip


Step 10: Configure the tnsnames.ora for the data databases that you want to connect to from this database client.  For example:

cat $ORACLE_HOME/network/admin/tnsnames.ora
HRDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hrdb.example.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = hrdb)
    )
  )

HRDB_SSL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCPS)(HOST = hrdb.example.com)(PORT = 2484))
    (SECURITY=(WALLET_LOCATION=/u01/app/oracle/tls))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = hrdb)
    )
  )

pdb1 =
  (DESCRIPTION=
    (ADDRESS=(PROTOCOL=TCP)(HOST=hrdb.example.com)(PORT=1521))
    (CONNECT_DATA=
      (SERVER = DEDICATED)
      (SERVICE_NAME=pdb1)
    )
  )

pdb1_ssl =
  (DESCRIPTION=
    (ADDRESS=(PROTOCOL=TCPS)(HOST=hrdb.example.com)(PORT=2484))
    (SECURITY=(WALLET_LOCATION=/u01/app/oracle/tls))
    (CONNECT_DATA=
      (SERVER=dedicated)
      (SERVICE_NAME=pdb1)
    )
  )





No comments: