About DATABASE

(아래 설정은 최소값임으로 더 높게 설정되어 있다면 수정할 필요가 없습니다.)

- OS
  o RHEL AS/ES 3.0 (Update 4 or later) 2.4.21-27.EL or higher
  o RHEL AS/ES 4.0 2.6.9-5.0.5.EL or higher
  o RHEL AS/ES 5.0 or higher
  o SuSE SLES9 2.6.5-7.201 or higher

- OS Kernel
 
  SuSE SLES9:
    SEMMSL 250
    SEMMNS 32000
    SEMMNI 128
    SEMOPM 100
    SHMMAX RAM times 0.5
    SHMMNI 4096
    SHMALL = SHMMAX/pagesize (Note 301830.1)
    FILE-MAX 65536
    IP_LOCAL_PORT_RANGE 1024 65000
    RMEM_DEFAULT 1048576
    RMEM_MAX 1048576
    WMEM_DEFAULT 262144
    WMEM_MAX 262144
 
  Other Linux OS:
    SEMMSL 250
    SEMMNS 32000
    SEMMNI 128
    SEMOPM 100
    SHMMAX RAM times 0.5
    SHMMNI 4096
    SHMALL = SHMMAX/pagesize (Note 301830.1)
    FILE-MAX 65536
    IP_LOCAL_PORT_RANGE 1024 65000
    RMEM_DEFAULT 262144
    RMEM_MAX 262144
    WMEM_DEFAULT 262144
    WMEM_MAX 262144


  RHEL 5  or OEL5(oracle enterprise linux5)
   kernel.shmmni = 4096
   kernel.sem = 250 32000 100 128
   fs.file-max = 65536
   net.ipv4.ip_local_port_range = 1024 65000
   net.core.rmem_default = 1048576
   net.core.rmem_max = 1048576
   net.core.wmem_default = 262144
  net.core.wmem_max = 262144


