°Ô½Ã¹° 3°Ç
 
[Oracle] RHEL6.5¿¡ Oracle 11g ¼³Ä¡Çϱâ
±Û¾´ÀÌ : theko ³¯Â¥ : 2014-11-12 (¼ö) 13:03 Á¶È¸ : 18708
RedHat Enterpirse Linux 6.5 ¿¡ Oracle 11g ¼³Ä¡Çϱâ

£± ¼³Ä¡ ½Ã³ª¸®¿À
°¡) RHEL 6.5 DeskTop ÆÐÅ°Áö¸¸ ¼³Ä¡ ÈÄ Ãß°¡ÀûÀÎ RPM ¼³Ä¡
³ª) Oracle 11g ±¸¼º¿¡ ÇÊ¿äÇÑ ÆÐÅ°Áö
binutils
compat-libcap1
compat-libstdc++-33
gcc
gcc-c++
glibc
glibc-devel
ksh
libgcc
libstdc++
libstdc++-devel
libaio
libaio-devel
make
sysstat

´Ù) Oracle µ¥ÀÌÅÍ ¼³Ä¡ °æ·Î
/app

£² ¼³Ä¡¿¡ ÇÊ¿äÇÑ Oracle 11g ´Ù¿î·Îµå (Oracle °èÁ¤ ÇÊ¿ä)
°¡) ´Ù¿î·Îµå °æ·Î
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/

³ª) ´Ù¿î·Îµå ÆÄÀÏ (Oracle 11g)
´Ù¿î·Îµå Çϱâ Àü¿¡ ¶óÀ̼±½º µ¿ÀÇ°¡ ÇÊ¿äÇÔ (´Ù¿î·Îµå »óÀ§¿¡ ÀÖÀ½)

Oracle Database 11g Release 2
Standard Edition, Standard Edition One, and Enterprise Edition

(11.2.0.1.0)
Linux x86-64 ÀÇ File 1, File 2
linux.x64_11gR2_database_1of2.zip
linux.x64_11gR2_database_2of2.zip

£³ ±×·ì°ú °èÁ¤ »ý¼º ¹× Host µî·Ï
°¡) Install ¿¡ ÇÊ¿äÇÑ Oracle ±×·ì°ú °èÁ¤À» »ý¼ºÇÑ´Ù.
#groupadd oinstall
#groupadd dba
#useradd –g oinstall –G dba oracle
#passwd oracle

/etc/hosts ¾Æ·¡¿¡ Host Á¤º¸¸¦ ³Ö¾îÁØ´Ù.
#vim /hosts
10.10.10.200 200-VM

£´ Ä¿³Î ÆĶó¹ÌÅÍ ¼³Á¤ (Oracle 11g ±âÁØ)
 
°¡) ½Ã½ºÅÛ ¼³Á¤ÀÌ Á¦½ÃÇÑ °ªº¸´Ù Ŭ °æ¿ì´Â ¼öÁ¤ÇÏÁö ¾Ê°í ³·Àº °æ¿ì ¼öÁ¤ÇØÁØ´Ù.
¼öÁ¤ÀÌ ÇÊ¿äÇÏ´Ù¸é sysctl.conf ¿¡¼­ ¼öÁ¤ÇØÁØ´Ù.

#vim /etc/sysctl.conf





£µ Oracle À» À§ÇÑ Resource Limits ¼³Á¤À» º¯°æ ÇØÁØ´Ù.
°¡) /etc/security/limits.conf ÆÄÀÏ Á¦ÀÏ ¾Æ·¡¿¡ ³Ö¾îÁØ´Ù.
oracle    soft    nproc    2047
oracle    hard    nproc    16384
oracle    soft    nofile    1024
oracle    hard    nofile    65536
oracle    soft    stack    10240

£¶ Oracle Install µð·ºÅ丮 ¸¸µé±â
°¡) ¸¶¿îÆ® Æ÷ÀÎÆ®°¡ µû·Î ÇÊ¿äÇÑ °æ¿ì ÁöÁ¤ÀÌ °¡´ÉÇϸç, ¿©±â¼­´Â µðÆúÆ®(/app) °æ·Î·Î ÁöÁ¤Çß´Ù.
#mkdir –p /app
#chown –R oracle:oinstall /app
#chmod –R 775 /app

£· Oracle ȯ°æ º¯¼ö ¸¸µé±â
°¡) Oracle ȯ°æ º¯¼ö¸¦ ¸¸µé¾îÁִµ¥ ÇÁ·ÒÇÁÆ® ¶óÀο¡¼­ ¸í·É¾î¸¦ ÀԷ½ÃÄÑ Áִµ¥ ¾ÕÀ¸·Î °è¼Ó »ç¿ëµÉ º¯¼ö À̹ǷΠoracle °èÁ¤ÀÇ È¯°æ º¯¼ö¿¡ ³Ö¾îÁØ´Ù.
ORACLE_BASE=/app/oracle
ORACLE_SID=RHELORA

vim /home/oracle/.basr_profile // Á¦ÀÏ ¾Æ·¡¿¡ Ãß°¡ÇØÁØ´Ù.

export ORACLE_BASE=/app/oracle
export ORACLE_SID=RHELORA
export ORACLE_HOME=/app/oracle/dbhome
export ORACLE_HOME_LISTNER=$ORACLE_HOME/bin/lsnrctl

£¸ Oracle ¼³Ä¡¸¦ ½ÃÀÛÇØÁØ´Ù
°¡) Oracle ¼³Ä¡¸¦ ½ÃÀÛÇϴµ¥ Å͹̳ο¡¼­µµ °¡´ÉÇÏÁö¸¸, Á¦°¡ Å×½ºÆ® Çغ» °æ¿ì Å͹̳ο¡¼­´Â ¼³Ä¡°¡ ÁߴܵǸç, X-Windows ¸ðµå¿¡¼­ ¼³Ä¡¸¦ ÇÏ¿´´Ù.

