ubuntu ¿¡ oracle 11g Release2 ¼³Ä¡ -1 Ãâó: http://shinyul.tistory.com/10?category=541650 [½ÃÀÛ...]
ÇØ´ç °Ô½Ã±ÛÀº http://ioriy2k.pe.kr/archives/815 ¿¡¼ ÆÛ¿Ô½À´Ï´Ù.
Oracle Database´Â Oracle¿¡¼ °³¹ßÇÑ °ü°èÇü Database·Î ±ÝÀ¶±Ç°ú ÀÏ¹Ý ±â¾÷, °ø°ø±â°ü, ½ÉÁö¾î ¿ì¸®³ª¶ó¿¡¼´Â ÃʵîÇб³ Çг»Àü»ê¸Á¿¡±îÁö »ç¿ëµË´Ï´Ù. (ÃʵîÇб³¿¡ ¾ó¸¶³ª ¸¹Àº DB 󸮷®ÀÌ ÇÊ¿äÇϱ淡.. ´ëÇ¥ÀûÀÎ ¿¹»ê ³¶ºñ ÇàÁ¤ÀÌÁÒ. ¤¾¤¾ Mysql·Îµµ ÃæºÐÇÑ °ÍÀ»..) ¶Ù¾î³ ¾ÈÁ¤¼º°ú Performance·Î °¡Àå ³Î¸® »ç¿ëµÇ´Â DatabaseÀÎ OracleÀº Windows, Linux, Unix °è¿ Server¿¡¼ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
Oracle Database¿¡¼ °ø½ÄÀûÀ¸·Î Áö¿øÇÏ´Â Linux ¹èÆ÷ÆÇÀº Asianux Server, Red Hat Enterprise Linux(RHEL), SUSE Linux Enterprise ServerÀÔ´Ï´Ù. ÃֽŠReleaseÀÎ Oracle 11g Release 2¿¡¼ Áö¿øÇÏ´Â ¹èÆ÷ÆÇÀ» ÀÚ¼¼È÷ ¿°ÅÇÏ¸é ¾Æ·¡¿Í °°½À´Ï´Ù.
- Asianux Server 3 SP2
- Oracle Enterprise Linux 4 Update 7
- Oracle Enterprise Linux 5 Update 2
- Red Hat Enterprise Linux 4 Update 7
- Red Hat Enterprise Linux 5 Update 2
- SUSE Linux Enterprise Server 10 SP2
- SUSE Linux Enterprise Server 11
¹°·Ð °ø½ÄÀûÀ¸·Î Áö¿øÇÏÁö ¾Ê´Â Linux ¹èÆ÷ÆÇÀÌ¶óµµ ¼³Ä¡ ¹× ±¸µ¿ÀÌ °¡´ÉÇÕ´Ï´Ù. À̹ø Post¿¡¼´Â Ubuntu¿¡¼ Oracle 11g Relase 2¸¦ ¼³Ä¡ÇÏ´Â ¹æ¹ýÀ» ¾Ë¾Æº¸µµ·Ï ÇÏ°Ú½À´Ï´Ù.
Table of Contents [Show]
1. Çʼö Package ¼³Ä¡
Oracle Database¸¦ ¼³Ä¡Çϱâ À§Çؼ »ç¿ëµÇ´Â Çʼö Package¸¦ ¼³Ä¡ÇÕ´Ï´Ù.
1.1. Natty Narwhal 11.04 ÀÌÇÏÀÇ ¹èÆ÷ÆÇÀÇ °æ¿ì
Terminal¿¡¼ ´ÙÀ½°ú °°ÀÌ ÀÔ·ÂÇÕ´Ï´Ù.
1 | $ sudo apt-get install unzip build-essential x11-utils rpm ksh lsb-rpm libaio1 |
1.2. Oneiric Ocelot 11.10ÀÇ °æ¿ì
Terminal¿¡¼ ¾Æ·¡ÀÇ ¸í·ÉÀ¸·Î ¼³Ä¡ÇÕ´Ï´Ù.
- 32bit:1
2
3$ sudo apt-get install unzip build-essential x11-utils rpm ksh libaio1
$ wget "http://launchpadlibrarian.net/64397544/lsb-rpm_4.8.1-6ubuntu1_i386.deb"
$ sudo dpkg -i lsb-rpm_4.8.1-6ubuntu1_i386.deb - 64bit:1
2
3$ sudo apt-get install unzip build-essential x11-utils rpm ksh libaio1
$ wget "http://launchpadlibrarian.net/64397680/lsb-rpm_4.8.1-6ubuntu1_amd64.deb"
$ sudo dpkg -i lsb-rpm_4.8.1-6ubuntu1_amd64.deb
1.3. Precise Pangolin 12.04ÀÇ °æ¿ì
Terminal¿¡¼ ´ÙÀ½°ú °°ÀÌ ÀÔ·°ÇÕ´Ï´Ù.
- 32bit:1
2
3
4$ sudo apt-get install unzip build-essential x11-utils rpm ksh libaio1 libdb4.8
$ wget "http://launchpadlibrarian.net/59032965/liblzma2_5.0.0-2_i386.deb"
$ wget "http://launchpadlibrarian.net/64397544/lsb-rpm_4.8.1-6ubuntu1_i386.deb"
$ sudo dpkg -i liblzma2_5.0.0-2_i386.deb lsb-rpm_4.8.1-6ubuntu1_i386.deb - 64bit:1
2
3
4$ sudo apt-get install unzip build-essential x11-utils rpm ksh libaio1 libdb4.8
$ wget "http://launchpadlibrarian.net/59033014/liblzma2_5.0.0-2_amd64.deb"
$ wget "http://launchpadlibrarian.net/64397680/lsb-rpm_4.8.1-6ubuntu1_amd64.deb"
$ sudo dpkg -i liblzma2_5.0.0-2_amd64.deb lsb-rpm_4.8.1-6ubuntu1_amd64.deb
1.4. Quantal Quetzal 12.10 ÀÌ»óÀÇ °æ¿ì
Quantal Quetzal 12.10, Raring Ringtail 13.04ÀÇ °æ¿ì´Â Terminal¿¡¼ ´ÙÀ½°ú °°ÀÌ ÀÔ·°ÇÕ´Ï´Ù.
- 32bit:1
2
3
4
5$ sudo apt-get install unzip build-essential x11-utils rpm ksh libaio1
$ wget "http://launchpadlibrarian.net/100815189/libdb4.8_4.8.30-11ubuntu1_i386.deb"
$ wget "http://launchpadlibrarian.net/59032965/liblzma2_5.0.0-2_i386.deb"
$ wget "http://launchpadlibrarian.net/64397544/lsb-rpm_4.8.1-6ubuntu1_i386.deb"
$ sudo dpkg -i libdb4.8_4.8.30-11ubuntu1_i386.deb liblzma2_5.0.0-2_i386.deb lsb-rpm_4.8.1-6ubuntu1_i386.deb - 64bit:1
2
3
4
5$ sudo apt-get install unzip build-essential x11-utils rpm ksh libaio1
$ wget "http://launchpadlibrarian.net/100815432/libdb4.8_4.8.30-11ubuntu1_amd64.deb"
$ wget "http://launchpadlibrarian.net/59033014/liblzma2_5.0.0-2_amd64.deb"
$ wget "http://launchpadlibrarian.net/64397680/lsb-rpm_4.8.1-6ubuntu1_amd64.deb"
$ sudo dpkg -i libdb4.8_4.8.30-11ubuntu1_amd64.deb liblzma2_5.0.0-2_amd64.deb lsb-rpm_4.8.1-6ubuntu1_amd64.deb
2. libstdc++5 ¼³Ä¡
libstdc++ Package´Â GNU Standard C++ Library·Î¼ GCC¿Í °°Àº GNUÀÇ Compiler·Î CompileÇÑ ApplicationÀ» À§ÇÑ Runtime LibraryÀÔ´Ï´Ù.
UbuntuÀÇ °æ¿ì, libstdc++6°¡ ¼³Ä¡µÇ¾î Àִµ¥ Oracle Database¿¡¼´Â libstdc++5¸¦ »ç¿ëÇÕ´Ï´Ù.
2.1. Lucid Lynx 10.04ÀÇ °æ¿ì
Repository¿¡¼ libstdc++5¸¦ Áö¿øÇÏÁö ¾ÊÀ¸¹Ç·Î ´ÙÀ½°ú °°Àº ¹æ¹ýÀ¸·Î libstdc++5¸¦ ¼³Ä¡ÇÕ´Ï´Ù.
- 64bit:1
2
3
4$ wget http://mirrors.kernel.org/ubuntu/pool/universe/g/gcc-3.3/libstdc++5_3.3.6-17ubuntu1_amd64.deb
$ dpkg-deb -x libstdc++5_3.3.6-17ubuntu1_amd64.deb libstdc++
$ sudo cp libstdc++/usr/lib/libstdc++.so.5.0.7 /usr/lib/
$ sudo ln -s /usr/lib/libstdc++.so.5.0.7 /usr/lib/libstdc++.so.5 - 32bit:1
2
3
4$ wget http://security.ubuntu.com/ubuntu/pool/universe/i/ia32-libs/ia32-libs_2.7ubuntu6.1_amd64.deb
$ dpkg-deb -x ia32-libs_2.7ubuntu6.1_amd64.deb ia32-libs
$ sudo cp ia32-libs/usr/lib/libstdc++.so.5.0.7 /usr/lib/
$ sudo ln -s /usr/lib/libstdc++.so.5.0.7 /usr/lib/libstdc++.so.5
2.2. Maverick Meerkat 10.10ºÎÅÍ Quantal Quetzal 12.10±îÁöÀÇ °æ¿ì
Quantal Quetzal 12.10, Precise Pangolin 12.04, Oneiric Ocelot 11.10, Natty Narwhal 11.04, Maverick Meerkat 10.10ÀÇ °æ¿ì¿¡´Â ´ÙÀ½°ú °°ÀÌ ÀÔ·ÂÇÏ¸é °£´ÜÈ÷ ¼³Ä¡µË´Ï´Ù.
1 | $ sudo apt-get install libstdc++5 |
2.3. Raring Ringtail 13.04ÀÇ °æ¿ì
- 64bit: Ubuntu Repository¿¡ ÀÖ´Â libstdc++5¸¦ ¼³Ä¡ÇÒ °æ¿ì, ¼³Ä¡ ´ÙÀ½°ú °°Àº Message°¡ Ç¥½ÃµÉ ¼ö ÀÖ½À´Ï´Ù.1
2
3Error in invoking target 'install' of makefile '/opt/oracle/product/11.2.0/db_1/ctx/lib/ins_ctx.mk'.
/usr/lib/x86_64-linux-gnu/libstdc++.so.5: undefined reference to `memcpy@GLIBC_2.14'¹®Á¦¸¦ ÇØ°áÇϱâ À§Çؼ libstdc++5¸¦ ´ÙÀ½°ú °°ÀÌ ÀÔ·ÂÇÏ¿© µû·Î ¼³Ä¡ÇÕ´Ï´Ù.
¼³Ä¡½Ã lsb-rpm ÆÐÅ°Áö´Â ´ÙÀ½ ÆÐÅ°Áö¿¡ ÀÇÁ¸: liblua5.1-0 ¹ß»ý½Ã liblua5.1-0 ¼³Ä¡ ÁøÇà
- > sudo apt-get install liblua5.1-0
1
2
3
4
5$ wget "http://mirrors.kernel.org/ubuntu/pool/universe/g/gcc-3.3/libstdc++5_3.3.6-25ubuntu1_amd64.deb"
$ dpkg-deb -x libstdc++5_3.3.6-25ubuntu1_amd64.deb libstdc++
$ sudo cp libstdc++/usr/lib/x86_64-linux-gnu/libstdc++.so.5.0.7 /usr/lib/x86_64-linux-gnu
$ sudo ln -s /usr/lib/x86_64-linux-gnu/libstdc++.so.5.0.7 /usr/lib/x86_64-linux-gnu/libstdc++.so.5
$ sudo ldconfig - 32bit: Ubuntu RepositoryÀÇ libstdc++5¸¦ ¼³Ä¡ÇÏ¸é µË´Ï´Ù.1$ sudo apt-get install libstdc++5
3. Group°ú °èÁ¤ »ý¼ºÇϱâ
OracleÀ» ¼³Ä¡ÇÏ°í »ç¿ëÇϱâ À§ÇÑ Group°ú °èÁ¤À» »ý¼ºÇÕ´Ï´Ù. ´ÙÀ½°ú °°ÀÌ Terminal¿¡¼ ÀÔ·ÂÇÕ´Ï´Ù.
1 2 3 4 5 | $ sudo addgroup oinstall $ sudo addgroup dba $ sudo useradd -g oinstall -G dba -d /home/oracle -s /bin/bash -m oracle $ sudo passwd oracle $ sudo chown oracle:dba /home/oracle -R |
4. Symbolic Link ¼³Á¤Çϱâ
¼³Ä¡ Program¿¡¼ »ç¿ëÇÏ´Â ÀϺΠProgramÀÇ °æ·Î°¡ ´Þ¶ó¼ ¹®Á¦°¡ ¹ß»ýÇÒ ¼ö Àֱ⠶§¹®¿¡ ¼³Ä¡ ProgramÀÌ ÀνÄÇÒ ¼ö ÀÖ´Â Directory·Î Symbolic Link¸¦ °É¾îÁÝ´Ï´Ù.
1 2 3 | $ sudo ln -s /usr/bin/awk /bin/awk $ sudo ln -s /usr/bin/rpm /bin/rpm $ sudo ln -s /usr/bin/basename /bin/basename |
5. Kernel º¯¼ö ¼³Á¤
Oracle Database´Â DBÀÇ ¾ÈÁ¤¼º°ú Performance¸¦ À§Çؼ SystemÀÇ ÀÚ¿øÀ» ¸¹ÀÌ »ç¿ëÇÕ´Ï´Ù. ±×·¡¼ ±âº»ÀûÀÎ Linux Kernel ¼³Á¤À¸·Î´Â DB¸¦ ¿î¿ëÇϴµ¥ ¹®Á¦°¡ Àֱ⠶§¹®¿¡ ´ÙÀ½°ú °°ÀÌ Kernel º¯¼ö¸¦ ¼³Á¤ÇØ ÁÝ´Ï´Ù.
Ubuntu¿¡¼´Â Kernel º¯¼ö¸¦ ¼³Á¤ÇÏ´Â FileÀ» /etc/sysctl.d¿¡ °ü·ÃµÈ Application º°·Î ÀúÀåÇÏ°í Àû¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ·¸°Ô ¼³Á¤ÇØ ³õÀ¸¸é Â÷ÈÄ ¹èÆ÷ÆÇÀÌ UpgradeµÇ°Å³ª °ü·Ã Package°¡ UpdateµÉ ¶§ ¼³Á¤ÀÌ º¯°æµÇ´Â ¹®Á¦¸¦ ÇØ°áÇÒ ¼ö ÀÖ½À´Ï´Ù.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | $ sudo vi /etc/sysctl.d/30-oracle.conf fs.file-max = 6815744 fs.aio-max-nr = 1048576 kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.core.rmem_default = 4194304 net.core.rmem_max = 4194304 net.core.wmem_default = 1048576 net.core.wmem_max = 1048576 net.ipv4.ip_local_port_range = 9000 65535 $ sudo service procps start |
6. Resource Limit ¼³Á¤
Oracle DB¸¦ À§Çؼ SystemÀÇ º¸¾ÈÁ¤Ã¥À¸·Î ¹¿©ÀÖ´Â ÀÚ¿ø¼³Á¤À» º¯°æÇÕ´Ï´Ù. oracle °èÁ¤¿¡ ÇÑÇÏ¿© ÃÖ´ë Process ¼ö¿Í ÃÖ´ë ¿ ¼ö ÀÖ´Â File Descripter ¼ö¸¦ ¼³Á¤ÇÕ´Ï´Ù.
Ubuntu¿¡¼´Â /etc/security/limits.d ¿¡¼ °¢ Application¿¡ ´ëÇÑ Limit ¼³Á¤À» ÇÒ ¼ö ÀÖ½À´Ï´Ù. Terminal¿¡¼ ´ÙÀ½°ú °°ÀÌ ÀÔ·ÂÇÕ´Ï´Ù.
1 2 3 4 5 6 | $ sudo vi /etc/security/limits.d/oracle.conf oracle soft nproc 2047 oracle hard nproc 16383 oracle soft nofile 1023 oracle hard nofile 65535 |
7. ¼³Ä¡ Directory »ý¼º
Oracle Database°¡ ¼³Ä¡µÉ Directory¸¦ ¹Ì¸® »ý¼ºÇÕ´Ï´Ù. Oracle °èÁ¤¿¡¼ ÇØ´ç Directory¸¦ »ý¼ºÇÏÁö ¸øÇϱ⠶§¹®¿¡ Root ±ÇÇÑÀ¸·Î ¹Ì¸® ¸¸µé¾î ³õ½À´Ï´Ù.
1 2 3 4 | $ sudo mkdir /opt/oracle $ sudo chown oracle:dba /opt/oracle $ sudo mkdir /opt/oraInventory $ sudo chown oracle:oinstall /opt/oraInventory |
8. oracle °èÁ¤À» À§ÇÑ È¯°æº¯¼ö ¼³Á¤
ÀÌÁ¦ System ¼³Á¤ÀÇ ¸¶Áö¸·ÀÔ´Ï´Ù. Home DirectoryÀÇ .bashrc¿¡ ¸¶Áö¸· ºÎºÐ¿¡ »ý¼ºÇÑ oracle °èÁ¤¿¡ Àû¿ëÇÒ È¯°æº¯¼ö¸¦ Ãß°¡ÇÕ´Ï´Ù.
1 2 3 4 5 6 7 8 | $ su - oracle $ vi ~/.bashrc export ORACLE_BASE=/opt/oracle export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1 export ORACLE_SID=orcl11 export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib export PATH=$PATH:$ORACLE_HOME/bin |
9. ¸¶Ä¡¸é¼..
Oracle Database¸¦ ¼³Ä¡Çϱâ À§ÇÑ ±âº»ÀûÀÎ ¼³Á¤ ¹× Çʼö Package ¼³Ä¡´Â ¸ðµÎ ¸¶ÃƽÀ´Ï´Ù. ÀÌÁ¦ OracleÀ» Download ¹Þ°í Installer¸¦ »ç¿ëÇؼ ¼³Ä¡ÇÏ´Â °Í°ú Ubuntu¿¡¼ Æí¸®ÇÏ°Ô OracleÀ» »ç¿ëÇϱâ À§ÇÑ ¼³Á¤µéÀ» ÇÏ¸é ¼³Ä¡´Â ¸¶¹«¸® µÉ °ÍÀÔ´Ï´Ù. ´ÙÀ½ Post¿¡¼´Â OracleÀ» Installer¸¦ »ç¿ëÇؼ ¼³Ä¡ÇÏ´Â ¹æ¹ýÀ» ¾Ë¾Æº¸°Ú½À´Ï´Ù.
Ãâó: http://shinyul.tistory.com/10?category=541650 [½ÃÀÛ...]