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

OracleµÄÐ¶ÔØ·½·¨

   ֮ǰ¸ø´ó¼Ò½éÉÜÁËÔÚWIN7ÉÏOracle 10gµÄ°²×°·½·¨£¬½ÓÏÂÀ´¾Í¸Ã¸ø´ó¼Ò½éÉÜËüµÄÐ¶ÔØ·½·¨ÁË¡£ºÜ¶àÈ˲»¸Ò°²×°Oracle¾ÍÊǵ£Ðݲװºó»áÐ¶ÔØ²»¸É¾»£¬Æäʵµ±³õÎÒÒ²ÓйýÕâ¸ö¹ËÂÇ£¬ºÇºÇ¡£µ«ºóÀ´·¢ÏÖ£¬ÆäÊµÐ¶ÔØÊǺÜÈÝÒ×µÄÊ¡£¾Í¼¸²½¶øÒÑ£¬²»ÐžÍÇë¿´£º
 
¿ÉÒÔʹÓòúÆ·×Ô´øµÄÐ¶ÔØ¹¤¾ßÈ¥Ð¶ÔØ¡£
1£®    °´ÕÕ²½ÖèÖ´ÐУº¿ªÊ¼→³ÌÐò→Oracle→Oracle - OraDb10g_home1→Oracle Installation Products→Universal Installer½øÐвÙ×÷¡£µ¥»÷Ð¶ÔØ²úÆ·°´Å¥£¬½øÈëÒѰ²×°²úÆ·½çÃæ¡£Ò»´Î¿ÉÒÔÐ¶ÔØÈ«²¿²úÆ·£¬Ò²¿ÉÒÔÖ»Ð¶ÔØ²¿·Ö²úÆ·¡£½¨Òéµ±¼ÆËã»úϵͳ×ÊÔ´£¬ÓÈÆäÊÇÄÚ´æ²»ÊÇ×ã¹»´óʱ£¬²»ÒªÒ»´ÎÐ¶ÔØÈ«²¿²úÆ·£¬·ñÔòÐ¶ÔØËٶȺÜÂý»òÕß²»Äܳɹ¦Ð¶ÔØ¡£ÕâµãµÃÌØ±ð×¢ÒâÁË£¬×îºÃÏÈÐ¶ÔØ¿Í»§¶ËÈ»ºóÔÙÐ¶ÔØ·þÎñÆ÷¡£ÄÍÐĵȴý½ø¶ÈÌõ´ïµ½100%£¬Ð¶ÔØÍê±Ïºó£¬ÔÚ“InventoryĿ¼”ÖУ¬Ìáʾδ°²×°µÄ²úÆ·£¬²¢ÇÒOracleÑ¡ÏîÔÚ“³ÌÐò”²Ëµ¥ÖÐÏûʧÁË¡£
2£®    °Ñ×¢²á±íÖÐËùÓÐOracleÈë¿Úɾ³ý¡£Ò»¸ö¶¼²»ÄÜÁôÏ£¬·ñÔò¾ÍÓпÉÄÜÔì³ÉÐ¶ÔØ²»¸É¾»£¡
°´ÕÕ²½ÖèÖ´ÐУº¿ªÊ¼→¸½¼þ→ÔËÐУ¬´ò¿ª“ÔËÐД½çÃæ¡£ÔÚ“´ò¿ª”Îı¾¿òÖÐÊäÈë“regedit”£¬
µ¥»÷“È·¶¨”°´Å¥£¬“½øÈë×¢²á±í±à¼­Æ÷”½çÃæ¡£
°Ñ“HKEY_LOCAL_MACHINE\SYSTEM\CURRENTCONTROLSET\SERVIES”ϵÄËùÓÐOracleÈë¿Úɾ³ý¡£¹²ÓÐ5¸ö£¨OracleDBConsoleXSCJ£¬OracleJobSchedulerXSCJ£¬OracleOraDb10g_home1iSQL*Plus£¬OracleOraDb10g_home1TNSListener£¬OracleServiceXSCJ£©¡£
°Ñ“HKEY_LOCAL_MACHINE\SYSTEM\CURRENTCONTROLSET\SERVIES\EVENTLOG\APPLICATION”ϵÄËùÓÐOracleÈë¿Úɾ³ý¡£¹²ÓÐ3¸ö£¨Oracle.xscj£¬OracleDBConsoleXSCJ£¬OracleOraDb10g_home1iSQL*Plus£©¡£
3. ɾ³ýËùÓÐOracleĿ¼¡£°Ñ°²×°Â·¾¶ÏºͲÙ×÷ϵͳĿ¼ÏµÄOracleĿ¼ɾ³ý£¬Õâʱ²¢²»ÄÜÍêȫɾ³ý£»ÖØÐÂÆô¶¯¼ÆËã»úºó£¬²ÅÄÜÍêȫɾ³ýOracleĿ¼¡£
 
ÖÁ´Ë£¬Oracle ²ÅÍêȫɾ³ý£¡×îºó£¬×£´ó¼ÒºÃÔË£¬Í¬Ã㣡


Ïà¹ØÎĵµ£º