³ª) 2¹ø ¿¡¼­ ¹Þ¾Æ³õÀº Oracle ¼³Ä¡ ÆÄÀÏ 1¹ø°ú 2¹øÀ» °°Àº µð·ºÅ丮·Î ³Ö¾îÁØ ÈÄ ÇØ´ç µð·ºÅ丮ÀÇ ±ÇÇÑÀ» 775 ·Î ¸ÂÃç ÁØ´Ù. ( Àú´Â /usr/local/src/database )
#chmod –R 755 /usr/local/src/database
#export LANG=C
#cd /usr/local/src/database
#./runInstaller

´Ù) >>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set.    Failed <<<<
Some requirement checks failed. You must fulfill these requirements before

¿À·ù ¹ß»ý ½Ã ¾Æ·¡ ¸í·É¾î¸¦ ÀÔ·Â ÇØÁØ´Ù.
xhost +SI:localuser:oracle

£¹ GUI ¼³Ä¡ ½ÃÀÛ
°¡) Configure Security Updates
À̸ÞÀÏ º¸³»´Â ¿É¼ÇÀº üũ ÇØÁ¦ ÇÏ°í Next

³ª) I Installation Options
Create and configure a database ¼±Åà ÈÄ Next

´Ù) System Class
Server Class ¼±Åà ÈÄ Next

¶ó) Grid Options
Single Instance database Installation ¼±Åà ÈÄ Next

¸¶) Install Type
Advanced Install ¼±Åà ÈÄ Next

¹Ù) Product Languages
Korean Ãß°¡ ÈÄ Next

ȍ) Database Edition
Enterprise Edtion ¼±Åà ÈÄ Next

¾Æ) Installation Location
Software Location ¿¡ /app/oracle/dbhome À¸·Î ¼öÁ¤ ÈÄ Next

ÀÚ) Create Inventory
µðÆúÆ® °ª ±×´ë·Î Next

Â÷) Database Indentifiers
Global database name – RHELORA,
Oracle Service Identifier (SID) – RHELORA ¼öÁ¤ ÈÄ Next

Ä«) Configuration Options
Memory – Enable Automatic Memory Management üũ
Character sets – Chose from following list of character sets (Unicode standard UTF-8 AL32UTF8)
Security – Æнº
Sample Schemas – Create database with sample schemas üũ
Next

Ÿ) Management Options
µðÆúÆ® °ª ±×´ë·Î Next

ÆÄ) Backup and Recovery
¹é¾÷ÀÌ ÇÊ¿äÇÏ´Ù¸é Enable automated backups üũ ÈÄ °èÁ¤&ºñ¹ø ÀÔ·Â
¹é¾÷ÀÌ ÇÊ¿äÇÏÁö ¾Ê´Ù¸é Do not enable automated backups
Next

ÇÏ) Schema Passwords
Å×½ºÆ® ¿ëµµ À̹ǷΠ¸ðµç °èÁ¤ÀÇ ºñ¹Ð¹øÈ£¸¦ °°°Ô ¼³Á¤ÇÑ´Ù.
Use the same password for all accounts ¼±Åà ÈÄ °èÁ¤ °ú ºñ¹ø ÀÔ·Â
Next

°¡) Operating System Groups
Database Administrator (OSDBA) Group - dba

³ª) Prerequis ite Checks
Oracle ¿¡¼­ ¿ä±¸ÇÏ´Â ÆÐÅ°Áöµé¿¡ ´ëÇÑ Ã¼Å©¸¦ ÁøÇà ÇÏ´Â ºÎºÐ, ÆÐÅ°Áö¸¦ ãÁö ¸øÇؼ­ Failed °¡ ¶°µµ, »óÀ§ ¹öÀüÀÇ ÆÐÅ°Áö°¡ ÀÖ´Ù¸é ignore All ·Î ÁøÇàÇصµ ¹®Á¦´Â ¾ø´Ù.

´Ù) Install Product
ÃÖÁ¾ ¼³Ä¡ ÁøÇàÀÌ ¿Ï·áµÇ°í Finish Ŭ¸¯ÇÏ¸é ¡°Database Configuration Assistant¡± âÀÌ ¶ß¸é¼­ ¼³Ä¡¸¦ ¸¶¹«¸® ¹× ¼³Á¤À» ¿Ï·á°¡ ÁøÇàµÈ´Ù.
£±£° ¼³Ä¡ ¿Ï·á ÈÄ ½ÇÁ¦ ·Î±×ÀÎ ¹× DB È®ÀÎ
#cd /app/oracle/dbhome/bin/
[oracle@200-VM bin]$ ./sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Tue Nov 11 05:15:55 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter user-name: /as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/app/oracle/oradata/RHELORA/system01.dbf
/app/oracle/oradata/RHELORA/sysaux01.dbf
/app/oracle/oradata/RHELORA/undotbs01.dbf
/app/oracle/oradata/RHELORA/users01.dbf
/app/oracle/oradata/RHELORA/example01.dbf

SQL>

°¡) ÃÖÁ¾ ¼³Ä¡ ¹× È®ÀÎ ¿Ï·á

À̸§ Æнº¿öµå
ºñ¹Ð±Û (üũÇÏ¸é ±Û¾´À̸¸ ³»¿ëÀ» È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù.)
¿ÞÂÊÀÇ ±ÛÀÚ¸¦ ÀÔ·ÂÇϼ¼¿ä.
 

miwit.com sir.co.kr DNS Powered by DNSEver.com DNS Powered by DNSEver.com