¼ ·Ð
ÀÎÅÍ³Ý ¼¹ö·Î¼ÀÇ ¸¹Àº °¡´É¼ºÀ» º¸¿©ÁÖ°í ÀÖ´Â
Linux´Â »ç½Ç»ó ¹Ì¹¦ÇÑ ¹®Á¦°¡ ÀÖ¾ú´Ù. Apache´Â À¥¼¹ö·Î¼ÀÇ ´õÇÒ
³ªÀ§ ¾ø´Â Á¤»óÀÇ °íÁö¿¡ ÀÖ¾ú°í, Samba´Â ¸¹Àº ÀÛ¾÷µéÀ» MS WINDOWS·ÎºÎÅÍ
Çعæ½ÃÄÑ ÁÖ¾úÀ¸¸ç X WINDOW´Â MSÀÇ ±×°Í°ú ¸øÁö ¾ÊÀº ¸¹Àº À©µµ¿ì
¸Å´ÏÀúµé·Î Ä¡ÀåµÇ¾ú´Ù. ¹®Á¦´Â Á»´õ ½Å·Ú¼º ÀÖ´Â ¼ºñ½ºµéÀ̾ú°í
±×°ÍÀº ´ëü·Î D/B ½Ã½ºÅÛ°úÀÇ ¹ÐÁ¢ÇÑ °ü°è¸¦ °¡Áø´Ù. ¹°·Ð Linux¿¡¼µµ
¾ÆÁÖ ÈǸ¢ÇÑ(±×°Íµµ °ø°³ÀÇ) D/B µéÀÌ Á¸ÀçÇϴµ¥ MiniSQLÀ̳ª PostgresqlµîÀÌ
±×°ÍÀÌ°í MySQL°°Àº Á¶±Ý Ưº°ÇÑ(¹Ý °ø°³/¹Ý »ó¿ë) °Íµéµµ ÀÖ´Ù.
ÇÏÁö¸¸, À̰͵éÀÌ ¾Æ¹«¸® ÈǸ¢ÇÏ´Ù°í Çصµ »ç¿ëÀÚÀÇ ÀÔÀå¿¡¼´Â
´©±¸Çϳª Ã¥ÀÓÁ®ÁÖÁöµµ, ±â¼úÁö¿ø ÇØÁÖÁöµµ ¾Ê´Â ÀÌ·¯ÇÑ D/B ½Ã½ºÅ۵鿡
ÀÚ½ÅÀÇ ±ÍÁßÇÑ, ȤÀº »ó¾÷ÀûÀÎ ¸ñÀûÀÇ ÀڷḦ ´ã¾ÆµÎ°í ¸¾ ÆíÇØ
ÇÏ´Â ÀÌ´Â º°·Î ¾øÀ» °ÍÀÌ´Ù. ±×·¯³ª Áö±ÝÀº ¿©·¯ ¿ì¿© °îÀý ³¡¿¡
Linux´Â Oracle À» À§½ÃÇÑ ´ëÇü D/B½Ã½ºÅÛ ¾÷üµé·ÎºÎÅÍ Áö¿øÀ»
¹Þ°Ô µÇ¾ú´Ù. ´ëÇü »ó¿ë D/B½Ã½ºÅÛ ¾÷üµéÀÇ Áö¿ø°ú ¿£ÅÍÇÁ¶óÀÌÁî±Þ
¼º´ÉÀ» °®Ãá Ä¿³Î 2.2ÀÇ ¹ßÇ¥·Î ÀÎÅÍ³Ý ¼¹ö ½ÃÀåÀ» ³Ñ¾î ÀÌÁ¦´Â
±¹³»¿¡¼µµ ¿£ÅÍÇÁ¶óÀÌÁî Ç÷§ÆûÀ¸·Î Linux °¡ °·ÂÇÏ°Ô µîÀåÇÏ°í
ÀÖ´Ù.
¸ñ Àû
ÀÌ ±ÛÀÇ ¸ñÀûÀº °£´ÜÇÏ´Ù. ¿©·¯ D/Bº¥´õµéÀÇ
Á¦Ç°Áß¿¡¼ À¯µ¶ Çѱ¹¿¡¼ ÃÊ°¼¼¸¦ º¸ÀÌ°í ÀÖ´Â Oracle (server
for Linux 8.0.5)¸¦ Linux»ó¿¡¼ ¼³Ä¡ÇÏ´Â ¹æ¹ý°ú ¿î¿ë ¹æ¹ý, ±×¸®°í
°£´ÜÇÑ pro-c »ç¿ë¹ý, ±×¸®°í ÇÑÂü ÁÖ°¡¸¦ ¿Ã¸®°í ÀÖ´Â php3¿ÍÀÇ
¿¬µ¿À» ¾à 3ȸºÐ¿¡ °ÉÃÄ »ìÆ캻´Ù. Test¿¡ »ç¿ëµÈ Oracle server´Â
Á¤Ç°ÀÌ ¾Æ´Ï°í Oracle Home Page¿¡ °¡¸é ½±°Ô ±¸ÇÒ ¼ö ÀÖ´Â °³¹ßÀÚ
¹öÀüÀÓÀ» ¾Ë·ÁµÐ´Ù.
¡Ý ½Ã½ºÅÛ ¿ä±¸»çÇ×
¸Þ¸ð¸® : È°¿ëÀÇ ¸ñÀûÀÌ ¾Æ´Ò °æ¿ì 32¸Þ°¡µµ
°¡´É
½º¿Ò¿µ¿ª : ÀϹÝÀûÀ¸·Î RAMÀÇ 3¹è Å©±âÀÇ ½º¿Ò¿µ¿ªÀÌ
±ÇÀå. 1GBÀÌ»óÀÇ RAMÀ» °¡Áø
½Ã½ºÅÛ¿¡¼´Â
2¹è Å©±âÀÇ ½º¿Ò¿µ¿ªÀÌ ±ÇÀåµÈ´Ù.
µð½ºÅ© : ÃÖ¼ÒÇÑ 4°³(At least four devices)
: Oracle ¼ÒÇÁÆ®¿þ¾î ¼³Ä¡¸¦ À§ÇØ Çϳª, ³ª¸ÓÁö
¼¼°³´Â
OFAȣȯ µ¥ÀÌÅͺ£À̽º¸¦ »ý¼ºÇϱâ À§ÇØ »ç¿ëµÈ´Ù. -
È°¿ëÀÇ ¸ñÀûÀÌ ¾Æ´Ò °æ¿ì ÇÑ °³ÀÇ µð½ºÅ©¶óµµ »ó°ü¾ø´Ù. -
È°¿ëÀÇ ¸ñÀûÀ̶ó¸é ÃÖ¼Ò 2°³ÀÇ ¹°¸®Àû µð½ºÅ© Ãßõ (¸®´ª½º, ¿À¶óŬ
) -
´Ù¿î·Îµå ¹ÞÀº ÆÄÀÏ°ú ¾ÐÃàÀ» Ç®°í ¼³Ä¡ÇÒ ¿ë·®À¸·Î ÃÖ¼Ò 1±â°¡
ÀÌ»óÀÌ ÇÊ¿äÇÏ´Ù.
Operating System : Linux 2.0.34 - ¿À¶óŬÀÇ
¸®´ª½º ÆÀÀº ½ÇÁ¦ 2.0.33 ÀÌ»óÀ̶ó°í ÇÑ´Ù. - ÇÊÀÚ´Â Âü°í·Î
±¹³»¿¡¼ À¯¸íÇÑ ¾ËÂ¥ ¸®´ª½º 5.2¸¦ »ç¿ëÇÏ¿´À¸¸ç Ä¿³ÎÀº 2.0.36À»
»ç¿ëÇÏ¿´´Ù.
System Libraries : GNU C Library, version
2.0.7 - ¹®¼»ó¿¡¼´Â 2.0.7ÀÌ»óÀ» ¿ä±¸ÇÏ°í ÀÖÀ¸³ª ¿À¶óŬÀÇ
¸®´ª½º °³¹ß ÆÀÀ¸·ÎºÎÅÍÀÇ ¼³¸íÀ¸·Î´Â ½ÇÁ¦
2.0.6ÀÌ»óÀÌ¸é µÈ´Ù°í ÇÑ´Ù. GLIBC 2.1.x
¿ëÀ¸·Î´Â ÆÐÄ¡ ÆÄÀÏÀÌ µû·Î ³ª¿Í ÀÖ´Ù. ¾ÆÁ÷ Å×½ºÆ®´Â Çغ¸Áö ¸øÇß´Ù.
Window Manager : ¾î¶² X À©µµ¿ì ½Ã½ºÅÛµµ °¡´É
-¼Ö¶ó¸®½º¿¡¼´Â X-window »ó¿¡¼ °ü¸®ÇÒ ¼ö ÀÖ´Â svrmgrm ÀÌ ÀÖÁö¸¸
Linux¿¡¼´Â ÇöÀç
Ä¿¸Çµå ¶óÀÎ ¸ðµå¿¡¼¸¸ ÀÛµ¿ÇÏ´Âsvrmgrl ¸¸ÀÌ Á¸ÀçÇÑ´Ù.
°¡. root ·Î ÇÏ¿©¾ß ÇÒÀÏ
1. ´Ù¿î·Îµå http://technet.oracle.com¿¡¼
¿À¶óŬ ¸®´ª½º¸¦ ´Ù¿î ¹Þ´Â´Ù.
2. /usr/src ¿¡ ´Ù¿î·Îµå ¹ÞÀº 805ship.tgz ÆÄÀÏÀ»
¿Å±ä ÈÄ /usr/src/ora¿¡¼ ¾ÐÃàÀ» Ǭ´Ù. /usr/src/ora
»ó¿¡ ´ÙÀ½°ú °°Àº ÆÄÀÏ°ú µð·ºÅ丮°¡ »ý¼ºµÇ¾úÀ» °ÍÀÌ´Ù.
# ls DST.LST
network/
plsql/
nlsrtl/ precomp/
RELDESC.TXT
ocommon/ rdbms/
bin/
oemagent/ slax/
oracore/
sqlplus/ jdbc/
orainst/
svrmgr/ lib/
ord/
unix.prd otrace/
unixdoc/
3. Create Mount Points ÀÌÁ¦
¿À¶óŬÀ» ¼³Ä¡ÇÒ À§Ä¡¸¦ Á¤ÇÏ´Â ´Ü°èÀÌ´Ù. ¿©±â¼´Â /home/oracle¿¡
¿À¶óŬÀ» ¼³Ä¡
ÇÏ´Â °ÍÀ¸·Î °¡Á¤ÇÏ°Ú´Ù. ÀÌ À§Ä¡¿¡ ¿À¶óŬÀ»
¼³Ä¡ÇÒ ÇÏµå µð½ºÅ© ÆÄƼ¼ÇÀ» ¸¶¿îÆ® ½ÃÄѾß
ÇÑ´Ù. - ´ëºÎºÐÀÇ »ç¿ëÀÚ°¡ ÇϳªÀÇ
ÆÄƼ¼Ç¿¡ ¸®´ª½º¸¦ ¼³Ä¡ÇÒ °ÍÀÌ´Ù. ±×·¸Áö¸¸ ¸¸ÀÏ µÎ°³ ÀÌ»óÀÇ
Çϵåµð½ºÅ© ÆÄƼ¼ÇÀ» ÀÌ¿ëÇÒ °ÍÀ̶ó¸é /etc/fstabÀÇ
³»¿ëÀ» ÀûÇÕÇÏ°Ô °íÃÄ¾ß ÇÑ´Ù.
°¢ ÆÄƼ¼ÇÀÇ ³»¿ëÀ» ´ÙÀ½¿¡ ¼³¸íÇϵµ·Ï ÇÏ°Ú´Ù.
4. DBA group »ý¼º /etc/group
ÆÄÀÏ¿¡ dba¶ó´Â ±×·ìÀ» »ý¼ºÇÑ´Ù.
# groupadd dba ȤÀº
Á÷Á¢ vi edit·Î /etc/groupÀ» ÆíÁýÇÒ ¼öµµ ÀÖ´Ù.
5. ¸®´ª½º Ä¿³Î ¼³Á¤ ¿À¶óŬ8
¼¹öÀÇ SGA ±¸Á¶¸¦ ¼ö¿ëÇϱâ À§ÇØ ¸®´ª½º Ä¿³ÎÀÇ Interprocess Communication
(IPC) ÆĶó¸ÞÅ͵éÀ» ¼³Á¤ÇØ¾ß ÇÑ´Ù. ½Ã½ºÅÛÀÌ
SGA¸¦ ¼ö¿ëÇϱ⿡ ÃæºÐÇÑ shared ¸Þ¸ð¸®¸¦
°¡ÁöÁö ¾Ê¾Ò´Ù¸é µ¥ÀÌÅͺ£À̽º¸¦ ½ÇÇàÇÒ
¼ö ¾øÀ» °ÍÀÌ´Ù.
´ÙÀ½¿¡ »óÀÀÇÏ´Â Ä¿³Î ÆĶó¸ÞÅ͸¦ ¼³Á¤ÇÑ´Ù.
maximum size of a shared memory segment(SHMMAX)
maximum number of shared memory segments in the system(SHMMNI)
maximum number of shared memory segments a user process can
attatch(SHMSEG) maximum amount of shared memory that can
be allocated system-wide(SHMMNS) SHMMAX*SHMSEG¿¡ ÀÇÇØ Çã¿ëµÇ´Â
Àüü shred ¸Þ¸ð¸® Å©±â°¡ °áÁ¤µÈ´Ù.
¤¡) SHMMAX = 4294967295 : ´ÜÀÏ °øÀ¯ ¸Þ¸ð¸®
¼¼±×¸ÕÆ®ÀÇ ÃÖ´ëÅ©±â(¹ÙÀÌÆ®´ÜÀ§) ¤¤) SHMMIN = 1 : ´ÜÀÏ °øÀ¯¸Þ¸ð¸®
¼¼±×¸ÕÆ®ÀÇ ÃÖ¼ÒÅ©±â(¹ÙÀÌÆ®) ¤§) SHMIMNI = 100 : °øÀ¯¸Þ¸ð¸®
Áö½ÃÀÚ(identifiers)ÀÇ °¹¼ö ¤©) SHMSEG = 10 : °¢ ÇÁ·Î¼¼½º¿¡
ºÎ¿©µÉ ¼ö ÀÖ´Â °øÀ¯¸Þ¸ð¸® ¼¼±×¸ÕµåÀÇ ÃÖ´ë °¹¼ö ¤±)
SEMMNS = 200 : ½Ã½ºÅÛ ³»ÀÇ ¼¼¸¶Æ÷¾î °¹¼ö ¤²) SEMMNI = 70
: ¼¼¸¶Æ÷¾î Áö½ÃÀÚ(identifiers)ÀÇ °¹¼ö. SEMMNIÀº µ¿½Ã¿¡ »ý¼ºµÉ
¼ö ÀÖ´Â ¼¼¸¶Æ÷¾î
°¹¼ö¸¦ °áÁ¤ÇÑ´Ù. ¤µ) SEMMSL = PROCESSES ÃʱâÈ ÆĶó¸ÞÅÍÀÇ
°ª°ú °°°Å³ª Å©µµ·Ï, ÇϳªÀÇ ¼¼¸¶Æ÷¾î ¾È¿¡
Á¸ÀçÇÒ
¼ö ÀÖ´Â ¼¼¸¶Æ÷¾îµéÀÇ ÃÖ´ë °¹¼ö.
¿À¶óŬ
ÇÁ·Î¼¼½ºµéÀÇ ÃÖ´ë °¹¼ö¿Í °°¾Æ¾ß ÇÑ´Ù.
¼Ö¶ó¸®½ºÀÇ °æ¿ì¿¡´Â ´ÙÀ½ÀÇ °ªµéÀ» /etc/system
ÆÄÀÏ¿¡¼ ¼³Á¤ÇØ ÁÖ¾î¾ß ÇÏÁö¸¸, ¼³Á¤À» ÇÏÁö ¾Ê¾Æ ¹®Á¦°¡ ¹ß»ýÇÑÀûÀº
¾ø¾ú´Ù. ±âº» Ä¿³Î »óÅ·Π³õ°í ÀνºÅçÇÏ¿©µµ ¹«¹æÇÏ´Ù. (·¹µåÇòÀÇ
µðÆúÆ® Ä¿³ÎÀÌµç ´Ù½Ã ÄÄÆÄÀÏÇÑ Ä¿³ÎÀ̵ç)
6. ¿À¶óŬ °ü¸®ÀÚ °èÁ¤ »ý¼º adduser
ȤÀº useradd ·Î dba±×·ì¿¡ ¼ÓÇÏ´Â À¯Àú oracleÀ» »ý¼ºÇÑ´Ù.
¤¡) adduser ¸í·ÉÀ¸·Î oracle user¸¦ »ý¼ºÇÑ´Ù.
# adduser oracle ¤¤) vi
/etc/passwd ¸í·ÉÀ» »ç¿ëÇÏ¿© oracle user ÀÇ ¼³Á¤ °ªÀ» À§¿¡¼
¼³¸íÇÑ °Í´ë·Î ¹Ù²Û´Ù.
- dba gid¿Í °°¾Æ¾ß ÇÑ´Ù.
7. oratab ÆÄÀÏ »ý¼º ¿À¶óŬ
ÀνºÅϽº¿¡ ´ëÇÑ Á¤º¸´Â oracle ¼ÒÀ¯ÀÇ oratab ÆÄÀÏ¿¡ ÀúÀåµÈ´Ù.
ÇÏÁö¸¸ ÀÌ ½ºÅ©¸³Æ®¸¦ root·Î ½ÇÇàÇؼ /etc
µð·ºÅ丮¿¡ oratab ÆÄÀÏÀÌ »ý¼ºµÇµµ·Ï ÇÑ´Ù.
½ÇÁ¦ ÀνºÅç°úÁ¤¿¡¼ oratab.shÀ»
½ÇÇàÇϸé ORACLE_OWNERȯ°æº¯¼ö°¡ ¼³Á¤µÇ¾î ÀÖ´ÂÁö ¹¯°í
ÀÖ´Ù. µû¶ó¼ ORACLE_OWNERÀ» ´ÙÀ½°ú °°ÀÌ ¼³Á¤ÇÑ´Ù.
³ª. oracle user ·Î ÇÒ ÀÏ
1. ~/.bash_profileÀÇ ¼öÁ¤ (
shÀ» »ç¿ëÇÒ °æ¿ì .profileÀ» ¼öÁ¤ÇÑ´Ù. redhat ¸®´ª½º¸¦ ±âÁØÀ¸·Î
¼³¸íÇÑ´Ù.) oracle·Î Á¢¼ÓÇÏ¿© ´ÙÀ½°ú °°ÀÌ
.profileÀ» ¸¸µç´Ù. RedHat¿¡¼´Â .bash profile ÀÌ´Ù.
export ORACLE_HOME=/home/oracle/app/oracle/product/8.0.5
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/jdbc/lib
export ORACLE_SID=linux export ORACLE_TERM=386 export
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data export
PATH=$PATH:$ORACLE_HOME/bin export TMPDIR=/tmp export
CLASSPATH=$ORACLE_HOME/jdbc/lib/classes111.zip
umask 022 (À§¿¡¼ export ´ÙÀ½ÀÇ ÁÙÀ» export µÚ¿¡ ³ª¿Í¾ß
ÇÑ´Ù.)
À§ÀÇ °æ¿ì´Â ¡°root ÀÛ¾÷ 4¡±ÀÇ ¡°Create Mount
Points¡±¿¡¼ À̾߱âÇÑ ¿À¶óŬÀ» ¼³Ä¡ÇÒ °æ·Î·Î /home/oracleÀÎ
°æ¿ìÀÌ´Ù.
°¢ ¼³Á¤¿¡ ´ëÇÑ ¼³¸í
ORACLE_HOME : ¿À¶óŬÀ» /home/oracle¿¡
¼³Ä¡Çϱâ·Î ÇÏ¿´À¸¹Ç·Î /home/oracle/app/oracle/product/8.0.5·Î
ÁöÁ¤µÈ´Ù.
LD_LIBRARY_PATH : ¿À¶óŬÀÇ µ¿Àû/Á¤Àû ¶óÀ̺귯¸®ÀÇ
°æ·Î¸¦ ³ªÅ¸³»´Â ȯ°æº¯¼ö·Î Pro*C³ª PHPµîÀ» »ç¿ëÇÒ ¶§ Áß¿äÇÏ°Ô
Àû¿ëµÈ´Ù.
ORACLE_SID : ¿À¶óŬ ÀνºÅϽºÀÇ À̸§ÀÌ´Ù.
¿µ¹®ÀÚ·Î 3-4±ÛÀÚ·Î Á¤ÇØÁØ´Ù. ÇÊÀÚ´Â ÀνºÅÏÆ®ÀÇ À̸§À» linux
¶ó°í Áö¾ú´Ù.
±× ¿ÜÀÇ È¯°æº¯¼ö´Â ¿¹Á¦¿¡ ³ª¿Í ÀÖ´Â µ¥·Î Çϸé
µÈ´Ù.
Áö¿ª¾ð¾î¼³Á¤ ȯ°æº¯¼ö NLS_LANGÀº ¸ðµç ÀνºÅçÀÌ
³¡³ª°í ¼³¸íÇϵµ·Ï ÇÏ°Ú´Ù.
ȯ°æº¯¼ö °»½Å
À§¿Í °°ÀÌ .profile³»¿ëÀ» º¯°æÇÏ¿´´Ù¸é
# . .bash_profile ȤÀº # source .bash_profile
ÇÏ¿© ȯ°æº¯¼ö ³»¿ëÀ» ¾÷µ¥ÀÌÆ®ÇÑ´Ù. ¶Ç´Â oracle°èÁ¤À¸·Î ´Ù½Ã
·Î±×ÀÎÇÑ´Ù.
´Ù. ½ÇÁ¦ÀûÀÎ Oracle ÀÇ ¼³Ä¡
1. ÀνºÅç·¯ ½ÇÇà
¤¡) oracle·Î ·Î±×ÀÎ ÇÑ´Ù. - Àý´ë root·Î
ÀνºÅç·Î¸¦ ½ÇÇàÇÏ¸é ¾ÈµÈ´Ù. ¤¤) oracle ¼³Ä¡ µð·ºÅ丮·Î
À̵¿ # cd /usr/src/ora/orainst
¤§) orainst¸¦ ½ÇÇàÇÑ´Ù. #
./orainst ¸¦ ½ÇÇàÇÑ´Ù.
ȸ鿡¼ [TAB]Å°, È»ìǥŰ, ½ºÆäÀ̽º ¹Ù¸¦
ÀÌ¿ëÇÏ¿© Ç׸ñÀ» ¼±ÅÃÇÒ ¼ö ÀÖ´Ù.
2. °ËÀº ¹è°æÀÇ ¼³Ä¡È¸éÀÌ ³ª¿À¸é Custom InstallÀ»
¼±ÅÃÇÑ´Ù.
3. óÀ½ ¼³Ä¡ÇÏ´Â °ÍÀ̹ǷÎ, (o) Install, Upgrade,
or De-Install SoftwareÀ» ¼±ÅÃÇÑ´Ù.
4. »õ·Ó°Ô ÀνºÅç ÇÒ °ÍÀ̹ǷΠInstall
New Product - Create DB ObjectsÀ» ¼±ÅÃÇÑ´Ù.
5. Mount Point¸¦ ¼³Á¤ÇÑ´Ù. root user·Î ÇÒ
ÀÏ 5. ¹ø¿¡¼ ¼³Á¤ÇÑ °Íó·³ mount point¸¦ /home/oracle·Î
¼³Á¤ÇÑ´Ù.
6. .bash_profile¿¡¼ ¼³Á¤ÇÑ °Íó·³ $ORACLE_HOME
µð·ºÅ丮¸¦ ¼³Á¤ÇÑ´Ù.
7. ORACLE_BASE ¿Í ORACLE_HOMEÀ» ¼³Á¤ÇÑ´Ù.
8. log ÆÄÀÏÀÌ ³²À» À§Ä¡¸¦ ¼³Á¤ÇÑ´Ù.
9. Install from CD-ROMÀ» ¼±ÅÃÇÏ¿©¾ß ÇÑ´Ù.
10. ORACLE_SID¸¦ .bash_profile¿¡¼ ¼³Á¤ÇÑ
°Í°ú °°ÀÌ linux·Î ¼±ÅÃÇÑ´Ù.
11. NLS ÀÇ ¼³Á¤ - ¿©±â¿¡¼´Â ÀÏ´Ü ALL language¸¦
¼±ÅÃÇÑ´Ù.
12. install ÀÌ ³¡ÀÌ ³ ÈÄ root.shÀ» ½ÇÇàÇ϶ó´Â
¸Þ½ÃÁö°¡ Ãâ·ÂµÈ´Ù. ¹Ýµå½Ã install ÈÄ¿¡´Â root.shÀ»
½ÇÇàÇÏ¿©¾ß ÇÑ´Ù.
13. Software Asset Manager¿¡¼ ¼³Ä¡ÇÑ ºÎºÐÀ»
¼±ÅÃÇÑ´Ù.¿©±â¿¡¼´Â ¸ðµç ºÎºÐÀ» ¼³Ä¡
ÇÑ´Ù°í °¡Á¤À» ÇÑ´Ù.
14. 13)¿¡¼Ã³·³ InstallÀ» ¼±ÅÃÇÑ ÈÄ ¸î °¡Áö
»çÇ׿¡ ´ëÇÏ¿© OK¸¦ ÇÑ ÈÄ OSOPER group (dba)
¸¦ ¼³Á¤ÇÑ´Ù.
15. »ý¼ºÇÒ DB Object¸¦ ¼±ÅÃÇÑ´Ù. - Filesystem-Based
DatabaseÀ» ¼±ÅÃÇÑ´Ù.
16. Database Mount Points¸¦ Á¤ÇÑ´Ù. ¼³Ä¡µµÁß¿¡
3°³ÀÇ mount points¸¦ ±âÀÔÇ϶ó°í Çϴµ¥ ¹°¸®ÀûÀ¸·Î
ºÐ¸®µÈ Çϵ尡 3°³ Á¸ÀçÇÏ¸é °¡Àå ÁÁÁö¸¸ ½ÇÁ¦ PC¿¡¼´Â Èûµç ÀÏÀÌ´Ù.
ÀÌ·¸°Ô 3°÷À¸·Î µ¥ÀÌÅ͸¦ ºÐ¸®ÇÏ´Â
ÀÌÀ¯´Â µ¥ÀÌÅͺ£À̽º°¡ ÇÏµå µð½ºÅ©·ÎÀÇ Àбâ/¾²±â¸¦ ÇÏ´Â
°úÁ¤¿¡¼ °æÇÕÀ» ÁÙÀÌ°í ¿¡·¯ ¹× ¹®Á¦ÀÇ ¹ß»ý½Ã ÀÚ¿¬½º·± º¹±¸¸¦
À§ÇÑ °ÍÀÌ´Ù.
ÇÏÁö¸¸ ¿À¶óŬ ÇÁ·Î±×·¥°ú µ¿ÀÏÇÑ
Çϵåµð½º¿¡ ¹Û¿¡ ÀνºÅç ÇÒ °ø°£ÀÌ ¾ø´Ù¸é ¿©±â¿¡ ¸ðµÎ
µ¿ÀÏÇÑ °æ·Î¸¦ Àû¾îÁÖ¸é µÈ´Ù.
ÇÊÀÚµµ ¿À¶óŬÀ»
¼³Ä¡ÇÒ ¶§ /home/oracle¿¡ ¿À¶óŬ ÇÁ·Î±×·¥À» ¼³Ä¡ÇÏ°í µ¥ÀÌÅÍ
ÆÄÀÏÀ» À§ÇÑ 3°³ÀÇ ¸¶¿îÆ® Æ÷ÀÎÆ®µµ
/home/oracle·Î ¼³Á¤ÇÏ¿´´Ù.
17. Character Set ¼³Á¤ - ÇѱÛÀ» ¾²±â À§ÇؼKO16KSC5601·Î
¼³Á¤ÇÑ´Ù.
18. National Character Set ¼³Á¤
19. System password ÀÇ ¼³Á¤ (º¸Åë manager¶ó°í
password¸¦ ÀÔ·ÂÇÑ´Ù. )
20. sys password ÀÇ ¼³Á¤ ( manager·Î password¸¦
¼³Á¤. )
21. dba password ÀÇ ¼³Á¤ ( no¶ó°í ¼³Á¤ÇÑ´Ù.
)
22. TNS Listener Password ÀÇ ¼³Á¤
23. Configure MTS and start SQL*Net listener
¼³Á¤Àº no·Î ÇÑ´Ù.
24. Control files ÀÇ À§Ä¡ È®ÀÎ.
25. ±âº»ÀûÀÎ µ¥ÀÌÅͺ£À̽º °ü·Ã ÆÄÀÏÀÇ À§Ä¡¿Í
¿ë·®ÀÇ È®ÀÎ
26. JDBC ¼ÂÀÇ ¼±Åà (default·Î ¼±ÅÃÀ»ÇÑ´Ù.)
27. CTX Temporary TablespaceÀ» ¼±ÅÃÇÑ´Ù.
28. CTX demo tableÀ» ¼³Ä¡ÇÒ °ÍÀ» ¼±ÅÃÇÑ ÈÄ¿¡,
Oracle Document¸¦ ¼³Ä¡ÇÒ °Í¿¡ ´ëÇÏ¿©
¼ÂÆÃÇÑ´Ù. µð·ºÅ丮¸¦ ¼³Á¤ÇÑ ÈÄ
pdf, html, both ¾î¶² Çü½ÄÀ¸·Î ¼³Ä¡ÇÒ °ÍÀÎÁö ¹¯´Âµ¥
±×¶§¿¡´Â ÀÚ½ÅÀÌ ¿øÇÏ´Â Ç׸ñ Áß¿¡¼
ÇÑ°¡Áö¸¦ ¼±ÅÃÇÏ¸é µÈ´Ù.
29. ÀÌÁ¦ ÀνºÅçÀÌ ½ÃÀ۵DZ⠽ÃÀÛÇÏ°í ±×·¡ÇÁ°¡
¿Ã¶ó°¡±â ½ÃÀÛÇÑ´Ù. ÇÏ¿°¾øÀÌ ±â´Ù¸®ÀÚ -_-;
30. ¼³Ä¡¿Ï·á ȸé.
31. ¼³Ä¡ °ËÁõ ¼³Ä¡°¡
¸ðµÎ ³¡³µ´Ù¸é $ORACLE_HOME/orainst µð·ºÅ丮¿¡ »ý¼ºµÈ root.shÀ»
root °èÁ¤
À¸·Î ½ÇÇà ½ÃŲ´Ù.
¤¡) root·Î ·Î±×ÀÎÇÑ´Ù.
¤¤) cd $ORACLE_HOME/orainst ¤§)
./root.sh
# ./root.sh - /etc/oratab ¾Æ·¡¿¡ ´ÙÀ½°ú
°°Àº ³»¿ëÀÌ Ãß°¡µÇ¾ú´Ù.
*:/home/oracle//app/oracle/product/8.0.5:N
linux:/home/oracle/app/oracle/product/8.0.5:N
¶ó. Oracle Database ÀÇ ±¸µ¿
1. oracle user·Î login.
2. svrmgrlÀ» ½ÇÇà½ÃŲ ÈÄ database¸¦ °¡µ¿ÇÑ´Ù.
$ svrmgrl - svrmgrl
ÀÇ ½ÇÇà
SVRMGR> connect internal -
internal Á¢¼Ó Connected. Oracle
Server Manager Release 3.0.5.0.0 - Production
(c) Copyright 1997, Oracle Corporation.
All Rights Reserved.
Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.1.0 - Production
SVRMGR> connect internal -
internal Á¢¼Ó Connected.
SVRMGR> startup; ORACLE
instance started. Total System Global Area 4754704
bytes Fixed Size 48400
bytes Variable Size 4222976
bytes Database Buffers 409600
bytes Redo Buffers 73728
bytes Database mounted. Database
opened.
SVRMGR> exit - svrmgrl ÀÇ Á¾·á
Server Manager complete.
3. lsnrctl ¸í·ÉÀ» ÀÌ¿ëÇÏ¿© Oracle listenerÀ»
°¡µ¿½ÃŲ´Ù. - lsnrctl start : Oracle
listener ÀÇ °¡µ¿ - lsnrctl stop
: Oracle listener ÀÇ ¸ØÃã $ lsnrctl
start
LSNRCTL for Linux: Version 8.0.5.0.0 - Production
on 26-APR-99 21:56:51 (c) Copyright 1997 Oracle Corporation.
All rights reserved.
Starting /home/oracle/app/oracle/product/8.0.5/bin/tnslsnr:
please wait...
TNSLSNR for Linux: Version 8.0.5.0.0 - Production
System paramete rfile is /home/oracle/app/oracle/product/8.0.5/network/admin/
listener.ora Log messages written to /home/oracle/app/oracle/product/8.0.5/network/log/
listener.log Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=6)(KEY=linux))
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=PNPKEY))
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=11)(HOST=192.168.1.1)(PORT=1521))
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=linux))
STATUS of the LISTENER ------------------------ Alias
LISTENER
Version TNSLSNR
for Linux: Version 8.0.5.0.0 - Production Start Date 26-APR-99
21:56:56 Uptime 0
days 0 hr. 0 min. 1 sec Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /home/oracle/app/oracle/product/8.0.5/network/admin/
listener.ora Listener Log File
/home/oracle/app/oracle/product/8.0.5/network/log/ listener.log
Services Summary... extproc has
1 service handler(s) linux has
1 service handler(s) The command completed successfully
- ¿À¶óŬ ¸®½º³Ê°¡ Á¦´ë·Î ½ÇÇàÀÌ µÇÁö ¾ÊÀ»
°æ¿ì listener.ora, tnsnames.oraÀ» ¾Ë¸Â°Ô
ÆíÁýÇÑ´Ù. (/home/oracle/app/oracle/product/8.0.5/network/admin
À§Ä¡ÇÏ¿© ÀÖ´Ù.)
´ÙÀ½Àº tcp/ip ÇÁ·ÎÅäÄÝÀ» ±âÁØÀ¸·Î ÇÏ¿©¼ listener.ora¸¦
¾Ë¸Â°Ô ÆíÁýÇÑ °ÍÀÌ´Ù.
# # Installation Generated Net8 Configuration
# Version Date: Jun-17-97 # Filename: Listener.ora #
LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL=
IPC)(KEY= linux)) (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
(ADDRESS= (PROTOCOL= TCP)(Host= 192.168.1.1) (Port= 1521))
- database °¡ ¼³Ä¡µÇ¾î ÀÖ´Â ip¸¦ Àû¾îÁØ´Ù. ) SID_LIST_LISTENER
= (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= 192.168.1.1.)
- database °¡ ¼³Ä¡µÇ¾î ÀÖ´Â ip¸¦ Àû¾îÁØ´Ù. (ORACLE_HOME=
/home/oracle/app/oracle/product/8.0.5) (SID_NAME =
linux) - linux sid , ¼³Ä¡µµÁß Àû¾îÁØ sid¸¦ Àû¾îÁØ´Ù.
) (SID_DESC = (SID_NAME = extproc) (ORACLE_HOME
= /home/oracle/app/oracle/product/8.0.5)
(PROGRAM = extproc) ) )
STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER
= 10 TRACE_LEVEL_LISTENER = OFF
# # Installation Generated Net8 Configuration
# Version Date: Oct-27-97 # Filename: Tnsnames.ora
# extproc_connection_data = (DESCRIPTION
= (ADDRESS = (PROTOCOL = IPC)(KEY = linux)) (CONNECT_DATA
= (SID = extproc)) ) linux = - oracle alias
(DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= 192.168.1.1)
(Port= 1521)) - database °¡ ¼³Ä¡µÇ¾îÀÖ´Â database ÀÇ ip
(CONNECT_DATA = (SID = linux)) - oracle sid
)
linux_BEQ = (DESCRIPTION = (ADDRESS
= (PROTOCOL = BEQ)(PROGRAM = /home/oracle/app/oracle/product/8.0.5)
(argv0 = oraclelinux) (args = ¡®(DESCRIPTION = (LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))¡¯)
(envs = ¡®ORACLE_HOME=/home/oracle/app/oracle/product/8.0.5,ORACLE_SID=linux¡¯)
) )
4. ÀÌÁ¦ ´Ù½Ã lsnrctl start ¸í·ÉÀ¸·Î ½ÇÇàÇÏ¿©
Oracle listenerÀ» ½ÇÇàÇÑ´Ù. ÀÌÁ¦
sqlplusÀ» ½ÇÇàÇÏ¿© Á¢¼ÓÀÌ µÇ³ª È®ÀÎÀ» ÇÏÀÚ. test ¿ëÀ¸·Î id :
scott password : tiger °¡ Á¦°øµÊÀ»
¾Ë ¼ö ÀÖ´Ù. ÀÌ¹Ì ¼³Ä¡ Áß¿¡ system°ú sysÀÇ password´Â Á÷Á¢ ÀÔ·ÂÇÏ¿´À¸¹Ç
·Î, system ȤÀº sys·Î Á¢¼ÓÀÌ °¡´ÉÇÑÁö
È®ÀÎÇÒ ¼ö ÀÖ´Ù.
5. sqlplus·Î Á¢¼ÓÀÌ È®ÀεǾúÀ¸¸é ÀÌÁ¦ listenerÀ»
Á¾·áÇÑ ÈÄ database¸¦ Á¾·á½ÃÄÑ º¸ÀÚ.
- listener ÀÇ Á¾·á $ lsnrctl stop
LSNRCTL for Linux: Version 8.0.5.0.0 - Production
on 26-APR-99 22:18:35
(c) Copyright 1997 Oracle Corporation. All
rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=linux))
The command completed successfully
- oracle database ÀÇ shutdown $ svrmgrl
Oracle Server Manager Release 3.0.5.0.0 - Production
(c) Copyright 1997, Oracle Corporation. All
Rights Reserved.
Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
SVRMGR> connect internal Connected.
SVRMGR> shutdown Database closed. Database dismounted.
ORACLE instance shut down. SVRMGR> exit Server Manager
complete.
$
¸¶. Oracle Database ÀÇ »ç¿ëÀÚ µî·Ï
system/manager¶ó´Â Oracle »ç¿ëÀÚ °èÁ¤Àº UNIX½Ã½ºÅÛ¿¡¼ÀÇ
root¸¦ »ç¿ëÇÏ´Â °Í°ú À¯»çÇϱ⠶§¹®¿¡ ¿ì¸®´Â ¹®Á¦¸¦ ¹ß»ý½ÃÅ°´Â
°ÍÀ» ÃÖ¼ÒÈÇϱâ À§ÇØ µÇµµ·Ï ÀûÀº ±ÇÇÑÀ» °®´Â »ç¿ëÀÚ¸¦ »ý¼ºÇÒ
ÇÊ¿ä°¡ ÀÖ´Ù.
SQL*PLUS¿¡ ¿¬°áÇÏ°í »ç¿ëÀÚ¸¦ »ý¼ºÇÑ´Ù.
$ sqlplus system/manager
SQL*Plus: Release 8.0.5.1.0 - Production
Copyright (c) Oracle Corporation 1997. All
rights reserved.
Connected to: Oracle8 Server Release 8.0.5.0.0
- Production Release PL/SQL Release 8.0.5.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 Oracle8 Server Release 8.0.5.0.0
- Production Release PL/SQL Release 8.0.5.0.0 - Production
½Ã½ºÅÛ¿¡ »õ·Î¿î »ç¿ëÀÚ°èÁ¤À» »ý¼ºÇÏ¿´±â ¶§¹®¿¡
»õ·Î¿î °èÁ¤À» °¡Áö°í ½Ã½ºÅÛ¿¡ ·Î±×ÀÎ ÇÒ¼ö ÀÖ´Ù. Oracle µ¥ÀÌÅͺ£À̽º¿¡
·Î±×ÀÎ Çϱâ À§Çؼ´Â ´ÙÀ½°ú °°´Ù.
$ sqlplus <user>/<password>
ÀÌ ºÎºÐÀÌ ¿¡·¯ ¸Þ½ÃÁö ¾øÀÌ ¼öÇàµÈ´Ù¸é, ¼º°øÀûÀ¸·Î
Oracle µ¥ÀÌÅͺ£À̽º¸¦ ¼³Ä¡ÇÑ °ÍÀÌ´Ù.
¹Ù. Oracle µ¥ÀÌÅÍ º£À̽ºÀÇ ÀÚµ¿ ½ÇÇà
Oracle µ¥ÀÌÅͺ£À̽ºÀÇ ÀÚµ¿ ½ÃÀÛ°ú ÁßÁö´Â Oracle¿¡¼
Á¦°øÇÏ´Â ÆÄÀÏÀÎ dbstart¿Í dbstop¸¦ ÀÌ¿ëÇÏ¿© ¼³Á¤ÇÒ ¼ö ÀÖ´Ù.
ÀÌ·¯ÇÑ ÆÄÀϵéÀº etc/oratab ÆÄÀÏÀÇ Á¸Àç¿©ºÎ¿¡ ÀÇÁ¸ÇÑ´Ù.
/etc/oratab ÆÄÀÏÀÇ Çü½ÄÀº ´ÙÀ½°ú °°´Ù.
SID:ORACLE_HOME:AUTO
¼³Á¤ ¿¹
# # This file is used by ORACLE utilities.
It is created by root.sh # and updated by the Oracle8
and SQL*Net install procedures. # # A colon, ¡®:¡¯,
is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, ¡®#¡¯,
are comments. # # Entries are of the form: # $ORACLE_SID:$ORACLE_HOME:<N|Y>:
# # The first and second fields are the system identifier
and home # directory of the database respectively. The
third field indicates # to the dbstart utility that the
database should, ¡°Y¡±, or should not, # ¡°N¡±, be brought
up at system boot time. # # Multiple entries with the
same $ORACLE_SID are not allowed. # # linux:/oracle8/app/oracle/product/8.0.5:Y
init.d & rc.d
¸®´ª½º ½Ã½ºÅÛÀÇ ½ÃÀÛ°úÁ¤À̳ª Á¾·á°úÁ¤À» º¯ÇüÇÏ¿©
µ¥ÀÌŸº£À̽º¸¦ ½ÃÀÛ½ÃÅ°°í Á¾·á ½Ãų ¼ö ÀÖ´Ù. ÀÌ°ÍÀº ¸Å¿ì ½±Áö¸¸,
¾î¶°ÇÑ Linux(slackware, debian, redhat, etc)½Ã½ºÅÛÀ» »ç¿ëÇÏ´À³Ä¿¡
µû¶ó º¯°æµÉ ¼ö ÀÖ´Ù´Â °ÍÀ» ÇÊÀÚ´Â ÁöÀûÇÑ´Ù. ÀÌ ¹®¼¿¡¼´Â
Redhat Linux 5.2 ¿¡¼ µ¿ÀÛÇÏ´Â ¿¹¸¦ º¸¿©ÁÙ °ÍÀÌ´Ù. ÀÚ½ÅÀÇ Linux
½Ã½ºÅÛ¿¡ µû¶ó ¼öÁ¤Çϱâ À§Çؼ´Â ÀÚ½ÅÀÇ Linux ½Ã½ºÅÛ ¹®¼ ÀڷḦ
Âü°íÇÑ´Ù. ¿ì¼±, ¿ì¸®´Â /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 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
¸¶Ä¡´Â ±Û
ÀÌ»óÀ¸·Î °£·«ÇÏ°Ô³ª¸¶ Linux »ó¿¡¼ÀÇ Oracle
µ¥ÀÌÅͺ£À̽º ¼³Ä¡¿Í ±¸µ¿¹ý¿¡ ´ëÇؼ ¾Ë¾Æº¸¾Ò´Ù. ±×¸²°ú
ÇÔ²² Á» ´õ ¸íÈ®ÇÑ ¼³Ä¡¹ýÀ» ¼Ò°³ÇØ ÁÙ ¼öµµ ÀÖ¾úÁö¸¸, ÀÌÁ¦ °£´ÜÇÑ
¼³Ä¡¹ý Á¤µµ´Â ±âŸ Ã¥À̳ª ¿À¶óŬ»ç ¼¼¹Ì³ª¿¡ °¡¸é ½±°Ô ±¸ÇÒ ¼ö
ÀÖÀ¸¹Ç·Î ±âº» ¼³Ä¡¹ý¿¡ »ç¿ëÀÚ µî·Ï, ÀÚµ¿ ½ÃÀÛ/Á¾·á¸¦ Ãß°¡ÇØ
ù ±ÛÀ» ¸¶Ä£´Ù. ´ÙÀ½¿¡´Â °£´ÜÇÑ sqlplus »ç¿ë¹ý, Oracle SQL,
pro-c ¿¡´ëÇؼ ¾Ë¾Æº¸°í ¸¶Áö¸·À¸·Î PHP3¿Í ¿¬µ¿ÇÏ´Â °ÍÀ¸·Î ÀÌ
±ÛÀ» ¸¶Ä¥±î ÇÑ´Ù.
¡ã top
|