<!doctype linuxdoc system>
<article>
<title>
Oracle Database HOWTO
 <author>Paul Haigh, <url url="mailto:paul@nailed.demon.co.uk" name="paul@nailed.demon.co.uk">
<trans> (¹ø¿ª:Á¶È«·¡ <url url="mailto:chorr@uriel.net" name="chorr@uriel.net">)
<tdate> v1.1, 20 June 1998
<abstract>
¸®´ª½º ½Ã½ºÅÛ¿¡¼­ ¿À¶óÅ¬ µ¥ÀÌÅÍº£ÀÌ½º ¼­¹ö ¼³Ä¡/¼³Á¤ °¡ÀÌµå
  </abstract>
<toc>

<sect> °³¿ä
 <sect1> ¹®¼­¹öÀü<p>
<verb>
	   v0.1 - 21 Feb 1998 - Paul Haigh - ¿À¸®Áö³¯ ¹®¼­ ¹öÁ¯.
	   v0.2 - 01 Mar 1998 - Paul Haigh - ¹®¼­±³Á¤.
 	   v1.0 - 10 Mar 1998 - Paul Haigh - LDP µî·Ï.
	   v1.1 - 20 Jun 1998 - Paul Haigh - ¹®Á¦Á¡ÇØ°á ºÎºÐÃß°¡.
</verb>
</p>
<sect1> ÀúÀÛ±Ç
<p>	¸®´ª½º HOWTO ¹®¼­µéÀÇ ÀúÀÛ±ÇÀº °¢ ¹®¼­ÀÇ ÀúÀÚµé¿¡°Ô ÀÖ´Ù.  
	¸®´ª½º HOWTO´Â ÀÌ ÀúÀÛ±ÇÀÌ À¯ÁöµÇ´Â ÇÑ ¸ðµç ¹°¸®Àû ¸ÅÃ¼³ª ÀüÀÚ ¸ÅÃ¼¸¦ 
	ÅëÇØ ¹®¼­ ÀüÃ¼ È¤Àº ºÎºÐÀ¸·Î¼­ Àç»ý»ê ¹× ¹èÆ÷µÉ ¼ö ÀÖ´Ù.
	»ó¾÷ÀûÀÎ Àç¹èÆ÷µµ Çã¿ëµÇ¸ç Àå·ÁµÈ´Ù.  ÇÏÁö¸¸ ÀÌ·± °æ¿ì¿¡´Â ÀúÀÚ¿¡°Ô ¾Ë·ÁÁÖ±â ¹Ù¶õ´Ù.
	¸ðµç ¹ø¿ªÀÌ³ª ÆÄ»ýÀûÀÎ ÀÛ¾÷µé, ¸®´ª½º HOWTO ¹®¼­µéÀ» °áÇÕÇÏ´Â ÀÛ¾÷µéÀº 
	ÀÌ ÀúÀÛ±Ç ¾È³»¿¡ µû¶ó¾ß  ÇÑ´Ù.  ÀÌ´Â ¿©·¯ºÐÀÌ HOWTO¸¦  ÀÌ¿ëÇÑ ÀÛ¾÷À» ÇÏ°í ³ª¼­ ±× ¹èÆ÷¿¡ ºÎ°¡ÀûÀÎ Á¦ÇÑÁ¶°ÇÀ» ´Þ¾Æ¼­´Â ¾ÈµÈ´Ù´Â ¶æÀÌ´Ù.
	¾î¶² °æ¿ì¿¡´Â ÀÌ ±ÔÄ¢¿¡ ´ëÇÑ ¿¹¿Üµµ Çã¿ëµÉ ¼ö ÀÖÀ¸¹Ç·Î, ¾Æ·¡ ÁÖ¼Ò¸¦ ÅëÇØ¼­ ¸®´ª½º HOWTO Á¶Á¤ÀÚ¿Í Á¢ÃËÇÏ±â ¹Ù¶õ´Ù. 
            °£´ÜÈ÷ ¸»ÇØ¼­ ¿ì¸®´Â ÀÌ Á¤º¸¸¦ 	 °¡´ÉÇÑ ÇÑ ¸¹Àº °æ·Î¸¦ ÅëÇØ¼­ º¸±ÞÇÏ±â¸¦ ¹Ù¶õ´Ù.  ÇÏÁö¸¸ ¿ì¸®´Â HOWTO ¹®¼­¿¡ ´ëÇÑ ÀúÀÛ±ÇÀÌ À¯ÁöµÇ±â¸¦ ¹Ù¶ó¸ç, 
           HOWTO¸¦ Àç¹èÆ÷ÇÏ´Â ¸ðµç °èÈ¹À» Åëº¸¹Þ±â¸¦ ¹Ù¶õ´Ù.
</p>

<sect1> Ã¥ÀÓ¿¡ ´ëÇÑ Æ÷±â
<p>	ÇÊÀÚ´Â µÉ¼ö ÀÖ´Â ÇÑ ¿Ã¹Ù¸¥ Á¤º¸¸¦ Á¦°øÇÏ±â À§ÇÏ¿© ³ë·ÂÇÏ¿´Áö¸¸, ºÎÁ·ÇÑ	Á¤º¸ÀÇ °á°ú·Î¼­ ÀÏ¾î³ª´Â ÀÏ¿¡ ´ëÇØ¼­´Â Ã¥ÀÓÀ» Áú ¼ö ¾ø´Ù. 
            ÇÊÀÚ´Â HOWTO	¹®¼­ÀÇ Á¤º¸¿¡ ´ëÇØ¼­ º¸ÁõÇÒ ¼ö¾øÀ¸¸ç, HOWTO¹®¼­ÀÇ Á¤º¸¸¦ °¡Áö°í ¼öÇàÇÏ´Â 	ÀÏ·ÃÀÇ ÀÛ¾÷¿¡ ´ëÇØ¼­µµ Ã¥ÀÓÁú ¼ö ¾ø´Ù.
</p>

<sect1>  HowToÀÇ ¸ñÀû<p>
	ÀÌ Howto¹®¼­¿¡¼­´Â ¸®´ª½º ¸Ó½Å¿¡¼­ µ¿ÀÛÇÏ´Â ¿À¶óÅ¬µ¥ÀÌº£ÀÌ½ºÀÇ ±âº»ÀûÀÎ¼³Ä¡¿Í ±âº»ÀûÀÎ °ü¸®ºÎºÐÀ» ´Ù·ê °ÍÀÌ´Ù. 
	Æ¯º°È÷  ¿À¶óÅ¬¼­¹ö/SQL*Net ¼³Ä¡¹× SQL*Net Å¬¶óÀÌ¾ðÆ® ¼³Á¤ºÎºÐÀ» ´Ù·é´Ù. 
 	ÀÌ ¹®¼­´Â ¿À¶óÅ¬ º£ÀÌ½ºÀÇ ¼¼ºÎ°ü¸® ¶Ç´Â »ç¿ë¿¡ ´ëÇÑ ±íÀÌÀÖ´Â ºÎºÐÀ» ´Ù·çÁö ¾ÊÀ¸¸ç, ÀÌ¿Í °°Àº ³»¿ëÀ» Ã£	À¸·Á°í ÇÑ´Ù¸é O'Reilly¶Ç´Â ´Ù¸¥ ÃâÆÇ»ç¿¡¼­ ³ª¿Â Ã¥µéÀ» »ìÆìº¸±â ¹Ù¶õ´Ù.
	ÀÌ¹®¼­¿¡¼­´Â Unix¿¡¼­ µ¿ÀÛÇÏ´Â ¿À¶óÅ¬ÇÁ·Î±×·¥ÀÇ °³¹ß¿¡ ´ëÇØ¼­µµ ¾ð±ÞÇÏÁö ¾Ê´Â´Ù. ÀÌºÎºÐ¿¡ ´ëÇØ ÇÊ¿äÇÏ´Ù¸é SCO·Î ºÎÅÍ SCO°³¹ß½Ã½ºÅÛ 
	(OpenServer 5.X)¸¦ ±¸ÀÔÇÒ °ÍÀ» ±ÇÀåÇÑ´Ù. SCO °³¹ß½Ã½ºÅÛÀº <url url="http://www.sco.com" name="www.sco.com">¿¡¼­ $19¶ó´Â Àú·ÅÇÑ °¡°ÝÀ¸·Î ±¸ÀÔÇÒ ¼ö ÀÖ´Ù. 
	HOWTO ¹®¼­¸¦ µû¶óÇÏ±â À§ÇØ ÇÊ¿äÇÑ ¸î°¡Áö Ç×¸ñ¿¡ ´ëÇØ ¾ð±ÞÇÑ´Ù.
	?Oracle Server CD for SCO OpenServer (version 7.3.3.0.0)
	
	ÀÌ°ÍÀº ÇÕ¹ýÀûÀÎ º¹»çº»ÀÌ¾î¾ßÇÑ´Ù. ±â¾ïÇÒ °ÍÀº ¿À¶óÅ¬Àº ¿µ¸®¸¦ Ãß±¸ÇÏ±âÀ§ÇÑ È¸»çÀÌ¸ç ÀÌ Á¦Ç°¿¡ ´ëÇÑ Ã¥ÀÓÀÖ´Ù.
	 ¸¸¾à SQL ±â¹ÝÀÇ ´Ù¸¥ µ¥ÀÌÅÍº£ÀÌ½º¸¦ »ç¿ëÇÏ±â ¿øÇÑ´Ù¸é PostgresSQL¶Ç´Â ±×¿Í À¯»çÇÑ µ¥ÀÌÅÍº£ÀÌ½º¸¦ »ç¿ëÇÏ¸é µÈ´Ù.
	Oracle Web Site·ÎºÎÅÍ 60ÀÏ Æò°¡ÆÇÀ» ÅëÇØ ¼³Ä¡ ÇØ º¼¼öµµ ÀÖ´Ù.
	ÇÊÀÚ °³ÀÎÀûÀ¸·Î ÀÌ·± ¹æ¹ýÀ¸·Î ¼³Ä¡ÇØº¸Áø ¾Ê¾ÒÀ¸¸ç ÀÌ°ÍÀº ¿ÏÀüÈ÷ °ËÁõµÈ
	¹æ¹ýÀº ¾Æ´Ï´Ù. 

 <bf>	Linux Server</bf>
	 ÀÌ°Í¸¶Àú ¼³Ä¡µÇ¾îÀÖÁö ¾Ê´Ù¸é ¹®¼­¸¦ ÀÐÁöµµ ¾Ê¾ÒÀ»°ÍÀÌ´Ù.
 	 <bf>Kernel 2.0.30+ </bf>
	 ´Ù¸¥ Kernel¿¡ ´ëÇØ¼­´Â º¸ÀåÇÒ ¼ö°¡ ¾ø´Ù. 
 	 <bf>iBCS  </bf>
	 iBCS°¡ ¼³Ä¡µÇ¾îÇÏ´Â °ÍÀº ¸Å¿ìÁß¿äÇÑ ºÎºÐÀÌ°í °¡´ÉÇÑÇÑ
	°¡ÀåÃÖ±ÙÀÇ ¹öÀüÀ» »ç¿ëÇÒ °ÍÀ» ÃßÃµÇÑ´Ù.
	(ÇÊÀÚ´Â ·¹µåÇÞÀÇ iBCS-2.0-10.i386.rpmÀ» »ç¿ëÇÏ°í ÀÖ´Ù.) 
 	 <bf>´ë¿ë·®µð½ºÅ© </bf>
	 600¸Þ°¡¹ÙÀÌÆ®ÀÌ»óÀÌ Àû´çÇÑ µð½ºÅ© ¿ë·®ÀÏ °ÍÀÌ´Ù. ÀÌ ¿ë·®À» ¸ðµÎ¸¦ »ç¿ëÇÒ ÇÊ¿ä°¡ ¾ø´Ù°í »ý°¢ÇÑ´Ù¸é ´õ ÀûÀº ¾çÀ» »ç¿ëÇØµµ °¡´ÉÇÏ´Ù.
	 ÇÏÁö¸¸ °³ÀÎÀûÀ¸·Î ÃßÃµÇÏ°í ½ÍÁö´Â ¾Ê´Ù. 
 	 <bf>32Mb + Ram </bf>
	 RamÀ»  ¸¹ÀÌ »ç¿ëÇÑ´Ù°í ´À³¢°ÚÁö¸¸ ¿À¶óÅ¬ µ¥ÀÌÅ¸º£ÀÌ½º´Â º¹ÀâÇÑ Á¾·ùÀÇ ¼ÒÇÁÆ®¿þ¾î¶ó´Â °ÍÀ» ±â¾ïÇØ¾ßÇÑ´Ù.
	 ±×·¸´Ù°í ÇØ¼­ ¿À¶óÅ¬ÀÌ³ª ÇÊÀÚ°¡ ´õ Àû	Àº ·¥¿¡¼­ ¿À¶óÅ¬ µ¥ÀÌÅ¸º£ÀÌ½º ÀÛµ¿À» ÇÏÁö¾Ê´Â´Ù´Â °ÍÀº ¾Æ´Ï´Ù.
	 ´ÜÁö, ÃßÃµÇÒ ¸¸ÇÑ ·¥ÀÇ ¿ë·®ÀÌ 32¸Þ°¡ ¹ÙÀÌÆ®¶ó´Â°ÍÀÌ´Ù.  
</p>	

<sect1>  ¾ÕÀ¸·ÎÀÇ °³¼±»çÇ×<p>
	ÀÌ HOWTO ¹®¼­¿¡¼­´Â ¿À¶óÅ¬ µ¥ÀÌÅ¸º£ÀÌ½º ¼­¹ö ÀÚÃ¼¿¡ ´ëÇØ¼­´Â ´Ù·çÁö ¾Ê´Â´Ù.
	 ±×·¯³ª, ½Ã°£ÀÌ Çã¶ôµÈ´Ù¸é ´ÙÀ½ HOWTO ¹öÀü¿¡¼­ ¾Æ·¡ÀÇ Ç×¸ñµéÀ» Æ÷ÇÔ½ÃÅ³°ÍÀÌ´Ù.
<itemize>
  
 	<item>Oracle ¶óÀÌºê·¯¸®¸¦ »ç¿ëÇÑ Oracle Pro* ÇÁ·Î±×·¥ÀÇ °³¹ß
  	<item>´Ù¸¥ ¿À¶óÅ¬¼­¹ö¹öÀü ¼³Ä¡
  	<item>¿À¶óÅ¬ À¥¼­¹öÀÇ ¼³Ä¡
  	<item>Oracle Kernel Relink
</itemize>
</p>

<sect> ¿À¶óÅ¬ ¼ÒÇÁÆ®¿þ¾î ¼³Ä¡
<sect1> ¼­¹öÁØºñ»çÇ×
<sect2>¿À¶óÅ¬»ç¿ëÀÚ µî·Ï<p>

	¿À¶óÅ¬µ¥ÀÌÅÍº£ÀÌ½º¸¦ »ç¿ëÇÏ±â À§ÇØ¼­´Â ¿À¶óÅ¬µ¥ÀÌÅÍº£ÀÌ½º¸¦ À¯Áö/°ü¸® ÇÒ¼ö ÀÖ´Â »ç¿ëÀÚ°¡ ÀÖ¾î¾ß¸¸ÇÑ´Ù. 
	 ¿ì¸®°¡ ¿À¶óÅ¬Ä¿³Î(ÃßÈÄ¿¡ ÀÚ¼¼ÇÑ ¼³¸í)¸¦Àç¼³Á¤ÇÏ·Á´Â ÀÇµµ´Â ¾ø±â ¶§¹®¿¡ ¿ì¸®´Â »ç¿ëÀÚÀÌ¸§°ú ±×·ìÀÌ¸§À» À§ÇÑ ¿À¶óÅ¬¿¡¼­ Á¦°øÇÏ´Â ¼³Á¤À» ¹Þ¾Æµé¿©¾ßÇÑ´Ù.
	 ÀÌ ºÎºÐÀº »ç¿ëÀÚ ORACLE°ú ±×·ì DBA·Î ÁöÁ¤µÇ¾î ÀÖ´Ù.
<enum>
<item> Root·Î½á ·Î±×ÀÎ
<item> oracle À¯Àú¿Í dba ±×·ì »ý¼º
<code>
	$ groupadd dba
	$ useradd oracle
</code>

<item> À¯Àú oracleÀ» À§ÇÑ home µð·ºÅä¸® »ý¼º
<code>
       $ mkdir /home/oracle
       $ mkdir /home/oracle/7.3.3.0.0 (Version of Oracle)
       $ chown -R oracle.dba /home/oracle
</code>
</enum>
</p>

<sect1>  CDROMÀ¸·Î ¼³Ä¡<p>
	¾Æ½±°Ôµµ SCO°è¿­ÀÇ µð½ºÅ©¿¡¼­ÀÇ Oracle Installer´Â Á¦´ë·Î µ¿ÀÛÇÏÁö ¾ÊÀ» 	°ÍÀÌ´Ù. Core DumpºÎÅÍ ½Ã½ºÅÛ Á¤Áö±îÁö ´Ù¾çÇÑ ¹®Á¦¸¦ °æÇèÇÏ¿´´Ù. °á°úÀûÀ¸	·Î ¿ì¸®´Â CDROM¿¡¼­ ÆÄÀÏµéÀ» º¹»çÇÏ¿© ¾ÐÃàÀ» Ç® ÇÊ¿ä°¡ ÀÖ´Ù.
	(CDROMÀÌ ½Ã½ºÅÛ¿¡ ¸¶¿îÆ®µÇ¾ú´ÂÁö È®ÀÎ)
