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)