AIXË«»úÈȱ¸»·¾³Ï°²×°ORACLE10G - ͼÎÄ

Ë«»úÈȱ¸»·¾³AIXϰ²×°ORACLE10G

root.sh¡£´ò¿ªÒ»¸öеÄÖÕ¶Ë£¬ÓÃrootÓû§µÇ¼£¬Ö´ÐÐÕâ¸ö½Å±¾£¬ÕâÀï²»ÔÚ½éÉÜ¡£

µ±½Å±¾Ö´ÐÐÍê³Éºó£¬²¢Çҳɹ¦£¬¹Ø±ÕÕâ¸öдò¿ªµÄÖÕ¶Ë£¬»Øµ½°²×°Ò³Ã棬µã»÷¡°OK¡±°´Å¥£¬°²×°³ÌÐòÌáʾÄúϵͳ°²×°³É¹¦¡£

5 Ö÷»ú½¨¿â

±¾Õ½ÚÖ÷ÒªÊǽéÉÜΪoracle½¨Á¢Êý¾Ý¿â¹ý³Ì£¬´Ë²½ÖèÖ»ÔÚÖ÷»ú10.1.1.206ÉÏÖ´ÐУ¬×¢Òâ²»ÒªÔÚ±¸»ú10.1.1.208ÉÏÖ´ÐС£ 5.1 ÐÞ¸ÄBUG

ÔÚ´´½¨¿âǰÐèÒª×öÒ»¼þÊÂÇ飬ÓÉÓÚoracle10.2.0.3°æ±¾´æÔÚÒ»¸ö¹ØÓÚrawutlµÄBUG£¬ÎÒÃÇÐèÒªÐ޸ĴËÎÊÌ⣬ÓÃrootÓû§µÇ¼£¬²½ÖèÈçÏ£º #cd

/home/orastartup/Disk1/stage/components/oracle.has.common/10.2.0.1/1/DataFiles (˵Ã÷£º½øÈë10.2.0.1°²×°°üµÄDataFilesĿ¼£¬¾ÍÊÇÎÒÃǽâѹµÄ10gaix5l64.cpioĿ¼)

#ls -l (˵Ã÷£º²é¿´Ä¿Â¼ÏÂÎļþ£¬Äú¿ÉÒÔÕÒµ½ÓÐÒ»¸öfilegroup17.jarÎļþ) #mkdir filegroup17 (˵Ã÷£º´´½¨filegroup17Ŀ¼) #cd filegroup17 (˵Ã÷£º½øÈëfilegroup17Ŀ¼)

#jar -xvf ../filegroup17.jar (˵Ã÷£º½âѹfilegroup17.jarÎļþ) #mv $ORACLE_HOME/bin/rawutl $ORACLE_HOME/bin/rawutl.bak (˵Ã÷£º±¸·ÝÔ­²»ºÃʹµÄrawutlÎļþ)

#cp rawutl $ORACLE_HOME /bin/rawutl (˵Ã÷£º°Ñ½âѹµÄ°ü¿½±´¹ýÈ¥) #chmod +x $ORACLE_HOME/bin/rawutl (˵Ã÷£ºÎªÎļþ¸³Óè¶ÁдȨÏÞ) ÒÔÉϹ¤×÷Íê³Éºó£¬ÎÒÃǾͿÉÒÔÄܹýdbca´´½¨¿âÁË¡£

16

Ë«»úÈȱ¸»·¾³AIXϰ²×°ORACLE10G

5.2 ´´½¨¿â

»Øµ½µÚÒ»´Î´ò¿ªµÄÖÕ¶Ë£¨oracleÓû§ÄǸö£©£¬ÊäÈëÈçÏÂÃüÁ $dbca (˵Ã÷£º´ò¿ªdbca¹ÜÀíÒ³Ãæ)

ÊäÈëºó£¬ÏµÍ³»áµ¯³ödbca¹ÜÀíÒ³Ãæ£¬ÔÚÅäÖùý³ÌÖÐÐèҪעÒâµÄÊÇÒÔϼ¸µã£º 1¡¢ ÔÚDatabase IdentificationÒ³ÖУ¬Global Database NameÏîÊäÈë¡°orcl¡±¡£ 2¡¢ ÔÚManagement OptionsÒ³ÖУ¬È¡Ïû¡°configure the Database with Enterprise

