About DATABASE

vi /etc/system


forceload:sys/shmsys  
forceload:sys/semsys
set shmsys:shminfo_shmmax=2147483648
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100 
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100 
set semsys:seminfo_semmsl=256 
set semsys:seminfo_semmns=500 
set semsys:seminfo_semopm=100 
set semsys:seminfo_semvmx=32767 

# groupadd -g 101 oinstall
# groupadd -g 102 dba    
# useradd -m -d /u0/oracle -g oinstall -G dba -u 103 -s /bin/bash oracle


.bash_profile

PS1='$PWD  $'
umask=022
export EDITOR=vi
export LANG=C
export ORACLE_BASE=/u0/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0/db_1
export ORACLE_SID=ring
export ORACLE_TERM=vt100
export PATH=$PATH:$ORACLE_HOME/bin:/bin:/usr/bin:/sbin:/usr/ccs/bin:/usr/ucb
#export SHLIB_PATH=$ORACLE_HOME/lib:/usr/lib:$ORACLE_HOME/network/lib (HP 용)     
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:$ORACLE_HOME/network/lib
#export LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/lib:/usr/ccs/lib (AIX 용)
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export TNS_ADMIN=$ORACLE_HOME/network/admin
export DISPLAY=220.76.205.26:0.0

패치셋 적용후
db생성시에  
만약 13% 쯤에 에러메시지와 코드가 뜬다면 무시해도 된다.
물론 내용이 ORA-29807  Specified Operator does not exist. 일때 말이다.

listener.ora
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME =/u0/oracle/product/9.2.0/db_1)



      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ring )(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )