Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2002/03/23(16:34) from 210.117.182.162 | |
ÀÛ¼ºÀÚ : °ÁÙ±â (jkkang65@hanmail.net) | Á¶È¸¼ö : 3851 , ÁÙ¼ö : 198 |
[Oracle] Oracle 8i ÀνºÅç¹æ¹ý |
---|
[Oracle 8i install ¹æ¹ý] 1. System resource È®ÀÎ [HP/UX] Memory : minimum of 128M Swap space : Twice the amount of RAM CD-ROM : ISO 9660 format CD-ROM disk Disk space : Enterprise Edition Oracle 8i client Programmer/2000 ------------------------------------------------------ minimal 700M N/A N/A Typical 900M 400M 300M OS : HP/UX 11.0 [Solaris] Memory : minimum of 128M Swap space : Twice the amount of RAM CD-ROM : ISO 9660 format CD-ROM disk Disk space : Enterprise Edition Oracle 8i client Programmer/2000 ----------------------------------------------------- minimal 660M N/A N/A Typical 811M 306M 276M OS : Solaris 2.6 or 2.7 OS patch : At least kernel jumbo patch revision #105181-06 [AIX] Memory : minimum of 128M Swap space : Twice the amount of RAM CD-ROM : ISO 9660 format CD-ROM disk Disk space : Enterprise Edition Oracle 8i client Programmer/2000 ------------------------------------------------------ minimal 700M N/A N/A Typical 800M 400M 300M OS : AIX Version 4.2.1 or subsequent OS patch : (AIX 4.2.1 : IX62429 , IX67174 , IX67978 , IX68932 , IX70737 , IX78933, IX81957, IX86229) (AIX 4.3 : IX71948, IX796790, IX81863, IX89382) 'Oracle8i Installation Guide for AIX-Based Systems Release 8.1.5 ÂüÁ¶.' unix Oracle RDBMS´Â shared memory ¹× semaphore¸¦ »ç¿ëÇϸç install ½Ã ÀÌ ÀÚ¿øµéÀÌ ÃæºÐÈ÷ ¸¶·ÃÀÌ µÇ¾î ÀÖ´ÂÁö¸¦ È®ÀÎÇÏ¿©¾ß ÇÑ´Ù. (ÀÌ¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ »çÇ×Àº bulletin.10305¸¦ ÂüÁ¶ÇÑ´Ù.) %Oracle 8i¸¦ Install ½Ã »ç¿ëÇÏ°Ô µÇ´Â Oracle universal Installer´Â Graphic User Interface ȯ°æ¿¡¼ ¼öÇàµÇ´Â Java applicationÀÌ´Ù. ¶§¹®¿¡ Install ½ÃÀÛ ½Ã CD·ÎºÎÅÍ JRE¸¦ ±¸¼ºÇϱâ À§ÇØ JAVA virtual machineÀ» loadÇÑ ÈÄ installer°¡ ¼öÇàÀÌ µÈ´Ù. 2. Oracle owner »ý¼º Oracle 8i¸¦ installÇϱâ À§ÇÏ¿© ¸ÕÀú dba group¿¡ ¼ÓÇÏ´Â, ¿¹¸¦ µé¾î oracle À̶ó´Â unix °èÁ¤À» »ý¼ºÇÏ¿©¾ß Çϸç oracle shell parameterµéÀÌ ¼³Á¤µÇ¾îÁ®¾ßÇÑ´Ù. ¿¹ > HOME=/oracle4/ora8i PATH=/usr/bin::/usr/bin:/oracle4/ora8i/app/oracle/product/8.1.5/bin: /opt/bin:/bin:/etc:/usr/bin/X11:/usr/ccs/bin:/usr/openwin/bin: /usr/dt/bin:/usr/include:. LOGNAME=oracle8i HZ=100 TERM=vt100 TZ=ROK SHELL=/usr/bin/csh MAIL=/var/mail/oracle8i LANG=ko DISPLAY=152.69.30.100:0 PWD=/oracle4/ora8i USER=oracle8i EDITOR=/usr/bin/vi ORACLE_HOME=/oracle4/ora8i/app/oracle/product/8.1.5 ORACLE_SID=ORA815 ORACLE_TERM=vt100 #NLS_LANG=American_America.US7ASCII ORA_NLS33=/oracle4/ora8i/app/oracle/product/8.1.5/ocommon/nls/admin/data ORACLE_OWNER=oracle8i TNS_ADMIN=/oracle4/ora8i/app/oracle/product/8.1.5/network/admin LD_LIBRARY_PATH=/oracle4/ora8i/app/oracle/product/8.1.5/lib: /usr/openwin/lib:/usr/bin:/usr/lib TMPDIR=/tmp ORATAB_FAIL=TRUE DISPLAY parameter( 3. Oracle Universal Installer ¼öÇà 3.1 ÀÌÁ¦ X-Windows ȯ°æ¿¡¼ oracle owner user shellÀ» ¶ç¿î ÈÄ staged directory³ª CD¿¡¼ installer¸¦ ¶ç¿î´Ù. CD-ROM mount-point directory¿¡¼ ´ÙÀ½°ú °°ÀÌ OUI¸¦ ½ÇÇàÇÑ´Ù. $./runInstaller 3.2 Welcome Screen Welcome ScreenÀÌ ³ªÅ¸³ª¸é next buttonÀ» ´©¸¥´Ù. 3.3 File Location screen Source path´Â ±×´ë·Î µÎ°í Destination Directory¿¡ $ORACLE_HOMEÀ¸·Î ÁöÁ¤µÈ °ªÀÌ ³ªÅ¸³µ´ÂÁö È®ÀÎÇÑ ÈÄ Next buttonÀ» ¼±ÅÃÇÑ´Ù. ¸¸ÀÏ Oracle 8i¸¦ óÀ½ installÇÏ´Â °æ¿ì ÀÌ ´Ü°è¿¡¼ orainventory directory À§Ä¡¿¡ ´ëÇÑ pointer fileÀ» »ý¼ºÇϱâ À§ÇÏ¿© root user·Î /tmp/oraintRoot.sh¸¦ ¼öÇàÇØ¾ß ÇÒ °ÍÀÌ´Ù. 3.4 Available Products Screen install Oracle 8i Enterprise Edition 8.1 ÀÌ ¼±ÅõǾîÁ® ÀÖÀ» °ÍÀÌ´Ù. Next buttonÀ» ¼±ÅÃÇÑ´Ù. 3.5 Installation Type screen CustomÀ» ¼±ÅÃÇÑ´Ù. ¸¸¾à typicalÀ» ¼±ÅÃÇÏ°Ô µÇ¸é nls charactersetÀÌ US7ASCII·Î ÁöÁ¤ÀÌ µÉ °ÍÀ̸ç tablespaceÀÇ Å©±â°¡ default·Î ÁöÁ¤ÀÌ µÉ °ÍÀÌ´Ù. Next buttonÀ» ¼±ÅÃÇÑ´Ù. 3.6 Available Product Component screen JDBC driverµéÀ» ¸ðµÎ ¼±ÅÃÇÑ´Ù. ¼±ÅõǾîÁø product component ¿Ü Ãß°¡ÀûÀ¸·Î installÀ» ¿øÇÏ´Â product ComponentµéÀ» ¼±ÅÃÇÑ´Ù. Next buttonÀ» ¼±ÅÃÇÑ´Ù. 3.7 Authetication Methods screen Next buttonÀ» ¼±ÅÃÇÑ´Ù. 3.8 Privileged Operating System Groups Unix GroupÀÌ dbaÀÎÁö È®ÀÎÇÑ´Ù. Next buttonÀ» ¼±ÅÃÇÑ´Ù. 3.9 Create Database screen 'Yes' radio button¸¦ ¼±ÅÃÇÑ´Ù. 3.10 Database Identification screen Global Database nameÀ» ±âÀÔÇÑ´Ù. <$ORACLE_SID>. Next buttonÀ» ¼±ÅÃÇÑ´Ù. 3.11 Database File Location screen datafileµéÀÌ »ý¼ºµÉ directory¸¦ ±âÀÔÇÑ´Ù. 3.12 Oracle Protocol Support screen network protocolÀ» ¼±ÅÃÇÑ´Ù. Next buttonÀ» ¼±ÅÃÇÑ´Ù. 3.13 Summary screen Install buttonÀ» ¼±ÅÃÇÑ´Ù. 3.14 running root.sh dialog box installationÀÌ ³¡³ª¸é root.sh¼öÇà dialog box°¡ ¶ã°ÍÀÌ´Ù. 'OK'¸¦ ¼±ÅÃÇÑÈÄ Next buttonÀ» ¼±ÅÃÇÑ´Ù. 4. Oracle Database Configuration Assistant(DBCA) OUI´Â database »ý¼º ÀÛ¾÷À» ÇÏÁö ¾Ê´Â ´ë½Å DBCA¿¡¼ database »ý¼º ÀÛ¾÷ÀÌ ÀÌ·ç¾îÁø´Ù. DBCA´Â Install ÈÄ $ORACLE_HOME/bin/dbassist ¸¦ ¼öÇàÇÏ¿© »ç¿ëÀÌ °¡´ÉÇÏ´Ù. 4.1 Configuration Tools screen Oracle Net8 Configuration Assistant dialog box°¡ ¶ã °ÍÀÌ¸ç ¿©±â¼ Net8¿¡ ´ëÇÑ ¼³Á¤ÀÌ °¡´ÉÇÏ´Ù. 4.2 Oracle Database Configuration Assistant Database »ý¼º ÀÛ¾÷ÀÌ ÀÌ·ç¾îÁø´Ù. »ý¼º ÀýÂ÷´Â ´ÙÀ½°ú °°´Ù. 1) Oracle Database Configuration Assistant°¡ ½ÃÀ۵Ǹé CustomÀ» ¼±ÅÃÇÑ ÈÄ Next buttonÀ» ¼±ÅÃÇÑ´Ù. 2) µ¿½Ã »ç¿ëÀÚ ¼ö(default : 15)¸¦ ÁöÁ¤ÇÑ´Ù. 3) shared/dedicated server modeÁß Çϳª¸¦ ¼±ÅÃÇÑ´Ù. IIOP¸¦ »ç¿ëÇÏ´Â °æ¿ì Shared Server mode¸¦ ¼±ÅÃÇÏ¿©¾ß ÇÒ °ÍÀÌ´Ù. 4) Global Database Name°ú SID°¡ Á¤È®È÷ ¼³Á¤µÇ¾î ÀÖ´ÂÁö È®ÀÎÇÏ°í ÃʱâÈ file À̸§Àº ±×´ë·Î µÐ´Ù. 5) compatible parameter °ªÀº ±×´ë·Î µÎ°í Change Character SetÀ» ¼±ÅÃÇÑ´Ù. default´Â US7ASCIIÀÌ´Ù. ¸¸ÀÏ NLS charater set ¹× national charactersetÀ» º¯°æÇÏ°íÀÚ ÇÏ´Â °æ¿ì ¼öÁ¤À» ÇÑ´Ù. 6) Tablespace¿¡ ´ëÇÑ size¸¦ È®ÀÎÇÑ ÈÄ ÇÊ¿äÇÑ °æ¿ì ¼öÁ¤ÇÑ´Ù. default·Î USERS tablespaceÀÇ °æ¿ì 10M·Î µÇ¾î ÀÖ´Ù. 7) redo log file¿¡ ´ëÇÑ size¸¦ È®ÀÎÇÑ ÈÄ ÇÊ¿äÇÑ °æ¿ì ¼öÁ¤ÇÑ´Ù. 8) Finish buttonÀ» ¼±ÅÃÇÑ´Ù. 9) database »ý¼º ÀÛ¾÷ÀÌ Á¾·áµÇ¸é $ORACLE_HOME/install diretory¿¡¼ installation log fileµéÀ» È®ÀÎÇØ º»´Ù. 5. post configuring Oracle8i install ÀÛ¾÷ÀÌ Á¾·áµÇ¸é root user·Î $ORACLE_HOME¿¡ À§Ä¡ÇÑ root.sh¸¦ ¼öÇàÇÑ´Ù. |