Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2003/08/05(11:33) from 211.169.72.154 | |
ÀÛ¼ºÀÚ : °ÁÙ±â (jkkang65@hanmail.net) | Á¶È¸¼ö : 4872 , ÁÙ¼ö : 129 |
[Oracle/Install] ¿À¶óŬ 9i(9.2.0) ÀνºÅçÇϱâ in AIX 5.1 (ÀÛ¼ºÁß) |
---|
* ½ÇÇàȯ°æ @ Console¿¡¼ ÀνºÅç ÇÒ¼ö ÀÖ´Ù. @ Console¾Õ¿¡¼ ÇÒ¼ö ¾ø´Ù¸é ³ªÃ³·³ PC¿¡¼ XManager·Î Remote LoginÇؼ ¼³Ä¡°¡ °¡´ÉÇÏ´Ù. 1. »çÀü ¼³Ä¡ ÀÛ¾÷ (1). Tasks to Perform as the root user Create a Group and User group »ý¼º : oinstall, dba user »ý¼º : oracle (Primary group : oinstall, Secondary group : dba) OracleÀ» ¼³Ä¡ÇÒ File System /oracle 4GB ÀÌ»ó »ý¼º Oracle ¼³Ä¡¸¦ À§ÇÑ /tmp 400MB ÀÌ»ó È®º¸ AIX 5L release 5.1 ML01+ (IY22854), IY26778, IY28766, IY28949, IY29965, IY30150 http://techsupport.services.ibm.com/server/fixes Java 1.3.1ÀÌ»ó ¼³Ä¡ ´ÙÀ½°ú °°ÀÌ ¿À¶óŬ(oracle user) Home Directory ¼³Á¤ # mkdir -p /oracle/app/oracle/product/9.2.0.1.0 # chown -R oracle:oinstall /oracle (2). Tasks to Perform as the oracle user Set Environment Variables DISPLAY=workstation_name:0.0 PATH=$ORACLE_HOME/bin:/usr/ccs/bin:$PATH ORACLE_HOME=/oracle/app/oracle/product/9.2.0.1.0 NLS_LANG=AMERICAN_AMERICA.KO16KSC5601 ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data ORACLE_SID=jkkang À§ÀÇ È¯°æº¯¼ö¸¦ oracle userÀÇ .profile¿¡ Ãß°¡ÇÑ´Ù À§ ȯ°æº¯¼öÁß ±½°Ô Ç¥½ÃµÈ ºÎºÐÀº ÇʼöÀûÀÌ°í, ³ª¸ÓÁö´Â »ý·«À» Çصµ ¹«³ÇÏ´Ù. 2. # smitty aio ¹®Á¦ ¹ß»ý½Ã aio ¼³Á¤Àº ¸¹Àº ¿ÜÀå µð½ºÅ©¸¦ »ç¿ëÇϴ ȯ°æ¿¡¼ ÇʼöÀûÀÌ´Ù. À̸¦ ¼³Á¤ÇÔÀ¸·Î½á I/O ¼º´ÉÀ» Áõ°¡½Ãų¼ö ÀÖ´Ù. min server # : 10 max server # : 20 STATE to be configured at system restart defined + State of fast path enable + minÀº maxÀÇ 1/2ÀÌ´Ù. º¸Åë transactionÀÌ ¸¹Àº °æ¿ì´Â 100,200 Á¤µµ·Î ¸ÂÃçÁØ´Ù. # pstat -a |grep aio Çؼ processÀÇ °¹¼ö È®ÀÎ ÇÊ¿ä ¼³Á¤º¯°æ½Ã ¹Ýµå½Ã Rebooting, ÁÖÀÇ»çÇ×: # export LANG=en_US °ú°°ÀÌ LANGÀÌ ¼³Á¤µÇ¾î ÀÖ¾î¾ß ÇÑ´Ù. ±× ÀÌÀ¯´Â OracleÀ» ¼³Ä¡ÇϱâÀü¿¡ ShellÀÌ È¯°æ°Ë»ç¸¦ Çϴµ¥, ¿µ¹®¸ðµå·Î °Ë»çÇϱ⠶§¹®ÀÌ´Ù. 3. Mount Oracle 9i CD-ROM Oracle CD¸¦ »ç¿ëÇϱâÀ§Çؼ´Â ¸Þ´º¾ó·Î mount¸¦ ÇØÁà¾ß ÇÑ´Ù. 2¹ø¾¾µð¸¦ ³ÖÀ¸¶ó°í ³ª¿Ã¶§µµ umount; mount¸¦ ¸Þ´º¾ó·Î ÇØÁà¾ß ÇÑ´Ù. 4. Run the rootpre.sh Script $ su - root # cd /cdrom # ./rootpre.sh # exit 5. Start Oracle Universal Installer in CDE Login oracle user ( # id -> oracle ) $ id uid=203(oracle) gid=204(oinstall) groups=205(dba) $ /cdrom/runInstaller ÇßÀ»¶§, 'y' * ¸î¹ø À߸ø ½ÇÇà½ÃÄѼ ´Ù½Ã ½ÇÇà½Ãų¶§, /tmp/OraInstall0 .... : Bad File number ¿¡·¯¸Þ½ÃÁö°¡ ¶ß¸é, # cd /tmp # rm -r OraInstall* ÈÄ, Àç½ÇÇà @ Standard Edition ¼±Åà - General Purpose ¼±Åà - Global Database Name/SID ÀÔ·Â - Java131 Home Dir ÀÔ·Â(/usr/Java131) - ´ÙÀ½ ´ÙÀ½ 6. Áß°£Áß°£¿¡ root ±ÇÇÑÀ¸·Î ¸Þ½ÃÁö¿¡ ¶ß´Â ShellÀ» ½ÇÇà½ÃÄÑÁØ´Ù. 7. Oracle ¼³Ä¡°¡ ³¡³ª°í Ãß°¡·Î Pro*C¸¦ ¼³Ä¡ÇÒ¼ö ÀÖ´Ù. (Custom ¿É¼Ç »ç¿ë) Pro*C´Â Oracle CD #1¹ø¿¡ µé¾îÀÖ´Ù. 8. ¼³Ä¡¿Ï·á 9. Oracle Startup Oracle 9i·Î ³Ñ¾î¿À¸é¼ ±âÁ¸¿¡ »ç¿ëÇÏ´ø svrmgrlÀÌ ¾÷¾îÁö°í ´ÙÀ½°ú °°ÀÌ ½ÃÀÛ/Á¾·á¸¦ ÇÒ¼ö ÀÖ´Ù. $ sqlplus /nolog SQL> connect system/xxxxxx as sysdba Connected to an idle instance. SQL> startup ORACLE instance started. 10. Oracle Shutdown $ sqlplus /nolog SQL> connect system/xxxxxx as sysdba SQL> shutdown immediate $ ps -ef|grep ora_ |