http://www.hackerschool.org/HS_Boards/zboard.php?id=Free_Lectures&no=245 [º¹»ç]
Áß¿ä»çÇ×:
°¢ Oracle8i Á¦Ç°¿¡ ÇÊ¿äÇÑ Çϵåµð½ºÅ© ÇÊ¿ä·®¿¡¼ JRE(Java Runtime Environment) ¹× OUI(Oracle Universal Installer)¸¦ OS°¡ ¼³Ä¡µÈ ÆÄ Æ¼¼Ç¿¡ ¼³Ä¡Çϱâ À§ÇØ 25MBÁ¤µµ°¡ Ãß°¡·Î ÇÊ¿ä
Oracle 8i Enterprise Edition for Windows NT
¿ä±¸»çÇ× ¼¼ºÎ³»¿ª
Operating System Windows NT4.0 Service Pack4ÀÌ»ó, Windows 2000
Processor ÃÖ¼Ò Pentium 166 ȤÀº 200 (PentiumII 266ÀÌ»ó ±ÇÀå)(*)
RAM 96 MB (256MB ÀÌ»ó ±ÇÀå)
Hard disk Typical Installation: 961MB(+22MB system drive)(**) Minimal installation: 758MB(+21MB system drive). Custom installation: ¼±ÅÃÇÑ Á¦Ç°¿¡ µû¶ó ´Ù¸§
Web browser Microsoft Internet Explorer release 4.x ÀÌ»ó Netscape Communicator release 4.0.5 ÀÌ»ó
Video 16 colorÀÌ»ó
Microsoft Visual C++ 5.0ȤÀº 6.0 Oracle AppWizard for Microsoft Visual C++ ¼³Ä¡ ½Ã ÇÊ¿ä
(*) µ¿ÀÏÇÑ ÄÄÇ»ÅÍ »ó¿¡¼ Oracle Intelligent Agent, Oracle Management Server, ±×¸®°í Oracle Enterprise Manager Client¸¦ ½ÇÇàÇÏ·Á¸é Pentium II 400ÀÌ»óÀ» »ç¿ëÇÏ±æ ±Ç°íÇÔ.
(**) Oracle Enterprise Manager Console, ÅëÇÕµÈ ¾îÇø®ÄÉÀ̼Ç, DBA Management Pack ¹× repository¸¦ À§ÇÑ 200MB¸¦ Æ÷ÇÔ.
Oracle 8i Client for Windows NT and Windows 95/98
¿ä±¸»çÇ× Administrator Programmer Application User
Operating System Windows NT4.0 Service Pack4 ÀÌ»ó,Windows 2000, Windows 95, Windows 98 Windows NT4.0 Service Pack4ÀÌ»ó,Windows 2000 , Windows 95, Windows 98 Windows NT4.0 Service Pack4ÀÌ»ó, Windows 2000, Windows 95, Windows 98
Processor Pentium 166(PII 266±ÇÀå) Pentium 133(P 166±ÇÀå) Pentium 133(P166±ÇÀå)
RAM 64 MB 32 MB(64MB ±ÇÀå) 32 MB(64MB ±ÇÀå)
Hard disk 201MB (*) (+18MB system drive) 100MB (+16MB system drive) 46.6MB (+15MB system drive)
(*) Oracle Enterprise Manager Console, ÅëÇÕµÈ ¾îÇø®ÄÉÀ̼Ç, DBA Management Pack ¹× repository¸¦ À§ÇÑ 200MB¸¦ Æ÷ÇÔ.
Oracle8i Management Infrastructure
¿ä±¸»çÇ× Oracle Management Server Oracle Internet Directory(*)
Operating System Windows NT4.0 Service Pack4 ÀÌ»ó, Windows 2000 Windows NT4.0 Service Pack4 ÀÌ»ó, Windows 2000
Processor Pentium 166 (PII 300±ÇÀå) Pentium 166 (PII 300±ÇÀå)
RAM 64 MB 96 MB
Hard disk 225 MB (+ 14 MB system drive) 938 MB (+ 11 MB system drive)
Web browser Microsoft Internet Explorer 4.x ÀÌ»ó Netscape Communicator release 4.0.5 ÀÌ»ó ÇÊ¿ä ¾øÀ½
Web Server Oracle Application Server 4..0.8 Internet Information Server (IIS) 4.0 ÇÊ¿ä ¾øÀ½
(*) Oracle Internet Directory´Â Oracle8i database release 8.1.6À» ÇÊ¿ä·Î ÇÔ. ¸¸¾à µ¥ÀÌÅͺ£À̽º °¡ ¼³Ä¡ µÇ¾î ÀÖÁö ¾Ê°í ÀÌ Ç׸ñÀ» ¼±ÅÃÇÑ °æ¿ì, ÀÚµ¿À¸·Î µ¥ÀÌÅͺ£À̽º°¡ ¼³Ä¡µÇ°Ô µÈ´Ù.
Áß¿ä»çÇ×: Oracle8i database release 8.1.6Àº Oracle Internet Directory 2.0.6°ú ȣȯµÈ´Ù. ÀÌÀü ¹öÀüÀÇ Oracle Internet Directory¸¦ 2.0.6À¸·Î ¾÷±×·¹À̵å ÇÏ¿©¼ Oracle8i 8.1.6°ú »ç¿ëÇÒ ¼ö´Â ¾ø´Ù.
±âŸ Á¦Ç°
Oracle database¸¦ ¼³Ä¡ÇÏ¸é¼ ÇÔ²² ¼³Ä¡ÇÒ ¼ö ÀÖ´Â ±âŸ Á¦Ç°µé¿¡´Â ´ÙÀ½°ú °°Àº °ÍÀÌ ÀÖ´Ù. ÀÌµé °¢°¢¿¡ ´ëÇÑ ¼³Ä¡°ü·Ã Á¤º¸´Â ÇØ´ç µµÅ¥¸ÕÆ®¸¦ ÂüÁ¶Çϵµ·Ï ÇÑ´Ù.
Oracle Parallel Server
Oracle Enterprise Manager
Recovery Manager
Oracle Parallel Server
Oracle Parallel Server¸¦ ¼³Ä¡ÇÏ·Á°í Çϸé Oracle8i Parallel Server Setup and Configuration Guide¸¦ ÂüÁ¶ Çϵµ·Ï ÇÑ´Ù.
Recovery Manager
Recovery Manager¸¦ ¼³Ä¡ÇÏ·Á¸é Legato Storage Manager for Oracle°°Àº ¹Ìµð¾î °ü¸® ·¹À̾ ÇÊ¿äÇÏ´Ù. ÀÌ °ÍÀº Oracle8i Enterprise Edition CD-ROM¿¡ Æ÷ÇԵǾî ÀÖ´Ù. º¸´Ù ÀÚ¼¼ÇÑ Á¤º¸´Â Oracle8i Enterprise Edition CD-ROM¿¡ Æ÷ÇÔµÈ Legato µµÅ¥¸ÕÆ®¸¦ ÂüÁ¶Çϵµ·Ï ÇÑ´Ù.
±âŸ »çÇ×
¼³Ä¡ ÀÛ¾÷ ½Ã¿¡´Â ¹Ýµå½Ã Administrator±ÇÇÑÀÌ ÀÖ´Â »ç¿ëÀÚ·Î ½Ç½ÃÇÏ¿©¾ß ÇÑ´Ù.
À̹ø ¸±¸®½º¿¡ Ãß°¡µÈ Á¦Ç°ÇöȲ
»õ Á¦Ç° ¼³¸í ÂüÁ¶
Oracle Provider for OLEDB ¾îÇø®ÄÉÀ̼Ç, ÄÄÆÄÀÏ·¯, ±×¸®°í ±âŸ µ¥ÀÌÅͺ£À̽º ÄÞÆ÷³ÍÆ®¿¡¼ Oracle DB¿¡ ´ëÇØ È¿°úÀû ¾×¼¼½º ¹æ¹ý ¹× ³ôÀº ¼º´ÉÀ» Á¦°øÇÑ´Ù. Oracle Provider for OLE DB User¡¯s Guide
Active Directory Support »ç¿ëÀÚ µé·Î ÇÏ¿©±Ý µ¥ÀÌÅͺ£À̽º ¼ºñ½º ¹× Net8 ¼ºñ½º ¸íÀ» Active Directory ÀÇ ¿ÀºêÁ§Æ®·Î ÀúÀåÇÒ ¼ö ÀÖ°Ô ÇØ ÁØ´Ù. Oracle8i Administrator¡¯s Guide for Windows NTÀÇ Á¦4Àå.
Windows native authentication enhancements Active Directory¸¦ »ç¿ëÇÒ ¶§ Windows 2000 µµ¸ÞÀο¡¼ Á¦°øÇÏ´Â Windows native authenticationÀÇ global user authentication ¹× role authorizationÀ» Áö¿øÇÑ´Ù. Oracle8i Administrator¡¯s Guide for Windows NTÀÇ Á¦8Àå.
Âü°í: ¸ðµç ¿î¿µÃ¼Á¦¿¡ ´ëÇØ °øÅëÀÎ »õ·Î¿î ÄÞÆ÷³ÍÆ®¿¡ ´ëÇÑ ³»¿ªÀº Getting to know Oracle8i¸¦ ÂüÁ¶Çϱ⠹ٶõ´Ù.
µµÅ¥¸ÕÆ® ¼±Åà ¿ä·É
¿øÇÏ´Â Á¤º¸ °ü·Ã µµÅ¥¸ÕÆ®
ÀÌÀü ¹öÀü¿¡¼ ¾÷±×·¹À̵å ȤÀº ¸¶À̱׷¹ÀÌ¼Ç Oracle8i Migration (*)Âü°í: ÀÌÀü ¹öÀüÀÌ ÀÖ´Â °æ¿ì Oracle Data Migration Assistant°¡ ÀÚµ¿À¸·Î °¨ÁöÇÏ¿© ¾Ë·ÁÁÜ
µ¿ÀÏ ÄÄÇ»ÅÍ »ó¿¡ º¹¼ö°³ÀÇ Oracle Home¿¡ ´ëÇØ Oracle ÄÞÆ÷³ÍÆ®¸¦ ¼³Ä¡ Oracle8i Administrator¡¯s Guide for Windows NTÀÇ Á¦3Àå
CD-ROM»óÀÇ ¸ðµç ¿À¶óŬ Á¦Ç°À» ¼³Ä¡ Oracle8i Installation Guide for Windows NT ÀÇ Á¦5Àå
¿À¶óŬ µ¥ÀÌÅͺ£À̽ºÀÇ ±âº» °³³ä ¹× °ü¸®¹æ¹ý Oracle8i Concepts, Oracle8i Administrator¡¯s Guide, Oracle8i Administrator¡¯s Guide for Windows NT
Networking °³³ä ¹× °ü¸® Net8 Administrator¡¯s Guide
Oracle Enterprise Manager °³³ä ¹× °ü¸® Oracle Enterprise Manager Concepts Guide, Oracle Enterprise Manager Administrator¡¯s Guide, Oracle Enterprise Manager Configuration Guide
2 ȯ°æ ¼³Á¤
´Ù¸¥ OS¿ë OracleÁ¦Ç°°ú´Â ´Þ¸® Windows NT¿ëÀº º°µµÀÇ È¯°æ¼³Á¤ÀÌ ÇÊ¿äÇÏÁö ¾Ê´Ù.
3 ¼³Ä¡ ÀÛ¾÷
¼³Ä¡´Â OUI(Oracle Universal Installer)¸¦ ½ÇÇàÇÏ¿© ¼öÇàÇÑ´Ù. OUI¸¦ ¼öÇàÇϱâ À§Çؼ´Â
Adminstrator ±ÇÇÑÀÌ ÀÖ´Â °èÁ¤À¸·Î ·Î±×ÀÎ ÇÑ´Ù.
Á¦Ç° CD-ROMÀ» »ðÀÔÇÑ´Ù.
OUI°¡ ÀÚµ¿ ½ÇÇà µÈ´Ù.
OUIÀÇ ¼öÇà
OUI¸¦ ½ÇÇàÇϱâ À§Çؼ´Â Administrator±ÇÇÑÀÌ ÀÖ´Â °èÁ¤À¸·Î ·Î±×ÀÎÇÏ¿© CD-ROM À» »ðÀÔÇÑ´Ù. ±×·¯¸é ´ÙÀ½ÆäÀÌÁö ±×¸² 3-1°ú °°Àº À©µµ¿ì°¡ ³ªÅ¸³´Ù. Ȥ½Ã autorun±â´ÉÀ» »ç¿ëÇÒ ¼ö ¾ø´Â °æ¿ì¿¡´Â Ž»ö±â³ª ³»ÄÄÇ»ÅÍ¿¡¼ CD-ROMÀ» ¿¬ ´ÙÀ½ setup.exe¸¦ ´õºí Ŭ¸¯ÇÑ´Ù. ±×·¯¸é ±×¸² 3-2¿Í °°Àº À©µµ¿ì°¡ ³ªÅ¸³´Ù.
¼³Ä¡ÀÛ¾÷ ½ÃÀÛ
[±×¸²3-1] Main Menu Window
Oracle8i Enterprise Edition CD-RomÀ» »ðÀÔÇÏ¸é ´ÙÀ½°ú °°Àº À©µµ¿ì°¡ Ç¥½ÃµÈ´Ù. ¿©±â¿¡¼ Install/Deinstall Products¸¦ ¼±ÅÃÇϸé OUI°¡ ½ÃÀ۵ȴÙ. Explorer CD´Â CDÀÇ ³»¿ëÀ» º¸´Â °ÍÀÌ°í Browse Documentation Àº °¢Á¾ µµÅ¥¸ÕÆ®¸¦ ÂüÁ¶ÇÏ´Â °ÍÀÌ´Ù.
OUI ÀÇ Ãʱâȸé
[±×¸²3-2 Ãʱâ ȸé]
±âÁ¸¹öÀüÀÇ ÀνºÅç·¯°¡ Java-baseÀÇ OUI(Oracle Universal Installer)·Î ¹Ù²î¾ú´Ù.
óÀ½À¸·Î ¼³Ä¡ÇÏ´Â °æ¿ì ´ÙÀ½ ¹öÆ°À» ´©¸¥´Ù. Á¦Ç° ¼³Ä¡ Á¦°Å¡¦ ¹öÆ°Àº ±âÁ¸¿¡ ¼³Ä¡µÈ Á¦Ç°À» »èÁ¦ÇÒ ¶§ »ç¿ëÇÏ°í, ¼³Ä¡µÈ Á¦Ç°¡¦ ¹öÆ°Àº ±âÁ¸¿¡ ¼³Ä¡µÈ Á¦Ç°ÀÇ ³»¿ëÀ» º¸´Â °ÍÀÌ´Ù.
ÆÄÀÏ À§Ä¡
[±×¸² 3-3 ÆÄÀÏ À§Ä¡ÁöÁ¤]
¼³Ä¡ÇÒ Á¦Ç°ÀÌ µé¾î ÀÖ´Â À§Ä¡¸¦ ÁöÁ¤ÇÏ°í Á¦Ç°ÀÌ ¼³Ä¡µÉ ORACLE_HOME µð·ºÅ丮¸¦ ÁöÁ¤ÇÑ ´ÙÀ½ Next ¹öÆ°À» ¼±ÅÃÇÏ¿© ´ÙÀ½À¸·Î ÁøÇàÇÑ´Ù. Âü°í·Î ORACLE_BASE¶ó´Â ȯ°æº¯¼ö¸¦ ÁöÁ¤ÇÑ °æ¿ì¿¡´Â Path: ºÎºÐ¿¡ ORACLE_BASEÀÇ È¯°æº¯¼ö °ªÀÌ ÀÚµ¿À¸·Î Ç¥½ÃµÇ¹Ç·Î ÀÌ º¯¼ö °ª ´ÙÀ½¿¡ ÇØ´ç °æ·Î(¿¹:/home/ora815)¸¦ Ãß°¡ÇÏ¸é µÈ´Ù.
Á¦Ç°Á¤º¸ ·Îµù
[±×¸² 3-4 Á¦Ç° Á¤º¸ ·Îµù]
¼³Ä¡¿¡ »ç¿ëÇÒ Á¦Ç° Á¤º¸¸¦ ·ÎµåÇÑ´Ù. ¼³Ä¡ °¡´ÉÇÑ Á¦Ç°ÀÇ ¸ñ·ÏÀ» ÀÐ¾î µéÀδÙ.
¼³Ä¡ °¡´É Á¦Ç° ¼±ÅÃ
[±×¸² 3-5 ¼³Ä¡ °¡´É Á¦Ç° ±¸ºÐ]
µ¥ÀÌÅͺ£À̽º¸¦ ±¸¼ºÇϱâ À§Çؼ´Â Oracle8i 8.1.5.0.0À» ¼±ÅÃÇÑ´Ù. Client/Serverȯ°æ±¸ÃàÀ» ¿øÇÏ´Â °æ¿ì¿¡´Â µ¥ÀÌÅͺ£À̽º ±¸¼ºÀÌ ³¡³ ´ÙÀ½ Client·Î »ç¿ëÇÒ ½Ã½ºÅÛ¿¡¼ OUI¸¦ »ç¿ëÇÏ¿© Oracle8i Client¸¦ ¼³Ä¡ÇÑ´Ù. Pro*C °°Àº °³¹ß ÅøÀÌ ÇÊ¿äÇÑ °æ¿ì¿¡´Â Oracle Programmer 8.1.5¸¦ ¼³Ä¡ÇÏ¸é µÈ´Ù.
¼³Ä¡ À¯Çü
[±×¸² 3-6 ¼³Ä¡ À¯Çü]
TypicalÀ» ¼±ÅÃÇÏ¸é °¢Á¾ ¼ÒÇÁÆ®¿þ¾î ¹× µ¥ÀÌÅͺ£À̽º¸¦ »çÀü¿¡ ±¸¼ºµÈ ÇüÅ·Π¼³Ä¡ÇØ ÁØ´Ù. MinimalÀº ÃÖ¼ÒÇÑÀÇ µ¥ÀÌÅͺ£À̽º ±â´É¸¸À» »ç¿ëÇÏ°íÀÚ ÇÒ ¶§ ¼±ÅÃÇÏ¸é µÈ´Ù. »ç¿ëÀÚ°¡ ¿øÇÏ´Â ÇüÅ·Π¿©·¯ °¡Áö ȯ°æÀÇ ¼¼ºÎÀûÀÎ ±¸¼ºÀ» ÇÏÀÚ¸é CustomÀ» ¼±ÅÃÇÑ´Ù. ¿©±â¿¡¼´Â CustomÀ» ±âÁØÀ¸·Î ¼³¸íÇÑ´Ù.
¼³Ä¡°¡´É Á¦Ç° ±¸¼º ¿ä¼Ò
[±×¸² 3-7 ¼³Ä¡ °¡´É Á¦Ç° ±¸¼º ¿ä¼Ò]
¼³Ä¡¸¦ ¿øÇÏ´Â Á¦Ç°¿¡ 4Ç¥½Ã¸¦ ÇÑ´Ù. Á¦Ç°¿¡ ´ëÇÑ ¼³¸íÀº ¸¶¿ì½ºÆ÷ÀÎÅ͸¦ °¡±îÀÌ °¡Á®°¡¸é À§ÀÇ ³ë¶õ ¹Ú½º¿¡¼Ã³·³ Ç¥½Ã°¡ µÈ´Ù. ±×·± ´ÙÀ½ ¿ìÃø »ó´ÜÀÇ ¾ð¾î ¼±ÅᦹöÆ°À» ´©¸¥´Ù.
¼³Ä¡°¡´É Á¦Ç° ±¸¼º ¿ä¼Ò(°è¼Ó)
[±×¸² 3-8 ¼³Ä¡ °¡´ÉÇÑ Á¦Ç° ¸ñ·Ï ¹× °ü·Ã Á¤º¸-¾ð¾î ¼±ÅÃ]
ÇÑ±Û µ¥ÀÌÅͺ£À̽º »ç¿ë, °¢Á¾ ¸Þ½ÃÁöÀÇ ÇÑ±Û ¹× ¿µ¹® »ç¿ëÀ» À§ÇØ ¿µ¾î¿Í ÇѱÛÀ» ¼±ÅÃÇÑ´Ù. Á¦Ç°¿¡¼ »ç¿ëÇÒ ¾ð¾î¸¦ ¼±ÅÃÇÑ´Ù. ±âº»ÀûÀ¸·Î ÇÑ±Û NT¿¡¼´Â Çѱ¹¾î°¡ ¼±ÅõǸç Ãß°¡·Î °ü¸®»óÀÇ ¸ñÀûÀ¸·Î ¿µ¾î¸¦ ¼±ÅÃÇÏ¿© ¸Þ½ÃÁö µîÀÇ ºÐ¼® ½Ã »ç¿ëÇÏ°Ô µÈ´Ù.
±¸¼º ¿ä¼Ò À§Ä¡
[±×¸² 3-9 ±¸¼º ¿ä¼Ò À§Ä¡ ÁöÁ¤]
ÀÌ È¸é¿¡ Ç¥½ÃµÈ ±¸¼º ¿ä¼ÒµéÀº ¿øÇÏ´Â À§Ä¡¿¡ ¼³Ä¡ ÇÒ ¼ö ÀÖ´Ù. Ưº°ÇÑ °æ¿ì°¡ ¾Æ´Ï¸é ±×³É ´ÙÀ½À» ´·¯ ÁøÇàÇϵµ·Ï ÇÑ´Ù.
Authentication Methods
[±×¸² 3-10 Authentication Methods]
ÀÌ È¸éÀº Oracle Advanced Security¸¦ ¼±ÅÃÇÏ¿´±â ¶§¹®¿¡ Ç¥½ÃµÈ´Ù. ÇØ´çÇ׸ñÀ» ¼±ÅÃÇϵ簡 ÇØ´ç»çÇ×ÀÌ ¾ø´Ù¸é ´ÙÀ½À» ´©¸¥´Ù.
OMS(Oracle Management Server ) ÀúÀå¼Ò
[±×¸² 3-11 OMS ÀúÀå¼Ò »ç¿ë¹æ¹ý ÁöÁ¤]
Oracle Management Server¸¦ »ç¿ëÇϱâ À§ÇÑ ÀúÀå¼Ò(Repository) »ç¿ë¹æ¹ýÀ» °áÁ¤ÇÑ´Ù. ÀÌÀü ¹öÀü¿¡¼ »ç¿ëÇÏ´ø ÀúÀå¼Ò¸¦ »ç¿ëÇÒ ¼öµµ ÀÖÀ¸¸ç »õ·Î ¼³Ä¡ÇÏ´Â °æ¿ì¿¡´Â »õ·Î¿î ÀúÀå¼Ò¸¦ ¼±ÅÃÇÑ´Ù, óÀ½ ¼³Ä¡ÇÏ´Â °æ¿ì¿¡´Â ȸ鿡¼Ã³·³ ¼±ÅÃÇÏ¸é µÈ´Ù.
µ¥ÀÌÅͺ£À̽º »ý¼º
[±×¸² 3-12 µ¥ÀÌÅͺ£À̽º ÀÛ¼º ¿©ºÎ ¼±ÅÃ]
Yes¸¦ ¼±ÅÃÇÏ¸é ±âº» ¼³Ä¡°úÁ¤ÀÌ ³¡³ ´ÙÀ½ ÀÚµ¿À¸·Î Database ÀÛ¼º°úÁ¤À» ½ÃÀÛ ÇÑ´Ù. No·Î ¼±ÅÃÇÑ °æ¿ì¿¡´Â ¼³Ä¡°úÁ¤ÀÌ ³¡³ ´ÙÀ½ Database Configuration Assistant(DBCA)¸¦ »ç¿ëÇÏ¿© ¸¸µé¾î¾ß ÇÑ´Ù. Ưº°ÇÑ °æ¿ì°¡ ¾Æ´Ï¶ó¸é Yes¸¦ ¼±ÅÃÇϵµ·Ï ÇÑ´Ù.
µ¥ÀÌÅͺ£À̽º ½Äº°
[±×¸² 3-13 µ¥ÀÌÅͺ£À̽º °íÀ¯¸íĪ ÁöÁ¤ ]
´Ù¸¥ µ¥ÀÌÅͺ£À̽º¿ÍÀÇ ±¸ºÐÀ» À§ÇÑ °íÀ¯ ¸íĪÀ» ÁöÁ¤ÇÑ´Ù. Global Database NameÀº µ¥ÀÌÅͺ£À̽º ¸íÀ» ÀǹÌÇϸç ÃßÈÄ, Net8 Ŭ¶óÀ̾ðÆ®¿¡¼ ¸®½º³Ê·ÎÀÇ Á¢¼ÓÀ» À§ÇÑ Á¤ÀÇ ½Ã ÀÌÀü¹öÀüÀÇ ORACLE_SID´ë½Å »ç¿ëµÈ´Ù. SID´Â µ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛ ¸íÀ» ¸»ÇÑ´Ù.
Oracle ÇÁ·ÎÅäÄÝ Áö¿ø
[±×¸² 3-14 Áö¿øµÇ´Â ³×Æ®¿öÅ© ÇÁ·ÎÅäÄÝ ¼±ÅÃȸé]
¼³Ä¡ÇÒ Ç׸ñÀ» ¸¶¿ì½º·Î ¼±Åà ÇÑ´Ù. ±âº»À¸·Î TCP/IP¿Í Named Pipes´Â ¼³Ä¡µÈ´Ù. ÇÊ¿ä¿¡ µû¶ó Ãß°¡ Çϵµ·Ï ÇÑ´Ù.
¼³Ä¡ Á¤º¸ ¿ä¾à
[±×¸² 3-15 ¼³Ä¡ÇÒ Á¦Ç°Á¤º¸ ¿ä¾à]
¼³Ä¡ÇÒ Á¦Ç°°ú °¢Á¾ °ü·Ã Á¤º¸°¡ Àϸñ¿ä¿¬ÇÏ°Ô Ç¥½ÃµÈ´Ù. À߸øµÈ °ÍÀÌ ÀÖÀ¸¸é ÀÌÀüÀ» ´·¯ ¼öÁ¤ÇÑ ´ÙÀ½ ÁøÇàÇÑ´Ù.
¼³Ä¡
[±×¸² 3-16 ¼³Ä¡ ½ÃÀÛ ]
¿©±âºÎÅÍ ½ÇÁ¦·Î ¼³Ä¡¸¦ ½ÃÀÛÇÑ´Ù. ¿¡·¯°¡ ¹ß»ýÇÒ °æ¿ì¿¡´Â À§ÀÇ È¸é¿¡¼ Ç¥½ÃµÇ´Â ·Î±×ÀÇ À§Ä¡¿¡¼ ÆÄÀÏÀ» ¿¬ ´ÙÀ½ ¿øÀÎÀ» ÆľÇÇÑ´Ù.
¼³Ä¡¿Ï·á
[±×¸² 3-17 ¼³Ä¡ ¿Ï·á]
¼ÒÇÁÆ®¿þ¾îÀÇ ¼³Ä¡°¡ ÀÌÁ¦ ¿Ï·áµÇ¾ú´Ù. ÇÏÁö¸¸ ¸®½º³Ê ¹× Database´Â »ý¼ºµÈ °ÍÀÌ ¾Æ´Ï¹Ç·Î ´ÙÀ½À» ´·¯ °è¼Ó ÁøÇàÇÏ¿©¾ß ÇÑ´Ù.
±¸¼º µµ±¸(Net8 ±¸¼º µµ±¸)
[±×¸² 3-18 Net8 ±¸¼º µµ±¸]
Net8±¸¼ºµµ±¸°¡ ÀÚµ¿À¸·Î ½ÃÀÛµÇ¾î¼ ¸®½º³Ê¸¦ ±¸¼ºÇØ ÁØ´Ù. ¿©±â¿¡¼´Â ´ÙÀ½À» ¼±ÅÃÇÑ´Ù.
Net8 Configuration Assistant :µð·ºÅ丮 ¼ºñ½º ¾×¼¼½º
[±×¸² 3-19 Net8 Configuration Assistant-µð·ºÅ丮 ¼ºñ½º ¾×¼¼½º ±¸¼º ]
OID(Oracle Internet Directory)¸¦ ±¸¼ºÇÒ °æ¿ì ¼±ÅÃÇÑ´Ù. ÃßÈÄ¿¡µµ ±¸¼º °¡´ÉÇÏ´Ù. µð·ºÅ丮 ¼ºñ½º¸¦ »ç¿ëÇÒ ¼ö Àִ ȯ°æÀÌ ¾Æ´Ñ °æ¿ì¿¡´Â ¾Æ´Ï¿À¸¦ ¼±ÅÃÇϵµ·Ï ÇÑ´Ù.
Net8 Configuration Assistant : Listener
[±×¸² 3-20 Net8 Configuration Assistant-¸íĪ]
¿øÇÏ´Â ¸®½º³Ê ¸íÀ» ÁöÁ¤ÇÑ´Ù. ±âº»°ªÀº LISTENERÀÌ´Ù.
Net8 Configuration Assistant : ÇÁ·ÎÅäÄÝ ¼±ÅÃ
[±×¸² 3-21 Net8 Configuration Assistant-Protocol]
¸®½º³Ê¿¡¼ »ç¿ëÇÒ ÇÁ·ÎÅäÄÝÀ» ¼±ÅÃÇÑ´Ù.
Net8 Configuration Assistant : Port No
[±×¸² 3-22 Net8 Configuration Assistant-Port ¹øÈ£]
Ŭ¶óÀ̾ðÆ®°¡ »ç¿ëÇÏ´Â TCP/IP Port¹øÈ£¸¦ ¼±ÅÃÇÑ´Ù. ±âº» °ªÀº 1521ÀÌ´Ù.
Net8 Configuration Assistant : ¸®½º³Ê Ãß°¡
[±×¸² 3-23 Net8 Configuration Assistant-¸®½º³Ê Ãß°¡]
Ãß°¡·Î ¸®½º³Ê¸¦ ±¸¼ºÇÒ °ÍÀÎÁö¸¦ °áÁ¤ÇÑ´Ù. ÃßÈÄ¿¡µµ ÇÊ¿äÇÒ °æ¿ì¿¡´Â Net8 Configuration Assistant¸¦ »ç¿ëÇÏ¿© ±¸¼ºÇÒ ¼ö ÀÖ´Ù. ´ÙÀ½À¸·Î ÁøÇàÇÑ´Ù.
Net8 Configuration Assistant : ¿Ï·á
[±×¸² 3-24 Net8 Configuration Assistant-¿Ï·á]
±¸¼ºÀÌ ¿Ï·áµÇ¾ú´Ù. ´ÙÀ½À¸·Î ÁøÇàÇÑ´Ù.
Net8 Configuration Assistant : Naming Method±¸¼º
[±×¸² 3-25 Net8 Configuration Assistant-Naming Methods]
Naming Method¸¦ ±¸¼ºÇÒ °ÍÀÎÁö¸¦ °áÁ¤ÇÑ´Ù. ȯ°æÀÌ ¸ÖƼ DBȯ°æÀÌ ¾Æ´Ï¶ó¸é ´ÙÀ½À¸·Î ÁøÇàÇÑ´Ù.
Net8 Configuration Assistant : Àüü¿Ï·á
[±×¸² 3-26 Net8 Configuration Assistant-¿Ï·á]
Àüü ±¸¼ºÀÌ ¿Ï·áµÇ¾ú´Ù. ¿Ï·á¸¦ ¼±Åà ÇÑ´Ù.
Oracle Database Configuration Assistant(DBCA- ÀÚµ¿½ÃÀÛ)
[±×¸² 3-27 DBCA-ÀÚµ¿½ÃÀÛ]
Database¸¦ ÀÛ¼ºÇϱâ À§ÇØ DBCA°¡ ÀÚµ¿À¸·Î ½ÃÀ۵ȴÙ.
Oracle Database Configuration Assistant(DBCA- Database Type)
[±×¸² 3-28 DBCA-»ý¼ºÇÒ µ¥ÀÌÅͺ£À̽º À¯Çü ¼±ÅÃ]
TypicalÀº ½Ã½ºÅÛÀÇ µðÆúÆ® °ªÀ¸·Î µ¥ÀÌÅͺ£À̽º¸¦ »ý¼ºÇϸç CustomÀº »ç¿ëÀÚ°¡ ¿øÇÏ´Â °ªÀ» Á÷Á¢ ¼³Á¤ÇÒ ¼ö ÀÖ´Ù. CustomÀ¸·Î ¼³Á¤ÇÒ °ÍÀ» ±Ç°íÇÑ´Ù. ¼±Åà ÈÄ ¡°´ÙÀ½(N)¡±À» ´©¸¥´Ù.
Oracle Database Configuration Assistant(DBCA-Database Environment )
[±×¸² 3-29 DBCA-µ¥ÀÌÅͺ£À̽º ȯ°æ ¼³Á¤ ȸé]
»ç¿ëÇÒ Æ®·£Àè¼ÇÀÇ À¯Çü¿¡ ¸Â°Ô ¼±ÅÃÇÑ´Ù. ¿©±â¿¡¼ ¼±ÅÃÇÑ ³»¿ë¿¡ µû¶ó µ¥ÀÌÅͺ£À̽º ºí·ÏÅ©±â°¡ °áÁ¤µÈ´Ù..
Oracle Database Configuration Assistant(DBCA-No of Database Users )
[±×¸² 3-30 DBCA-µ¥ÀÌÅͺ£À̽º »ç¿ëÀÚ ¼ö ¼³Á¤]
µ¥ÀÌÅͺ£À̽º·Î Á¢¼ÓÇÒ »ç¿ëÀÚ ¼ö¸¦ ÁöÁ¤ÇÑ´Ù. ÀÌ ¼ýÀÚ´Â ¹«Á¶°Ç ´Ã¸± ¼ö ÀÖ´Â °ÍÀÌ ¾Æ´Ï¶ó ¶óÀ̼±½º ±ÔÁ¤¿¡ µû¶ó¾ß ÇÑ´Ù.
Oracle Database Configuration Assistant(DBCA-Connection Mode)
[±×¸² 3-31 DBCA-Connection Mode ¼±ÅÃ]
Ŭ¶óÀ̾ðÆ®¿¡¼ ¼¹ö·ÎÀÇ Á¢¼Ó ½Ã »ç¿ëÇÒ Á¢¼Ó ¸ðµå¸¦ °áÁ¤ÇÑ´Ù. ÀϹÝÀûÀ¸·Î µ¿½Ã »ç¿ëÀÚ ¼ö°¡ Áß ´ëÇü±Þ ±Ô¸ðÀÎ °æ¿ì¿¡´Â °øÀ¯¼¹ö¸ðµå(Shared Service Mode) Áï, Multi-Threaded Server ¸ðµå·Î »ç¿ëÇÏ´Â °ÍÀÌ ¸®¼Ò½º Àý¾à Ãø¸é¿¡¼ À¯¸®ÇÏ¸ç ¼Ò±Ô¸ð ȯ°æÀÎ °æ¿ì¿¡´Â Àü¿ë ¼¹ö¸ðµå(Dedicated Server Mode)¸¦ »ç¿ëÇÏ´Â °ÍÀÌ ¹«³ÇÏ´Ù.
Oracle Database Configuration Assistant(DBCA-Database Options)
[±×¸² 3-32 DBCA-µ¥ÀÌÅͺ£À̽º ¿É¼Ç ¼±Åà ȸé]
¿øÇÏ´Â µ¥ÀÌÅͺ£À̽º ¿É¼ÇÀ» ¼±ÅÃÇÑ´Ù. ÀÌ ¶§µµ ÇØ´ç ¿É¼Ç¿¡ ´ëÇÑ ¶óÀ̼±½º¸¦ Ãëµæ ÇÏ¿´´Â°¡¸¦ È®ÀÎ ÈÄ ¼±ÅÃÇÑ´Ù.
Oracle Database Configuration Assistant(DBCA-Database Information)
[±×¸² 3-33 DBCA-µ¥ÀÌÅͺ£À̽º Á¤º¸ ¼öÁ¤ ȸé]
ȸ鿡 Ç¥½ÃµÈ Á¤º¸¸¦ È®ÀÎÇÑ ´ÙÀ½ ¼öÁ¤ÇÒ ³»¿ëÀÌ ÀÖÀ¸¸é ¼öÁ¤ÇÑ´Ù. ƯÈ÷ ¡°¹®ÀÚ ÁýÇÕ º¯°æ¡¦¡±À» ´·¯¼ ±¹°¡º° ¹®ÀÚ ÁýÇÕ(National Character Set)À» ¡°KO16KSC5601FIXED¡±·Î ¼³Á¤ÇÑ´Ù. ÀÌ °ÍÀº NCHAR³ª NVARCHAR2 ¹× NCLOB°°Àº data type À» »ç¿ëÇϱâ À§ÇØ ÇÊ¿äÇÏ´Ù.
Oracle Database Configuration Assistant(DBCA- INTERNAL password)
[±×¸² 3-34 DBCA-internal °èÁ¤ ¾ÏÈ£ÁöÁ¤]
OracleÀ» °ü¸®Çϱâ À§ÇÑ internal °èÁ¤ÀÇ ¾ÏÈ£¸¦ ¼³Á¤ÇÑ´Ù.
Oracle Database Configuration Assistant(DBCA-Control File)
[±×¸² 3-35 DBCA-Á¦¾î ÆÄÀÏ(Control file) ÆĶó¸ÞÅÍ ¼³Á¤]
ÄÜÆ®·ÑÆÄÀÏ¿¡¼ »ç¿ëµÉ µ¥ÀÌÅͺ£À̽º ÆÄÀÏ, ·Î±×ÆÄÀÏ ¸â¹öÀÇ ÃÖ´ë °³¼ö¸¦ ¼³Á¤ÇÑ´Ù.
Oracle Database Configuration Assistant(DBCA-Tablespace Information)
[±×¸² 3-36 DBCA-Å×ÀÌºí½ºÆäÀ̽º Á¤º¸]
°¢ Å×ÀÌºí½ºÆäÀ̽º º°·Î Å©±â ¹× °¢Á¾ °ø°£°ü·Ã ÆĶó¸ÞÅ͸¦ ¼öÁ¤ÇÑ´Ù. ±âº»¼³Ä¡ ÈÄ ¾÷¹«¿ëÀ¸·Î Å×ÀÌºí½ºÆäÀ̽º¸¦ Ãß°¡ÇÒ »ý°¢À̶ó¸é ÀÌ°÷¿¡ ÀÖ´Â ±âº» Å×ÀÌºí½ºÆäÀ̽ºµéÀÇ Å©±â¸¦ Ç¥Áغ¸´Ù ÃæºÐÇÏ°Ô Àâ¾ÆÁÖ´Â °ÍÀÌ ÁÁ´Ù.
Oracle Database Configuration Assistant(DBCA-Redo Log)
[±×¸² 3-37 ¸®µÎ·Î±× ÆÄÀÏ ]
¸®µÎ·Î±× ÆÄÀÏ°ü·Ã Á¤º¸¸¦ ¼öÁ¤ÇÑ´Ù. µ¥ÀÌÅͺ£À̽º¸¦ ±âº»º¸´Ù Å©°Ô »ç¿ëÇÒ »ý°¢À̶ó¸é ÀÌ°÷¿¡¼ ÃæºÐÇÑ Å©±â¸¦ ÁöÁ¤ÇÏ´Â °ÍÀÌ ÁÁ´Ù.
Oracle Database Configuration Assistant(DBCA-Checkpoint & Archive Log)
[±×¸² 3-38 DBCA-Checkpoint & Archive Log ¼³Á¤ ]
üũÆ÷ÀÎÆ®¸¦ ¹ß»ý½ÃÅ°´Â ÁÖ±â¿Í ¾ÆÄ«ÀÌºê ·Î±× °ü·Ã ÆĶó¸ÞÅ͸¦ ¼³Á¤ÇÑ´Ù. üũÆ÷ÀÎÆ® ¹ß»ýÁֱ⸦ ´ÊÃß·Á¸é Checkpoint interval°ªÀ» Å©°Ô ÁÖ¸é µÈ´Ù.
Oracle Database Configuration Assistant(DBCA-SGA Parameter)
[±×¸² 3-39 DBCA-SGA ÆĶó¸ÞÅÍ ¼³Á¤ ]
SGA¸¦ ±¸¼ºÇϱâÀ§ÇØ ÇÊ¿äÇÑ ÃʱâÈ ÆĶó¸ÞÅ͵éÀ» ¼³Á¤ÇÑ´Ù. ÀϹÝÀûÀ¸·Î SGA´Â Àüü °¡¿ë ¸Þ¸ð¸®ÀÇ 1/2ÀÌ»ó »ç¿ëÇÏÁö ¾Êµµ·Ï ÇÑ´Ù. ȸ鿡¼ Å©±â·Î ³¡³ªÁö ¾Ê´Â ÆĶó¸ÞÅ͵éÀº °³¼ö¸¦ ÁöÁ¤ÇÑ´Ù. ÀÌÀü ȸ鿡¼ ·Î±×ÆÄÀÏÀÇ Å©±â¸¦ º¯°æÇÑ °æ¿ì¿¡´Â °°Àº ºñÀ²·Î ·Î±× ¹öÆÛ Å©±â(¹ÙÀÌÆ®)µµ ¼öÁ¤ÇÑ´Ù. ¸¸¾à OLTP¼º ¾÷¹«¿¡ »ç¿ëÇÒ °Å¶ó¸é ºí·Ï Å©±â(¹ÙÀÌÆ®)¸¦ ±âº»(2048)¿¡ °¡±õ°Ô, DSS¼º ¾÷¹«¿¡ »ç¿ëÇÒ °Å¶ó¸é 16K¿¡ °¡±õ°Ô »ç¿ëÇÏ¸é µÈ´Ù. È¥ÇÕÇü(Hybrid) ÇüÅÂÀÎ °æ¿ì¿¡´Â ÀûÀýÇÑ Áß°£Ä¡¸¦ ã¾Æ³»¼ ÁöÁ¤ÇÑ´Ù.
Oracle Database Configuration Assistant(DBCA-Trace)
[±×¸² 3-40 DBCA-Trace ÆÄÀÏ µð·ºÅ丮 ÁöÁ¤]
½Ã½ºÅÛ µð¹ö±ëÀ» À§ÇÑ Trace ÆÄÀÏÀÌ ÀúÀåµÉ Àå¼Ò¸¦ ÁöÁ¤ÇÑ´Ù.
Oracle Database Configuration Assistant(DBCA-½ÇÇà ¹æ¹ý)
[±×¸² 3-41 DBCA-½ÇÇà ¹æ¹ý ¼±ÅÃ]
°è¼ÓÇؼ Database¸¦ ÀÛ¼ºÇÒ °ÍÀÎÁö, ¾Æ´Ï¸é °ü·Ã ÆÄÀϵéÀ» ÀúÀåÇÑ ´ÙÀ½ ´Ù¸¥ â¿¡¼ ½ÇÇàÇÒ °ÍÀÎÁö¸¦ °áÁ¤ÇÑ´Ù. Ưº°ÇÑ °æ¿ì°¡ ¾Æ´Ï¶ó¸é ¡°´ÙÀ½¡±À» ´·¯ °è¼ÓÁøÇàÇϸé Áö±Ý±îÁö ÁöÁ¤ÇÑ Á¤º¸¿¡ ¸Â°Ô µ¥ÀÌÅͺ£À̽º°¡ ÀÛ¼ºµÈ´Ù. ÇÏÁö¸¸ ¼÷·ÃµÈ »ç¿ëÀÚ¶ó¸é ÀÏ´Ü ÀúÀåÇÑ ´ÙÀ½ ÇØ´ç ÆÄÀÏÀÇ ³»¿ëÀ» ¿øÇϴ ȯ°æ¿¡ ¸Âµµ·Ï º¸´Ù ¼¼¹ÐÇÏ°Ô ¼öÁ¤ÇÑ ´ÙÀ½ ½ÇÇàÇÏ´Â °Íµµ °¡´ÉÇÏ´Ù.
Oracle Database Configuration Assistant(DBCA-Alert)
[±×¸² 3-42 DBCA-µ¥ÀÌÅͺ£À̽º ÀÛ¼º ¾Ë¸² Ç¥½Ã]
µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇÏ°Ú´Ù´Â ¾Ë¸² Ç¥½ÃÀÌ´Ù. ¡°Yes¡±¸¦ ´·¯ ÁøÇàÇÑ´Ù.
Oracle Database Configuration Assistant(DBCA-Progress)
[±×¸² 3-43 DBCA-µ¥ÀÌÅͺ£À̽º ÀÛ¼º ÁøÇàȸé]
µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇϱâ À§ÇÑ °¢°¢ÀÇ °úÁ¤ÀÌ ÁøÇàµÈ´Ù. ȸ鿡 ³ª¿µÈ Ç׸ñÀ» ¼ø¼´ë·Î ó¸®ÇÑ´Ù.µ¥ÀÌÅÍ µñ¼Å³Ê¸® ºä »ý¼º ¹× Oracle JServer Ãß°¡¿¡ ´Ù¼Ò ¸¹Àº ½Ã°£ÀÌ ¼Ò¿äµÇ°í, ±× ¿ÜÀÇ Ç׸ñµéÀº ¾à°£ÀÇ Ã³¸®½Ã°£ÀÌ ¼Ò¿äµÈ´Ù.
Oracle Database Configuration Assistant(DBCA-Listener Start)
[±×¸² 3-44 DBCA- ¸®½º³Ê ±âµ¿ ]
ÀÛ¾÷À» ¿Ï·áÇÔ¿¡ ¾Õ¼ ¿ø°ÝÁö¿¡¼µµ µ¥ÀÌÅͺ£À̽º¸¦ °ü¸®ÇÒ ¼ö ÀÖµµ·Ï ¸®½º³Ê¸¦ º¯°æµÈ ȯ°æ¿¡ ¸Â°Ô Àç±âµ¿ ½ÃŲ´Ù. Yes¸¦ ¼±ÅÃÇÑ´Ù.
Oracle Database Configuration Assistant(DBCA-Completion Alert)
[±×¸² 3-45 DBCA-ÀÛ¾÷ Á¾·á ¾È³» ȸé]
ÀÛ¾÷ÀÌ ³¡³ª¸é ±×¸²°ú °°Àº ¾Ë¸² Ç¥½Ã°¡ ³ªÅ¸³´Ù. ¿©±â¿¡ Ç¥½ÃµÇ´Â Á¤º¸´Â µû·Î ¸Þ¸ðÇØ µÎ°Å³ª ¾Ï±âÇØ µÎ´Â °ÍÀÌ ÁÁ´Ù. ¡°OK¡±¸¦ ¼±ÅÃÇÏ¸é ¼³Ä¡´Â ¿©±â¼ ³¡³ª°í ÀüüÀÛ¾÷¿¡ ´ëÇÑ Á¤º¸¸¦ º¸¿©Áִ ȸéÀÌ Ç¥½ÃµÇ°í ¼³Ä¡°¡ ¿ÏÀüÈ÷ ³¡³´Ù.
Oracle Database Configuration Assistant(DBCA-ÀÛ¾÷°á°ú)
[±×¸² 3-46 DBCA-ÀÛ¾÷ °á°ú ¾È³»]
ÀÛ¾÷ÀÌ ¼º°øÀûÀ¸·Î ³¡³µ´ÂÁö¸¦ ¾Ë·ÁÁִ ȸéÀÌ´Ù. »óÅ¿¡¼ ¼º°øÀÌ¸é ´ÙÀ½À» ¼±ÅÃÇÏ¿© °è¼Ó ÁøÇàÇÑ´Ù.
Oracle Database Configuration Assistant(DBCA-¼³Ä¡¿Ï·á)
[±×¸² 3-47 DBCA-¼³Ä¡ ÀÛ¾÷ Á¾·á ¾È³» ȸé]
¼³Ä¡ ¹× ±âº» ±¸¼ºÀÌ ¿ÏÀüÈ÷ ³¡ÀÌ ³µÀ¸¸ç Á¾·á¸¦ ¼±ÅÃÇϰųª ´ÙÀ½¼³Ä¡¸¦ ¼±ÅÃÇÏ¿© Ãß°¡·Î ´Ù¸¥ Á¦Ç°À» ¼³Ä¡ÇÒ ¼öµµ ÀÖ´Ù..
4. µ¥ÀÌÅͺ£À̽º ±âµ¿°ú Á¾·á
¼³Ä¡ °úÁ¤ Áß¿¡ ÀÌ¹Ì µ¥ÀÌÅͺ£À̽º ÀνºÅϽº°¡ ±âµ¿ µÇ¾î Àֱ⠶§¹®¿¡ ´Ù½Ã ±âµ¿ÇÏ·Á¸é ¿¡·¯°¡ ³ªÁö¸¸, ½Ã½ºÅÛÀ» Àç½Ãµ¿Çߴٰųª µ¥ÀÌÅͺ£À̽º¸¦ Á¾·á ½ÃŲ °æ¿ì¿¡´Â Àç ±âµ¿ÇØ¾ß ÇÑ´Ù.
Oracle Service »óÅ ȮÀÎ
µ¥ÀÌÅͺ£À̽º¸¦ ±âµ¿Çϱâ Àü¿¡ ¸ÕÀú ½ÃÀÛ->¼³Á¤->Á¦¾îÆÇ->¼ºñ½º¿¡¼ Oracle°ü·Ã ¼ºñ½º°¡ Á¤»óÀûÀ¸·Î ½ÃÀ۵Ǿî ÀÖ´ÂÁö¸¦ È®ÀÎÇÏ¿©¾ß ÇÑ´Ù.
[±×¸² 4-1 Oracle Services]
ÃÖ¼ÒÇÑ Oracle8iTNSListener ¿Í OracleServieO8i ´Â ½ÃÀ۵Ǿî ÀÖ¾î¾ß ÇÑ´Ù. ¸¸¾à ½ÃÀ۵Ǿî ÀÖÁö ¾Ê´Ù¸é ½ÃÀÛ¹öÆ°À» ´·¯ ½ÃÀÛ ½ÃŲ´Ù. NT ¼¹ö¸¦ óÀ½ ºÎÆÃÇÑ °æ¿ì¿¡´Â ÀÚµ¿À¸·Î ÀÌµé ¼ºñ½º°¡ ½ÃÀÛµÇ°Ô µÇ¸ç ÀÌ °æ¿ì ¿À¶óŬ ÀνºÅϽºµµ ÀÚµ¿À¸·Î ½ÃÀÛµÇ°Ô µÈ´Ù. ÇÏÁö¸¸ shutdown ¸í·ÉÀ» »ç¿ëÇÏ¿© Á¾·á½ÃŲ °æ¿ì¿¡´Â ´ÙÀ½¿¡ ¼Ò°³ÇÏ´Â startup ¸í·ÉÀ¸·Î ±âµ¿ ½ÃÄÑ¾ß ÇÑ´Ù.
µ¥ÀÌÅͺ£À̽ºÀÇ ±âµ¿(Server Manager)
[±×¸² 4-2 Oracle Startup]
µ¥ÀÌÅͺ£À̽º Á¾·á(Server Manager)
[±×¸² 4-3 Oracle Shutdown]
5.µ¥ÀÌÅÍ º£À̽º ÁúÀÇ
À§¿¡¼ ¼³¸íÇÑ ¹Ù¿Í °°ÀÌ Oracle 8i ¼¹ö¸¦ ¼³Ä¡ÇÏ¿´´Ù¸é SCOTTÀ̶ó´Â µ¥ÀÌÅͺ£À̽º »ç¿ëÀÚ¿Í ±× ½ºÅ°¸¶ ¹× »ùÇà Å×À̺íÀ» »ý¼ºÇÑ ´ÙÀ½, ±× »ùÇà Å×ÀÌºí¿¡ ´ëÇÑ ÁúÀǸ¦ ÇØ º¸ÀÚ.
µ¥ÀÌÅͺ£À̽º »ç¿ëÀÚ ¹× ½ºÅ°¸¶ ÀÛ¼º(Server Manager)
[±×¸² 5-1 User Creation]
µ¥ÀÌÅͺ£À̽º ¿¬°á ¹× µ¥¸ðÅ×À̺í ÀÛ¼º
ÅؽºÆ®³ª GUI ±â¹ÝÀÇ sqlplus¸¦ »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º¿¡ Á¢¼ÓÇÑ´Ù.
[±×¸²5-2 Character mode SQL*Plus Demo schema ÀÛ¼º]
[±×¸²5-3 GUI Mode SQL*Plus]
Å×ÀÌºí ¸í È®ÀÎ ¹× ³»¿ë ÁúÀÇ
[±×¸²5-4 Character mode SQL*Plus schema Á¶È¸]
|
Hit : 15938 Date : 2004/12/14 12:02
|