Oracle 11g R2 Download
http://www.oracle.com/technology/software/products/database/index.html
![](http://postfiles15.naver.net/20100105_126/nemesisx_1262678611526tCBV4_jpg/01_nemesisx.jpg?type=w2)
/etc/sysctl.conf ÆÄÀÏÀ» ¿¾î ´ÙÀ½ ³»¿ëÀ» Ãß°¡ÇÑ´Ù.
kernel.shmmax = 536870912
kernel.shmall = 2097152
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
kernel.shmax¿Í kernel.shmallÀº Default°ªÀÌ ÀÖ¾î ±âÁ¸°ÍÀ¸·Î ¼³Á¤Çß´Ù.
±âº»°ªÀÌ ÀÖÀ» °æ¿ì À§°ªº¸´Ù ³ôÀ¸¸é »ó°ü¾ø´Ù.
![](http://postfiles9.naver.net/20100105_168/nemesisx_1262678611814iHYoF_jpg/02_nemesisx.jpg?type=w2)
/sbin/sysctl -p ½ÇÇà
![](http://postfiles11.naver.net/20100105_282/nemesisx_1262678612049g3y3C_jpg/03_nemesisx.jpg?type=w2)
/etc/security/limits.conf ÆÄÀÏÀ» ¿¾î ¾Æ·¡³»¿ë Ãß°¡
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
![](http://postfiles14.naver.net/20100105_29/nemesisx_1262678612268xQCHP_jpg/04_nemesisx.jpg?type=w2)
/etc/pam.d/login ÆÄÀÏÀ» ¿¾î ¾Æ·¡³»¿ë Ãß°¡
session required pam_limits.so
![](http://postfiles2.naver.net/20100105_145/nemesisx_1262678612544NwhLS_jpg/05_nemesisx.jpg?type=w2)
/etc/selinux/config ÆÄÀÏÀ» ¿¾î SELINUX¸¦ disabled ½ÃÄÑÁØ´Ù.
¼ÂÆðªÀ» Àû¿ëÇϱâ À§ÇØ OS¸¦ ¸®ºÎÆà ½ÃŲ´Ù.
![](http://postfiles9.naver.net/20100105_40/nemesisx_1262678612705P0MyV_jpg/07_nemesisx.jpg?type=w2)
ºÎÆÃÈÄ CentOS ½Ãµð³ª À̹ÌÁö¸¦ ¸¶¿îÆ® ½ÃŲ´Ù.
/media/CentOS_5.4_Final/CentOS·Î °¡¼ ÇÊ¿äÇÑ ÆÐÅ°Áö¸¦ ¼³Ä¡ÇÑ´Ù.
ÀÎÅͳݿ¡ ¿¬°áµÈ´Ù¸é yum installÀ» ÀÌ¿ëÇØ ¼³Ä¡Çصµ »ó°ü¾ø´Ù.
ÇÊ¿äÇÑ ÆÐÅ°Áö ¸ñ·Ï
- compat-libstdc++-33-3.2.3-61
- elfutils-libelf-0.125-3.el5
- elfutils-libelf-devel-0.125-3.el5
- glibc-2.5-12
- glibc-devel-2.5-12
- glibc-common-2.5-12
- gcc-4.1.1-52.el5
- gcc-c++-4.1.1-52.el5
- kernel-headers
- libgcc-4.1.1-52.el5
- libaio-0.3.106-3.2
- libaio-devel-0.3.106-3.2
- libstdc++-4.1.1-52.el5
- libstdc++-devel-4.1.1-52.el5
- unixODBC-2.2.11-7.1
- unixODBC-devel-2.2.11-7.1
- sysstat-7.0.0-3.el5
- binutils-2.17.50.0.6-2.el5
- make-3.81-1.1
| |
|
ÆÐÅ°Áö ¼³Ä¡ ¸í·É¾î
- rpm -Uvh compat-libstdc++-33*
- rpm -Uvh elfutils-libelf*
- rpm -Uvh glibc-2.*
- rpm -Uvh glibc-devel-2.*
- rpm -Uvh glibc-common-2.*
- rpm -Uvh glibc-headers-2.*
- rpm -Uvh gcc-4.*
- rpm -Uvh gcc-c++-4.*
- rpm -Uvh ksh*
- rpm -Uvh libgcc-4.*
- rpm -Uvh libaio-0.*
- rpm -Uvh libaio-devel-0.*
- rpm -Uvh libgomp-4.*
- rpm -Uvh libstdc++-4.*
- rpm -Uvh libstdc++-devel-4.*
- rpm -Uvh unixODBC-2.*
- rpm -Uvh unixODBC-devel-2.*
- rpm -Uvh sysstat-7.*
- rpm -Uvh binutils-2.*
- rpm -Uvh make-3.*
| |
![](http://postfiles7.naver.net/20100105_278/nemesisx_12626786129427OiS1_jpg/08_nemesisx.jpg?type=w2)
oinstall°ú dba±×·ìÀ» ¸¸µé°í oracle °èÁ¤À» ¸¸µç´Ù.
![](http://postfiles3.naver.net/20100105_146/nemesisx_1262678613431myfk2_jpg/09_nemesisx.jpg?type=w2)
/oracle µð·ºÅ丮¸¦ ¸¸µç´Ù.
¿À¶óŬ ¼³Ä¡ÇÒ ±âº» µð·ºÅ丮´Â /oracle/11g´Ù.
¼ÒÀ¯ÀÚ¸¦ oracle·Î º¯°æÇÏ°í ¾²±â°¡ °¡´ÉÇϵµ·Ï Æ۹̼ÇÀ» º¯°æÇÑ´Ù.
![](http://postfiles14.naver.net/20100105_189/nemesisx_12626786136558W1N0_jpg/13_nemesisx.jpg?type=w2)
oracle °èÁ¤À¸·Î Á¢¼ÓÇÏ¿©(su - oracle)
.bash_profile ÆÄÀÏ¿¡ ´ÙÀ½³»¿ëÀ» Ãß°¡ÇÑ´Ù.
SIDÀÇ °æ¿ì NEMI¶ó´Â À̸§À¸·Î ÁöÁ¤ÇÏ¿´´Ù.
ORACLE_HOSTNAME=localhost.localdomain; export ORACLE_HOSTNAME
ORACLE_BASE=/oracle/11g; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=NEMI; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
![](http://postfiles16.naver.net/20100105_143/nemesisx_1262678614070oPcTv_jpg/15_nemesisx.jpg?type=w2)
SAMBA³ª FTP(oracle°èÁ¤)¸¦ ÅëÇØ Oracle 11g R2 zipÆÄÀÏ 2°³¸¦ ¼¹ö·Î Àü¼ÛÇÑ´Ù.
¾Æ·¡¿Í °°ÀÌ ¾ÐÃàÀ» Ǭ´Ù.
unzip linux.x64_11gR2_database_1of2.zip
unzip linux.x64_11gR2_database_2of2.zip
ÀÌÁ¦ºÎÅÍ xmingÀ» ÅëÇØ InstallÀ» ÇÒ °ÍÀÌ´Ù.
xmingÀº ¿ø°ÝÀ¸·Î GUI¿ë LinuxÇÁ·Î±×·¥À» À©µµ¿ìȸ鿡¼ º¼ ¼ö ÀÖ°Ô ÇØÁÖ´Â ÇÁ·Î±×·¥ÀÌ´Ù.
xmingÀÌ ¾Æ´Ï´õ¶óµµ CentOS ¸ÞÀΠȸ鿡¼ ¼³Ä¡ ÇÒ ¼ö ÀÖ´Ù.
Âü°í·Î export LANG=c ¸¦ ²À ÇØÁÖ¾î¾ß ±ÛÀÚ°¡ ¾È±úÁø´Ù.
¾ÐÃàǬ Æú´õ¿¡¼ ./runInstaller ¸¦ ½ÇÇà½ÃÅ°ÀÚ.
![](http://postfiles4.naver.net/20100105_147/nemesisx_1262678614319qkD8W_jpg/16_nemesisx.jpg?type=w2)
EmailÀ» ÀÔ·ÂÇÏ¸é º¸¾ÈÀ̽´ °ü·Ã ³»¿ëÀ» º¸³»ÁÖ´Â °Í °°´Ù.
Å©°Ô ÇÊ¿ä¾ø´Ù¸é üũ¹Ú½º¸¦ ÇØÁ¦ÇÏ°í Next¸¦ ´©¸¥´Ù.
![](http://postfiles13.naver.net/20100105_156/nemesisx_1262678614682CJeiq_jpg/17_nemesisx.jpg?type=w2)
µ¥ÀÌÅͺ£À̽º±îÁö »ý¼ºÇϱ⠶§¹®¿¡ ù¹ø°¸¦ ¼±ÅÃÇÑ´Ù.
![](http://postfiles5.naver.net/20100105_132/nemesisx_1262678614981PLqUb_jpg/18_nemesisx.jpg?type=w2)
¼¹ö¿ë ¼³Ä¡À̹ǷΠServer Class¸¦ ¼±ÅÃ
![](http://postfiles13.naver.net/20100105_268/nemesisx_1262678615317FN2MJ_jpg/19_nemesisx.jpg?type=w2)
RAC¸¦ ÅëÇØ ÀÌÁßÈ ±¸¼ºÀ» ÇÏÁö ¾ÊÀ¸¹Ç·Î ½Ì±ÛÀνºÅϽº ¼±ÅÃ
![](http://postfiles12.naver.net/20100105_299/nemesisx_1262678615607nGLKK_jpg/20_nemesisx.jpg?type=w2)
±âº» ¼³Ä¡ÀÎ Typical Install ¼±ÅÃ
![](http://postfiles2.naver.net/20100105_257/nemesisx_12626786164512eC5O_jpg/21_nemesisx.jpg?type=w2)
¼³Ä¡ À§Ä¡¸¦ Á¤ÇÒ ¼ö Àִ ȸéÀÌ´Ù.
±Û·Î¹ú µ¥ÀÌÅͺ£À̽º¸í°ú Æнº¿öµå¸¦ ÀÔ·ÂÇÑ´Ù.
![](http://postfiles6.naver.net/20100105_197/nemesisx_1262678616973HigeU_jpg/22_nemesisx.jpg?type=w2)
¿À¶óŬ Àκ¥Å丮 ¼³Ä¡ À§Ä¡¸¦ Á¤Çϴ ȸé
![](http://postfiles16.naver.net/20100105_47/nemesisx_1262678617247wXqME_jpg/23_nemesisx.jpg?type=w2)
¿À¶óŬ ¼³Ä¡Áß¿¡¼ Á¦ÀÏ Áß¿äÇÑ ºÎºÐÀÌ´Ù.
´Ù¸¥ ºÎºÐº¸´Ù ÆĶó¹ÌÅÍ¿Í ÆÐÅ°Áö´Â fail·Î ³ª¿À¸é ¾ÈµÈ´Ù.
ÆĶó¹ÌÅÍ°ªÀÌ failÀÏ °æ¿ì ±ÇÀå°ªÀ¸·Î º¯°æÇÏ°í
ÆÐÅ°Áö°¡ failÀÏ °æ¿ì rpmÀ̳ª yumÀ» ÅëÇØ ¹Ýµå½Ã ¼³Ä¡ÇÑ´Ù.
ÆÐÅ°ÁöÀÇ °æ¿ì ¹«½ÃÇÏ¸é ¼³Ä¡ Áß ¿¡·¯°¡ ³´Ù.
Å×½ºÆ®¿ë ¼¹ö¶ó ¸Þ¸ð¸®¿Í Swap »çÀÌÁî´Â ¹«½ÃÇÏ°í ¼³Ä¡ÇÏ¿´´Ù.
ignore All¸¦ üũÇÏ¸é ¹«½ÃÇÏ°í ¼³Ä¡°¡ ÁøÇàµÈ´Ù.
![](http://postfiles8.naver.net/20100105_7/nemesisx_1262678617600FSjmW_jpg/24_nemesisx.jpg?type=w2)
ÃÖÁ¾ ¼³Á¤ Á¤º¸¸¦ È®ÀÎÇÑ´Ù.
ƯÀÌ»çÇ×ÀÌ ¾øÀ¸¸é Finish¸¦ ´©¸¥´Ù.
![](http://postfiles3.naver.net/20100105_66/nemesisx_1262678793348rXkjU_jpg/25_nemesisx.jpg?type=w2)
¿À¶óŬ 11g ¼³Ä¡°¡ ÁøÇàµÈ´Ù.
![](http://postfiles12.naver.net/20100105_27/nemesisx_1262678793556u1yCg_jpg/27_nemesisx.jpg?type=w2)
µ¥ÀÌÅͺ£À̽º »ý¼º ȸé
![](http://postfiles11.naver.net/20100105_42/nemesisx_1262678793801kovk5_jpg/28_nemesisx.jpg?type=w2)
¼³Ä¡°¡ ¿Ï·áµÇ¾ú´Ù.
![](http://postfiles5.naver.net/20100105_100/nemesisx_12626787939873Vd2P_jpg/29_nemesisx.jpg?type=w2)
Password Management¸¦ ´©¸£¸é À¯Àú Àá±Ý¿©ºÎ¿Í ¾ÏÈ£¸¦ ÁöÁ¤ÇÒ ¼ö ÀÖ´Ù.
![](http://postfiles13.naver.net/20100105_172/nemesisx_1262678794161PwXdN_jpg/30_nemesisx.jpg?type=w2)
root°èÁ¤À¸·Î Á¢¼ÓÇÏ¿© 2°³ÀÇ ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇÏÀÚ.
![](http://postfiles15.naver.net/20100105_286/nemesisx_1262678794449JdAC1_jpg/31_nemesisx.jpg?type=w2)
ÃÖÁ¾ÀûÀ¸·Î ¼³Ä¡°¡ ¿Ï·áµÈ´Ù.
![](http://postfiles9.naver.net/20100105_264/nemesisx_1262678794631UOdAI_jpg/32_nemesisx.jpg?type=w2)
sqlplus·Î Á¢¼ÓÇÏ¿© ÀνºÅϽº¸¦ È®ÀÎÇØ º¸ÀÚ.