<enum>
<item> Oracle·Î ·Î±×ÀÎ
<item> /home/oracle/7.3.3.0.0µð·ºÅä¸®·Î ÀÌµ¿
<item> CDROM¿¡¼­ ¼³Ä¡ÆÄÀÏÀ» º¹»ç
<code>
  	$ cp -a /mnt/cdrom/* .
</code>
<item> CDROM¿¡ ÀÖ´Â Oracle°ü·ÃÆÄÀÏÀÇ ¾ÐÃàÀ» Ç®±â
<code>
       	$ find . -name *_ -exec ~/7.3.3.0.0/orainst/oiuncomp {} \;
</code>
</enum>
</p>

<sect1> ¼³Ä¡ÀÛ¾÷

<sect2> Root¸¦ À§ÇÑ ÀÛ¾÷<p>
	OracleÀ» »ç¿ëÇÒ °¢ »ç¿ëÀÚ¸¦ À§ÇÑ /etc/profile³ª .profile¿¡ ´ÙÀ½ÁÙÀ» Ãß°¡ÇÑ´Ù.
<code>
       # Oracle Specific
       ORACLE_HOME=/home/oracle/7.3.3.0.0
       ORACLE_SID=orcl
       ORACLE_TERM=vt100
       export ORACLE_HOME ORACLE_SID ORACLE_TERM
      # Alter path for Oracle
       PATH=&quot;$PATH:$ORACLE_HOME/bin&quot;
</code>
	¿ì¸®´Â ¶ÇÇÑ ¼ÒÀ¯±ÇÇÑÀÚ¸¦ ¹Ù²Ü ÇÊ¿ä°¡ ÀÖ°í OracleÀÇ ±ÇÇÑÀ» Æí¸®ÇÏ°Ô »ç¿ëÇÒ ¼ö ÀÖµµ·Ï Ãß°¡ÇÑ´Ù. 
<code>
       $ chown root.root $ORACLE_HOME/bin/osh
       $ chmod u+s $ORACLE_HOME/bin/osh

  </code>  
</p>

<sect2> OracleÀ» À§ÇÑ ÀÛ¾÷
<p>	Á¤È®ÇÑ µ¿ÀÛÀ» È®ÀÎÇÏ±â À§ÇÑ Oracle°ü·Ã ÆÄÀÏÀÇ ±ÇÇÑÀ» º¯°æÇÑ´Ù.
<code>
       $ chmod +x $ORACLE_HOME/bin/*
       $ chmod u+s $ORACLE_HOME/bin/oracle
</code>

	Oracle°ü·Ã ÅøµéÀº $ORACLE_HOME/tool_name/mesg µð·ºÅä¸®¿¡ ÀÖ´Â ¸Þ½ÃÁöµéÀ» ¿ä±¸ÇÑ´Ù. 
±×·¡¼­ msg_shipµð·ºÅä¸®¿¡¼­ msegµð·ºÅä¸®·Î msb°ü·ÃÆÄÀÏµéÀ» ¿Å±ä´Ù.

     <code>
       	$ mv $ORACLE_HOME/plsql/mesg/mesg_ship/*
	$ORACLE_HOME/plsql/mesg/.
       	$ mv $ORACLE_HOME/rdbms/mesg/mesg_ship/*
	$ORACLE_HOME/rdbms/mesg/.
       	$ mv $ORACLE_HOME/svrmgr/mesg/mesg_ship/*
	$ORACLE_HOME/svrmgr/mesg/.
</code>

	¸¸¾à ´ÙÀ½ µð·ºÅä¸®°¡ Á¸ÀçÇÏÁö ¾ÊÀ¸¸é »ý¼ºÇÑ´Ù.
<code>
       $ mkdir $ORACLE_HOME/rdbms/log
       $ mkdir $ORACLE_HOME/rdbms/audit
       $ mkdir $ORACLE_HOME/network/log
</code>
</p>

<sect2>´ç½ÅÀÌ »èÁ¦ÇÒ ¼ö ÀÖ´Â ºÎºÐµé
<p>	´ÙÀ½ µð·ºÅä¸®´Â ¾ÈÀüÇÏ°Ô »èÁ¦µÉ¼ö ÀÖ´Â °ÍµéÀÌ´Ù.
<verb>
    	$ORACLE_HOME/guicommon2/
    	$ORACLE_HOME/ctx/
    	$ORACLE_HOME/md/
    	$ORACLE_HOME/mlx/
    	$ORACLE_HOME/precomp/
    	$ORACLE_HOME/slax/
</verb>
</p>

<sect>µ¥ÀÌÅÍº£ÀÌ½º »ý¼º
<p>Oracle¼­¹ö¸¦ ¼³Ä¡ÇÑ Áö±ÝºÎÅÍ ¼³Ä¡¸¦ ½ÃÇèÇÒ µ¥ÀÌÅÍº£ÀÌ½º¸¦ ¼³Ä¡ÇÒ
ÇÊ¿ä°¡ ÀÖ´Ù.  ¸¸¾à Oracle 7.2.x³ª ÀÌÀü ¹öÀüÀ» »ç¿ëÇÑ´Ù¸é, ¾Æ·¡ºÎºÐ¿¡ ÀÖ´Â
¹®Á¦ÇØ°áÁöÄ§À» ÀÐ±â¹Ù¶õ´Ù.
</p>

<sect1>¼³Ä¡°ü·Ã ÆÄÀÏ ¼³Ä¡<p>
	$ORACLE_HOME/dbs/init.ora¸¦ $ORACLE_HOME/dbs/initorcl.ora·Î º¹»çÇÑ´Ù.
<code>
       	$ cd $ORACLE_HOME/dbs
       	$ cp init.ora initorcl.ora
</code>
	´ÙÀ½ÁÙÀ» »ý¼ºÇÑ ÆÄÀÏ¿¡ Ãß°¡ÇÑ´Ù.
<code>
  	db_name = orcl
  	COMPATIBLE=7.3.3.0.0
</code>
</p>
<sect1> µ¥ÀÌÅÍº£ÀÌ½º ¼³Ä¡ ½ºÅ©¸³Æ®¸¦ »ý¼º<p>
	$ORACLE_HOME/dbsµð·ºÅä¸®¿¡  makedb.sqlÀÇ ÀÌ¸§À¸·Î ÆÄÀÏÀ» »ý¼ºÇÑ´Ù.
<code>
       	connect internal
       	startup nomount
       	set echo on
       	spool makedb.log
       	create database orcl
               maxinstances 1
               maxlogfiles  8
               datafile '$ORACLE_HOME/dbs/orcl_syst_01.dbf' size 40M reuse
               logfile
                       '$ORACLE_HOME/dbs/orcl_redo_01.dbf' size 1M reuse,
                       '$ORACLE_HOME/dbs/orcl_redo_02.dbf' size 1M reuse,
                       '$ORACLE_HOME/dbs/orcl_redo_03.dbf' size 1M reuse;
       @$ORACLE_HOME/rdbms/admin/catalog.sql
       create tablespace rollback
               datafile '$ORACLE_HOME/dbs/orcl_roll_01.dbf' size 8.5M reuse;
       create tablespace temp
               datafile '$ORACLE_HOME/dbs/orcl_temp_01.dbf' size 5M reuse
               temporary;
       create tablespace users
               datafile '$ORACLE_HOME/dbs/orcl_user_01.dbf' size 10M reuse;
       create rollback segment r1 tablespace rollback storage ( optimal 5M );
       alter rollback segment r1 online;
       connect system/manager
       @$ORACLE_HOME/rdbms/admin/catdbsyn.sql
       connect internal
       @$ORACLE_HOME/rdbms/admin/catproc.sql
       connect system/manager
       @$ORACLE_HOME/sqlplus/admin/pupbld.sql
       spool off
       exit
</code>
</p> 
 
<sect1> µ¥ÀÌÅÍº£ÀÌ½º ¼³Ä¡ ½ºÅ©¸³Æ®¸¦ ½ÇÇà<p>
	svrmgrl¸í·ÉÀ» ¼öÇàÇÑ ÈÄ ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇÑ´Ù.
<code>
  	$ cd $ORACLE_HOME/dbs
  	$ svrmgrl
 	Oracle Server Manager Release 2.3.3.0.0 - Production
 	Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
 	Oracle7 Server Release 7.3.3.0.0 - Production Release
  	PL/SQL Release 2.3.3.0.0 - Production
 	SVRMGR&gt; connect internal
  	Connected.
  	SVRMGR&gt; startup nomount
  	ORACLE instance started.
  	Total System Global Area       4313312 bytes
  	Fixed Size                       41876 bytes
  	Variable Size                  4140364 bytes
  	Database Buffers                122880 bytes
  	Redo Buffers                      8192 bytes
  	SVRMGR&gt; @makedb
  	&lt;loads of messages&gt;
  	SVRMGR&gt; exit
  	Server Manager complete.
</code>
</p>
   
<sect1> µ¥ÀÌÅÍº£ÀÌ½º ±¸µ¿½ÃÅ°±â<p>
	¿ì¼±Àº ¼öµ¿À¸·Î(ÀÌÈÄ¿¡´Â ÀÚµ¿À¸·Î ±¸µ¿µÉ °ÍÀÌ´Ù.)µ¥ÀÌÅÍº£ÀÌ½º¸¦ ±¸µ¿½ÃÅ³ÇÊ¿ä°¡ ÀÖ´Ù. 
	Oracle µ¥ÀÌÅÍº£ÀÌ½º¸¦ ½ÃÀÛÇÏ±âÀ§ÇØ¼­´Â &quot;connect internal&quot;À» ÇÑÈÄ¿¡ &quot;startup&quot;ÀÌ¶ó´Â command¸¦ ½ÇÇàÇØ¾ß ÇÑ´Ù. 
<code>
       $ svrmgrl
      Oracle Server Manager Release 2.3.3.0.0 - Production
      Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
      Oracle7 Server Release 7.3.3.0.0 - Production Release
       PL/SQL Release 2.3.3.0.0 - Production
      SVRMGR&gt; connect internal
       Connected.
       SVRMGR&gt; startup
       ORACLE instance started.
       Total System Global Area       4313316 bytes
       Fixed Size                       41876 bytes
       Variable Size                  4140368 bytes
       Database Buffers                122880 bytes
       Redo Buffers                      8192 bytes
       Database mounted.
       Database opened.
       SVRMGR&gt; exit
       Server Manager complete.
</code>
</p>

<sect1>   µ¥ÀÌÅÍº£ÀÌ½º ÁßÁö½ÃÅ°±â
<p>	Oracleµ¥ÀÌÅÍº£ÀÌ½º¸¦ ÁßÁö½ÃÅ°±â¾Ê°í Linux¼­¹ö¸¦ Àç½ÇÇà½ÃÅ°´Â °ÍÀº µ¥ÀÌÅÍº£ÀÌ½º¸¦ ÆÄ±«½ÃÅ³ ¼ö ÀÖ´Â Å« À§ÇèÀÌ ÀÖ´Ù´Â °ÍÀ» ¸í½ÉÇØ¾ß ÇÑ´Ù. 
	±×·¯¹Ç·Î,Linux shutdown¸í·ÉÀ» »ç¿ëÇÏ±âÀü¿¡ µ¥ÀÌÅÍº£ÀÌ½º¸¦ ÁßÁö½ÃÅ°´Â °ÍÀÌ ¹Ù¶÷Á÷ÇÑ°ÍÀÌ´Ù. 
<code>
       $ svrmgrl
      Oracle Server Manager Release 2.3.3.0.0 - Production
      Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
      Oracle7 Server Release 7.3.3.0.0 - Production Release
       PL/SQL Release 2.3.3.0.0 - Production
      SVRMGR&gt; connect internal
       Connected.
       SVRMGR&gt; shutdown
       Database closed.
       Database dismounted.
       ORACLE instance shut down.
       SVRMGR&gt; exit
       Server Manager complete.
</code>
</p>

<sect1> ±âº»»ç¿ëÀÚ »ý¼º<p>
	µ¥ÀÌÅÍº£ÀÌ½º°¡ »ý¼ºµÇ¸é¼­ ÀÚµ¿ÀûÀ¸·Î µÎ °³ÀÇ Æ¯º°ÇÑ »ç¿ëÀÚ°èÁ¤ÀÌ »ý¼ºµÈ´Ù.  ´ÙÀ½¿¡ ±× ºÎºÐÀ» ¸í½ÃÇÑ´Ù.
<code>
       Username                Password
      SYSTEM                  MANAGER
       SYS                     change_on_install
</code>
	ÀÌ·¯ÇÑ »ç¿ëÀÚ°èÁ¤Àº ÀüÇüÀûÀ¸·Î µ¥ÀÌÅÍº£ÀÌ½º¸¦ À§ÇÑ ±âº»ÀûÀÎ
	µ¥ÀÌÅÍµñ¼Å³Ê¸®Á¤º¸¸¦ À¯ÁöÇÏ±â À§ÇÑ °ÍÀÌ´Ù. °¡´ÉÇÑÇÑ ºü¸¥½Ã°£³»¿¡
	±âº»ÀûÀÎÀ¸·Î ÁöÁ¤µÈ ¾ÏÈ£¸¦ ¹Ù²Ù´Â °ÍÀÌ ÁÁ´Ù.
	ÀÌ·¯ÇÑ ºÎºÐÀ» ´ÙÀ½°ú °°Àº °úÁ¤À¸·Î º¯°æµÈ´Ù.
<code>
  	sqlplus system/manager
 	SQL*Plus: Release 3.3.3.0.0 - Production on Sat Feb 21 12:43:33 1998
 	Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.

 	Connected to:
  	Oracle7 Server Release 7.3.3.0.0 - Production Release
 	SQL&gt; alter user system identified by &lt;newpassword&gt;;
 	User altered.
 	SQL&gt; alter user sys identified by &lt;newpassword&gt;;
 	User altered.
 	SQL&gt; exit;
  	Disconnected from Oracle7 Server Release 7.3.3.0.0 - Production Release
  	PL/SQL Release 2.3.3.0.0 - Production
</code>
	system/manager¶ó´Â  Oracle »ç¿ëÀÚ °èÁ¤Àº UNIX½Ã½ºÅÛ¿¡¼­ÀÇ root¸¦ »ç¿ëÇÏ´Â °Í°ú À¯»çÇÏ±â ¶§¹®¿¡ ¿ì¸®´Â ¹®Á¦¸¦ ¹ß»ý½ÃÅ°´Â °ÍÀ» ÃÖ¼ÒÈ­ÇÏ±â À§ÇØ
	 µÇµµ·Ï ÀûÀº ±ÇÇÑÀ» °®´Â »ç¿ëÀÚ¸¦ »ý¼ºÇÒ ÇÊ¿ä°¡ ÀÖ´Ù. 
	(»ç¿ëÀÚ¸¦ »ý¼ºÇÏ±â Àü¿¡ µ¥ÀÌÅÍº£ÀÌ½º¸¦ ½ÇÇà½ÃÅ°´Â °ÍÀ» ±â¾ïÇÏ¶ó)
	SQL*PLUS¿¡ ¿¬°áÇÏ°í »ç¿ëÀÚ¸¦ »ý¼ºÇÑ´Ù.
<code>
       $ sqlplus system/manager
      SQL*Plus: Release 3.3.3.0.0 - Production on Sat Feb 21 12:43:33 1998
      Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.

      Connected to:
       Oracle7 Server Release 7.3.3.0.0 - Production Release
       PL/SQL Release 2.3.3.0.0 - Production
      SQL&gt; create user &lt;user&gt; identified by &lt;psw&gt;
         2  default tablespace users
         3  temporary tablespace temp;
      User created.
      SQL&gt; grant connect, resource to &lt;user&gt;
      Grant succeeded.
      SQL&gt; exit
       Disconnected from Oracle7 Server Release 7.3.3.0.0 - Production Release
       PL/SQL Release 2.3.3.0.0 - Production
</code>
	½Ã½ºÅÛ¿¡ »õ·Î¿î »ç¿ëÀÚ°èÁ¤À» »ý¼ºÇÏ¿´±â ¶§¹®¿¡ »õ·Î¿î °èÁ¤À» °¡Áö°í ½Ã½ºÅÛ¿¡ ·Î±×ÀÎ ÇÒ¼ö ÀÖ´Ù. 
	Oracleµ¥ÀÌÅÍº£ÀÌ½º¿¡ ·Î±×ÀÎÇÏ±â À§ÇØ¼­´Â ´ÙÀ½°ú °°´Ù.
<code>
       $ sqlplus &lt;user&gt;/&lt;password&gt;
</code>
	ÀÌºÎºÐÀÌ ¿¡·¯¸Þ¼¼Áö¾øÀÌ ¼öÇàµÈ´Ù¸é, ¼º°øÀûÀ¸·Î ¿À¶óÅ¬ µ¥ÀÌÅ¸º£ÀÌ½º¸¦ ¼³Ä¡ÇÑ°ÍÀÌ´Ù.
	 ÀÌ ¼­¹ö°¡ ¾Æ´Ñ ´Ù¸¥ È£½ºÆ®¿¡¼­ ÀÌ ¿À¶óÅ¬ µ¥ÀÌÅ¸º£ÀÌ½º¿¡ Á¢±Ù	ÇÏÁö ¾Ê´Â´Ù¸é  ¸ðµç ÀÛ¾÷Àº ¿Ï·áµÈ°ÍÀÌ´Ù.
	±×·¯³ª, ´ëºÎºÐ »ç¶÷µéÀº ³×Æ®¿öÅ©¸¦ ÀÌ¿ëÇÏ¿© ¿ø°ÝÀ¸·Î µ¥ÀÌÅ¸º£ÀÌ½º ¼­¹ö¿¡ Á¢¼ÓÇÏ±æ ¿øÇÒ°ÍÀÌ´Ù. ±×·¸°Ô ÇÏ±â À§ÇØ¼­´Â ´ÙÀ½°ú °°Àº °úÁ¤À» ¼öÇàÇØ¾ßÇÑ´Ù. 
</p>

<sect>¼­¹ö¿¡ SQL*NetÀ» ¼³Á¤ÇÏ±â
<p>	¸ðµç ÀÌ·¯ÇÑ ºÎ·ùÀÇ ÆÄÀÏµéÀº Oracle ³×Æ®¿öÅ©¿¡ °ü·ÃµÈ ¼ÒÇÁÆ®¿þ¾î(SQL*Net,aka Net8 for Oracle8)¸¦ ¼³Á¤ÇÑ´Ù. ÀÌ·¯ÇÑ ÆÄÀÏµéÀº 
	$ORACLE_HOME/network/adminµð·ºÅä¸®¾È¿¡ ¼­¹ö·Î½á »ý¼ºµÇ¾îÁ®¾ß ÇÑ´Ù.
</p>

<sect1>tnsnames.ora
<p>	TNSNAMES.ORAÆÄÀÏÀº ¿¬°á °¡´ÉÇÑ µ¥ÀÌÅ¸º£ÀÌ½º ÀÎ½ºÅÏ½ºµéÀ» ±â¼úÇÏ¿© ÁØ´Ù.
	»õ·ÎÀÌ »ý¼ºµÈ µ¥ÀÌÅÍº£ÀÌ½º ÀÎ½ºÅÏ½º¸¦ À§ÇØ ¾Æ·¡ºÎºÐ°ú °°ÀÌ Ãß°¡ÇÑ´Ù.
<code>
       orcl.world =
         (DESCRIPTION =
           (ADDRESS_LIST =
               (ADDRESS =
                 (COMMUNITY = tcp.world)
                 (PROTOCOL = TCP)
                 (Host = &lt;INSERT HOST NAME OF SERVER HERE&gt; )
                 (Port = 1521)
               )
               (ADDRESS =
                 (COMMUNITY = tcp.world)
                 (PROTOCOL = TCP)
                 (Host = &lt;INSERT HOST NAME OF SERVER HERE&gt; )
                 (Port = 1526)
               )
           )
           (CONNECT_DATA = (SID = ORCL)
           )
         )
</code>
</p>

<sect1> listener.ora
<p>	LISTENER.ORAÆÄÀÏÀº ´Ù¸¥ ½Ã½ºÅÛ¿¡ ¿¬°áÇÏ´Â °Í¿¡ °ü·ÃµÈ ºÎºÐÀ» ±â¼úÇÏ°í
	¼­¹ö listenerÀ» À§ÇØ ¿ä±¸µÇ´Â ´Ù¸¥ ¼³Á¤À» Æ÷ÇÔÇÑ´Ù. listenerÀÌ¸§,
	listenerÁÖ¼Ò, listener¿¡ ÀÇÇØ Á¦°øµÇ´Â µ¥ÀÌÅÍº£ÀÌ½º, ¼³Á¤¸Å°³º¯¼öµîÀ»
	¶ÇÇÑ Æ÷ÇÔÇÑ´Ù.
	´ÙÀ½¿¡ ÇÑ ¿¹°¡ ÀÖ´Ù.
<code>
       # Name of listener and addresses to listen on
       LISTENER =
               ( ADDRESS_LIST =
                       (ADDRESS =
                               (PROTOCOL=tcp)
                               (HOST=&lt;INSERT HOST&gt;)
                               (PORT=1521)
                               (COMMUNITY=UK_SUP_TCPIP)
                       )
                       (ADDRESS =
                               (PROTOCOL=ipc)
                               (KEY=700)
                               (COMMUNITY=UK_SUP_TCPIP)
                       )
               )
      # List of services served by this listener
       SID_LIST_LISTENER=
               (SID_LIST=
                       (SID_DESC=
                               (SID_NAME=orcl)
                               (ORACLE_HOME=/home/oracle/7.3.3.0.0)
                       )
               )
      # Start of configuration parameters.
       TRACE_LEVEL_LISTENER=OFF
       TRACE_FILE_LISTENER = &quot;listener&quot;
       LOG_FILE_LISTENER = &quot;listener&quot;
       CONNECT_TIMEOUT_LISTENER = 10
       STOP_LISTENER = YES
       DBA_GROUP = dba
</code>
</p>

<sect1> sqlnet.ora
<p>	SQLNET.ORAÆÄÀÏÀº ³×Æ®¿öÅ©ÀÇ Æ¯º°ÇÑ ¿¬°áÁöÁ¡(node)¿¡ ´ëÇÑ ¼³Á¤À»
	Æ÷ÇÔÇÑ´Ù. ÀÌ°ÍÀº µ¥ÀÌÅÍº£ÀÌ½º¿Í listenerÀÇ ¼ö¿Í´Â »ó°üÀÌ ¾ø´Ù. ÀÌ
	ÆÄÀÏ¿¡¼­ °¡Àå Áß¿äÇÑ ºÎºÐÀº Dead Connection Timeout ¼³Á¤º¯¼öÀÌ´Ù.Dead
	Connection TimeoutÀº µ¥ÀÌÅÍº£ÀÌ½º ÀÎ½ºÅÏ½º¿¡ Á¢¼öµÇ´Â °¢°¢ÀÇ
	ÇÁ·Î¼¼½º¸¦ Ã¼Å©ÇÏ°í, °è¼ÓÀûÀÎ ÀÀ´ä¿¡ °ü·ÃµÈ Å¬¶óÀÌ¾ðÆ®¸¦ È®ÀÎÇÑ´Ù.
	Å¬¶óÀÌ¾ðÆ®(¾î¶°ÇÑ ÇüÅÂÀÇ)°¡ ÀÀ´äÀÌ µÇÁö ¾Ê´Â´Ù¸é Oracle ¼­¹öÀÇ
	½ÇÇàÁßÀÎ ÇÁ·Î¼¼½º´Â ÁßÁöµÈ´Ù.
	ÀÌ°ÍÀº ¸¹Àº ¼öÀÇ Å¬¶óÀÌ¾ðÆ®°¡ µ¥ÀÌÅÍº£ÀÌ½º¿¡ Á¢±ÙÇÏ·ÁÇÒ ¶§ ¸Å¿ì
	À¯¿ëÇÑ´Ù. Æ¯È÷, Oracleµ¥ÀÌÅÍº£ÀÌ½º·ÎºÎÅÍ Á¤È®È÷ ºüÁ®³ª°¡´Âµ¥ ½ÇÆÐÇÏ´Â
	Å¬¶óÀÌ¾ðÆ®µéÀÌ ¸¹ÀÌ Á¸ÀçÇÒ °¡´É¼ºÀÌ ÀÖ´Â °³¹ß±â°£¿¡ Àû¿ëÀÌ µÈ´Ù°í º¼
	¼ö ÀÖ´Ù.
	¾Æ·¡ºÎºÐ¿¡ ´ç½ÅÀÌ »ç¿ëÇÒ sqlnet.oraÆÄÀÏÀÇ ¿¹°¡ ÀÖ´Ù.
<code>
  	TRACE_LEVEL_CLIENT = OFF
  	sqlnet.expire_time = 30         # The number of seconds between
	client checks.
  	names.default_domain = world
  	name.default_zone = world
</code>
</p>

<sect1>ListenerÀ» ½ÇÇà½ÃÅ°°í Á¾·áÇÏ±â
<p>	listener¿Í SQL*NetÀÇ ¼³Á¤À» ³¡¸¶ÃÆÀ¸¹Ç·Î, ³×Æ®¿öÅ© ¼ÒÇÁÆ®¿þ¾î¸¦
	»ç¿ëÇÏ¿© µ¥ÀÌÅÍº£ÀÌ½º¿¡ Á¢±ÙÇÒ ¼ö ÀÖ´Ù.(µ¥ÀÌÅÍº£ÀÌ½º¿¡ Á÷Á¢ ¿¬°áÀ»
	ÇÏ±âÀü¿¡, ¿ì¸®´Â ¿ø°Ý Å¬¶óÀÌ¾ðÆ® ½Ã½ºÅÛ¿¡¼­ Á¢±ÙÇÏ´Â °ÍÀ» ½ÃÇèÇÒ
	°ÍÀÌ´Ù.)
	À§ÀÇ ¼³Á¤À» »ç¿ëÇÏ¿© listenerÀ» ½ÇÇà½ÃÅ²´Ù.
<code>
       $ lsnrctl
      	LSNRCTL for SCO System V/386: Version 2.3.3.0.0 - Production 
	on 23-FEB-98 20:38:25
      	Copyright (c) Oracle Corporation 1994.  All rights reserved.
      	Welcome to LSNRCTL, type &quot;help&quot; for information.
      	LSNRCTL&gt; start
       	Starting /home/oracle/7.3.3.0.0/bin/tnslsnr: please wait...
      	TNSLSNR for SCO System V/386: Version 2.3.3.0.0 - Production
       	System parameter file is
	/home/oracle/7.3.3.0.0/network/admin/listener.ora
       	Log messages written to
	/home/oracle/7.3.3.0.0/network/log/listener.log
       	Listening on:
	(ADDRESS=(PROTOCOL=tcp)(DEV=6)(HOST=192.168.1.1)(PORT=1521))
       	Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=700))
      	Connecting to
	(ADDRESS=(PROTOCOL=tcp)(HOST=magic.com)(PORT=1521)
		(COMMUNITY=UK_SUP_TCPIP))
       	STATUS of the LISTENER
</code>
<code>
       	Alias       LISTENER
       	Version     TNSLSNR for SCO System V/386: Version 2.3.3.0.0 - Production
       	Start Date  23-FEB-98 20:38:50
       	Uptime       0 days 0 hr. 0 min. 0 sec
       	Trace Level  off
       	Security     OFF
       	SNMP         ON
       	Listener Parameter File
	/home/oracle/7.3.3.0.0/network/admin/listener.ora
       	Listener Log File
	/home/oracle/7.3.3.0.0/network/log/listener.log
       	Services Summary...
        orcl          has 1 service handler(s)
       	The command completed successfully
       	LSNRCTL&gt; exit
</code>
	listenerÀ» ÁßÁö½ÃÅ°±â À§ÇØ¼­´Â ´ÙÀ½°ú °°´Ù.
<code>
  	$ lsnrctl
 	LSNRCTL for SCO System V/386: Version 2.3.3.0.0 - Production 
	on 23-FEB-98 20:43:20
 	Copyright (c) Oracle Corporation 1994.  All rights reserved.
 	Welcome to LSNRCTL, type &quot;help&quot; for information.
 	LSNRCTL&gt; stop
  	Connecting to
	(ADDRESS=(PROTOCOL=tcp)
		 (HOST=magic.com)
	         (PORT=1521)
		 (COMMUNITY=UK_SUP_TCPIP)
	)
  	The command completed successfully
  	LSNRCTL&gt; exit
</code>
 	¸í½ÃµÈ hostname¸¦ À§ÇÑ IPÁÖ¼Ò¸¦ ¹ÝÈ¯ÇÏÁö ¾Ê´Â DNS¼³Á¤À» °®´Â´Ù¸é,
	listenerÀ» ½ÇÇà½ÃÅ°°í, ÁßÁö½ÃÅ³ ¶§¿¡ ¾à°£ÀÇ ½Ã°£ÀÌ ¼Ò¿äµÈ´Ù.(2-3ºÐ,
	DNS timeout º¯¼ö¿¡ °ü·ÃµÇ¾î) ÀÌ·¯ÇÑ °æ¿ì¿¡´Â °ÆÁ¤ÇÏÁö ¸»°í, ÀÎ³»ÇÏ¶ó.
	±â´Ù¸®¶ó.
</p>

<sect>Å¬¶óÀÌ¾ðÆ® È¯°æ ¼³Á¤
<sect1> À©µµ¿ìÈ¯°æ Å¬¶óÀÌ¾ðÆ®
<p>	ÃÖ±Ù ¹öÁ¯ÀÇ Oracle Client SoftwareÀ» »ç¿ëÇÏ´Â PC¿¡¼­ÀÇ SQL*Net
	¼³Á¤Àº ¸Å¿ì ½±´Ù. ¸ðµç ºÎºÐÀÌ µ¿ÀÛÇÏ´Â Å¬¶óÀÌ¾ðÆ® ¼³Ä¡¸¦ ¼öÇàÇÏ´Â °¡Àå
	ÁÁÀº(½¬¿î) ¹æ¹ýÀº Oracle¿¡¼­ Á¦°øÇÏ´Â SQL*Net Easy Configuration ÅøÀ»
	ÀÌ¿ëÇÏ´Â °ÍÀÌ´Ù.
	ÀÌ ÅøÀº tnsnames.ora¿Í sqlnet.oraÆÄÀÏÀÇ ¼³Á¤À» º¯°æ ÇÒ ¼ö ÀÖ´Â À§Àúµå
	ÇüÅÂÀÇ ÀÎÅÍÆäÀÌ½º¸¦ °®´Â´Ù.
	&quot;Add Database Alias&quot;¸¦ ¼±ÅÃÇÏ°í, Ä¿¼­°¡ À§Ä¡ÇÑ °÷¿¡ &quot;Database alias&quot;¿¡
	´ëÇÑ ÀÌ¸§À» ÀÔ·ÂÇÑ´Ù. 
	ÀÌ alias´Â µ¥ÀÌÅÍº£ÀÌ½º ÀÎ½ºÅÍ½º¸¦ ÂüÁ¶ÇÒ ÀÌ¸§ÀÌ°í, ÀÎ½ºÅÏ½º
	ÀÌ¸§(ÀÌ·¯ÇÑ °æ¿ì¿¡´Â orcl)°ú °°Àº ÀÌ¸§ÀÌ¾î¾ß ÇÑ´Ù.
	ÇÁ·ÎÅäÄÝ·Î½á TCP/IP¸¦ ¼±ÅÃÇÏ°í, µ¥ÀÌÅÍº£ÀÌ½º ½Ã½ºÅÛÀÇ hostname¿Í
	µ¥ÀÌÅÍº£ÀÌ½ºÀÇ ÀÎ½ºÅÏ½º ÀÌ¸§À» ÀÔ·ÂÇÑ´Ù.
	¿Ï·áµÇ¾ú´Ù.
	±×·¯³ª, SQL*Net Easy Configuration ToolÀÌ ¾ø´Ù°í °ÆÁ¤ÇÏÁö ¸»¶ó. ¼­¹ö¿¡
	Á¸ÀçÇÏ´Â °÷°ú °°Àº Å¬¶óÀÌ¾ðÆ® ½Ã½ºÅÛ¿¡¼­
	$ORACLE_HOME/network/adminµð·ºÅä¸®¿¡ tnsnames.ora¿Í sqlnet.oraÆÄÀÏÀ»
	»ý¼ºÇÑ´Ù. ÀÌ°ÍÀº ¼­¹ö¿¡¼­(¾î¶² ÀÇ¹Ì¿¡¼­´Â Ç×»ó ÁÁÀº »ý°¢ÀÎ)¿Í °°Àº
	alias¸¦ Áö¿øÇÒ °ÍÀÌ´Ù.
</p>

<sect1> Unix Å¬¶óÀÌ¾ðÆ®
<p>	UNIX Å¬¶óÀÌ¾ðÆ®´Â À©µµ¿ì Å¬¶óÀÌ¾ðÆ®¿Í ¸Å¿ì ´Ù¸£Áö ¾Ê´Ù. Oracle¿¡¼­
	Á¦°øÇÏ´Â Network ManagerÀÌ ÀÖ´Ù¸é, À§¿¡¼­ ¾ð±ÞÇÑ ³»¿ë°ú °°Àº ¹æ¹ýÀ¸·Î
	ÇÏ¸é µÈ´Ù. ¸¸¾à ±×·¸°Ô ÇÒ ¼ö ¾ø´Ù¸é, ¼­¹ö¿¡ Á¸ÀçÇÏ´Â
	$ORACLE_HOME/network/adminµð·ºÅä¸®¿¡ ÀÖ´Â ÆÄÀÏµéÀÇ ¼³Á¤°ú °°Àº °ÍÀ»
	ÀÌ¿ëÇÏ¸é µÈ´Ù.
</p>

<sect>ÀÚµ¿ ½ÃÀÛ°ú ÁßÁö
<sect1> dbstart &amp; dbstop
<p>	Oracle µ¥ÀÌÅÍº£ÀÌ½ºÀÇ ÀÚµ¿ ½ÃÀÛ°ú ÁßÁö´Â Oracle¿¡¼­ Á¦°øÇÏ´Â ÆÄÀÏÀÎ
	dbstart¿Í dbstop¸¦ ÀÌ¿ëÇÏ¿© ¼³Á¤(¹öÀü 7.3.3.0.0)ÇÒ ¼ö ÀÖ´Ù. ÀÌ·¯ÇÑ
	ÆÄÀÏµéÀº µ¿ÀÛ(ºñ·Ï dbstart¿Í dbshutÆÄÀÏÀ» ¹Ù²Ü¼ö ÀÖÁö¸¸, ¿Å°ÜÁú ¼ö
	ÀÖ´Ù.)ÇÒ ¼ö ÀÖ´Â etc/oratab ÆÄÀÏÀÇ Á¸Àç¿©ºÎ¿¡ ÀÇÁ¸ÇÑ´Ù.
	/etc/oratab ÆÄÀÏÀÇ Çü½ÄÀº ´ÙÀ½°ú °°´Ù.
<code>
       	SID:ORACLE_HOME:AUTO
</code>
	¿¹)
<code>
       orcl:/home/oracle/7.3.3.0.0:Y
       leaveup:/home/oracle/7.3.2.1.0:N
</code>
</p>

<sect1> init.d &amp; rc.d
<p>	¸®´ª½º ½Ã½ºÅÛÀÇ ½ÃÀÛ°úÁ¤ÀÌ³ª Á¾·á°úÁ¤À» º¯ÇüÇÏ¿© µ¥ÀÌÅ¸º£ÀÌ½º¸¦ ½ÃÀÛ½ÃÅ°°í Á¾·á½ÃÅ³¼ö ÀÖ´Ù. 
	ÀÌ°ÍÀº ¸Å¿ì½±Áö¸¸, ¾î¶°ÇÑ Linux(slackware, debian, redhat, etc)½Ã½ºÅÛÀ» »ç¿ëÇÏ´À³Ä¿¡ µû¶ó  º¯°æµÉ¼ö ÀÖ´Ù´Â °ÍÀ» ÇÊÀÚ´Â ÁöÀûÇÑ´Ù. 
	ÀÌ ¹®¼­¿¡¼­´Â Redhat Linux 5.0¿¡¼­ µ¿ÀÛÇÏ´Â ¿¹¸¦ º¸¿©ÁÙ °ÍÀÌ´Ù. 	
	ÀÚ½ÅÀÇ Linux ½Ã½ºÅÛ¿¡ µû¶ó ¼öÁ¤ÇÏ±âÀ§ÇØ¼­´Â ÀÚ½ÅÀÇ Linux ½Ã½ºÅÛ ¹®¼­ ÀÚ·á¸¦ Âü°íÇÑ´Ù.
	(ºñ·Ï ±×·¯ÇÑ °ÍÀÌ Unix ½Ã½ºÅÛÀÇ Sys V °è¿­À» À§ÇÑ °Í¿¡ Àû¿ëµÇ´õ¶óµµ)
	¿ì¼±, ¿ì¸®´Â /etc/rc.d/init.d µð·ºÅä¸®¿¡ ÀÖ´Â dbshut¿Í dbstart¸¦
	½ÇÇàÇÒ ½ºÅ©¸³Æ®¸¦ »ý¼ºÇÒ ÇÊ¿ä°¡ ÀÖ´Ù.
<code>
  #!/bin/sh
  #
  # /etc/rc.d/init.d/oracle
  # Description: Starts and stops the Oracle database and listeners
  # See how we were called.
  case &quot;$1&quot; in
    start)
          echo -n &quot;Starting Oracle Databases: &quot;
          echo &quot;----------------------------------------------------&quot;
	  &gt;&gt; /var/log/oracle
          date +&quot;! %T %a %D : Starting Oracle Databases as part of system up.&quot; 
	  &gt;&gt; /var/log/oracle
          echo &quot;----------------------------------------------------&quot;
	  &gt;&gt; /var/log/oracle
          su - oracle -c dbstart &gt;&gt; /var/log/oracle
          echo &quot;Done.&quot;
          echo -n &quot;Starting Oracle Listeners: &quot;
          su - oracle -c &quot;lsnrctl start&quot; &gt;&gt; /var/log/oracle
          echo &quot;Done.&quot;
          echo &quot;&quot;
          echo &quot;----------------------------------------------------&quot;
	  &gt;&gt; /var/log/oracle
          date +&quot;! %T %a %D : Finished.&quot; &gt;&gt; /var/log/oracle
          echo &quot;----------------------------------------------------&quot;
	  &gt;&gt; /var/log/oracle
          touch /var/lock/subsys/oracle
          ;;
    stop)
          echo -n &quot;Shutting Down Oracle Listeners: &quot;
          echo &quot;----------------------------------------------------&quot;
	  &gt;&gt; /var/log/oracle
          date +&quot;! %T %a %D : ShutDown Oracle Databases as part of system down.&quot; 	  &gt;&gt; /var/log/oracle
          echo &quot;----------------------------------------------------&quot;
	  &gt;&gt; /var/log/oracle
          su - oracle -c &quot;lsnrctl stop&quot; &gt;&gt; /var/log/oracle
          echo &quot;Done.&quot;
          rm -f /var/lock/subsys/oracle
          echo -n &quot;Shutting Down Oracle Databases: &quot;
          su - oracle -c dbshut &gt;&gt; /var/log/oracle
          echo &quot;Done.&quot;
          echo &quot;&quot;
          echo &quot;----------------------------------------------------&quot;
	  &gt;&gt; /var/log/oracle
          date +&quot;! %T %a %D : Finished.&quot; &gt;&gt; /var/log/oracle
          echo &quot;----------------------------------------------------&quot;
	  &gt;&gt; /var/log/oracle
          ;;
    restart)
          echo -n &quot;Restarting Oracle Databases: &quot;
          echo &quot;----------------------------------------------------&quot;
	  &gt;&gt; /var/log/oracle
          date +&quot;! %T %a %D : Restarting Oracle Databases as part of system up.&quot; 	  &gt;&gt; /var/log/oracle
          echo &quot;----------------------------------------------------&quot;
	  &gt;&gt; /var/log/oracle
          su - oracle -c dbstop &gt;&gt; /var/log/oracle
          su - oracle -c dbstart &gt;&gt; /var/log/oracle
          echo &quot;Done.&quot;
          echo -n &quot;Restarting Oracle Listeners: &quot;
          su - oracle -c &quot;lsnrctl stop&quot; &gt;&gt; /var/log/oracle
          su - oracle -c &quot;lsnrctl start&quot; &gt;&gt; /var/log/oracle
          echo &quot;Done.&quot;
          echo &quot;&quot;
          echo &quot;----------------------------------------------------&quot;
	  &gt;&gt; /var/log/oracle
          date +&quot;! %T %a %D : Finished.&quot; &gt;&gt; /var/log/oracle
          echo &quot;----------------------------------------------------&quot;
	  &gt;&gt; /var/log/oracle
          touch /var/lock/subsys/oracle
          ;;
    *)
          echo &quot;Usage: oracle {start|stop|restart}&quot;
          exit 1
  esac
</code>
	ÀÌ ÆÄÀÏÀÌ ½ÇÁ¦ÀûÀ¸·Î Á¤È®È÷ ´ç½ÅÀÇ ½Ã½ºÅÛ¿¡¼­  µ¥ÀÌÅÍº£ÀÌ½º¸¦
	ÁßÁöÇÏ°í ½ÇÇà½ÃÅ°´ÂÁö¸¦ È®ÀÎÇØ¾ß ÇÑ´Ù. ¿¡·¯¸Þ¼¼Áö¸¦ À§ÇÑ
	/var/log/oracleÀÎ log ÆÄÀÏÀ» È®ÀÎÇÏ¶ó.
	´ÙÀ½ ¸í·ÉµéÀº ½ÇÇà¼öÁØ 2,3,4¿¡ ÇØ´çÇÏ´Â µ¥ÀÌÅ×º£ÀÌ½º¸¦ ½ÇÇà½Ã´Â´Â °ÍÀ»
	È®ÀÎ ½ÃÄÑÁÙ °ÍÀÌ´Ù.
<code>
       $ ln -s ../init.d/oracle /etc/rc.d/rc2.d/S99oracle
       $ ln -s ../init.d/oracle /etc/rc.d/rc3.d/S99oracle
       $ ln -s ../init.d/oracle /etc/rc.d/rc4.d/S99oracle
</code>
	½Ã½ºÅÛÀ» Àç ºÎÆÃÇÏ°Å³ª, Àç ½ÇÇà½ÃÅ³¶§¿¡ µ¥ÀÌÅÍº£ÀÌ½º¸¦
	ÁßÁö½ÃÅ°±âÀ§ÇØ¼­ ¿ì¸®´Â ´ÙÀ½°ú °°Àº ¿¬°á(link)ÀÌ ÇÊ¿äÇÑ´Ù.
<code>
       $ ln -s ../init.d/oracle /etc/rc.d/rc0.d/K01oracle          # Halting
       $ ln -s ../init.d/oracle /etc/rc.d/rc6.d/K01oracle          # Rebooting
</code>
</p>

<sect>´Ù¸¥ ºÎºÐµé
<sect1>Áö´ÉÇü ¿¡ÀÌÀüÆ®
<p>	Oracle Intelligent AgentÀ» ÇÊ¿ä·Î ÇÑ´Ù¸é, È¯°æ¼³Á¤ÀÇ º¯È­¾øÀÌ
	°¡´ÉÇÏ´Ù. IA¸¦ ½ÇÇàÇÏ±â À§ÇØ¼­´Â ´ÙÀ½°ú °°´Ù.
<code>
       $ lsnrctl dbsnmp_start
</code>
	IA¸¦ ÁßÁö½ÃÅ°±â À§ÇØ¼­´Â ´ÙÀ½°ú °°´Ù.
<code>
       $ lsnrctl dbsnmp_stop
</code>
	¼º°øÀ» ³ªÅ¸³»°Å³ª Intelligent Agent¸¦ ½ÇÇàÇÏ°Å³ª, ÁßÁöÇÏ´Â ¾î¶°ÇÑ
	¸Þ½ÃÁöµµ Ãâ·ÂÇÏÁö ¾Ê´Â´Ù. 
	ÀÎÅÚ¸®ÀüÆ® ¸Þ´ÏÀú´Â ¿À¶óÅ¬µ¥ÀÌÅ¸º£ÀÌ½º °ü¸® Å¬¶óÀÌ¾ðÆ® ¼ÒÇÁÆ®¿þ¾îÀÎ
	Enterprise Manager¿Í ¿¬°áÇÏ±âÀ§ÇÑ °ÍÀÌ´Ù.
	È®ÀÎÇÏ´Â ¹æ¹ýÀº ¿À¶óÅ¬ Enterprise Manager¿¡¼­ ÇÒ ¼ö ÀÖ´Ù. 
</p>

<sect>¹®Á¦ÇØ°á
<p>	¿©·¯ °¡Áö ´Ù¾çÇÑ ¹®Á¦ÇØ°á ½Ç¸¶¸®(hints)µéÀº ´ÙÀ½°ú °°´Ù.
</p>

<sect1>  Oracle 7.2.x¸¦ »ç¿ëÇÒ ¶§, ³ª´Â µ¥ÀÌÅÍº£ÀÌ½º¸¦ »ý¼ºÇÒ ¼ö ¾ø´Ù.<p>
	7.2.x Á¦Ç°Áß¿¡¼­ Oracle¿¡¼­ Á¦°øµÇ´Â ÀÌ·¯ÇÑ ÆÄÀÏµéÀº º´·Ä¼­¹öÈ¯°æÀ»
	±¸ÃàÇÏ·Á´Â °ÍÀ» ½ÃµµÇÏ·Á´Â °ÍÀº Á¤È®ÇÏÁö ¾Ê´Ù. Á¦°øµÇ´Â init.oraÆÄÀÏÀº
	´ÙÀ½°ú °°Àº ÁÙÀÇ ³»¿ëÀ» Æ÷ÇÔÇÑ´Ù.
<code>
       # define parallel server (multi-instance) parameters
       ifile = ora_system:initps.ora
</code>
	¹®Á¦¸¦ ÇØ°áÇÏ±â À§ÇØ¼­´Â ´Ü¼øÈ÷ ÁÖ¼®Ã³¸®¸¦ ÇÏ¸éµÈ´Ù.
<code>
       # define parallel server (multi-instance) parameters
       #ifile = ora_system:initps.ora
</code>
</p>
<sect1> 3.4.x.¹öÀü¿¡¼­ svrmgrl½ÇÇàÁß segmentation ¿À·ù¸¦ ¾ò¾ú´Ù.<p>
	ÀÌ·¯ÇÑ ¹®Á¦µéÀº ¸¹Àº »ç¶÷µé¿¡°Ô¼­ ¾Ë·ÁÁ³´Ù. Gerald Weber
	<url url="mailto:gerald_weber@master.co.at" name="gerald_weber@master.co.at">°¡ ÇØ°áÇÏ¿´´Ù.
<code>
 	¾È³ç Paul,
 	´ç½ÅÀÇ µµ¿ò¿¡ ¿ì¼± °¨»çÇÑ´Ù. ¹®Á¦´Â iBCS-emulator ÀÚÃ¼ÀÌ´Ù.
	Oracle½Ã½ºÅÛÀÌ iBCSÀÇ ÇöÀç ¹öÀü¿¡¼­ Áö¿øÇÏÁö ¾Ê´Â sysconf-callsÀ»
	¼öÇàÇÏ´Â °Í °°´Ù.
  	&lt;7&gt;[22]615 sysconf(34)
  	&lt;7&gt;iBCS2 unsupported sysconf call 34
  	&lt;7&gt;[22]615 sysconf error return linux=-22 -&gt; ibcs=22 &lt;Invalid argument&gt;
  	&lt;7&gt;[24]615 sysconf(34)
  	&lt;7&gt;iBCS2 unsupported sysconf call 34
  	&lt;7&gt;[24]615 sysconf error return linux=-22 -&gt; ibcs=22 &lt;Invalid argument&gt;
 ¹®Á¦ÇØ°á : ´ÙÀ½°ú °°Àº diff-pach¸¦ iBCS-source.apply¿¡ Àû¿ëÇÑ´Ù

 --- sysconf.c   Sun Apr 19 19:19:15 1998
  +++ sysconf.c.ori       Sun Apr 19 19:28:45 1998
  @@ -60,7 +60,6 @@
   #define _SC_JOB_CONTROL        5
   #define _SC_SAVED_IDS  6
   #define _SC_VERSION    7
  -#define _SC_HACK_FOR_ORACLE 34
  #define _SC_PAGESIZE   11
 @@ -97,11 +96,6 @@
                  case _SC_SAVED_IDS: {
                          return (1);
                  }
  -
  -               case _SC_HACK_FOR_ORACLE: {
  -                 return (1);
  -               }
  -
                 case _SC_PAGESIZE: {
                    return PAGE_SIZE;
</code>
</p>

<sect>µµ¿ÍÁÖ½Å ºÐµé
<p>ÀÌ¹®¼­´Â Bob Withers( <url url="mailto:bwit@pobox.com" name="bwit@pobox.com">)°¡ ÀÛ¼ºÇÑ ¹®¼­¸¦ ±âº»À¸·Î ÇÏ¿´°í,
Georg Rehfeld(<url url="mailto:rehfeld@wmd.de" name="rehfeld@wmd.de">)¿Í David Mansfield(
<url url="mailto:david@claremont.com" name="david@claremont.com">)°¡ Á¦°øÇÑ Á¤º¸¸¦ Ãß°¡ÇÏ¿´½À´Ï´Ù.
Bob Withers, Mark Watling( <url url="mailto:mwatling@mjw-ltd.demon.co.uk" name="mwatling@mjw-ltd.demon.co.uk">), Peter
Sodhi(<url url="mailto:petersodhi@unn.unisys.com" name="petersodhi@unn.unisys.com">)°ú
Greg Hankins(<url url="mailto:greg.hankins@cc.gatech.edu" name="greg.hankins@cc.gatech.edu">)°¡ ¹®¼­¸¦ °ËÁõÇÏ¿´½À´Ï´Ù.
ÇÔ²² Á¶»çÇÏ°í ¹®¼­ÀÛ¾÷À» ÇØÁØ ¸ðµç »ç¶÷µé¿¡°Ô °¨»çÇÕ´Ï´Ù. Ãß°¡ ÁÖ¼®°ú
Á¶¾ðÀ» ÇØÁØ Bob Withers °ú Mark Watling 
¿¡°Ô Æ¯º°È÷ °¨»çÇÕ´Ï´Ù.
</p>
</article>


