Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÍêÈ«Ð¶ÔØOracle·½·¨

 
ÍêÈ«Ð¶ÔØOracle·½·¨£º
Èí¼þ»·¾³£º
1¡¢Windows XP + Oracle 10g
2¡¢Oracle°²×°Â·¾¶Îª£ºd:\Oracle
1¡¢Èç¹ûÊý¾Ý¿âÅäÖÃÁË×Ô¶¯´æ´¢¹ÜÀí(ASM),Ó¦¸ÃÏÈɾ³ý¾Û¼¯Í¬²½·þÎñCSS£¨cluster Synchronization Services).ɾ³ýCSS·þÎñµÄ·½·¨ÊÇÔÚDOSÃüÁîÐÐÖÐÖ´ÐÐÈçÏÂÃüÁ localconfig delete
2¡¢ÔÚ“·þÎñ”´°¿ÚÖÐÍ£Ö¹OracleµÄËùÓзþÎñ¡£
3¡¢ÔÚ“¿ªÊ¼”²Ëµ¥ÖÐÒÀ´ÎÑ¡Ôñ“³ÌÐò”/“Oracle-OraDb10g_home1"/"Oracle Installation Products”/"Universal Installer"£¬´ò¿ªOracle Universal Installer(OUI)´°¿Ú
4¡¢µ¥»÷“Ð¶ÔØ²úÆ·”°´Å¥£¬´ò¿ª“²úÆ·Çåµ¥”´°¿Ú£¬Ñ¡ÖÐҪɾ³ýµÄOracle²úÆ·£¬µ¥»÷“ɾ³ý”°´Å¥£¬´ò¿ª“È·ÈÏɾ³ý”¶Ô»°¿ò¡£
5¡¢ÔÚ“È·ÈÏɾ³ý”¶Ô»°¿òÖе¥»÷“ÊÇ”°´Å¥£¬¿ªÊ¼É¾³ýÑ¡ÔñµÄOracle²úÆ·¡£
6¡¢É¾³ý×Ô¶¯´æ´¢¹ÜÀí£¨ASM),ÔÚDOSÃüÁîÐÐÖÐÖ´ÐÐÈçÏÂÃüÁoracle -delete -asmsid +asm
7¡¢ÔËÐÐregeditÃüÁ´ò¿ª×¢²á±í´°¿Ú¡£É¾³ý×¢²á±íÖÐÓëOracleÏà¹ØµÄÄÚÈÝ£¬¾ßÌåÈçÏ£º
       1¡¢É¾³ýHKEY_LOCAL_MACHINE/SOFTWARE/ORACLEĿ¼¡£
        2¡¢É¾³ýHKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/ServicesÖÐËùÓÐÒÔoracle»òOraWebΪ¿ªÍ·µÄ¼ü¡£
        3¡¢É¾³ýHKEY_LOCAL_MACHINE/SYSETM/CurrentControlSet/Services/Eventlog/applicationÖÐËùÓÐÒÔoracle¿ªÍ·µÄ¼ü¡£
        4¡¢É¾³ýHKEY_CLASSES_ROOTĿ¼ÏÂËùÓÐÒÔOra¡¢Oracle¡¢Orcl»òEnumOraΪǰ׺µÄ¼ü¡£
        5¡¢É¾³ýHKEY_CURRENT_USER/SOFTWARE/Microsoft/windows/CurrentVersion/Explorer/MenuOrder/Start Menu/ProgramsÖÐËùÓÐÒÔoracle ¿ªÍ·µÄ¼ü¡£
        6¡¢É¾³ýHKDY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INIÖгýMicrosoft ODBC for Oracle×¢²á±í¼üÒÔÍâµÄËùÓк¬ÓÐOracleµÄ¼ü¡£
ÆäÖÐÓÐЩע²á±íÏî¿ÉÄÜÒѾ­ÔÚÐ¶ÔØOracle²úƷʱ±»É¾³ý¡£
8¡¢É¾³ý»·¾³±äÁ¿ÖеÄPATHT CLASSPATHÖаüº¬OracleµÄÖµ¡£
9¡¢É¾³ý“¿ªÊ¼”/“³ÌÐò”ÖÐËùÓÐOracleµÄ×éºÍͼ±ê¡£
10¡¢É¾³ýËùÓÐÓëOracleÏà¹ØµÄĿ¼£¬°üÀ¨£º
       


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

hpux+slvm+mc/sg+oracle 10g racʵʩÊÖ²á

 Ó²¼þ»·¾³:hp rx2660*2+hp eva4400
Èí¼þ»·¾³:hpux 11.23,oracle 10g for hpux,oracle clusterware,mc/serviguard 11.18
1.°²×°HPUX
2.´ò²¹¶¡,²ÎÕÕÎĵµ¼´¿É,»ò´òµ½magepatch dec.12.07ÒÔºóÒ²¿ÉÒÔ
3.°²×°mc/sg+SGeRAC(hp MC/ServiceguardΪÅäºÏoracle racËùʹÓõÄÄ£¿é)
4.¹æ»®´æ´¢
lock vg:1G
rac:100G
5.ÐÞ¸ÄÄÚ ......

½âÎöoracleµÄrownum

¶ÔÓÚrownumÀ´ËµËüÊÇoracleϵͳ˳Ðò·ÖÅäΪ´Ó²éѯ·µ»ØµÄÐеıàºÅ£¬·µ»ØµÄµÚÒ»ÐзÖÅäµÄÊÇ1£¬µÚ¶þÐÐÊÇ2£¬ÒÀ´ËÀàÍÆ£¬Õâ¸öα×ֶοÉÒÔÓÃÓÚÏÞÖÆ²éѯ·µ»ØµÄ×ÜÐÐÊý£¬¶øÇÒrownum²»ÄÜÒÔÈκαíµÄÃû³Æ×÷Ϊǰ׺¡£
¾ÙÀý˵Ã÷£º
ÀýÈç±í£ºstudent(ѧÉú)±í£¬±í½á¹¹Îª£º
ID¡¡¡¡¡¡    char(6)¡¡¡¡¡¡¡¡¡¡ --ѧºÅ
name¡¡¡¡¡¡¡¡VA ......

OracleµÄ³õʼ»¯²ÎÊýÎļþ

     oracleʵÀýÆô¶¯Ê±¶ÁÈ¡pfile²ÎÊýÎļþ£¬ÐÞ¸Äpfile³õʼ»¯²ÎÊýÎļþºó£¬±ØÐëÖØÐÂÆô¶¯ÊµÀý²ÅÄÜÉúЧ¡£ 
     pfile²ÎÊýÎļþÓëspfile²ÎÊýÎļþ¶¼ÊÇÓÃÀ´´æ·Å³õʼ»¯²ÎÊýµÄÎïÀíÎļþ£¬pfileÒÔÎı¾ÎļþµÄÐÎʽ´æ´¢£¬ÓŵãÊÇÒ×Óڲ鿴ÓëÐ޸ģ»spfileÒÔ¶þ½øÖƵÄÐÎʽ´æ´¢£¬ËäÈ»ÄÜʵÏÖÒÔʵÀ ......

oracle £º´æ´¢¹ý³ÌºÍº¯ÊýµÄ¼¸ÖÖд·¨

¹ØÓÚ´æ´¢¹ý³ÌºÍº¯ÊýµÄ¶¨ÒåÍøÉÏÒ»ËÑÒ»´ó°Ñ£¬ÕâÀï¾Í²»ÌØÊâ½éÉÜÁË£¬ÕâÀï¾ÍÖ»¶ÔÎÒ×Ô¼ºÐ´µÄ¼¸ÖÖ¸ñʽµÄ´æ´¢¹ý³ÌºÍº¯Êý×öһЩ×ܽᣬϣÍû¶Ô´ó¼ÒÓеã°ïÖú¡£
 Ò»£º´æ´¢¹ý³Ì
  
1£º×îÆÕͨµÄÒ»ÖÖ¡££¨´«²Î£¬²éѯÓαִ꣬ÐУ¬Ñ­»·Óαê×ö²åÈ붯×÷£©¡£
create or replace procedure zy2040_sirole(rolekey in varchar2) ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