Oracle environment variable commands and oracle environment variables

Oracle environment variable commands and oracle environment variables

Oracle environment variable commands

Enter the command: ll-all

Run vi. bash_profile.

#. Bash_profile

# Get thealiases and functions

If [-f ~ /. Bashrc]; then

.~ /. Bashrc

Fi

# Userspecific environment and startup programs

PATH = $ PATH: $ HOME/bin

ExportPATH

ExportORACLE_SID = orcl

ExportORACLE_HOME =/usr/lib/oracle/11.2/client64

ExportTMP =/tmp

ExportTMPDIR = $ TMP

ExportPATH = $ PATH: $ ORACLE_HOME/bin

ExportLANG = "en_US"

ExportTNS_ADMIN = $ ORACLE_HOME/network/admin; # Set tnsnames. ora connection

Complete variable parameters:

ORACLE_BASE =/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME = $ ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME

ORACLE_SID = ORCL; export ORACLE_SID

ORACLE_TERM = xterm; export ORACLE_TERM

TNS_ADMIN = $ ORACLE_HOME/network/admin; export TNS_ADMIN

PATH = $ ORACLE_HOME/bin: $ PATH; export PATH

NLS_LANG = AMERICAN_AMERICA.ZHS16GBK; export NLS_LANG

# ExportNLS_LANG = AMERICAN_AMERICA.AL32UTF8

LC_CTYPE = zh_CN.GBK; export LC_CTYPE

LC_ALL = zh_CN.UTF8; export LC_ALL

LANG = zh_CN.GBK; export LANG

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

CLASSPATH = $ ORACLE_HOME/jdk/jre: $ ORACLE_HOME/jlib: $ ORACLE_HOME/rdbms/jlib;

Export CLASSPATH