Manager¡±Ïî¡£

3¡¢ ÔÚStorage OptionsÒ³ÖУ¬Ñ¡Ôñ¡°Raw Devices¡±ÏÆä×ÓÏîSpecify Raw

Devices Mapping File»á×Ô¶¯´ÓÉèÖõĻ·¾³±äÁ¿ÖлñÈ¡²ÎÊý£º /home/oracle/app/dbca_raw_config.txt;

4¡¢ ÔÚRecovery ConfigurationÒ³ÖУ¬È¡Ïû¡°Specify Flash Recovery Area¡±

Ïî¡£

5¡¢ ÔÚInitiallzation ParametersÒ³ÖУ¬¡°Sizing¡±²Ëµ¥ÏîÖÐÅäÖÃProcessesֵΪ

500

6¡¢ ÔÚInitiallzation ParametersÒ³ÖУ¬ ¡°Character Sets¡±²Ëµ¥ÏîÖÐÑ¡¶¨¡°Choose

from the list of character sets¡±ÏÔÚÆä×ÓÏîDatabase Character SetÖÐÑ¡Ôñ¡°ZHS16GBK ¨C GBK 16 - bit Simplified Chinese¡±(×Ö·û¼¯)

7¡¢ ÔÚInitiallzation ParametersÒ³ÖУ¬¡°Parmeter File¡±²Ëµ¥ÏîÖÐÑ¡¶¨¡°Create

server parameter file(SPFILE)¡±ÏÆä×ÓÏî¡°Server Parameter Filename¡±»á×Ô¶¯ÅäÖÃΪ/dev/rorcl_spfile¡£

8¡¢ ÔÚCreation OptionsÒ³ÖУ¬Ñ¡¶¨¡°Create Database¡±Ïî¡£

ÉÏǰÅäÖÃÍê³Éºó£¬ÏµÍ³¿ªÊ¼´´½¨Êý¾Ý¿â£¬Èç¹ûûÓÐÅäÖôíÎó£¬ÏµÍ³»áÌáʾ´´

17

Ë«»úÈȱ¸»·¾³AIXϰ²×°ORACLE10G

½¨³É¹¦£¬Èç¹ûÓÐÒì³£·¢Éú£¬Çë×ÔÐд¦Àí¡£ 5.3 ´´½¨¼àÌý

µ±Êý¾Ý¿â´´½¨Íê³Éºó£¬ÎÒÃÇÐèÒª´´½¨Ò»¸ö¼àÌý£¬ÓÃÖÕ¶Ë£¨oracleÓû§ÄǸö£©ÊäÈëÈçÏÂÃüÁ

$netca (˵Ã÷£ºÆô¶¯ÍøÂçÅäÖóÌÐò)

ÊäÈëºó£¬ÏµÍ³»áµ¯³önetca¹ÜÀíÒ³Ãæ£¬ÔÚÅäÖùý³ÌÖÐÐèҪעÒâµÄÊÇÒÔϼ¸µã£º 1¡¢ Ñ¡Ôñ¡°Listener configuration¡±Ïî¡£ 2¡¢ Ñ¡Ôñ¡°Add¡±Ï´´½¨Ò»¸öеļàÌý¡£ 3¡¢ Listener name ÏîĬÈϼ´¿É¡£ 4¡¢ ЭÒéÑ¡Ôñ¡°TCP¡±¡£ 5¡¢ ¶Ë¿ÚĬÈÏʹÓá°1521¡±¡£

ÉÏǰÅäÖÃÍê³Éºó£¬ÏµÍ³¿ªÊ¼´´½¨¼àÌý£¬Èç¹ûûÓÐÅäÖôíÎó£¬ÏµÍ³»áÌáʾ´´½¨³É¹¦£¬Èç¹ûÓÐÒì³£·¢Éú£¬Çë×ÔÐд¦Àí¡£ 5.4 ´´½¨ÍøÂç·þÎñÃû

