Æí¸®ÇÑ È£½ºÆà ¹Ì¼ÒIDC

   
 
 
 

      1Â÷ ³×ÀÓ¼­¹ö :
      ns1.misoidc.com
      101.79.73.101

      2Â÷ ³×ÀÓ¼­¹ö :
      ns2.misoidc.com
      101.79.73.105

      ¾îÁ¦ : 304 ,¿À´Ã : 352
      Àüü : 1,151,398


     

 

 
ÀÛ¼ºÀÏ : 10-07-06 17:31
CentOS 5.5 ±â¹Ý Oracle 10g ¼³Ä¡(2. ȯ°æ º¯¼ö ¼³Á¤)
 ±Û¾´ÀÌ : ½ÑÀ¥È£½ºÆÃ
Á¶È¸ : 31,449  

2. ȯ°æ º¯¼ö ¼³Á¤


 

¼³Ä¡ Áغñ ÀÛ¾÷

½º¿Ò¿µ¿ª 2GB ÀÌ»ó

/tmp ¿µ¿ª 1GB ÀÌ»ó

¼³Ä¡µð·ºÅ͸® 3GB ÀÌ»ó °ø°£ ÇÊ¿ä

 

¹æÈ­º® SELinux ´Â Disable

 

¾Æ·¡ »çÀÌÆ®¿¡¼­ ¿À¶óŬ ´Ù¿î·Îµå ÇÏ°í ´Ù¿î·Îµå Çϸ鼭 ÁغñÀÛ¾÷ ½ÇÇà
http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201linuxsoft.html

 

1. root·Î ·Î±×ÀÎÇÏ¿© °èÁ¤ »ý¼º

# groupadd oinstall
# groupadd dba
# useradd -g oinstall -G dba oracle
# passwd oracle

# mkdir -p /u01/app/oracle/product/10.2.0/db_1
# chown -R oracle.oinstall /u01

 

2. ½Ã½ºÅÛ ÆĶó¸ÞÅÍ Ãß°¡.

# vi /etc/sysctl.conf


¾Æ·¡ ³»¿ë Ãß°¡ / ±âÁ¸³»¿ë ÁÖ¼®
# oracle 10g setting
kernel.shmall = 2097152
kernel.shmmax = 2147483648

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 = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

 

# /sbin/sysctl -p
Ãâ·Â È®ÀÎ

 

# vi /etc/pam.d/login


¾Æ·¡ ³»¿ë Ãß°¡
# oracle 10g setting
session  required  /lib/security/pam_limits.so

 

# vi /etc/security/limits.conf


¾Æ·¡ ³»¿ë Ãß°¡
# oracle 10g setting
oracle     soft     nproc     2047
oracle     hard    nproc     16384
oracle     soft     nofile      1024
oracle     hard    nofile      65536

 

# vi /etc/profile


¾Æ·¡ ³»¿ë Ãß°¡
# oracle 10g setting
if [ $USER = "oracle" ]; then
 ulimit -u 16384 -n 65536
fi

       


3. ½Ã½ºÅÛ ÀçºÎÆà ÈÄ ·çÆ®°èÁ¤ ·Î±×ÀÎ

# shutdown -r now

 

# vi /etc/redhat-release
¾Æ·¡ ³»¿ë Ãß°¡ / ±âÁ¸³»¿ë »èÁ¦ ¶Ç´Â ÁÖ¼®
¼öÁ¤ Àü : CentOS release 5.3 (Final)
¼öÁ¤ ÈÄ : redhat-4

 

4. oracle »ç¿ëÀÚ·Î ·Î±×¿ÂÇÏ¿©, Oracle ȯ°æ º¯¼ö¸¦ ¼³Á¤

# su - oracle
$ cd ~
$ vi .bash_profile


¾Æ·¡ ³»¿ë Ãß°¡
# oracle 10g setting
TMP=/tmp; export TMP
TMPDIR=$TMP;
export TMPDIR
ORACLE_BASE=/u01/app/oracle;
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1;
export ORACLE_HOME
ORACLE_SID=orcl;
export ORACLE_SID
ORACLE_TERM=xterm;
export ORACLE_TERM
PATH=/usr/sbin:$PATH;
export PATH
PATH=$ORACLE_HOME/bin:$PATH;
export PATH
export LANG=C

 

