Oracle Database HOWTO
Paul Haigh, paul@nailed.demon.co.uk <mailto:paul@nailed.demon.co.uk>
(¹ø¿ª:Á¶È«·¡ chorr@uriel.net <mailto:chorr@uriel.net>)
v1.1, 20 June 1998
¸®´ª½º ½Ã½ºÅÛ¿¡¼ ¿À¶óŬ µ¥ÀÌÅͺ£À̽º ¼¹ö ¼³Ä¡/¼³Á¤ °¡À̵å
______________________________________________________________________
¸ñÂ÷
1. °³¿ä
1.1 ¹®¼¹öÀü
1.2 ÀúÀÛ±Ç
1.3 Ã¥ÀÓ¿¡ ´ëÇÑ Æ÷±â
1.4 HowToÀÇ ¸ñÀû
1.5 ¾ÕÀ¸·ÎÀÇ °³¼±»çÇ×
2. ¿À¶óŬ ¼ÒÇÁÆ®¿þ¾î ¼³Ä¡
2.1 ¼¹öÁغñ»çÇ×
2.1.1 ¿À¶óŬ»ç¿ëÀÚ µî·Ï
2.2 CDROMÀ¸·Î ¼³Ä¡
2.3 ¼³Ä¡ÀÛ¾÷
2.3.1 Root¸¦ À§ÇÑ ÀÛ¾÷
2.3.2 OracleÀ» À§ÇÑ ÀÛ¾÷
2.3.3 ´ç½ÅÀÌ »èÁ¦ÇÒ ¼ö ÀÖ´Â ºÎºÐµé
3. µ¥ÀÌÅͺ£À̽º »ý¼º
3.1 ¼³Ä¡°ü·Ã ÆÄÀÏ ¼³Ä¡
3.2 µ¥ÀÌÅͺ£À̽º ¼³Ä¡ ½ºÅ©¸³Æ®¸¦ »ý¼º
3.3 µ¥ÀÌÅͺ£À̽º ¼³Ä¡ ½ºÅ©¸³Æ®¸¦ ½ÇÇà
3.4 µ¥ÀÌÅͺ£À̽º ±¸µ¿½ÃÅ°±â
3.5 µ¥ÀÌÅͺ£À̽º ÁßÁö½ÃÅ°±â
3.6 ±âº»»ç¿ëÀÚ »ý¼º
4. ¼¹ö¿¡ SQL*NetÀ» ¼³Á¤Çϱâ
4.1 tnsnames.ora
4.2 listener.ora
4.3 sqlnet.ora
4.4 ListenerÀ» ½ÇÇà½ÃÅ°°í Á¾·áÇϱâ
5. Ŭ¶óÀ̾ðÆ® ȯ°æ ¼³Á¤
5.1 À©µµ¿ìȯ°æ Ŭ¶óÀ̾ðÆ®
5.2 Unix Ŭ¶óÀ̾ðÆ®
6. ÀÚµ¿ ½ÃÀÛ°ú ÁßÁö
6.1 dbstart & dbstop
6.2 init.d & rc.d
7. ´Ù¸¥ ºÎºÐµé
7.1 Áö´ÉÇü ¿¡ÀÌÀüÆ®
8. ¹®Á¦ÇØ°á
8.1 Oracle 7.2.x¸¦ »ç¿ëÇÒ ¶§, ³ª´Â µ¥ÀÌÅͺ£À̽º¸¦ »ý¼ºÇÒ ¼ö ¾ø´Ù.
8.2 3.4.x.¹öÀü¿¡¼ svrmgrl½ÇÇàÁß segmentation ¿À·ù¸¦ ¾ò¾ú´Ù.
9. µµ¿ÍÁֽŠºÐµé
______________________________________________________________________
1. °³¿ä
1.1. ¹®¼¹öÀü
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 - ¹®Á¦Á¡ÇØ°á ºÎºÐÃß°¡.
1.2. ÀúÀÛ±Ç
¸®´ª½º HOWTO ¹®¼µéÀÇ ÀúÀÛ±ÇÀº °¢ ¹®¼ÀÇ ÀúÀڵ鿡°Ô ÀÖ´Ù. ¸®´ª½º
HOWTO´Â ÀÌ ÀúÀÛ±ÇÀÌ À¯ÁöµÇ´Â ÇÑ ¸ðµç ¹°¸®Àû ¸Åü³ª ÀüÀÚ ¸Åü¸¦ ÅëÇØ
¹®¼ Àüü ȤÀº ºÎºÐÀ¸·Î¼ Àç»ý»ê ¹× ¹èÆ÷µÉ ¼ö ÀÖ´Ù. »ó¾÷ÀûÀÎ Àç¹èÆ÷µµ
Çã¿ëµÇ¸ç Àå·ÁµÈ´Ù. ÇÏÁö¸¸ ÀÌ·± °æ¿ì¿¡´Â ÀúÀÚ¿¡°Ô ¾Ë·ÁÁֱ⠹ٶõ´Ù.
¸ðµç ¹ø¿ªÀ̳ª ÆÄ»ýÀûÀÎ ÀÛ¾÷µé, ¸®´ª½º HOWTO ¹®¼µéÀ» °áÇÕÇÏ´Â ÀÛ¾÷µéÀº
ÀÌ ÀúÀÛ±Ç ¾È³»¿¡ µû¶ó¾ß ÇÑ´Ù. ÀÌ´Â ¿©·¯ºÐÀÌ HOWTO¸¦ ÀÌ¿ëÇÑ ÀÛ¾÷À»
ÇÏ°í ³ª¼ ±× ¹èÆ÷¿¡ ºÎ°¡ÀûÀÎ Á¦ÇÑÁ¶°ÇÀ» ´Þ¾Æ¼´Â ¾ÈµÈ´Ù´Â ¶æÀÌ´Ù.
¾î¶² °æ¿ì¿¡´Â ÀÌ ±ÔÄ¢¿¡ ´ëÇÑ ¿¹¿Üµµ Çã¿ëµÉ ¼ö ÀÖÀ¸¹Ç·Î, ¾Æ·¡ ÁÖ¼Ò¸¦
ÅëÇؼ ¸®´ª½º HOWTO Á¶Á¤ÀÚ¿Í Á¢ÃËÇϱ⠹ٶõ´Ù. °£´ÜÈ÷ ¸»Çؼ ¿ì¸®´Â ÀÌ
Á¤º¸¸¦ °¡´ÉÇÑ ÇÑ ¸¹Àº °æ·Î¸¦ ÅëÇؼ º¸±ÞÇϱ⸦ ¹Ù¶õ´Ù. ÇÏÁö¸¸
¿ì¸®´Â HOWTO ¹®¼¿¡ ´ëÇÑ ÀúÀÛ±ÇÀÌ À¯ÁöµÇ±â¸¦ ¹Ù¶ó¸ç, HOWTO¸¦
Àç¹èÆ÷ÇÏ´Â ¸ðµç °èȹÀ» Å뺸¹Þ±â¸¦ ¹Ù¶õ´Ù.
1.3. Ã¥ÀÓ¿¡ ´ëÇÑ Æ÷±â
ÇÊÀÚ´Â µÉ¼ö ÀÖ´Â ÇÑ ¿Ã¹Ù¸¥ Á¤º¸¸¦ Á¦°øÇϱâ À§ÇÏ¿© ³ë·ÂÇÏ¿´Áö¸¸, ºÎÁ·ÇÑ
Á¤º¸ÀÇ °á°ú·Î¼ ÀϾ´Â ÀÏ¿¡ ´ëÇؼ´Â Ã¥ÀÓÀ» Áú ¼ö ¾ø´Ù. ÇÊÀÚ´Â
HOWTO ¹®¼ÀÇ Á¤º¸¿¡ ´ëÇؼ º¸ÁõÇÒ ¼ö¾øÀ¸¸ç, HOWTO¹®¼ÀÇ Á¤º¸¸¦
°¡Áö°í ¼öÇàÇÏ´Â ÀÏ·ÃÀÇ ÀÛ¾÷¿¡ ´ëÇؼµµ Ã¥ÀÓÁú ¼ö ¾ø´Ù.
1.4. HowToÀÇ ¸ñÀû
ÀÌ Howto¹®¼¿¡¼´Â ¸®´ª½º ¸Ó½Å¿¡¼ µ¿ÀÛÇÏ´Â ¿À¶óŬµ¥À̺£À̽ºÀÇ
±âº»ÀûÀμ³Ä¡¿Í ±âº»ÀûÀÎ °ü¸®ºÎºÐÀ» ´Ù·ê °ÍÀÌ´Ù. Ưº°È÷
¿À¶óŬ¼¹ö/SQL*Net ¼³Ä¡¹× SQL*Net Ŭ¶óÀ̾ðÆ® ¼³Á¤ºÎºÐÀ» ´Ù·é´Ù. ÀÌ
¹®¼´Â ¿À¶óŬ º£À̽ºÀÇ ¼¼ºÎ°ü¸® ¶Ç´Â »ç¿ë¿¡ ´ëÇÑ ±íÀÌÀÖ´Â ºÎºÐÀ»
´Ù·çÁö ¾ÊÀ¸¸ç, ÀÌ¿Í °°Àº ³»¿ëÀ» ã À¸·Á°í ÇÑ´Ù¸é O'Reilly¶Ç´Â ´Ù¸¥
ÃâÆǻ翡¼ ³ª¿Â Ã¥µéÀ» »ìÆ캸±â ¹Ù¶õ´Ù. À̹®¼¿¡¼´Â Unix¿¡¼
µ¿ÀÛÇÏ´Â ¿À¶óŬÇÁ·Î±×·¥ÀÇ °³¹ß¿¡ ´ëÇؼµµ ¾ð±ÞÇÏÁö ¾Ê´Â´Ù. À̺κп¡
´ëÇØ ÇÊ¿äÇÏ´Ù¸é SCO·Î ºÎÅÍ SCO°³¹ß½Ã½ºÅÛ (OpenServer 5.X)¸¦ ±¸ÀÔÇÒ
°ÍÀ» ±ÇÀåÇÑ´Ù. SCO °³¹ß½Ã½ºÅÛÀº www.sco.com <http://www.sco.com>¿¡¼
$19¶ó´Â Àú·ÅÇÑ °¡°ÝÀ¸·Î ±¸ÀÔÇÒ ¼ö ÀÖ´Ù. HOWTO ¹®¼¸¦ µû¶óÇϱâ À§ÇØ
ÇÊ¿äÇÑ ¸î°¡Áö Ç׸ñ¿¡ ´ëÇØ ¾ð±ÞÇÑ´Ù. ?Oracle Server CD for SCO
OpenServer (version 7.3.3.0.0)
ÀÌ°ÍÀº ÇÕ¹ýÀûÀÎ º¹»çº»À̾î¾ßÇÑ´Ù. ±â¾ïÇÒ °ÍÀº ¿À¶óŬÀº ¿µ¸®¸¦
Ãß±¸ÇϱâÀ§ÇÑ È¸»çÀ̸ç ÀÌ Á¦Ç°¿¡ ´ëÇÑ Ã¥ÀÓÀÖ´Ù. ¸¸¾à SQL ±â¹ÝÀÇ ´Ù¸¥
µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ëÇϱ⠿øÇÑ´Ù¸é PostgresSQL¶Ç´Â ±×¿Í À¯»çÇÑ
µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ëÇÏ¸é µÈ´Ù. Oracle Web Site·ÎºÎÅÍ 60ÀÏ Æò°¡ÆÇÀ»
ÅëÇØ ¼³Ä¡ ÇØ º¼¼öµµ ÀÖ´Ù. ÇÊÀÚ °³ÀÎÀûÀ¸·Î ÀÌ·± ¹æ¹ýÀ¸·Î ¼³Ä¡Çغ¸Áø
¾Ê¾ÒÀ¸¸ç ÀÌ°ÍÀº ¿ÏÀüÈ÷ °ËÁõµÈ ¹æ¹ýÀº ¾Æ´Ï´Ù.
Linux Server À̰͸¶Àú ¼³Ä¡µÇ¾îÀÖÁö ¾Ê´Ù¸é ¹®¼¸¦ ÀÐÁöµµ
¾Ê¾ÒÀ»°ÍÀÌ´Ù. Kernel 2.0.30+ ´Ù¸¥ Kernel¿¡ ´ëÇؼ´Â º¸ÀåÇÒ ¼ö°¡ ¾ø´Ù.
iBCS iBCS°¡ ¼³Ä¡µÇ¾îÇÏ´Â °ÍÀº ¸Å¿ìÁß¿äÇÑ ºÎºÐÀÌ°í °¡´ÉÇÑÇÑ °¡ÀåÃÖ±ÙÀÇ
¹öÀüÀ» »ç¿ëÇÒ °ÍÀ» ÃßõÇÑ´Ù. (ÇÊÀÚ´Â ·¹µåÇÞÀÇ iBCS-2.0-10.i386.rpmÀ»
»ç¿ëÇÏ°í ÀÖ´Ù.) ´ë¿ë·®µð½ºÅ© 600¸Þ°¡¹ÙÀÌÆ®ÀÌ»óÀÌ Àû´çÇÑ µð½ºÅ© ¿ë·®ÀÏ
°ÍÀÌ´Ù. ÀÌ ¿ë·®À» ¸ðµÎ¸¦ »ç¿ëÇÒ ÇÊ¿ä°¡ ¾ø´Ù°í »ý°¢ÇÑ´Ù¸é ´õ ÀûÀº ¾çÀ»
»ç¿ëÇصµ °¡´ÉÇÏ´Ù. ÇÏÁö¸¸ °³ÀÎÀûÀ¸·Î ÃßõÇÏ°í ½ÍÁö´Â ¾Ê´Ù. 32Mb +
Ram RamÀ» ¸¹ÀÌ »ç¿ëÇÑ´Ù°í ´À³¢°ÚÁö¸¸ ¿À¶óŬ µ¥ÀÌŸº£À̽º´Â º¹ÀâÇÑ
Á¾·ùÀÇ ¼ÒÇÁÆ®¿þ¾î¶ó´Â °ÍÀ» ±â¾ïÇؾßÇÑ´Ù. ±×·¸´Ù°í Çؼ ¿À¶óŬÀ̳ª
ÇÊÀÚ°¡ ´õ Àû Àº ·¥¿¡¼ ¿À¶óŬ µ¥ÀÌŸº£À̽º ÀÛµ¿À» ÇÏÁö¾Ê´Â´Ù´Â °ÍÀº
¾Æ´Ï´Ù. ´ÜÁö, ÃßõÇÒ ¸¸ÇÑ ·¥ÀÇ ¿ë·®ÀÌ 32¸Þ°¡ ¹ÙÀÌÆ®¶ó´Â°ÍÀÌ´Ù.
1.5. ¾ÕÀ¸·ÎÀÇ °³¼±»çÇ×
ÀÌ HOWTO ¹®¼¿¡¼´Â ¿À¶óŬ µ¥ÀÌŸº£À̽º ¼¹ö ÀÚü¿¡ ´ëÇؼ´Â ´Ù·çÁö
¾Ê´Â´Ù. ±×·¯³ª, ½Ã°£ÀÌ Çã¶ôµÈ´Ù¸é ´ÙÀ½ HOWTO ¹öÀü¿¡¼ ¾Æ·¡ÀÇ Ç׸ñµéÀ»
Æ÷ÇÔ½Ãų°ÍÀÌ´Ù.
o Oracle ¶óÀ̺귯¸®¸¦ »ç¿ëÇÑ Oracle Pro* ÇÁ·Î±×·¥ÀÇ °³¹ß
o ´Ù¸¥ ¿À¶óŬ¼¹ö¹öÀü ¼³Ä¡
o ¿À¶óŬ À¥¼¹öÀÇ ¼³Ä¡
o Oracle Kernel Relink
2. ¿À¶óŬ ¼ÒÇÁÆ®¿þ¾î ¼³Ä¡
2.1. ¼¹öÁغñ»çÇ×
2.1.1. ¿À¶óŬ»ç¿ëÀÚ µî·Ï
¿À¶óŬµ¥ÀÌÅͺ£À̽º¸¦ »ç¿ëÇϱâ À§Çؼ´Â ¿À¶óŬµ¥ÀÌÅͺ£À̽º¸¦ À¯Áö/°ü¸®
ÇÒ¼ö ÀÖ´Â »ç¿ëÀÚ°¡ ÀÖ¾î¾ß¸¸ÇÑ´Ù. ¿ì¸®°¡ ¿À¶óŬĿ³Î(ÃßÈÄ¿¡ ÀÚ¼¼ÇÑ
¼³¸í)¸¦Àç¼³Á¤ÇÏ·Á´Â Àǵµ´Â ¾ø±â ¶§¹®¿¡ ¿ì¸®´Â »ç¿ëÀÚÀ̸§°ú ±×·ìÀ̸§À»
À§ÇÑ ¿À¶óŬ¿¡¼ Á¦°øÇÏ´Â ¼³Á¤À» ¹Þ¾Æµé¿©¾ßÇÑ´Ù. ÀÌ ºÎºÐÀº »ç¿ëÀÚ
ORACLE°ú ±×·ì DBA·Î ÁöÁ¤µÇ¾î ÀÖ´Ù.
1. Root·Î½á ·Î±×ÀÎ
2. oracle À¯Àú¿Í dba ±×·ì »ý¼º
___________________________________________________________________
$ groupadd dba
$ useradd oracle
___________________________________________________________________
3. À¯Àú oracleÀ» À§ÇÑ home µð·ºÅ丮 »ý¼º
___________________________________________________________________
$ mkdir /home/oracle
$ mkdir /home/oracle/7.3.3.0.0 (Version of Oracle)
$ chown -R oracle.dba /home/oracle
___________________________________________________________________
2.2. CDROMÀ¸·Î ¼³Ä¡
¾Æ½±°Ôµµ SCO°è¿ÀÇ µð½ºÅ©¿¡¼ÀÇ Oracle Installer´Â Á¦´ë·Î µ¿ÀÛÇÏÁö
¾ÊÀ» °ÍÀÌ´Ù. Core DumpºÎÅÍ ½Ã½ºÅÛ Á¤Áö±îÁö ´Ù¾çÇÑ ¹®Á¦¸¦
°æÇèÇÏ¿´´Ù. °á°úÀûÀ¸ ·Î ¿ì¸®´Â CDROM¿¡¼ ÆÄÀϵéÀ» º¹»çÇÏ¿©
¾ÐÃàÀ» Ç® ÇÊ¿ä°¡ ÀÖ´Ù. (CDROMÀÌ ½Ã½ºÅÛ¿¡ ¸¶¿îÆ®µÇ¾ú´ÂÁö È®ÀÎ)
1. Oracle·Î ·Î±×ÀÎ
2. /home/oracle/7.3.3.0.0µð·ºÅ丮·Î À̵¿
3. CDROM¿¡¼ ¼³Ä¡ÆÄÀÏÀ» º¹»ç
___________________________________________________________________
$ cp -a /mnt/cdrom/* .
___________________________________________________________________
4. CDROM¿¡ ÀÖ´Â Oracle°ü·ÃÆÄÀÏÀÇ ¾ÐÃàÀ» Ç®±â
___________________________________________________________________
$ find . -name *_ -exec ~/7.3.3.0.0/orainst/oiuncomp {} \;
___________________________________________________________________
2.3. ¼³Ä¡ÀÛ¾÷
2.3.1. Root¸¦ À§ÇÑ ÀÛ¾÷
OracleÀ» »ç¿ëÇÒ °¢ »ç¿ëÀÚ¸¦ À§ÇÑ /etc/profile³ª .profile¿¡ ´ÙÀ½ÁÙÀ»
Ãß°¡ÇÑ´Ù.
______________________________________________________________________
# 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="$PATH:$ORACLE_HOME/bin"
______________________________________________________________________
¿ì¸®´Â ¶ÇÇÑ ¼ÒÀ¯±ÇÇÑÀÚ¸¦ ¹Ù²Ü ÇÊ¿ä°¡ ÀÖ°í OracleÀÇ ±ÇÇÑÀ» Æí¸®ÇÏ°Ô
»ç¿ëÇÒ ¼ö ÀÖµµ·Ï Ãß°¡ÇÑ´Ù.
______________________________________________________________________
$ chown root.root $ORACLE_HOME/bin/osh
$ chmod u+s $ORACLE_HOME/bin/osh
______________________________________________________________________
2.3.2. OracleÀ» À§ÇÑ ÀÛ¾÷
Á¤È®ÇÑ µ¿ÀÛÀ» È®ÀÎÇϱâ À§ÇÑ Oracle°ü·Ã ÆÄÀÏÀÇ ±ÇÇÑÀ» º¯°æÇÑ´Ù.
______________________________________________________________________
$ chmod +x $ORACLE_HOME/bin/*
$ chmod u+s $ORACLE_HOME/bin/oracle
______________________________________________________________________
Oracle°ü·Ã ÅøµéÀº $ORACLE_HOME/tool_name/mesg µð·ºÅ丮¿¡ ÀÖ´Â
¸Þ½ÃÁöµéÀ» ¿ä±¸ÇÑ´Ù. ±×·¡¼ msg_shipµð·ºÅ丮¿¡¼ msegµð·ºÅ丮·Î
msb°ü·ÃÆÄÀϵéÀ» ¿Å±ä´Ù.
______________________________________________________________________
$ 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/.
______________________________________________________________________
¸¸¾à ´ÙÀ½ µð·ºÅ丮°¡ Á¸ÀçÇÏÁö ¾ÊÀ¸¸é »ý¼ºÇÑ´Ù.
______________________________________________________________________
$ mkdir $ORACLE_HOME/rdbms/log
$ mkdir $ORACLE_HOME/rdbms/audit
$ mkdir $ORACLE_HOME/network/log
______________________________________________________________________
2.3.3. ´ç½ÅÀÌ »èÁ¦ÇÒ ¼ö ÀÖ´Â ºÎºÐµé
´ÙÀ½ µð·ºÅ丮´Â ¾ÈÀüÇÏ°Ô »èÁ¦µÉ¼ö ÀÖ´Â °ÍµéÀÌ´Ù.
$ORACLE_HOME/guicommon2/
$ORACLE_HOME/ctx/
$ORACLE_HOME/md/
$ORACLE_HOME/mlx/
$ORACLE_HOME/precomp/
$ORACLE_HOME/slax/
3. µ¥ÀÌÅͺ£À̽º »ý¼º
Oracle¼¹ö¸¦ ¼³Ä¡ÇÑ Áö±ÝºÎÅÍ ¼³Ä¡¸¦ ½ÃÇèÇÒ µ¥ÀÌÅͺ£À̽º¸¦ ¼³Ä¡ÇÒ
ÇÊ¿ä°¡ ÀÖ´Ù. ¸¸¾à Oracle 7.2.x³ª ÀÌÀü ¹öÀüÀ» »ç¿ëÇÑ´Ù¸é, ¾Æ·¡ºÎºÐ¿¡
ÀÖ´Â ¹®Á¦ÇØ°áÁöħÀ» Àбâ¹Ù¶õ´Ù.
3.1. ¼³Ä¡°ü·Ã ÆÄÀÏ ¼³Ä¡
$ORACLE_HOME/dbs/init.ora¸¦ $ORACLE_HOME/dbs/initorcl.ora·Î º¹»çÇÑ´Ù.
______________________________________________________________________
$ cd $ORACLE_HOME/dbs
$ cp init.ora initorcl.ora
______________________________________________________________________
´ÙÀ½ÁÙÀ» »ý¼ºÇÑ ÆÄÀÏ¿¡ Ãß°¡ÇÑ´Ù.
______________________________________________________________________
db_name = orcl
COMPATIBLE=7.3.3.0.0
______________________________________________________________________
3.2. µ¥ÀÌÅͺ£À̽º ¼³Ä¡ ½ºÅ©¸³Æ®¸¦ »ý¼º
$ORACLE_HOME/dbsµð·ºÅ丮¿¡ makedb.sqlÀÇ À̸§À¸·Î ÆÄÀÏÀ» »ý¼ºÇÑ´Ù.
______________________________________________________________________
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
______________________________________________________________________
3.3. µ¥ÀÌÅͺ£À̽º ¼³Ä¡ ½ºÅ©¸³Æ®¸¦ ½ÇÇà
svrmgrl¸í·ÉÀ» ¼öÇàÇÑ ÈÄ ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇÑ´Ù.
______________________________________________________________________
$ 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> connect internal
Connected.
SVRMGR> 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> @makedb
<loads of messages>
SVRMGR> exit
Server Manager complete.
______________________________________________________________________
3.4. µ¥ÀÌÅͺ£À̽º ±¸µ¿½ÃÅ°±â
¿ì¼±Àº ¼öµ¿À¸·Î(ÀÌÈÄ¿¡´Â ÀÚµ¿À¸·Î ±¸µ¿µÉ °ÍÀÌ´Ù.)µ¥ÀÌÅͺ£À̽º¸¦
±¸µ¿½ÃųÇÊ¿ä°¡ ÀÖ´Ù. Oracle µ¥ÀÌÅͺ£À̽º¸¦ ½ÃÀÛÇϱâÀ§Çؼ´Â "connect
internal"À» ÇÑÈÄ¿¡ "startup"À̶ó´Â command¸¦ ½ÇÇàÇØ¾ß ÇÑ´Ù.
______________________________________________________________________
$ 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> connect internal
Connected.
SVRMGR> 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> exit
Server Manager complete.
______________________________________________________________________
3.5. µ¥ÀÌÅͺ£À̽º ÁßÁö½ÃÅ°±â
Oracleµ¥ÀÌÅͺ£À̽º¸¦ ÁßÁö½ÃÅ°±â¾Ê°í Linux¼¹ö¸¦ Àç½ÇÇà½ÃÅ°´Â °ÍÀº
µ¥ÀÌÅͺ£À̽º¸¦ Æı«½Ãų ¼ö ÀÖ´Â Å« À§ÇèÀÌ ÀÖ´Ù´Â °ÍÀ» ¸í½ÉÇØ¾ß ÇÑ´Ù.
±×·¯¹Ç·Î,Linux shutdown¸í·ÉÀ» »ç¿ëÇϱâÀü¿¡ µ¥ÀÌÅͺ£À̽º¸¦ ÁßÁö½ÃÅ°´Â
°ÍÀÌ ¹Ù¶÷Á÷ÇÑ°ÍÀÌ´Ù.
______________________________________________________________________
$ 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> connect internal
Connected.
SVRMGR> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SVRMGR> exit
Server Manager complete.
______________________________________________________________________
3.6. ±âº»»ç¿ëÀÚ »ý¼º
µ¥ÀÌÅͺ£À̽º°¡ »ý¼ºµÇ¸é¼ ÀÚµ¿ÀûÀ¸·Î µÎ °³ÀÇ Æ¯º°ÇÑ »ç¿ëÀÚ°èÁ¤ÀÌ
»ý¼ºµÈ´Ù. ´ÙÀ½¿¡ ±× ºÎºÐÀ» ¸í½ÃÇÑ´Ù.
______________________________________________________________________
Username Password
SYSTEM MANAGER
SYS change_on_install
______________________________________________________________________
ÀÌ·¯ÇÑ »ç¿ëÀÚ°èÁ¤Àº ÀüÇüÀûÀ¸·Î µ¥ÀÌÅͺ£À̽º¸¦ À§ÇÑ ±âº»ÀûÀÎ
µ¥ÀÌÅ͵ñ¼Å³Ê¸®Á¤º¸¸¦ À¯ÁöÇϱâ À§ÇÑ °ÍÀÌ´Ù. °¡´ÉÇÑÇÑ ºü¸¥½Ã°£³»¿¡
±âº»ÀûÀÎÀ¸·Î ÁöÁ¤µÈ ¾ÏÈ£¸¦ ¹Ù²Ù´Â °ÍÀÌ ÁÁ´Ù. ÀÌ·¯ÇÑ ºÎºÐÀ» ´ÙÀ½°ú
°°Àº °úÁ¤À¸·Î º¯°æµÈ´Ù.
______________________________________________________________________
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> alter user system identified by <newpassword>;
User altered.
SQL> alter user sys identified by <newpassword>;
User altered.
SQL> exit;
Disconnected from Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - Production
______________________________________________________________________
system/manager¶ó´Â Oracle »ç¿ëÀÚ °èÁ¤Àº UNIX½Ã½ºÅÛ¿¡¼ÀÇ root¸¦
»ç¿ëÇÏ´Â °Í°ú À¯»çÇϱ⠶§¹®¿¡ ¿ì¸®´Â ¹®Á¦¸¦ ¹ß»ý½ÃÅ°´Â °ÍÀ» ÃÖ¼ÒÈÇϱâ
À§ÇØ µÇµµ·Ï ÀûÀº ±ÇÇÑÀ» °®´Â »ç¿ëÀÚ¸¦ »ý¼ºÇÒ ÇÊ¿ä°¡ ÀÖ´Ù. (»ç¿ëÀÚ¸¦
»ý¼ºÇϱâ Àü¿¡ µ¥ÀÌÅͺ£À̽º¸¦ ½ÇÇà½ÃÅ°´Â °ÍÀ» ±â¾ïÇ϶ó) SQL*PLUS¿¡
¿¬°áÇÏ°í »ç¿ëÀÚ¸¦ »ý¼ºÇÑ´Ù.
______________________________________________________________________
$ 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> create user <user> identified by <psw>
2 default tablespace users
3 temporary tablespace temp;
User created.
SQL> grant connect, resource to <user>
Grant succeeded.
SQL> exit
Disconnected from Oracle7 Server Release 7.3.3.0.0 - Production Release
PL/SQL Release 2.3.3.0.0 - Production
______________________________________________________________________
½Ã½ºÅÛ¿¡ »õ·Î¿î »ç¿ëÀÚ°èÁ¤À» »ý¼ºÇÏ¿´±â ¶§¹®¿¡ »õ·Î¿î °èÁ¤À» °¡Áö°í
½Ã½ºÅÛ¿¡ ·Î±×ÀÎ ÇÒ¼ö ÀÖ´Ù. Oracleµ¥ÀÌÅͺ£À̽º¿¡ ·Î±×ÀÎÇϱâ À§Çؼ´Â
´ÙÀ½°ú °°´Ù.
______________________________________________________________________
$ sqlplus <user>/<password>
______________________________________________________________________
À̺κÐÀÌ ¿¡·¯¸Þ¼¼Áö¾øÀÌ ¼öÇàµÈ´Ù¸é, ¼º°øÀûÀ¸·Î ¿À¶óŬ µ¥ÀÌŸº£À̽º¸¦
¼³Ä¡ÇÑ°ÍÀÌ´Ù. ÀÌ ¼¹ö°¡ ¾Æ´Ñ ´Ù¸¥ È£½ºÆ®¿¡¼ ÀÌ ¿À¶óŬ µ¥ÀÌŸº£À̽º¿¡
Á¢±Ù ÇÏÁö ¾Ê´Â´Ù¸é ¸ðµç ÀÛ¾÷Àº ¿Ï·áµÈ°ÍÀÌ´Ù. ±×·¯³ª, ´ëºÎºÐ
»ç¶÷µéÀº ³×Æ®¿öÅ©¸¦ ÀÌ¿ëÇÏ¿© ¿ø°ÝÀ¸·Î µ¥ÀÌŸº£À̽º ¼¹ö¿¡ Á¢¼ÓÇϱæ
¿øÇÒ°ÍÀÌ´Ù. ±×·¸°Ô Çϱâ À§Çؼ´Â ´ÙÀ½°ú °°Àº °úÁ¤À» ¼öÇàÇؾßÇÑ´Ù.
4. ¼¹ö¿¡ SQL*NetÀ» ¼³Á¤Çϱâ
¸ðµç ÀÌ·¯ÇÑ ºÎ·ùÀÇ ÆÄÀϵéÀº Oracle ³×Æ®¿öÅ©¿¡ °ü·ÃµÈ
¼ÒÇÁÆ®¿þ¾î(SQL*Net,aka Net8 for Oracle8)¸¦ ¼³Á¤ÇÑ´Ù. ÀÌ·¯ÇÑ ÆÄÀϵéÀº
$ORACLE_HOME/network/adminµð·ºÅ丮¾È¿¡ ¼¹ö·Î½á »ý¼ºµÇ¾îÁ®¾ß ÇÑ´Ù.
4.1. tnsnames.ora
TNSNAMES.ORAÆÄÀÏÀº ¿¬°á °¡´ÉÇÑ µ¥ÀÌŸº£À̽º ÀνºÅϽºµéÀ» ±â¼úÇÏ¿©
ÁØ´Ù. »õ·ÎÀÌ »ý¼ºµÈ µ¥ÀÌÅͺ£À̽º ÀνºÅϽº¸¦ À§ÇØ ¾Æ·¡ºÎºÐ°ú °°ÀÌ
Ãß°¡ÇÑ´Ù.
______________________________________________________________________
orcl.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = <INSERT HOST NAME OF SERVER HERE> )
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = <INSERT HOST NAME OF SERVER HERE> )
(Port = 1526)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
______________________________________________________________________
4.2. listener.ora
LISTENER.ORAÆÄÀÏÀº ´Ù¸¥ ½Ã½ºÅÛ¿¡ ¿¬°áÇÏ´Â °Í¿¡ °ü·ÃµÈ ºÎºÐÀ» ±â¼úÇÏ°í
¼¹ö listenerÀ» À§ÇØ ¿ä±¸µÇ´Â ´Ù¸¥ ¼³Á¤À» Æ÷ÇÔÇÑ´Ù. listenerÀ̸§,
listenerÁÖ¼Ò, listener¿¡ ÀÇÇØ Á¦°øµÇ´Â µ¥ÀÌÅͺ£À̽º, ¼³Á¤¸Å°³º¯¼öµîÀ»
¶ÇÇÑ Æ÷ÇÔÇÑ´Ù. ´ÙÀ½¿¡ ÇÑ ¿¹°¡ ÀÖ´Ù.
______________________________________________________________________
# Name of listener and addresses to listen on
LISTENER =
( ADDRESS_LIST =
(ADDRESS =
(PROTOCOL=tcp)
(HOST=<INSERT HOST>)
(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 = "listener"
LOG_FILE_LISTENER = "listener"
CONNECT_TIMEOUT_LISTENER = 10
STOP_LISTENER = YES
DBA_GROUP = dba
______________________________________________________________________
4.3. sqlnet.ora
SQLNET.ORAÆÄÀÏÀº ³×Æ®¿öÅ©ÀÇ Æ¯º°ÇÑ ¿¬°áÁöÁ¡(node)¿¡ ´ëÇÑ ¼³Á¤À»
Æ÷ÇÔÇÑ´Ù. ÀÌ°ÍÀº µ¥ÀÌÅͺ£À̽º¿Í listenerÀÇ ¼ö¿Í´Â »ó°üÀÌ ¾ø´Ù. ÀÌ
ÆÄÀÏ¿¡¼ °¡Àå Áß¿äÇÑ ºÎºÐÀº Dead Connection Timeout ¼³Á¤º¯¼öÀÌ´Ù.Dead
Connection TimeoutÀº µ¥ÀÌÅͺ£À̽º ÀνºÅϽº¿¡ Á¢¼öµÇ´Â °¢°¢ÀÇ
ÇÁ·Î¼¼½º¸¦ üũÇÏ°í, °è¼ÓÀûÀÎ ÀÀ´ä¿¡ °ü·ÃµÈ Ŭ¶óÀ̾ðÆ®¸¦ È®ÀÎÇÑ´Ù.
Ŭ¶óÀ̾ðÆ®(¾î¶°ÇÑ ÇüÅÂÀÇ)°¡ ÀÀ´äÀÌ µÇÁö ¾Ê´Â´Ù¸é Oracle ¼¹öÀÇ
½ÇÇàÁßÀÎ ÇÁ·Î¼¼½º´Â ÁßÁöµÈ´Ù. ÀÌ°ÍÀº ¸¹Àº ¼öÀÇ Å¬¶óÀ̾ðÆ®°¡
µ¥ÀÌÅͺ£À̽º¿¡ Á¢±ÙÇÏ·ÁÇÒ ¶§ ¸Å¿ì À¯¿ëÇÑ´Ù. ƯÈ÷,
Oracleµ¥ÀÌÅͺ£À̽º·ÎºÎÅÍ Á¤È®È÷ ºüÁ®³ª°¡´Âµ¥ ½ÇÆÐÇϴ Ŭ¶óÀ̾ðÆ®µéÀÌ
¸¹ÀÌ Á¸ÀçÇÒ °¡´É¼ºÀÌ ÀÖ´Â °³¹ß±â°£¿¡ Àû¿ëÀÌ µÈ´Ù°í º¼ ¼ö ÀÖ´Ù.
¾Æ·¡ºÎºÐ¿¡ ´ç½ÅÀÌ »ç¿ëÇÒ sqlnet.oraÆÄÀÏÀÇ ¿¹°¡ ÀÖ´Ù.
______________________________________________________________________
TRACE_LEVEL_CLIENT = OFF
sqlnet.expire_time = 30 # The number of seconds between
client checks.
names.default_domain = world
name.default_zone = world
______________________________________________________________________
4.4. ListenerÀ» ½ÇÇà½ÃÅ°°í Á¾·áÇϱâ
listener¿Í SQL*NetÀÇ ¼³Á¤À» ³¡¸¶ÃÆÀ¸¹Ç·Î, ³×Æ®¿öÅ© ¼ÒÇÁÆ®¿þ¾î¸¦
»ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º¿¡ Á¢±ÙÇÒ ¼ö ÀÖ´Ù.(µ¥ÀÌÅͺ£À̽º¿¡ Á÷Á¢ ¿¬°áÀ»
ÇϱâÀü¿¡, ¿ì¸®´Â ¿ø°Ý Ŭ¶óÀ̾ðÆ® ½Ã½ºÅÛ¿¡¼ Á¢±ÙÇÏ´Â °ÍÀ» ½ÃÇèÇÒ
°ÍÀÌ´Ù.) À§ÀÇ ¼³Á¤À» »ç¿ëÇÏ¿© listenerÀ» ½ÇÇà½ÃŲ´Ù.
______________________________________________________________________
$ 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 "help" for information.
LSNRCTL> 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
______________________________________________________________________
______________________________________________________________________
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> exit
______________________________________________________________________
listenerÀ» ÁßÁö½ÃÅ°±â À§Çؼ´Â ´ÙÀ½°ú °°´Ù.
______________________________________________________________________
$ 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 "help" for information.
LSNRCTL> stop
Connecting to
(ADDRESS=(PROTOCOL=tcp)
(HOST=magic.com)
(PORT=1521)
(COMMUNITY=UK_SUP_TCPIP)
)
The command completed successfully
LSNRCTL> exit
______________________________________________________________________
¸í½ÃµÈ hostname¸¦ À§ÇÑ IPÁÖ¼Ò¸¦ ¹ÝȯÇÏÁö ¾Ê´Â DNS¼³Á¤À» °®´Â´Ù¸é, lis
tenerÀ» ½ÇÇà½ÃÅ°°í, ÁßÁö½Ãų ¶§¿¡ ¾à°£ÀÇ ½Ã°£ÀÌ ¼Ò¿äµÈ´Ù.(2-3ºÐ, DNS
timeout º¯¼ö¿¡ °ü·ÃµÇ¾î) ÀÌ·¯ÇÑ °æ¿ì¿¡´Â °ÆÁ¤ÇÏÁö ¸»°í, Àγ»Ç϶ó.
±â´Ù¸®¶ó.
5. Ŭ¶óÀ̾ðÆ® ȯ°æ ¼³Á¤
5.1. À©µµ¿ìȯ°æ Ŭ¶óÀ̾ðÆ®
ÃÖ±Ù ¹öÁ¯ÀÇ Oracle Client SoftwareÀ» »ç¿ëÇÏ´Â PC¿¡¼ÀÇ SQL*Net ¼³Á¤Àº
¸Å¿ì ½±´Ù. ¸ðµç ºÎºÐÀÌ µ¿ÀÛÇϴ Ŭ¶óÀ̾ðÆ® ¼³Ä¡¸¦ ¼öÇàÇÏ´Â °¡Àå
ÁÁÀº(½¬¿î) ¹æ¹ýÀº Oracle¿¡¼ Á¦°øÇÏ´Â SQL*Net Easy Configuration ÅøÀ»
ÀÌ¿ëÇÏ´Â °ÍÀÌ´Ù. ÀÌ ÅøÀº tnsnames.ora¿Í sqlnet.oraÆÄÀÏÀÇ ¼³Á¤À» º¯°æ
ÇÒ ¼ö ÀÖ´Â À§Àúµå ÇüÅÂÀÇ ÀÎÅÍÆäÀ̽º¸¦ °®´Â´Ù. "Add Database Alias"¸¦
¼±ÅÃÇÏ°í, Ä¿¼°¡ À§Ä¡ÇÑ °÷¿¡ "Database alias"¿¡ ´ëÇÑ À̸§À» ÀÔ·ÂÇÑ´Ù.
ÀÌ alias´Â µ¥ÀÌÅͺ£À̽º ÀνºÅͽº¸¦ ÂüÁ¶ÇÒ À̸§ÀÌ°í, ÀνºÅϽº
À̸§(ÀÌ·¯ÇÑ °æ¿ì¿¡´Â orcl)°ú °°Àº À̸§À̾î¾ß ÇÑ´Ù. ÇÁ·ÎÅäÄݷνá
TCP/IP¸¦ ¼±ÅÃÇÏ°í, µ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛÀÇ hostname¿Í µ¥ÀÌÅͺ£À̽ºÀÇ
ÀνºÅϽº À̸§À» ÀÔ·ÂÇÑ´Ù. ¿Ï·áµÇ¾ú´Ù. ±×·¯³ª, SQL*Net Easy
Configuration ToolÀÌ ¾ø´Ù°í °ÆÁ¤ÇÏÁö ¸»¶ó. ¼¹ö¿¡ Á¸ÀçÇÏ´Â °÷°ú °°Àº
Ŭ¶óÀ̾ðÆ® ½Ã½ºÅÛ¿¡¼ $ORACLE_HOME/network/adminµð·ºÅ丮¿¡
tnsnames.ora¿Í sqlnet.oraÆÄÀÏÀ» »ý¼ºÇÑ´Ù. ÀÌ°ÍÀº ¼¹ö¿¡¼(¾î¶²
Àǹ̿¡¼´Â Ç×»ó ÁÁÀº »ý°¢ÀÎ)¿Í °°Àº alias¸¦ Áö¿øÇÒ °ÍÀÌ´Ù.
5.2. Unix Ŭ¶óÀ̾ðÆ®
UNIX Ŭ¶óÀ̾ðÆ®´Â À©µµ¿ì Ŭ¶óÀ̾ðÆ®¿Í ¸Å¿ì ´Ù¸£Áö ¾Ê´Ù. Oracle¿¡¼
Á¦°øÇÏ´Â Network ManagerÀÌ ÀÖ´Ù¸é, À§¿¡¼ ¾ð±ÞÇÑ ³»¿ë°ú °°Àº ¹æ¹ýÀ¸·Î
ÇÏ¸é µÈ´Ù. ¸¸¾à ±×·¸°Ô ÇÒ ¼ö ¾ø´Ù¸é, ¼¹ö¿¡ Á¸ÀçÇÏ´Â
$ORACLE_HOME/network/adminµð·ºÅ丮¿¡ ÀÖ´Â ÆÄÀϵéÀÇ ¼³Á¤°ú °°Àº °ÍÀ»
ÀÌ¿ëÇÏ¸é µÈ´Ù.
6. ÀÚµ¿ ½ÃÀÛ°ú ÁßÁö
6.1. dbstart & dbstop
Oracle µ¥ÀÌÅͺ£À̽ºÀÇ ÀÚµ¿ ½ÃÀÛ°ú ÁßÁö´Â Oracle¿¡¼ Á¦°øÇÏ´Â ÆÄÀÏÀÎ
dbstart¿Í dbstop¸¦ ÀÌ¿ëÇÏ¿© ¼³Á¤(¹öÀü 7.3.3.0.0)ÇÒ ¼ö ÀÖ´Ù. ÀÌ·¯ÇÑ
ÆÄÀϵéÀº µ¿ÀÛ(ºñ·Ï dbstart¿Í dbshutÆÄÀÏÀ» ¹Ù²Ü¼ö ÀÖÁö¸¸, ¿Å°ÜÁú ¼ö
ÀÖ´Ù.)ÇÒ ¼ö ÀÖ´Â etc/oratab ÆÄÀÏÀÇ Á¸Àç¿©ºÎ¿¡ ÀÇÁ¸ÇÑ´Ù. /etc/oratab
ÆÄÀÏÀÇ Çü½ÄÀº ´ÙÀ½°ú °°´Ù.
______________________________________________________________________
SID:ORACLE_HOME:AUTO
______________________________________________________________________
¿¹)
______________________________________________________________________
orcl:/home/oracle/7.3.3.0.0:Y
leaveup:/home/oracle/7.3.2.1.0:N
______________________________________________________________________
6.2. init.d & rc.d
¸®´ª½º ½Ã½ºÅÛÀÇ ½ÃÀÛ°úÁ¤À̳ª Á¾·á°úÁ¤À» º¯ÇüÇÏ¿© µ¥ÀÌŸº£À̽º¸¦
½ÃÀÛ½ÃÅ°°í Á¾·á½Ãų¼ö ÀÖ´Ù. ÀÌ°ÍÀº ¸Å¿ì½±Áö¸¸, ¾î¶°ÇÑ
Linux(slackware, debian, redhat, etc)½Ã½ºÅÛÀ» »ç¿ëÇÏ´À³Ä¿¡ µû¶ó
º¯°æµÉ¼ö ÀÖ´Ù´Â °ÍÀ» ÇÊÀÚ´Â ÁöÀûÇÑ´Ù. ÀÌ ¹®¼¿¡¼´Â Redhat Linux
5.0¿¡¼ µ¿ÀÛÇÏ´Â ¿¹¸¦ º¸¿©ÁÙ °ÍÀÌ´Ù. ÀÚ½ÅÀÇ Linux ½Ã½ºÅÛ¿¡ µû¶ó
¼öÁ¤ÇϱâÀ§Çؼ´Â ÀÚ½ÅÀÇ Linux ½Ã½ºÅÛ ¹®¼ ÀڷḦ Âü°íÇÑ´Ù. (ºñ·Ï
±×·¯ÇÑ °ÍÀÌ Unix ½Ã½ºÅÛÀÇ Sys V °è¿À» À§ÇÑ °Í¿¡ Àû¿ëµÇ´õ¶óµµ) ¿ì¼±,
¿ì¸®´Â /etc/rc.d/init.d µð·ºÅ丮¿¡ ÀÖ´Â dbshut¿Í dbstart¸¦ ½ÇÇàÇÒ
½ºÅ©¸³Æ®¸¦ »ý¼ºÇÒ ÇÊ¿ä°¡ ÀÖ´Ù.
______________________________________________________________________
#!/bin/sh
#
# /etc/rc.d/init.d/oracle
# Description: Starts and stops the Oracle database and listeners
# See how we were called.
case "$1" in
start)
echo -n "Starting Oracle Databases: "
echo "----------------------------------------------------"
>> /var/log/oracle
date +"! %T %a %D : Starting Oracle Databases as part of system up."
>> /var/log/oracle
echo "----------------------------------------------------"
>> /var/log/oracle
su - oracle -c dbstart >> /var/log/oracle
echo "Done."
echo -n "Starting Oracle Listeners: "
su - oracle -c "lsnrctl start" >> /var/log/oracle
echo "Done."
echo ""
echo "----------------------------------------------------"
>> /var/log/oracle
date +"! %T %a %D : Finished." >> /var/log/oracle
echo "----------------------------------------------------"
>> /var/log/oracle
touch /var/lock/subsys/oracle
;;
stop)
echo -n "Shutting Down Oracle Listeners: "
echo "----------------------------------------------------"
>> /var/log/oracle
date +"! %T %a %D : ShutDown Oracle Databases as part of system down." >> /var/log/oracle
echo "----------------------------------------------------"
>> /var/log/oracle
su - oracle -c "lsnrctl stop" >> /var/log/oracle
echo "Done."
rm -f /var/lock/subsys/oracle
echo -n "Shutting Down Oracle Databases: "
su - oracle -c dbshut >> /var/log/oracle
echo "Done."
echo ""
echo "----------------------------------------------------"
>> /var/log/oracle
date +"! %T %a %D : Finished." >> /var/log/oracle
echo "----------------------------------------------------"
>> /var/log/oracle
;;
restart)
echo -n "Restarting Oracle Databases: "
echo "----------------------------------------------------"
>> /var/log/oracle
date +"! %T %a %D : Restarting Oracle Databases as part of system up." >> /var/log/oracle
echo "----------------------------------------------------"
>> /var/log/oracle
su - oracle -c dbstop >> /var/log/oracle
su - oracle -c dbstart >> /var/log/oracle
echo "Done."
echo -n "Restarting Oracle Listeners: "
su - oracle -c "lsnrctl stop" >> /var/log/oracle
su - oracle -c "lsnrctl start" >> /var/log/oracle
echo "Done."
echo ""
echo "----------------------------------------------------"
>> /var/log/oracle
date +"! %T %a %D : Finished." >> /var/log/oracle
echo "----------------------------------------------------"
>> /var/log/oracle
touch /var/lock/subsys/oracle
;;
*)
echo "Usage: oracle {start|stop|restart}"
exit 1
esac
______________________________________________________________________
ÀÌ ÆÄÀÏÀÌ ½ÇÁ¦ÀûÀ¸·Î Á¤È®È÷ ´ç½ÅÀÇ ½Ã½ºÅÛ¿¡¼ µ¥ÀÌÅͺ£À̽º¸¦ ÁßÁöÇÏ°í
½ÇÇà½ÃÅ°´ÂÁö¸¦ È®ÀÎÇØ¾ß ÇÑ´Ù. ¿¡·¯¸Þ¼¼Áö¸¦ À§ÇÑ /var/log/oracleÀÎ log
ÆÄÀÏÀ» È®ÀÎÇ϶ó. ´ÙÀ½ ¸í·ÉµéÀº ½ÇÇà¼öÁØ 2,3,4¿¡ ÇØ´çÇÏ´Â
µ¥ÀÌÅ׺£À̽º¸¦ ½ÇÇà½Ã´Â´Â °ÍÀ» È®ÀÎ ½ÃÄÑÁÙ °ÍÀÌ´Ù.
______________________________________________________________________
$ 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
______________________________________________________________________
½Ã½ºÅÛÀ» Àç ºÎÆÃÇϰųª, Àç ½ÇÇà½Ãų¶§¿¡ µ¥ÀÌÅͺ£À̽º¸¦
ÁßÁö½ÃÅ°±âÀ§Çؼ ¿ì¸®´Â ´ÙÀ½°ú °°Àº ¿¬°á(link)ÀÌ ÇÊ¿äÇÑ´Ù.
______________________________________________________________________
$ ln -s ../init.d/oracle /etc/rc.d/rc0.d/K01oracle # Halting
$ ln -s ../init.d/oracle /etc/rc.d/rc6.d/K01oracle # Rebooting
______________________________________________________________________
7. ´Ù¸¥ ºÎºÐµé
7.1. Áö´ÉÇü ¿¡ÀÌÀüÆ®
Oracle Intelligent AgentÀ» ÇÊ¿ä·Î ÇÑ´Ù¸é, ȯ°æ¼³Á¤ÀÇ º¯È¾øÀÌ
°¡´ÉÇÏ´Ù. IA¸¦ ½ÇÇàÇϱâ À§Çؼ´Â ´ÙÀ½°ú °°´Ù.
______________________________________________________________________
$ lsnrctl dbsnmp_start
______________________________________________________________________
IA¸¦ ÁßÁö½ÃÅ°±â À§Çؼ´Â ´ÙÀ½°ú °°´Ù.
______________________________________________________________________
$ lsnrctl dbsnmp_stop
______________________________________________________________________
¼º°øÀ» ³ªÅ¸³»°Å³ª Intelligent Agent¸¦ ½ÇÇàÇϰųª, ÁßÁöÇÏ´Â ¾î¶°ÇÑ
¸Þ½ÃÁöµµ Ãâ·ÂÇÏÁö ¾Ê´Â´Ù. ÀÎÅÚ¸®ÀüÆ® ¸Þ´ÏÀú´Â ¿À¶óŬµ¥ÀÌŸº£À̽º °ü¸®
Ŭ¶óÀ̾ðÆ® ¼ÒÇÁÆ®¿þ¾îÀÎ Enterprise Manager¿Í ¿¬°áÇϱâÀ§ÇÑ °ÍÀÌ´Ù.
È®ÀÎÇÏ´Â ¹æ¹ýÀº ¿À¶óŬ Enterprise Manager¿¡¼ ÇÒ ¼ö ÀÖ´Ù.
8. ¹®Á¦ÇØ°á
¿©·¯ °¡Áö ´Ù¾çÇÑ ¹®Á¦ÇØ°á ½Ç¸¶¸®(hints)µéÀº ´ÙÀ½°ú °°´Ù.
8.1. Oracle 7.2.x¸¦ »ç¿ëÇÒ ¶§, ³ª´Â µ¥ÀÌÅͺ£À̽º¸¦ »ý¼ºÇÒ ¼ö ¾ø´Ù.
7.2.x Á¦Ç°Áß¿¡¼ Oracle¿¡¼ Á¦°øµÇ´Â ÀÌ·¯ÇÑ ÆÄÀϵéÀº º´·Ä¼¹öȯ°æÀ»
±¸ÃàÇÏ·Á´Â °ÍÀ» ½ÃµµÇÏ·Á´Â °ÍÀº Á¤È®ÇÏÁö ¾Ê´Ù. Á¦°øµÇ´Â init.oraÆÄÀÏÀº
´ÙÀ½°ú °°Àº ÁÙÀÇ ³»¿ëÀ» Æ÷ÇÔÇÑ´Ù.
______________________________________________________________________
# define parallel server (multi-instance) parameters
ifile = ora_system:initps.ora
______________________________________________________________________
¹®Á¦¸¦ ÇØ°áÇϱâ À§Çؼ´Â ´Ü¼øÈ÷ ÁÖ¼®Ã³¸®¸¦ ÇϸéµÈ´Ù.
______________________________________________________________________
# define parallel server (multi-instance) parameters
#ifile = ora_system:initps.ora
______________________________________________________________________
8.2. 3.4.x.¹öÀü¿¡¼ svrmgrl½ÇÇàÁß segmentation ¿À·ù¸¦ ¾ò¾ú´Ù.
ÀÌ·¯ÇÑ ¹®Á¦µéÀº ¸¹Àº »ç¶÷µé¿¡°Ô¼ ¾Ë·ÁÁ³´Ù. Gerald Weber
gerald_weber@master.co.at <mailto:gerald_weber@master.co.at>°¡
ÇØ°áÇÏ¿´´Ù.
______________________________________________________________________
¾È³ç Paul,
´ç½ÅÀÇ µµ¿ò¿¡ ¿ì¼± °¨»çÇÑ´Ù. ¹®Á¦´Â iBCS-emulator ÀÚüÀÌ´Ù.
Oracle½Ã½ºÅÛÀÌ iBCSÀÇ ÇöÀç ¹öÀü¿¡¼ Áö¿øÇÏÁö ¾Ê´Â sysconf-callsÀ»
¼öÇàÇÏ´Â °Í °°´Ù.
<7>[22]615 sysconf(34)
<7>iBCS2 unsupported sysconf call 34
<7>[22]615 sysconf error return linux=-22 -> ibcs=22 <Invalid argument>
<7>[24]615 sysconf(34)
<7>iBCS2 unsupported sysconf call 34
<7>[24]615 sysconf error return linux=-22 -> ibcs=22 <Invalid argument>
¹®Á¦ÇØ°á : ´ÙÀ½°ú °°Àº 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;
______________________________________________________________________
9. µµ¿ÍÁֽŠºÐµé
À̹®¼´Â Bob Withers( bwit@pobox.com <mailto:bwit@pobox.com>)°¡ ÀÛ¼ºÇÑ
¹®¼¸¦ ±âº»À¸·Î ÇÏ¿´°í, Georg Rehfeld(rehfeld@wmd.de
<mailto:rehfeld@wmd.de>)¿Í David Mansfield( david@claremont.com
<mailto:david@claremont.com>)°¡ Á¦°øÇÑ Á¤º¸¸¦ Ãß°¡ÇÏ¿´½À´Ï´Ù. Bob
Withers, Mark Watling( mwatling@mjw-ltd.demon.co.uk
<mailto:mwatling@mjw-ltd.demon.co.uk>), Peter
Sodhi(petersodhi@unn.unisys.com <mailto:petersodhi@unn.unisys.com>)°ú
Greg Hankins(greg.hankins@cc.gatech.edu
<mailto:greg.hankins@cc.gatech.edu>)°¡ ¹®¼¸¦ °ËÁõÇÏ¿´½À´Ï´Ù. ÇÔ²²
Á¶»çÇÏ°í ¹®¼ÀÛ¾÷À» ÇØÁØ ¸ðµç »ç¶÷µé¿¡°Ô °¨»çÇÕ´Ï´Ù. Ãß°¡ ÁÖ¼®°ú
Á¶¾ðÀ» ÇØÁØ Bob Withers °ú Mark Watling ¿¡°Ô Ưº°È÷ °¨»çÇÕ´Ï´Ù.