¼àÌý´´½¨³É¹¦ºó£¬ÎÒÃÇÐèÒª´´½¨ÍøÂç·þÎñÃû£¬»¹ÊÇÔڸղŵÄnetca³ÌÐòÒ³ÃæÉÏ£¬²½ÖèÈçÏ£º

1¡¢ Ñ¡Ôñ¡°Local Net Service Name configuration¡±Ïî¡£ 2¡¢ Ñ¡Ôñ¡°Add¡±Ï´´½¨ÍøÂç·þÎñÃû¡£ 3¡¢ Service Name ÏîÊäÈë¡°orcl¡±¡£ 4¡¢ ЭÒéÑ¡Ôñ¡°TCP¡±¡£

5¡¢ Host name ÏîÊäÈëÄúÖ÷»úÃû³Æ£¬Èç¡°aixdb1¡±¡£

ÉÏǰÅäÖÃÍê³Éºó£¬ÏµÍ³¿ªÊ¼´´½¨ÍøÂç·þÎñÃû£¬Èç¹ûûÓÐÅäÖôíÎó£¬ÏµÍ³»áÌáʾ´´½¨³É¹¦£¬Èç¹ûÓÐÒì³£·¢Éú£¬Çë×ÔÐд¦Àí¡£

18

Ë«»úÈȱ¸»·¾³AIXϰ²×°ORACLE10G

5.5 Êý¾Ý¿â¼ì²â

µ±¿â¡¢¼àÌý¡¢ÍøÂç·þÎñÃûÈ«²¿´´½¨Íê³Éºó£¬ÎÒÃÇÐèÒª½øÐвâÊÔ£¬¼ì²éÊý¾Ý¿âÊÇ·ñÕý³££¬Í¨¹ýoracleÓû§µÇ¼¿ØÖÆÌ¨£¬ÊäÈëÈçÏÂÃüÁî²âÊÔ£º 1¡¢ $sqlplus /nolog

2¡¢ SQL>conn / as sysdba

3¡¢ SQL>select * from Tabs;(˵Ã÷£ºÈç¹ûϵͳ²éѯµ½ÏµÍ³±í£¬ËµÃ÷Êý¾Ý¿â³É¹¦)

4¡¢ SQL>conn system/system£¨ËµÃ÷£ºÈç¹ûµÇ¼Õý³££¬ËµÃ÷systemÓû§Õý³££© Èç¹ûÉÏÃæµÄÃüÁî½á¹ûÕý³££¬ËµÃ÷¿âÕý³£¡£ 5¡¢ SQL>exit (˵Ã÷£ºÍ˳öÊý¾Ý¿â)

6¡¢ $ lsnrctl start (˵Ã÷£ºÆô¶¯¼àÌý£¬Èç¹ûϵͳÌáʾÕý³££¬ËµÃ÷¼àÌý´´½¨³É¹¦)

5.6 ¹Ø±ÕÊý¾Ý¿âºÍ¼àÌý

Êý¾Ý¿â¼ì²âÍê³Éºó£¬ÎÒÃÇÐèÒª¹Ø±ÕÊý¾Ý¿â£¬ÃüÁîÈçÏ£º 1¡¢ $sqlplus /nolog

2¡¢ SQL>conn / as sysdba

3¡¢ SQL>shutdown immediate £¨ËµÃ÷£º¹Ø±ÕÊý¾Ý¿â£© 4¡¢ SQL>exit £¨ËµÃ÷£ºÍ˳öÊý¾Ý¿â£© 5¡¢ $lsnrctl stop (˵Ã÷£º¹Ø±Õ¼àÌý)

6 ±¸»ú½¨¿â

±¾Õ½ÚÖ÷ÒªÊǽéÉÜΪ±¸»ú½¨Á¢¿â¡¢¼àÌýºÍÍøÂç·þÎñÃû£¬ÓëÖ÷»ú²»Í¬´¦ÔÚÓÚ£¬ÎÒÃÇÖ»ÐèÒª°ÑÖ÷»ú½¨ºÃµÄÅäÖÃĿ¼¿½±´µ½±¸»úÉÏ£¬Ð޸IJ¿·ÖÎļþ²ÎÊý¼´¿É¡£

19

ÁªÏµ¿Í·þ£º779662525#qq.com(#Ìæ»»Îª@)