oracle中环境变量设置,Oracle 环境变量设置标准

g2bs1010:ylbatmp > ps -ef|grep pmon

otscode 23535     1   0 15:29:46 ?           1:50 ora_pmon_ylscode

otpadm 23090     1   0 15:29:41 ?           0:30 ora_pmon_ylpadm

otsmms 24379     1   0 15:30:13 ?           1:56 ora_pmon_ylsmms

otbinv 24036     1   0 15:30:05 ?           1:37 ora_pmon_ylbinv

otcif2 22908     1   0 15:29:38 ?           2:32 ora_pmon_ylcif2

otbatmp 23241     1   0 15:29:43 ?           2:08 ora_pmon_ylbatmp

otbfxms 25146     1   0 15:30:22 ?           1:48 ora_pmon_ylbfxms

otbos 26635     1   0 15:30:28 ?           1:47 ora_pmon_ylbos

g2bs1010:ylbatmp > su - otscode

Password:

Authorized uses only. All activity may be monitored and reported.

mesg: cannot change mode

g2bs1010:10g:sylscode > ls -al

drwxr-xr-x   2 otscode  dba           96 Oct  3 17:10 .cronjob

-rw-r--r--   1 otscode  dba         1065 Oct  1 11:11 .profile

drwx------   2 otscode  dba           96 Jun  7 12:37 .ssh

-rwx------   1 otscode  dba         1066 Jun 11 14:16 prof_bsscode1

-rw-r--r--   1 otscode  dba         1081 Oct  1 13:49 prof_ylscode

-rwx------   1 otscode  dba         1063 Jun  7 13:56 profile

drwxrwx---   3 otscode  dba           96 Oct 23 09:45 tmp

g2bs1010:10g:sylscode > more prof_ylscode

#       This is the default standard profile provided to a user.

#       They are expected to edit it to meet their own needs.

MAIL=/usr/mail/${LOGNAME:?}

stty erase "^H"

umask 022

ORACLE_SID=ylscode

ORACLE_BASE=/paic/bank/scode/data/app/oracle

ORACLE_HOME=$ORACLE_BASE/product/10.2.0

NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

ORA_NLS10=$ORACLE_HOME/nls/data

LD_LIBRARY_PATH=$ORACLE_HOME/lib

PATH=$ORACLE_HOME/bin:/usr/sbin:/usr/local/bin:/usr/ccs/bin:$PATH

NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"

export PS1 ORACLE_SID ORACLE_BASE ORACLE_HOME NLS_LANG ORA_NLS10 LD_LIBRARY_PATH NLS_DATE_FORMAT

export PATH

PS1="`hostname`:10g:s$ORACLE_SID > "

TERM=vt100;export TERM

#SHELL_PATH=/etc/paic/shell; export SHELL_PATH

P_MON_USER=ovsee   ; export P_MON_USER

P_MON_PWD=ovsee03  ; export P_MON_PWD

P_TNS_NAME=scode ; export P_TNS_NAME

HOME=/paic/bank/scode/data/otscode

GGS_HOME=/paic/bank/ylgg/goldengate/scode/goldengate

export GGS_HOME

LD_LIBRARY_PATH=$GGS_HOME:$LD_LIBRARY_PATH

export LD_LIBRARY_PATH

PATH=$GGS_HOME:$PATH

export PATH

TEMP=$HOME/tmp

export TEMP

EDITOR=vi

export EDITOR

g2bs1010:10g:sylscode > id

uid=13962(otscode) gid=102(dba)