oracle ¿ª·¢Éè¼ÆÒ»Ð©¹æ·¶¾­Ñé

1 Éè¼Æ±í¹ý³ÌÖÐ ¾¡Á¿²ÉÓÃÊý¾ÝÇý¶¯Ë¼Ïë
    ±ÈÈç˵Óû§×¢²á ÒòΪҵÎñÇé¿ö ÐèÒª4¸ö×ֶβ»Í¬×éºÏÀ´±íʾÓû§´ÓÄÄÀï×¢²áµÄ¡£ ÒµÎñ²¿ÐèÒª²»¶ÏÀ©Õ¹ÐµÄÇþµÀÀ´ÕÐÀ¿Óû§£¬±ÈÈçÔÚij¸öÍøÕ¾×öÁË¹ã¸æ¡£¶ø²»ÄÜÔÚÒµÎñ³ÌÐò»ò´æ´¢¹ý³ÌÖ±½ÓÐÞ¸Ä
  update f_userinfo
   set   f_regchannel='ÐÂÀËÊ ......

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨3£©£º´´½¨OracleÊý¾Ý¿â£¨1£©

¸Ð¾õÕâ¸ö»¹ÊÇ·Ö¿ªÐ´ºÃÁË£¬Êý¾Ý¿âµÄ´´½¨¹¤×÷£¬Ô­ÒÔΪºÃÈÝÒ×¾ÍÊÇÏÂÒ»²½ÏÂÒ»²½µÄÎÊÌ⣬ԭÀ´ÀïÃæµÄÄÚÈÝ»¹ÊǺܶàµÄ£¬°üÀ¨Ìåϵ½á¹¹ÒªÁ˽âһЩ£¬DBCA½¨¿âÊÇÈÝÒ×À­£¬²»¹ýÒª»áÊÖ¶¯½¨¿âÄDzŽпáÂÄøö½çÃæµãÏÂÒ»²½ÏÂÒ»²½Ë­²»»á°¡£¬ÄÇ»¹½ÐDBA°¡£¿ºÇºÇ¡£
Oracle·þÎñÆ÷ÓÉÏÂÁÐÁ½¸öʵÌå×é³É£ºÊµÀý£¨Instance£©ÓëÊý¾Ý¿â¡£ÊµÀýÓÉ´æ´¢½á¹¹º ......

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨3£©£º´´½¨OracleÊý¾Ý¿â£¨3£©

ÊÖ¶¯½¨¿âÆäʵҲ¿ÉÒÔ·ÖΪÁ½ÖÖ£¬Ò»ÖÖÊDz»Ê¹ÓÃOMF´´½¨£¬ÁíÒ»ÖÖÊÇʹÓÃOMF´´½¨¡£
Ò»¡¢²»Ê¹ÓÃOMFÊÖ¶¯´´½¨Êý¾Ý¿â
1¡¢´´½¨Îļþ¼Ð¡££¨¸ù¾Ý¸Õ²Å/ora01/db/oracle/admin/ocpÖеÄĿ¼£¬ÎÒÃÇҲͬÑù´´½¨£©
?[Copy to clipboard]View Code BASH
$ mkdir /ora01/db/oracle/admin/mydb
$ cd /ora01/db/oracle/admin/mydb
$ mkdir bdum ......

ORACLEÈëÃÅÊé¼®ÍÆ¼ö


OracleÈëÃÅÊé¼®ÍÆ¼ö
ºÜ¶àÅóÓÑÒªÎÒ°ïÃ¦ÍÆ¼öÒ»ÏÂOracleµÄÈëÃÅÊé¼®£¬Äܹ»Á˽âOracleµÄ»ù±¾¸ÅÄî¡¢»ù±¾ÖªÊ¶µÄÄÇÖÖ¡£
ÎÒ¾ÍÃâΪÆäÄÑ£¬ÍƼö¼¸±¾¡£
Ê×ÏÈÎÒÏëÇ¿µ÷µÄÒ»µãÊÇ£¬ÈκÎÒ»±¾ÏµÍ³µÄOracleÊé¼®Ö»ÒªÈÏÕæ¶ÁÏÂÀ´£¬¶¼»áÓв»´íµÄÊÕ»ñ£¬¶ÁÊé×î¼É»äµÄÊÇ»¢Í·Éßβ£¬Ç³³¢ÔòÖ¹¡£
1.µÚÒ»±¾ÒªÍƼö¸ø´ó¼ÒµÄÊÇOracleµÄ¸ÅÄîÊֲᣬÕâ±¾ÊÖ²á ......

oracle clob ºÍblobÎÊÌâµÄ½â¾ö

oracle clob ºÍblobÎÊÌâµÄ½â¾ö
 
ÕûÀíÁËoracle clob ºÍblobÎÊÌâµÄ½â¾ö°ì·¨£º
1£º½¨ÒéʹÓÃoracle 10µÄojdbc14.jar,·ñÔòµ±±£´æclobµÄʱºò¿ÉÄÜ»á³öÏÖÌ×½Ó×Ö´íÎó£» 
2£ºspringÅäÖÃÈçÏ£º 
java´úÂë: 
        <bean id="sessionFact ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