Ãß°¡ÈÄ ÀúÀåÇÏ°í ¾Æ·¡ ½ÇÇà

$ source .bash_profile

 

5. Çʼö ÆÐÅ°Áö ¼³Ä¡

# yum install binutils
# yum install compat-libgcc-296
# yum install compat-libstdc++-296
# yum install compat-libstdc++-33
# yum install cpp
# yum install gcc
# yum install gcc-c++
# yum install glibc
# yum install glibc-common
# yum install glibc-devel
# yum install glibc-headers
# yum install ksh
# yum install libaio
# yum install libaio-devel
# yum install libgcc
# yum install libstdc++
# yum install libstdc++-devel
# yum install make
# yum install setarch
# yum install libXp
# yum install openmotif
# yum install unixODBC*

 

6. ¿À¶óŬ ¾ÐÃà Ç®±â

´Ù¿î °æ·Î À̵¿ÈÄ
# unzip 10201_database_linux32.zip
# mkdir /oracle10g
# chmod 755 database
¼³Ä¡ ÆÄÀÏ ¿øÇϴ°÷¿¡ À̵¿ÈÄ ¼³Ä¡

 



 
 

Total 78
¹øÈ£ Á¦   ¸ñ ±Û¾´ÀÌ ³¯Â¥ Á¶È¸
48 SSH ±âº»¸í·É¾î ÃÖ°í°ü¸®ÀÚ 06-22 39847
47 Alteon L4½ºÀ§Ä¡ configuration ÃʱâÈ­ ¹× Dump ÀýÂ÷ ½ÑÀ¥È£½ºÆà 11-28 36311
46 Force10 OS Æß¿þ¾î ¾÷±×·¹ÀÌµå ½ÑÀ¥È£½ºÆà 06-28 34745
45 °­·ÂÇÑ ¿ÀǼҽº ÆÄƼ¼Ç º¹±¸ ÇÁ·Î±×·¥ - TestDisk ½ÑÀ¥È£½ºÆà 11-01 33331
44 [CentOS] Tomcat 7.0.4 ¼³Ä¡ (¼öÁ¤1) ½ÑÀ¥È£½ºÆà 11-16 32805
43 CentOS 5.5 ±â¹Ý Oracle 10g ¼³Ä¡(2. ȯ°æ º¯¼ö ¼³Á¤) ½ÑÀ¥È£½ºÆà 07-06 31450
42 mysql Replicating ½ÑÀ¥È£½ºÆà 10-31 30306
41 mod_jk¸¦ ÀÌ¿ëÇÑ Apache2 + Tomcat5.5 ¿¬µ¿ ¹× °¡»óÈ£½ºÆà ½ÑÀ¥È£½ºÆà 11-17 29691
40 Subversion/Trac ¹é¾÷ ¹× º¹±¸ ½ÑÀ¥È£½ºÆà 11-30 29530
39 drbd sync ±úÁ³À»¶§ [solved] ½ÑÀ¥È£½ºÆà 06-28 29014
38 MS-SQL ¸®Çø®ÄÉÀÌ¼Ç (º´ÇÕº¹Á¦) Å×À̺í Ãß°¡ ¹æ¹ý ½ÑÀ¥È£½ºÆà 05-09 28189
37 ¿À¶óŬ DB »ý¼º ½ÑÀ¥È£½ºÆà 07-13 28103
36 ¿À¶óŬ °èÁ¤»ý¼º ½ÑÀ¥È£½ºÆà 11-02 27491
35 The 5 minute DBA: Default My.cnf File ½ÑÀ¥È£½ºÆà 03-06 27357
34 DRBD(Distributed Replicated Block Device) ¼³Ä¡ ¹× ¼³Á¤ ½ÑÀ¥È£½ºÆà 06-24 26925
 1  2  3  4  5  6