- OS Patch List
 
  RHEL3:
    gcc-3.2.3-34
    glibc-2.3.2-95.20
    make-3.79.1
    openmotif21-2.1.30-8
    compat-db-4.0.14.5
    compat-gcc-7.3-2.96.128
    compat-gcc-c++-7.3-2.96.128
    compat-libstdc++-7.3-2.96.128
    compat-libstdc++=devel-7.3-2.96.128
    setarch-1.3-1
    XFree86 (Spatial only)
    XFree86-devel (Spatial only)
 
  RHEL4:
 
    binutils-2.15.92.0.2-10.EL4
    compat-db-4.1.25-9
    compat-libstdc++-296-2.96-132.7.2
    compat-libstdc++-33-3.2.3-47.3
    control-center-2.8.0-12
    gcc-3.4.3-9.EL4
    gcc-c++-3.4.3-9.EL4
    glibc-2.3.4-2
    glibc-common-2.3.4-2
    gnome-libs-1.4.1.2.90-44.1
    libstdc++-3.4.3-9.EL4
    libstdc++-devel-3.4.3-9.EL4
    make-3.80-5
    pdksh-5.2.14-30
    sysstat-5.0.5-1
    xscreensaver-4.18-5.rhel4.2
    openmotif21-2.1.30-11.RHEL4.2 (required to install Oracle demos)
    libaio-0.3.96
 
  RHEL 5(X86)
     gcc-c++-4.1.1-52.el5.i386.rpm 
     gcc-4.1.1-52.el5.i386.rpm
     libstdc++-devel-4.1.1-52.el5.i386.rpm
     glibc-devel-2.5-12.i386.rpm
     glibc-headers-2.5-12.i386.rpm
     libgomp-4.1.1-52.el5.i386.rpm
     libXp-1.0.0-8.i386.rpm
     compat-libstdc++-33-3.2.3-61.i386.rpm
     compat-gcc-34-3.4.6-4.i386.rpm
     compat-gcc-34-c++-3.4.6-4.i386.rpm
     sysstat-7.0.0-3.el5.i386.rpm




  RHEL 5(X86_64):
   gcc-c++-4.1.1-52.el5.x86_64.rpm     
   libstdc++-devel-4.1.1-52.el5.x86_64.rpm
   glibc-headers-2.5-12.x86_64.rpm
   glibc-devel-2.5-12.x86_64.rpm
   libgomp-4.1.1-52.el5.x86_64.rpm
   gcc-4.1.1-52.el5.x86_64.rpm
   glibc-devel-2.5-12.i386.rpm
   compat-gcc-34-c++-3.4.6-4
   compat-libstdc++-33-3.2.3-61 (x86_64)
   compat-libstdc++-33-3.2.3-61(i386)
   libXp-1.0.0-8 (i386)
   sysstat-7.0.0-3.el5.x86_64.rpm


  OEL 5:
   gcc-c++-4.1.1-52.el5.i386.rpm
   libstdc++-devel-4.1.1-52.el5.i386.rpm
   gcc-4.1.1-52.el5.i386.rpm
   glibc-devel-2.5-12.i386.rpm
   glibc-headers-2.5-12.i386.rpm
   libgomp-4.1.1-52.el5.i386.rpm
   libXp-1.0.0-8.i386.rpm
   compat-db-4.2.52-5.1.i386.rpm
   compat-libstdc++-296-2.96-138.i386.rpm
   compat-libstdc++-33-3.2.3-61.i386.rpm
   sysstat-5.0.5-1.i386.rpm
 

  OEL 5(X86_64):
   gcc-c++-4.1.1-52.el5.x86_64.rpm
   libstdc++-devel-4.1.1-52.el5.x86_64.rpm
   glibc-headers-2.5-12.x86_64.rpm
   glibc-devel-2.5-12.i386.rpm
   glibc-devel-2.5-12.x86_64.rpm
   libgomp-4.1.1-52.el5.x86_64.rpm
   gcc-4.1.1-52.el5.x86_64.rpm
   compat-db-4.2.52-5.1.i386.rpm
   compat-db-4.2.52-5.1.x86_64.rpm
   compat-libstdc++-33-3.2.3-61.i386.rpm
   compat-libstdc++-33-3.2.3-61.x86_64.rpm
   libXp-1.0.0-8.i386.rpm
   sysstat-7.0.0-3.el5.x86_64.rpm





 SuSE SLES9:
 
    default-RPMs (see Note 386391.1)
    glibc-devel-2.3.3-98.47.i586.rpm
    gcc-3.3.3-43.34.i586.rpm.
    libstdc++-devel-3.3.3-43.34.i586.rpm
    gcc-c++-3.3.3-43.34.i586.rpm
    db1-1.85-85.1.i586.rpm
    orbit-0.5.17-330.1.i586.rpm
    gnome-libs-1.4.1.7-671.1.i586.rpm.
    plotutils-2.4.1-575.1.i586.rpm
    gnuplot-3.7.3-256.1.i586.rpm
    sysstat-5.0.1-35.4.i586.rpm.


- Set the session limits for Oracle user(RHEL5 or OEL5)

 Add the following lines to the /etc/security/limits.conf file

   oracle soft nproc 2047
   oracle hard nproc 16384
   oracle soft nofile 1024
   oracle hard nofile 65536
 
 
 Add the following line in the /etc/pam.d/login file

   session required pam_limits.so
 
 
 Add the following lines to the /etc/profile.
  Change this accordingly if the oracle user has a different shell

if [ $USER = "oracle" ]; then
  if [ $SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
  else
    ulimit -u 16384 -n 65536
  fi
fi



- JDK & JRE : JDK 1.4.2_08 is installed
             
             
- Disk Space : 1.2G Database
               1.5 to 3.5G Install
              
              

- RAM :  1GB

- Swap:  If RAM = 1024MB to 2048Mb then 1.5 times RAM
         elseif RAM > 2048MB and < 8192MB then match RAM
         else RAM > 8192MB then .75 times RAM
        
- TMP :  400 M
        
- oracle user (dba group) 생성
        
- unzip, cpio 여부               
          
- xhosts 설정여부 (oracle user로 xclock 명령어실행 가능)