[CentOS] Oracle 11g R2 ¼³Ä¡ 2ºÎ
¿À¶óŬ ¼³Ä¡´Â X-Window¿¡¼ ¼³Ä¡ µÇ±â ¶§¹®¿¡ 1, 2ºÎ·Î ³ª´²¼ Æ÷½ºÆà ÇÑ´Ù.
1ºÎ´Â X-Window¿Í »ó°ü¾øÀÌ Terminal¿¡¼ ÁøÇà °¡´ÉÇÑ ºÎºÐ¿¡ ´ëÇÑ ³»¿ëÀ¸·Î Á¤¸®ÇÏ°í, 2ºÎ¿¡¼´Â X-Window¿¡¼ ¿À¶óŬ ¼³Ä¡ ȸéÀ» À§ÁÖ·Î ÁøÇà ÇÒ ¿¹Á¤ÀÌ´Ù.
1. ¿ø°ÝÁ¢¼Ó
- ¼¹ö¿¡´Â VNC Server¸¦ ±¸µ¿ÇØ ³õÀº »óÅ¿¡¼ VNC Ŭ¶óÀ̾ðÆ® ÇÁ·Î±×·¥À» ½ÇÇà ½ÃŲ´Ù. VNC Ŭ¶óÀ̾ðÆ® ÇÁ·Î±×·¥Àº UltraVNC¸¦ »ç¿ë Çß´Ù. VNC Server Á¤º¸´Â ÀÔ·ÂÀº IP¿Í Port¸¦ °°ÀÌ ÀÔ·ÂÇÑ´Ù.
- VNC Server¸¦ ±¸µ¿½ÃŲ UserÀÇ °èÁ¤À¸·Î ·Î±×ÀÎÇÑ´Ù. root·Î VNC Server¸¦ ±¸µ¿ÇÑ °æ¿ì¿¡´Â rootÀÇ VNC Password, oracle·Î VNC Server¸¦ ±¸µ¿ÇÑ °æ¿ì¿¡´Â oracle°èÁ¤ÀÇ VNC Password¸¦ ÀÔ·ÂÇÑ´Ù. ¿©±â¿¡¼´Â ¿À¶óŬ ¼³Ä¡¸¦ À§Çؼ ¿ø°Ý Á¢¼ÓÀ» Çϱ⠶§¹®¿¡ oracle °èÁ¤À¸·Î VNC Server¸¦ ±¸µ¿ÇÏ°í oracle °èÁ¤À¸·Î ·Î±×ÀÎ ÇÑ´Ù.
2. ¿À¶óŬ ¼³Ä¡ ÇÁ·Î±×·¥ Download
- ¿©±â¼ºÎÅÍ´Â X-Window¿¡¼ ÁøÇàÇÑ´Ù. Web Browser¸¦ ½ÇÇàÇÏ¿© ÁÖ¼Òâ¿¡ http://www.oracle.com site¿¡ Á¢±ÙÇÏ¿© ¸Þ´º¿¡ ÀÖ´Â downloads>Database 11g¸¦ ¼±ÅÃÇÑ´Ù.
- Accept License Agreememt¸¦ ¼±ÅÃÇÏ°í file1, file2¸¦ ´Ù¿î·Îµå ¹Þ´Â´Ù.
- ´Ü, ¼³Ä¡ÆÄÀÏÀ» ´Ù¿î·Îµå ¹ÞÀ¸·Á¸é ¿À¶óŬ¿¡ °èÁ¤ÀÌ ÀÖ¾î¾ß ÇÑ´Ù.
- file1À» Ŭ¸¯ÇÏ¸é ¾îµð¿¡ ´Ù¿î·Îµå ÇÒ Áö¸¦ ¼±ÅÃÇϴ ȸéÀÌ ³ª¿À°í Save ¹öÆ°À» Ŭ¸¯ÇÏ¸é ´Ù¿î·Îµå°¡ µÈ´Ù. file2µµ µ¿ÀÏÇÑ ¹æ¹ýÀ¸·Î ´Ù¿î·Îµå ¹Þ´Â´Ù.
3. ´Ù¿î¹ÞÀº ¿À¶óŬ ¼³Ä¡ÆÄÀÏÀÇ ¾ÐÃà ÇØÁ¦
- Å͹̳ΠâÀ» ¿¸é oracle °èÁ¤À¸·Î ½ÇÇàµÈ´Ù.
- ´Ù¿î·ÎµåµÈ ÆÄÀÏ linux.x64_11gR2_database_1of2.zip, linux.x64_11gR2_database_2of2.zipÀÇ ¾ÐÃàÀ» Ç®¾îÁÖ¸é /home/oracle/database¿¡ ¼³Ä¡ ÆÄÀÏÀÌ »ý¼ºµÈ´Ù.
[oracle@jjangwani123 ~]$ ll [oracle@jjangwani123 ~]$ unzip linux.x64_11gR2_database_2of2.zip [oracle@jjangwani123 ~]$ ll drwxr-xr-x 8 oracle oinstall 4096 8¿ù 21 2009 database |
4. ¿À¶óŬ ¼³Ä¡
- X-Window¿¡¼ oracle °èÁ¤À¸·Î /home/oracle/database/runInstaller¸¦ ½ÇÇàÇÑ´Ù. ½ÇÇàÀü¿¡ ÇöÀç ¼¼¼ÇÀÇ Language °ªÀ» º¯°æÇÑ´Ù. export LANG=C ½ÇÇà. Language°ªÀ» º¯°æÇÏÁö ¾ÊÀ¸¸é ÇѱÛÀÌ ±úÁ®¼ ³ªÅ¸³´Ù.
[oracle@jjangwani123 ~]$ cd database [oracle@jjangwani123 database]$ export LANG=C |
- Display º¯¼ö ¼³Á¤¿¡ µû¸¥ ½ÇÆп¡µµ °è¼Ó ÁøÇàÇÕ´Ï´Ù.
- ¿À¶óŬ ¼³Ä¡ ½ÃÀÛ ·Î°í
- ¼³Ä¡ ½ÃÀ۽ÿ¡ ¼¼¼ÇÀÇ Language ¼³Á¤(export LANG=C)À» ¾ÈÇÏ°í ½ÃÀÛÇÏ¸é ´ÙÀ½ ȸéó·³ ±úÁý´Ï´Ù. ¿À¸¥ÂÊ ¹Ø¿¡ ÀÖ´Â ¹öÆ°(cancle) Ŭ¸¯Çؼ È¸é ´ÝÀ¸½Ã°í Language ¼³Á¤ ÈÄ¿¡ ÁøÇàÇÏ¸é µË´Ï´Ù.
- Configure Security Updates. Ãʱâ À̸ÞÀÏ µîÀ» ³Ö´Â ȸéÀÔ´Ï´Ù. °ø¶õÀ¸·Î ³öµÎ°í ÁøÇà. [Next]
- ¿¡·¯¸Þ¼¼Áö°¡ ¶ßÁö¸¸... ±×³É ³Ñ¾î°©´Ï´Ù. [Yes]
- Installation Option.
Create and configure a database : ¿À¶óŬÀ» ¼³Ä¡ÇÏ¸é¼ Database¸¦ °°ÀÌ »ý¼ºÇÒÁö,
Install database software only : ¿À¶óŬ S/W¸¸ ¼³Ä¡ ÇÒÁö,
Upgrade an existing database : ±âÁ¸ Database¸¦ ¾÷±×·¹À̵å ÇÒÁö¸¦ ¼±ÅÃÇϴ ȸéÀÔ´Ï´Ù.
Create and configure a database ¼±Åà ÈÄ ÁøÇà [Next]
- System Class.
Desktop Class : Laptop ¶Ç´Â Desktop¿¡¼ »ç¿ëÇϱâ À§ÇÑ ½Ã½ºÅÛ,
Server Class : Server¿ë ½Ã½ºÅÛ ±¸¼ºÀ» ¼±ÅÃÇϴ ȸéÀÔ´Ï´Ù.
Server Class ¼±Åà ÈÄ ÁøÇà [Next]
- Grid Option. µ¥ÀÌÅͺ£À̽º ¼³Ä¡ À¯Çü ¼±ÅÃ.
Single Instance database installation : ´ÜÀÏ Instance Database,
Real Application Clusters database installation : Cluster Database ¼±ÅÃÇϴ ȸéÀÔ´Ï´Ù.
Single instance database installation ¼±Åà ÈÄ ÁøÇà. [Next]
- Install Type.
Typical install : ÀϹݼ³Ä¡,
Advanced install : °í±Þ/»ç¿ëÀÚ ¼³Ä¡¸¦ ¼±ÅÃÇϴ ȸé ÀÔ´Ï´Ù.
Advanced install ¼±Åà ÈÄ ÁøÇà [Next]
- Product Languages. »ç¿ëÇÒ ¾ð¾î¸¦ ¼±ÅÃÇϴ ȸé ÀÔ´Ï´Ù.
Available Languages¿¡¼ KoreanÀ» ¼±ÅÃ, Selected Languages¿¡ Ãß°¡ ÈÄ ÁøÇà. [Next]
- Database Edition. ¿À¶óŬ ¼³Ä¡ À¯ÇüÀ» ¼±ÅÃÇÕ´Ï´Ù.
Enterprise Edition, Standard Edition, Standard Edition One.
Standard Edition ¼±Åà ÈÄ ÁøÇà. [Next]
- Installation Location. ¼³Ä¡ °æ·Î¸¦ ÁöÁ¤ÇÕ´Ï´Ù.
oracle OS°èÁ¤ÀÇ .bash_profile¿¡ ¼³Á¤ µÇ¾îÀÖ´Â ORACLE_HOME, ORACLE_BASE¿¡ ÀÖ´Â Á¤º¸·Î Display µË´Ï´Ù.
¾Æ·¡ ȸ鿡´Â Á¦°¡ ¿©·¯¹ø ½ÃµµÇÏ¸é¼ ½ÇÆÐÇßÀ»¶§ ĸÃÄÇسõÀº°Å¶ó Software LocationÀÌ ´Ù¸£°Ô ³ª¿ÍÀֳ׿ä.
.bash_profileÀÇ °ªÀ» Á¤»óÀûÀ¸·Î °¡Á®¿Ô´Ù¸é ./oracle/11g ·Î µÇ¾îÀÖ¾î¾ß ÇÕ´Ï´Ù. [Next]
- Create Inventory. Inventory °æ·Î¸¦ ÁöÁ¤ÇÕ´Ï´Ù. [Next]
- Configureation Type.
General Purpose/Transaction Processing : ÀÏ¹Ý ¶Ç´Â Æ®·£Àè¼ÇÀÌ ¸¹Àº µ¥ÀÌÅͺ£À̽º,
Data Warehousing : µ¥ÀÌÅÍ ¿þ¾îÇÏ¿ì¡ ¿ëµµÀÇ µ¥ÀÌÅͺ£À̽º¸¦ ¼±ÅÃÇϴ ȸéÀÔ´Ï´Ù.
General Purpose/Transation Processing ¼±Åà ÈÄ ÁøÇà. [Next]
- Database Identifiers.
Global database name : ¿©·¯°³ÀÇ µ¥ÀÌÅͺ£À̽º°¡ ÀÖÀ»¶§ ±¸ºÐÇϱâ À§ÇÑ Global °ª, Oracle Service Identifier(SID) À» ¼³Á¤Çϴ ȸéÀÔ´Ï´Ù. SID´Â oracle OS°èÁ¤ÀÇ .bash_profile¿¡ ¼³Á¤ µÇ¾îÀÖ´Â ORACLE_SID °ªÀ» °¡Á®¿À´Â°Ô ¸Â½À´Ï´Ù. [Next]
- Configuration Option. Allocate Memory¸¦ ¼³Á¤Çϴ ȸéÀÔ´Ï´Ù. [Next]
- Management Option. µ¥ÀÌÅͺ£À̽º °ü¸® ¿É¼ÇÀ» ¼±ÅÃÇϴ ȸéÀÔ´Ï´Ù.
SMTP ServerµîÀ» ¿î¿µÇÏÁö ¾Ê±â¶§¹®¿¡ °ø¶õÀ¸·Î µÎ°í ÁøÇà. [Next]
- Database Storage. µ¥ÀÌÅͺ£À̽º »ý¼º °æ·Î¸¦ ¼³Á¤ ÇÏ´Â °÷ÀÔ´Ï´Ù.
ORACLE_BASE/oradata¿¡ »ý¼ºÇÕ´Ï´Ù.[Next]
- Backup and Recovery. µ¥ÀÌÅͺ£À̽º Backup ¼³Á¤À» Çϴ ȸé ÀÔ´Ï´Ù.
ÀÚµ¿ ¹é¾÷ ¿É¼ÇÀ» »ç¿ëÇÏÁö ¾ÊÀ» ¿¹Á¤ÀÌ¾î¼ Do not enable autoated backups ¼±Åà ÈÄ ÁøÇà. [Next]
- Schema Passwords. »ç¿ëÀÚº° ¾ÏÈ£¸¦ ¼³Á¤Çϴ ȸéÀÔ´Ï´Ù.
Use the same password for all accounts¸¦ ¼±ÅÃ, ¾ÏÈ£ÀÔ·Â ÈÄ ÁøÇà. [Next]
- ¿À¶óŬÀÇ ±ÇÀå»çÇ×Àº ¿µ¹®´ë¹®ÀÚ, ¿µ¹®¼Ò¹®ÀÚ, ¼ýÀÚ¸¦ Çϳª ÀÌ»ó ¼¯¾î¼ »ç¿ëÇϱ⸦ ±ÇÀåÇÏ°í Àֳ׿ä.
- Operating System Groups. ȸ鿡´Â Database Operator (OSOPER) Groupµµ dba·Î µÇ¾îÀִµ¥¿ä. oinstall·Î ¼±Åà ÈÄ ÁøÇàÇصµ ¹«¹æÇÕ´Ï´Ù. [Next]
- Prerequisite Checks. ¿À¶óŬ ¼³Ä¡ Àü package¸¦ °Ë»çÇÕ´Ï´Ù.
- Prerequisite Checks.
Ä¿³Î ÆĶó¹ÌÅͳª ÆÐÅ°Áö, Swap ¸Þ¸ð¸®µî¿¡ ´ëÇØ Á¡°ËÀ» ÇÑ´Ù. ÇØ´ç ³»¿ëµé¿¡ ´ëÇØ ¼³Ä¡ ¶Ç´Â ¼³Á¤ ÈÄ¿¡µµ ³²¾Æ ÀÖ´Â°Ô ÀÖÀ¸¸é ¸ðµÎ ÇØ°áÇÏ´Â°Ô ÁÁ´Ù. ´õÀÌ»ó ÇØ°á ÇÒ ¼ö ¾ø´Â °æ¿ì Ingore All À» üũ ÈÄ ÁøÇà. [Next]
- Summary. ¼³Ä¡ Ç׸ñµéÀÌ Á¦´ë·Î µÇ¾ú´ÂÁö È®ÀÎ ÈÄ ÁøÇà. [Next]
- Install Product.
- °³ÀÎÀûÀ¸·Î Install Product Áß Link Binaries ÁøÇà Áß¿¡ ¿¡·¯°¡ ¹ß»ýÇß¾ú½À´Ï´Ù.
- ¿¡·¯ ¸Þ¼¼Áö´Â
- /oracle/oraInventory/logs/installActions2012-08-10_02-27-14PM.log ³»¿ëÀ» »ìÆ캸´Ï make¿¡¼ ¹®Á¦°¡ Àִ°¡ ½Í¾ú½À´Ï´Ù¸¸... ¹¹°¡ ¹®Á¦ÀÎÁö ¸ô¶ó¼ °Ë»ösite ¹× ¿©·¯°÷À» µÚÁö°í, ¿À¶óŬ ¹öÀüº°·Î ¼³Ä¡ Çغ¸°í, ¿©·¯¹ø ¼³Ä¡/Á¦°Å¸¦ ¹Ýº¹ Çß¾ú½À´Ï´Ù. ¤Ð¤Ð
INFO: Linking sdo Options
INFO: Linking sdo Options
INFO: The output of this make operation is also available at: '/oracle/11g/install/make.log'
INFO: Exception occured during spawning :java.io.IOException: /usr/bin/make: cannot execute
INFO: Spawning the modified command :/usr/bin/make -f /oracle/11g/rdbms/lib/ins_rdbms.mk sdo_on ORACLE_HOME=/oracle/11g
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'sdo_on' of makefile '/oracle/11g/rdbms/lib/ins_rdbms.mk'. See '/oracle/oraInventory/logs/installActions2012-08-10_02-27-14PM.log' for details.
Exception Severity: 1
- ¸¶Áö¸·À¸·Î ¿Ö ¿¡·¯°¡ ³°ÇÁö Terminal¿¡¼ ¿¡·¯°¡ ³ ¸í·É¹®À» ´Ù½Ã ½ÇÇà ÇغýÀ´Ï´Ù.
[oracle@jjangwani123 ~]$ /usr/bin/make -f /oracle/11g/rdbms/lib/ins_rdbms.mk sdo_on ORACLE_HOME=/oracle/11g -bash: /usr/bin/make: Çã°¡ °ÅºÎµÊ |
[oracle@jjangwani123 ~]$ ll /usr/bin/make -rwx------ 1 root root 168992 5¿ù 25 2008 /usr/bin/make [oracle@jjangwani123 ~]$ su - root ¾ÏÈ£: [root@jjangwani123 ~]# chmod 755 /usr/bin/make |
- Çæ... make ÆÄÀÏ ½ÇÇà±ÇÇÑÀ» ¹Ù²Ù°í ÁøÇàÇÏ´Ï µË´Ï´Ù. ¤Ð¤Ð. Æ÷½ºÆÃÀº °£´ÜÇÏ°Ô Àû¾úÁö¸¸... À̰Ŷ§¹®¿¡ ¸çÄ¥À» °í»ýÇß´ÂÁö... ¾ÕÀ¸·Î´Â ¿¡·¯·Î±× Á» ¿½ÉÈ÷ ºÁ¾ß°Ú¾î¿ä... ¿µ¾î¶ó ´ëÃæ º»°Ô ¹®Á¦¿´´ø°Å °°½À´Ï´Ù. ¤¾¤¾
- Oracle Database Configuration Assistant. [OK]
- Execute Configuration scripts.
1) TerminalÀ» ¿¬´Ù.
2) root °èÁ¤À¸·Î ·Î±×ÀÎÇÑ´Ù.
3) /oracle/11g/root.sh ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇÑ´Ù. root.sh°¡ ÀÖ´Â °æ·Î´Â °³ÀÎÀÇ ¼³Ä¡ °æ·Î¿¡ µû¶ó ´Ù¸¦¼ö ÀÖ´Ù.
4) ´ÙÀ½À¸·Î ÁøÇà [OK]
- /oracle/11g/root.sh ½ÇÇà
[root@jjangwani123 11g]# ./root.sh Running Oracle 11g root.sh script...
The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /oracle/11g
Enter the full pathname of the local bin directory: [/usr/local/bin]: The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. Finished product-specific root actions. |
- Finish. ¿À¶óŬ ¼³Ä¡°¡ ³¡³µ½À´Ï´Ù.
5. ¿À¶óŬ Á¤»óÀûÀ¸·Î ¼³Ä¡ È®ÀÎ
- Enterprise Manager ½ÇÇà
¿À¶óŬ ¼³Ä¡½Ã¿¡ »ý¼ºµÈ SYS ¶Ç´Â SYSTEM °èÁ¤À¸·Î ·Î±×ÀÎ
- Enterprise Manager ¸ÞÀΠȸé