Configuration

Configuration Network Configuration Create tnsnames.ora:

Copy

# $ORACLE_HOME/network/admin/tnsnames.ora
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = db_host)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

Environment Settings

bash

Copy

# Set NLS parameters
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"
# Set TNS_ADMIN
export TNS_ADMIN=$ORACLE_HOME/network/admin

Security Configuration

bash

# Configure Oracle Wallet
orapki wallet create -wallet /etc/oracle/wallet -pwd WalletPasswd123
orapki wallet add -wallet /etc/oracle/wallet -trusted_cert -cert /path/to/cert.pem