|
|
[ÀϹÝ] ¿À¶óŬ 10g ¼³Ä¡ |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 220.¢½.198.135 |
ÀÐÀ½:5485 |
|
|
¿À¶óŬ 10g ¼³Ä¡Çϱâ | [ORACLE ÇнÀ----] 2005.06.03 13:20
¹Ù¶÷°øÁÖ(miskorea24) http://cafe.naver.com/q69/6378
¿À¶óŬÀ» ¼³Ä¡Çϱâ À§ÇÑ Áغñ
Çʼö RPM ÈÀϵé : gcc-3.2-7 5¹ø°·Î ¼³Ä¡
cpp-3.2-7 1¹ø°·Î ¼³Ä¡
glibc-devel-2.2.93-5 4¹ø°·Î ¼³Ä¡
kernel-headers-2.4.19-5cl 3¹ø°·Î ¼³Ä¡
binutils-2.13.90.0.2-2 2¹ø°·Î ¼³Ä¡
Oracle 10g¸¦ ¼³Ä¡ÇÏ·Á¸é ¸î¸î ÆÐÅ°Áö°¡ ¹Ýµå½Ã ¼³Ä¡µÇ¾î ÀÖ¾î¾ß ÇÕ´Ï´Ù.
È®ÀÎ ÈÄ ¼³Ä¡°¡ ¾ÈµÈ ÆÐÅ°Áö´Â µû·Î ¼³Ä¡ÇØ ÁÝ´Ï´Ù.
[root@ora10 src]# rpm -q binutils gcc make openmotif
[root@ora10 src]# rpm -Uvh --nodeps binutils-2.13.90.0.18-9.i386.rpm
[root@ora10 src]# rpm -Uvh --nodeps gcc-3.2.2-5.i386.rpm
[root@ora10 src]# rpm -Uvh --nodeps make-3.79.1-17.i386.rpm
[root@ora10 src]# rpm -Uvh --nodeps openmotif-2.2.2-14.i386.rpm
¸®´ª½º¿ë ¿À¶óŬÀº ¼³Ä¡½Ã¿¡ Linking ±îÁö °°ÀÌ ÇϹǷΠ¹Ýµå½Ã ±×¿¡ µû¸¥ Library °¡ ÇÊ¿äÇÏ´Ù.
À§ÀÇ RPM µéÀÌ ±×°ÍÀε¥ ¸¸ÀÏ ¼³Ä¡ ¾È ÇÑ RPM µéÀÌ ÀÖ´Ù¸é Linking ÇÒ ¶§ Invoke ¿¡·¯¸¦ Á¢ÇÏ°Ô
µÉ °ÍÀÌ´Ù. À§ÀÇ RPM µéÀº RedHat8.0 CD³ª http://rpmfind.net ¿¡¼ ±¸ÇÒ¼ö ÀÖ´Ù.
¿©±â¼ À§ÀÇ °ÍµéÀ» ¼³Ä¡ÇÒ ¶§ ÀÇÁ¸¼ºÀÌ ¹®Á¦°¡ µÇ¹Ç·Î ¼³Ä¡ ¼ø¼¸¦ µû¸£´Â °Ô Æí¸®ÇÒ °ÍÀÌ´Ù.
Âü°í·Î rpm ¼³Ä¡ ¸í·É¾î´Â #rpm -i ÆÐÅ°Áö À̸§ ÀÌ´Ù.
±×¸®°í ³» ¸®´ª½º ¼¹ö¿¡´Â kernel-headers°¡ ¼³Ä¡µÇ¾î ÀÖÁö ¾Ê¾Ò°í kernel-headers ÀνºÅç ½Ã
glibc-kernheaders-2.4-7.20 °ú Ãæµ¹ÇÏ¿© ¿¡·¯°¡ ³µ´Âµ¥
#rpm -e -nodeps glibc-kernheaders-2.4-7.20 ¸í·ÉÀ» ³»·Á »èÁ¦ÇÑ ÈÄ ´Ù½Ã
rpm -i kernel-headers-2.4.19-5cl.i386.rpm À» Çضó. ÀÌÁ¦ ÀßµÉ °ÍÀÌ´Ù.
À§ÀÇ °ÍµéÀÌ Á¦´ë·Î ¼³Ä¡ µÇ¾ú´ÂÁö È®ÀÎÇÏ·Á¸é ´ÙÀ½ÀÇ ¸í·ÉÀ» »ç¿ëÇÑ´Ù.
1. ¿À¶óŬ ÇÁ·Î±×·¥ ´Ù¿î·Îµå
¾Æ·¡ÀÇ ÁÖ¼Ò¿¡¼ ¿À¶óŬ ÆÄÀÏÁß, ship.db.cpio.gzÀ» ´Ù¿î ¹Þ½À´Ï´Ù.
http://www.oracle.com/technology/software/products/database/oracle10g/index.html
http://otn.oracle.com/software/products/database/oracle10g/index.html
¾Æ·¡ÀÇ ¸í·ÉÀ¸·Î ¾ÐÃàÀ» DZ´Ï´Ù.
# zcat ship.db.cpio.gz | cpio -idmv
2. OS ȯ°æ º¯°æ
¿À¶óŬ 10g´Â ÀÚüÀûÀ¸·Î Å×½ºÆ®µÈ ¸î °¡ÁöÀÇ OS¸¸ ¼³Ä¡µÇµµ·Ï üũÇÏ´Â ºÎºÐÀÌ ÀÖ½À´Ï´Ù.
À̸¦ À§ÇØ /etc/redhat-release ÆÄÀÏÀ» »ý¼º ÈÄ ·¹µåÇÞ 3 ¹öÀüÀ¸·Î ¸¸µì´Ï´Ù.
Oracle 10g¸¦ ¼³Ä¡ÇÏ·Á¸é ÀÎÁõµÈ ¿î¿µÃ¼Á¦¸¸ ¼³Ä¡°¡ °¡´ÉÇϵµ·Ï ÇÏ´Â ºÎºÐÀÌ ÀÖ½À´Ï´Ù.
RedHat Linux Advanced Server 3 ·Î ¼ÓÀÔ´Ï´Ù.
# echo "redhat-3" > /etc/redhat-release
3. »ç¿ëÀÚ ¹× ±×·ì»ý¼º
¾Æ·¡ÀÇ ¸í·ÉÀ¸·Î »ç¿ëÀÚ ¹× ±×·ìÀ» »ý¼ºÇÕ´Ï´Ù.
# groupadd dba
# groupadd oinstall
# useradd -g oinstall -G dba oracle
# passwd oracle
¿À¶óŬÀÌ ¼³Ä¡µÉ µð·ºÅ丮¸¦ »ý¼ºÇÕ´Ï´Ù. ---> ²À »ý¼ºÇÏÁö ¾Ê¾Æµµ /home/oracle¸¦ µðÆúÆ®·ÎÇصµµÈ´Ù.
# mdkir -p /u01/app/oracle
# chown -R oracle.oinstall /u01
# chmod -R 755 /u01/app/oracle
4. Ä¿³Î ÆĶó¹ÌÅÍ ¼öÁ¤
¿ø·¡ °øÀ¯¸Þ¸ð¸®¿Í ¼¼¸¶Æ÷¾î¸¦ º¯°æÇÑ °ªÀ» Àû¿ëÇÏ¿© Ä¿³ÎÀ» ÀçÄÄÆÄÀÏ ÇؾßÇÏÁö¸¸
¿©°ÇÀÌ µÇÁö ¾Ê´Â (ÇÊÀÚµµ Ä¿³Î ÀçÄÄÆÄÀÏ ¿©°ÇÀÌ ¾ÈµÈ´Ù.) °æ¿ì ¼ÒÇÁÆ®¿þ¾îÀûÀ¸·Î
°øÀ¯¸Þ¸ð¸®¿Í ¼¼¸¶Æ÷¾î¸¦ º¯°æÇÒ ¼ö ÀÖ´Ù.
°¡Àå ¸¶Áö¸·¿¡ ´ÙÀ½À» Ãß°¡ÇÕ´Ï´Ù.
/etc/sysctl.conf ÆÄÀÏ¿¡ µÞ ºÎºÐ¿¡ ¾Æ·¡¿Í °°ÀÌ ³»¿ëÀ» Ãß°¡ÇÕ´Ï´Ù.
[root@localhost ~]# cat >> /etc/sysctl.conf << eof
### Oracle 10g Kernel Parameters
kernel.shmmax = 1073741824
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range=1024 65000
¼öÁ¤ÇÑ /etc/systl.confÀÇ ÆĶó¹ÌÅÍ °ªÀ» »õ·Ó°Ô Ä¿³Î¿¡ Àû¿ë½Ãŵ´Ï´Ù.
[root@localhost ~]# /sbin/sysctl -p
5. ¿À¶óŬ »ç¿ëÀÚÀÇ È¯°æº¯¼ö Ãß°¡
/home/oracle/.bash_profile ÆÄÀÏÀÇ µÚ¿¡ ¾Æ·¡ ³»¿ëÀ» Ãß°¡ÇÕ´Ï´Ù.
##############################################
export ORACLE_BASE=/u01/app/oracle -->µðÆúÆ®·Î /home/oracle ·Î ÇßÀ½
export ORACLE_SID=ORCL ----------->ÆíÇÏ°Ô oracle ·Î ÇßÀ½
export ORACLE_HOME=ORACLE_BASE/product/10.1.0/db_1
export PATH=ATH:ORACLE_HOME/bin
export DISPLAY=127.0.0.1:0.0
##############################################
°ü¸®ÀÚ(root) ±ÇÇÑÀ¸·Î ¾Æ·¡ÀÇ ¸í·ÉÀ» ½ÇÇàÇÕ´Ï´Ù.
# xhost + 127.0.0.1
¡Ø À§ ¸í·ÉÀº ¹Ýµå½Ã ÇØ´ç ·ÎÄü¹ö¿¡¼ ÀÛ¾÷À» ÇÏ¼Å¾ß ÇÕ´Ï´Ù.(¿ø°Ý¿¡¼´Â ¾ÈµË´Ï´Ù.)
(¿À¶óŬ ¼³Ä¡´Â ·ÎÄü¹ö¿¡¼ ¸ðµç ÀÛ¾÷À» ÇϽô °ÍÀÌ ÁÁ½À´Ï´Ù.)
root ÀÌ¿ÜÀÇ ÀϹݰèÁ¤µµ ±ÇÇÑ»ó°ü¾øÀÌ ¿¢½ºÀ©µµ¿ì¸¦ »ç¿ëÇÒ¼öÀÖ°Ô ÇϱâÀ§ÇÑ ¸í·É
6. ¿À¶óŬ ¼³Ä¡½ÃÀÛ
¡Ø Áö±ÝºÎÅÍ´Â ¹Ýµå½Ã oracle »ç¿ëÀÚ °èÁ¤À¸·Î ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù.
Áö±Ý root±ÇÇÑÀ¸·Î ·Î±×ÀÎ µÇ¾îÀÖ´Ù¸é ·Î±×¾Æ¿ô ÇϽðí,
oracle °èÁ¤À¸·Î ´Ù½Ã ·Î±×ÀÎÇϽñ⠹ٶø´Ï´Ù.
¿À¶óŬ ¼³Ä¡ ÇÁ·Î±×·¥À» ¾ÐÃàǬ Àå¼Ò·Î À̵¿ÇÏ¿©, ¾Æ·¡ ÆÄÀÏÀ» ã¾Æ¼ ½ÇÇà½Ãŵ´Ï´Ù.
runInstaller
À̸í·ÉÀ» ³»·ÈÀ»¶§ ¿©·¯ °¡Áö ¿¡·¯°¡ ¶ã¼öÀÖ´Ù. /home /tmp /home/oracle µîÀÇ Æ۹̼ÇÀ» ´Ù½ÃÇѹø
È®ÀÎÇÏÀÚ 755
¡Ø ¸¸¾à ±ÛÀÚ°¡ ±úÁ®¼ º¸Àδٸé, ÇÁ·Î±×·¥À» Á¾·áÇÏ°í ¾Æ·¡¸í·ÉÀ» ÀÔ·ÂÇÑÈÄ ´Ù½Ã ÇÁ·Î±×·¥À» ½ÇÇàÇÕ´Ï´Ù.
unset LANG
7. Welcome
ȯ¿µÀλç ÀÔ´Ï´Ù. Next¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
8. Specify Inventory directory and credentials
µð·ºÅ丮¿Í ½Ã½ºÅÛ±×·ì ÁöÁ¤. Next¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
¡Ø °æ°íâÀÌ ³ªÅ¸³³´Ï´Ù.
/u01/app/oracle/oraInventory/orainstRoot.sh¸¦ ½ÇÇàÇ϶ó´Â ³»¿ëÀÔ´Ï´Ù.
ÄܼÖÀ» ¶ç¿ö¼ root ±ÇÇÑÀ¸·Î º¯°æÇÑ ´ÙÀ½, ¾Æ·¡¿Í °°ÀÌ ½ºÅ©¸³Æ® ÆÄÀÏÀ» ½ÇÇàÇÕ´Ï´Ù.
# /u01/app/oracle/oraInventory/orainstRoot.sh
Æ˾÷âÀÇ Continue¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
9. Specify File Locations
¼³Ä¡ÇÒ ÆÄÀÏ°ú ¼³Ä¡µÉ ÆÄÀÏÀÇ À§Ä¡¸¦ ÁöÁ¤ÇÕ´Ï´Ù. Next¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
10. Select Installation Type
¿À¶óŬÀ» ¼³Ä¡ÇÒ À¯ÇüÀ» ¼±ÅÃÇÕ´Ï´Ù. Enterprise EditionÀ» ¼±ÅÃÇÏ°í, Next¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
11. Specific Prerequisite Checks
ÀÌÁ¦±îÁöÀÇ ¼³Á¤À» È®ÀÎÇÕ´Ï´Ù. ÀÌ»ó ¾øÀ¸¸é Next¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
Ä¿³Î ÆĶó¹ÌÅ͸¦ üũÇÏ´Â ºÎºÐ¿¡¼ °æ°í Æ˾÷ÀÌ ¶å´Ï´Ù.
Yes¸¦ ´·¯ °æ°í¸¦ ¹«½ÃÇÏ°í °è¼Ó ÁøÇàÇÕ´Ï´Ù.
12. Select Database Configuration
µ¥ÀÌÅͺ£À̽º »ç¿ë ¿ëµµ¿¡ µû¶ó ¼³Á¤ ¿É¼ÇÀ» ¼±ÅÃÇÕ´Ï´Ù.
º¸Åë General Purpose·Î ÇÏ¸é µË´Ï´Ù. Next¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
13. Specify Database Configuration Options
µ¥ÀÌÅͺ£À̽ºÀÇ Global Database Name/SID/Character setÀÇ ¿É¼ÇÀ» ÁöÁ¤ÇÕ´Ï´Ù.
Global Database Name¿Í SID´Â [ORCL] ·Î Character setÀº [Korean KO16KSC5601]·Î Database ¿¹Á¦ ½ºÅ°¸¶µµ »ý¼ºÇÕ´Ï´Ù.
Next¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
14. Select Database Management Option
µ¥ÀÌÅͺ£À̽º¸¦ °ü¸®Çϴµ¥ ÇÊ¿äÇÑ ¿É¼ÇÀ» ¼±ÅÃÇÕ´Ï´Ù. Next¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
15. Specify Database File Storage Option
µ¥ÀÌÅͺ£À̽º ÆÄÀÏÀÇ ½ºÅ丮Áö ¿É¼ÇÀ» ÁöÁ¤ÇÕ´Ï´Ù. º¸Åë File SystemÀ¸·Î ÇÏ½Ã¸é µË´Ï´Ù.
Next¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
16. Specify Backup and Recovery Options
¹é¾÷À̳ª º¹±¸ ¿É¼ÇÀ» ÁöÁ¤ÇÕ´Ï´Ù. ±âº»°ªÀ¸·Î ³Ñ¾î°©´Ï´Ù.
Next¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
17. Specify Database Schema Passwords
¿À¶óŬ °ü¸®¸¦ À§ÇÑ °èÁ¤µéÀÇ Æнº¿öµå¸¦ ÀÔ·ÂÇÕ´Ï´Ù.
(SYS, SYSTEM, SYSMAN, DBSNMP µî)
°³º°ÀûÀ¸·Î ÀÔ·ÂÇصµ µÇ¸ç, ÇÏ´ÜÀÇ "Use the same password for all the accounts"¸¦ ¼±ÅÃÇÏ¿© Çѹø¿¡ µ¿ÀÏÇÏ°Ô ÀÔ·Â °¡´ÉÇÕ´Ï´Ù.
Next¸¦ Ŭ¸¯ÇÕ´Ï´Ù.
18. Summary
ÀÌÁ¦±îÁö ¼±ÅÃÇÑ ³»¿ëÀ» âÀ¸·Î º¸¿©ÁÝ´Ï´Ù. [Install] ¹öÆ°À» Ŭ¸¯ÇÏ¿© ¼³Ä¡¸¦ ½ÃÀÛÇÕ´Ï´Ù.
19. Install
....[¼³Ä¡ ÁøÇà Áß]....
ÀÚµ¿À¸·Î ¼³Ä¡°¡ ÁøÇàµÇ´Â µ¿¾È, Â÷ÇÑÀÜ ÇÏ¸é¼ ´À±ßÇÏ°Ô ±â´Ù·ÁÁݽôÙ.
20. Configuration Assistants
ÆÄÀÏ ¼³Ä¡ ÈÄ µ¥À̺£À̽º °ü·Ã ÆÄÀϵéÀ» º¹»çÇÏ°í ¿À¶óŬ ÀνºÅϽº¸¦ »ý¼ºÇÕ´Ï´Ù.
70%ÀÌ»ó ³Ñ¾î°¡¸é¼ Æнº¿öµå ¿À·ù°¡ ³¯ ¼ö ÀÖ½À´Ï´Ù. ÀÌ´Â ¹«½ÃÇϼŵµ ÁÁ½À´Ï´Ù.
¸ðµç ¼³Ä¡°¡ ³¡³ ÈÄ, °¢ ¿À¶óŬ ½Ã½ºÅÛ¿¡ Æнº¿öµå¸¦ ÁöÁ¤ÇÏ·Á¸é [Password Management]¸¦ Ŭ¸¯ÇÏ°í,
¾Æ´Ï¸é [OK] ¹öÆ°À» Ŭ¸¯ÇÕ´Ï´Ù.
21. Setup Privileges
[OK] ¹öÆ°À» Ŭ¸¯Çϸé root.sh ÆÄÀÏÀ» ½ÇÇàÇ϶ó´Â âÀÌ ³ªÅ¸³³´Ï´Ù.
root ±ÇÇÑÀ¸·Î ¾Æ·¡¿Í °°ÀÌ ½ºÅ©¸³Æ® ÆÄÀÏÀ» ½ÇÇàÇÕ´Ï´Ù.
# /u01/app/oracle/product/10.1.0/db_1/root.sh
22. End of Installation
ÀÌÁ¦ ¼³Ä¡°¡ ¸ðµÎ Á¾·áµÇ¾ú½À´Ï´Ù. Exit ¹öÆ°À» ´·¯¼ ÇÁ·Î±×·¥À» Á¾·áÇÕ´Ï´Ù.
* Ãß°¡ µ¡±Û
µ¥ÀÌŸº£À̽º¸¦ ±âµ¿¸¸ ÇÏ¸é ¾ÈµÇÁÒ ¿ÜºÎ¿¡¼ Á¢¼ÓÇϵµ·Ï ¸®½º³Ê¸¦ ¶ç¿ö¾ß ÇÕ´Ï´Ù.
¿ì¼± listener.ora ÆÄÀÏÀ» ¼öÁ¤ÇÕ´Ï´Ù.
ORACLE_HOME/network/admin/listener.ora ÆÄÀÏ ³»¿ë
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1)
(PROGRAM = extproc)
)
# Ãß°¡ºÎºÐ ½ÃÀÛ - ÀÌ°É Ãß°¡ÇØ¾ß 8i ÀÌÇÏÀÇ Å¬¶óÀ̾ðÆ®¿¡¼ ¿¬°áÇßÀ» ¶§ SERVICE_NAME °ü·Ã ³»¿ëÀÌ
¾ø½À´Ï´Ù.
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1)
)
# Ãß°¡ ºÎºÐ ³¡
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ÇØ´çip)(PORT = 1521)) # <== ¼¹ö¸í ´ë½Å¿¡ ¹Ýµå½Ã
ip¸¦ ³ÖÀ¸¼¼¿ä 127.0.0.1À» ³ÖÀ¸½Ã¸é ¾ÈµË´Ï´Ù. ¿ÜºÎ¿¡¼ ¼ÒÄÏÀÌ ´ÝÈù °ÍÀ¸·Î ÀνÄÇÕ´Ï´Ù.
)
)
)
ÇÑÅÒ³»¿ëÀ» ÀÏÀÏÀÌ º¸°í Ä£ °ÍÀÌ´Ï ¿ÀŸ°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. ÀÌ´Â °¨¾ÈÇÏ°í º¸¼¼¿ä.
ÀÌÁ¦ ¸®½º³Ê¸¦ ¶ç¿ó´Ï´Ù.
lsnrctl start
¸®½º³ÊÀÇ ±âµ¿À» È®ÀÎÇÕ´Ï´Ù.
netstat -a | grep 1521
tcp 0 0 ÇØ´çip:1521 *:* LISTEN
Àý´ë
tcp 0 0 ¼¹ö¸í:1521 *:* LISTEN
À¸·Î ³ª¿À¸é À§ ¼³Á¤Áß HOSTÀÇ ³»¿ëÀ» È®ÀÎÇϼ¼¿ä. µ¥ÀÌŸº£À̽º¸¦ ±âµ¿¸¸ ÇÏ¸é ¾ÈµÇÁÒ ¿ÜºÎ¿¡¼
Á¢¼ÓÇϵµ·Ï ¸®½º³Ê¸¦ ¶ç¿ö¾ß ÇÕ´Ï´Ù.
Database ½ÃÀÛ°ú Á¾·á
¨ç¿À¶óŬ µ¥ÀÌÅͺ£À̽º ½ÃÀÛÇϱâ
Database ÀÇ ½ÃÀÛ°ú Á¾·á´Â ¹Ýµå½Ã!! Oracle °èÁ¤À¸·Î ¼öÇàÇØ¾ß ÇÕ´Ï´Ù.
[root@ora10 /]# su oracle
oracle °èÁ¤À¸·Î ·Î±×ÀÎ ÈÄ oracle °èÁ¤ÀÇ È¯°æ¼³Á¤À» reload ÇÕ´Ï´Ù.
(óÀ½ºÎÅÍ ¿À¶óŬ °èÁ¤À¸·Î ·Î±×ÀÎ ÇÏ¿´´Ù¸é ÀÌ °úÁ¤Àº ºÒÇÊ¿äÇÕ´Ï´Ù.)
[oracle@ora10 /] sqlplus /nolog
SQL>connect / as sysdba
SQL> startup
¿À¶óŬ µ¥ÀÌÅͺ£À̽º¸¦ ½ÃÀÛÇÏ°í Á¾·áÇϱâ À§Çؼ´Â OS¿¡¼ÀÇ ÀÎÁõ°ú ¾ÏÈ£ ÆÄÀÏÀ» »ý¼ºÇÏ´Â
ÅøÀÎ orapwd¸¦ ÅëÇØ¾ß ÇÑ´Ù. ±×¸®°í sys ½ºÅ°¸¶ÀÇ ±ÇÇÑÀÎ sysdba ±ÇÇÑ°ú public ½ºÅ°¸¶
±ÇÇÑÀÎ sysoper ±ÇÇÑÀÇ Æ¯º°ÇÑ ½Ã½ºÅÛ ±ÇÇÑÀ» ¼ÒÀ¯ÇÑ »ç¿ëÀÚÀ̾î¾ß ÇÑ´Ù.
¡¤ sysdba : µ¥ÀÌÅͺ£À̽º ½ÃÀÛ/Á¾·á, ¾ÆÄ«ÀÌºê ¹× º¹±¸ ÀÛ¾÷, ALTER DATABASE OPEN,
MOUNT, BACKUP, CHANGE, CHARACHER SET ÀýÀÇ ¸í·É¾î ½ÇÇà
¡¤ sysoper : µ¥ÀÌÅͺ£À̽º ½ÃÀÛ/Á¾·á, ¾ÆÄ«ÀÌºê ¹× º¹±¸ ÀÛ¾÷, ALTER DATABASE OPEN,
MOUNT, BACKUP ÀýÀÇ ¸í·É¾î ½ÇÇà
SQL> SELECT * FROM vversion;
ÇöÀçÀÇ ¿À¶óŬ µ¥ÀÌÅͺ£À̽º ÀνºÅϽºÀÇ ¹öÀü È®ÀÎÇϱâ
¨è¿À¶óŬ µ¥ÀÌÅͺ£À̽º Á¾·áÇϱâ
[oracle@ora10 /] sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown immediate
SQL> exit
¨éoratab ÆÄÀÏ ÆíÁýÇϱâ
¿À¶óŬ µ¥ÀÌÅͺ£À̽º¸¦ /etc/rc.d/ini.d¿¡ ½ºÅ©¸³Æ®·Î ¼³Á¤ÇÏ¿© ÀÚµ¿À¸·Î ½ÇÇàÇÏ°Ô ÇÏ¿©º¾½Ã´Ù.
[root@ora10 /]# vi /etc/oratab
´ÙÀ½ ºÎºÐÀ» ¼öÁ¤ ([SID], [ORACLE_HOME], [ÀÚµ¿½ÇÇà/Á¾·á Ç÷¡±×]·Î ±¸¼ºµÇ¾î ÀÖ½À´Ï´Ù.)
ora10:/opt/oracle/product/10.1.0/db_1:Nè
ora10:/opt/oracle/product/10.1.0/db_1:Y
¨êParameter ÆÄÀÏ ¸µÅ©
xxxxxxxxxxxxÀº ÀÏÁ¤Ä¡ ¾ÊÀº ¼ýÀÚ ÀÔ´Ï´Ù.
[root@ora10 /]# cp /opt/oracle/admin/ora10/pfile/init.ora.xxxxxxxxxxxx \
/opt/oracle/product/10.1.0/db_1/dbs/initora10.ora
¨ë/etc/rc.d/init.d ¿¡ µî·ÏÇϱâ
oracle10g ½ºÅ©¸³Æ®¸¦ /etc/rc.d/init.d ¿¡ º¹»çÇÕ´Ï´Ù.
[root@ora10 /]# cp /usr/local/src/oracle-10.1.0.2.0 /etc/rc.d/init.d/
oracle10g¿¡ ½ÇÇà±ÇÇÑÀ» ºÎ¿©ÇÕ´Ï´Ù.
[root@ora10 /]# chmod 755 /etc/rc.d/init.d/oracle10g
½Ã½ºÅÛ¿¡ oarcle10g µ¥¸óÀ» µî·ÏÇÑ´Ù.
[root@ora10 /]# chkconfig --add oracle10g
[root@ora10 /]# chkconfig --level 2345 oracle10g on
Oracle Database¸¦ Àç½ÃÀÛ ½ÃÄѺ» ÈÄ, LISTENER µ¥¸óÀÌ ¶ç¿öÁ® ÀÕ´ÂÁö È®ÀÎÇÕ´Ï´Ù.
[root@ora10 /]# /etc/rc.d/init.d/oracle10g start
[root@ora10 /]# ps ax | grep LISTENER
################## listener.ora ##########################
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT
= 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC=
(SID_NAME=ORA817)
(ORACLE_HOME = oracle_home µð·ºÅ丮°æ·Î¸í)
)
)
###############################################################
ÀÌ·¸°Ô ¼öÁ¤ÇϽðí¿ä..
>lsnrctl start <- ¸®½º³Ê ¼ºñ½º ±âµ¿
ÇØÁÖ½Ã¸é µË´Ï´Ù..
###############################################################
.MK ¿À·ù
¸µÅ©ÇÒ¶§ ÀÚ²Ù .mk ¿À·ù°¡ ³ª¼ ¹ÌÄ¡°Ú³×¿ä
¿À¶óŬ ¼³Ä¡½Ã, ¸µÅ©ÀÛ¾÷Áß 65%Á¤µµ¿¡¼ ³ªÅ¸³ª´Â ¿¡·¯ 󸮹æ¹ýÀÔ´Ï´Ù.
****************************************************************
"Error invoking target install of makefile
/opt/oracle/product/9.0.1/plsql/lib/ins_plsql.mk"
"Error invoking target install of makefile
/opt/oracle/product/9.0.1/precomp/lib/ins-precomp.mk"
"Error invoking target install of makefile
/opt/oracle/product/9.0.1/precomp/lib/ins-net-client"
"Error invoking target install of makefile
/opt/oracle/product/9.0.1/precomp/lib/ins-oemagent"
****************************************************************
À§¿Í °°Àº ¿¡·¯¹ß»ý½Ã
1.
ORACLE_HOME/bin/genclntsh
ÆÄÀÏÀÇ
LD_SELF_CONTAINED="-z defs"
ÀÌ ºÎºÐÀ»
LD_SELF_CONTAINED=""
ÀÌ·¸°Ô ¼öÁ¤ÇÑ ´ÙÀ½
2.
ORACLE_HOME/bin/genclntsh
ÀÌ ½ºÅ©¸³Æ®¸¦
"oracle" À¯Àú·Î ½ÇÇà
su - oracle
ORACLE_HOME/bin/genclntsh
Created /opt/oracle/product/9.0.1/lib/libclntst9.a
3. ±×¸®°í ³ª¼ ¿¡·¯ Æ˾÷âÀÇ Àç½Ãµµ¸¦ ¼öÇàÇÕ´Ï´Ù.
##################################################################
Àúµµ À̹®Á¦ ¶§¹®¿¡ ¼¼¹øÀÇ ¸®´ª½º À缳ġ¿Í ¼¼¹øÀÇ ¿À¶óŬ À缳ġ¸¦ ½ÃµµÇØ º¸
¾Ò½À´Ï´Ù¸¸, ¸»Â¯ ²ÎÀ̾ú½À´Ï´Ù.
http://linux.oreillynet.com/lpt/a/4141
¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ.. 100% ¼³Ä¡µË´Ï´Ù.
ÀÌ»ó.
##################################################################
¹Ù¶÷°øÁÖ(miskorea24)
Ç÷¡½Ã,Æ÷Åä¼¥,php,asp,asp,ÀÚ¹Ù½ºÅ©¸³Æ®,¾×¼Ç,ű×,Ç÷¡½Ã,Æ÷Åä¼¥,php,asp,asp,ÀÚ¹Ù½ºÅ©¸³Æ®,¾×¼Ç,ű×
µ¡±Û ¾²±â
|
|
|
|
|
|