ASP.NETÅäÖÃOracleµÄÏà¹ØËµÃ÷
² Oracle9iµÄ°²×°£¬Çë²ÎÕÕ¹Ù·½µÄ°²×°ËµÃ÷¡£
² Oracle9i°²×°³É¹¦ÒÔºó£¬Ê¹ÓùÜÀíÔ±£¨Óû§Ãû£ºsys¡¢ÃÜÂ룺sys£©µÄÉí·ÝµÇ¼½øÈ¥£¬´´½¨Ò»¸öÓû§ddymis£¬ÃÜÂ룺ddymis,½ÇɫĬÈϸ³Óèdba¡£
² Oracle9i°²×°³É¹¦ÒԺ󣬾ßÌåµÄȨÏÞÉèÖÃÈçÏ£º
1. ÒÔAdministratorȨÏ޵ǼWindows.
2. Æô¶¯Window ×ÊÔ´ä¯ÀÀÆ÷ÕÒµ½ORACLE_HOMEĿ¼£¬ÈçC:\Oracle\ora92
3. ÓÒ¼üµ¯³ö²Ëµ¥£¬Ñ¡Ôñ¸ÃĿ¼¹²ÏíÓ밲ȫ£¨Win2000ÏÂÒªµã»÷ÊôÐÔ£©
4. µã»÷ “°²È«” ҳǩ
5. ÔÚ×éºÍÓû§Ãû³ÆÁбíÖеã»÷“Authenticated Users” Ïî.
6. ÔÚ¸ÃÓû§µÄȨÏÞÁбíÖУ¬½«“¶ÁÈ¡ºÍÔËÐДµÄÑ¡Ôñ¿òÖÃΪ²»Ñ¡ÖÐ״̬
7. Ôٴεã»÷“¶ÁÈ¡ºÍÔËÐДµÄÑ¡Ôñ¿ò£¬½«ÆäÉèÖÃΪѡÖÐ״̬
8. µã»÷“¸ß¼¶”°´Å¥²¢ÔÚȨÏÞÏîÄ¿ÖÐÈ·¶¨“Authenticated Users” ÊÇ·ñÓµÓГ¶ÁÈ¡²¢ÔËÐДȨÏÞ²¢Ó¦ÓÃÓÚ“¸ÃÎļþ¼Ð£¬¼°×ÓÎļþ¼ÐºÍÎļþ”. Èç¹û²»ÊÇ£¬Ë«»÷ÕâÑù£¬²¢È·±£È¨ÏÞ¿ÉÒÔ“Ó¦ÓÃÓÚ” “¸ÃÎļþ¼Ð£¬¼°×ÓÎļþ¼ÐºÍÎļþ”. ¸ÃÏî·Ç³£ÖØÒªÄãÒ»¶¨ÒªºË²é.
9. µã»÷“È·¶¨” °´Å¥
10. Windows.ÖØÆô¶¯, ÒÔʹµÃËùÓеÄÐÞ¸ÄÉúЧ.
Ïà¹ØÎĵµ£º
¡¾IT168¼¼ÊõÎĵµ¡¿
DATA GUARDµÄ×îÖ÷ÒªµÄ¹¦ÄÜÊÇÈßÔÖ¡£µ±È»¸ù¾ÝÅäÖõIJ»Í¬£¬DATA GUARD»¹¿ÉÒԾ߱¸ÒÔÏÂÌØµã£º¸ß¿ÉÓá¢ÐÔÄÜÌáÉý¡¢Êý¾Ý±£»¤ÒÔ¼°¹ÊÕϻָ´µÈ¡£
DATA GUARD¿ÉÒÔ·ÖΪÎïÀíSTANDBYºÍÂß¼STANDBYÁ½ÖÖ¡£¶þÕßµÄ×î´ó²î±ðÔÚÓÚ£¬ÎïÀíSTANDBYÓ¦ÓõÄÊÇÖ÷¿âµÄ¹éµµÈÕÖ¾£¬¶øÂ ......
OracleϵÁУºÍ¼Æ¬µÄ´æ´¢
Ò»£ºÊ²Ã´ÊÇ´ó¶ÔÏ󣬴ó¶ÔÏó»ù±¾²Ù×÷£¿
²Î¼ûÎÒµÄBLOG£ºOracleϵÁУºLOB´ó¶ÔÏó´¦Àí
http://blog.csdn.net/qfs_v/archive/2008/05/21/2464599.aspx
¶þ£¬Í¼Æ¬µÄ´æ´¢»ò¶þ½øÖÆÎļþµÄ´æ´¢
1£¬ÏȲåÈëÆÕͨÊý¾Ý£¬Óöµ½´ó¶ÔÏóÁÐʹÓÃempty_blob()¹¹Ôì¿ÕµÄÖ¸Õë¡£
Àý× ......
1£¬Ê²Ã´ÊÇÓαꣿ
¢Ù´Ó±íÖмìË÷³ö½á¹û¼¯£¬´ÓÖÐÿ´ÎÖ¸ÏòÒ»Ìõ¼Ç¼½øÐн»»¥µÄ»úÖÆ¡£
¢Ú¹ØÏµÊý¾Ý¿âÖеIJÙ×÷ÊÇÔÚÍêÕûµÄÐм¯ºÏÉÏÖ´Ðеġ£
ÓÉ SELECT Óï¾ä·µ»ØµÄÐм¯ºÏ°üÀ¨Âú×ã¸ÃÓï¾äµÄ WHERE ×Ó¾äËùÁÐÌõ¼þµÄËùÓÐÐС£ÓɸÃÓï¾ä·µ»ØÍêÕûµÄÐм¯ºÏ½Ð×ö½á¹û¼¯¡£
&n ......
×î½üÒ»¶Îʱ¼äһֱûд²©¿Í£¬²»ÊÇÀÁ£¬ÊÇѧÁËÌ«¶à¶«Î÷¡£ÒÔºóÂýÂý²¹ÉÏ¡£ 1. odbcÖÐÌí¼ÓoracleÊý¾ÝÔ´ odbcÖÐÌí¼ÓoracleÊý¾ÝÔ´Ê×ÒªÌõ¼þ£º°²×°oracle client¡£°²×°ÍêÖ®ºóÌí¼Ó£¬µ«ÊÇ»¹±ØÐëÔÚ°²×°Ä¿Â¼ÏÂͨ³£ÊÇC:\oracle\ora90\network\ADMIN\tnsnames.oraÖÐÌí¼ÓÒ»¸öÁ¬½Ó£¬Èçϸñʽ£º DXS =
(DESCRIPTION =
......
½ñÄêµÄOracleÈ«Çò´ó»áÓÚ10ÔÂ11ÈÕ£15ÈÕÔÚÃÀ¹ú¾É½ðɽµÄMosconeÖÐÐÄÒѾÀ¿ªÐòÄ»ÁË¡£
¡¡¡¡ Oracle¶ÔSun¹«Ë¾µÄ³¤ÆÚ¼Æ»®ÎÞÒÉÊDZ¾´ÎOOW´ó»áµÄ½¹µã¡£µ«ÔÚ̸ÂÛÕâ¸ö»°Ìâ֮ǰ£¬ÎÒÃÇ×¼±¸ÁËÒ»×é´ó»áµÄÓÐȤÊý¾Ý£¬ÏÈÈôó¼Ò¶Ô±¾´Î´ó»áÓиöÕûÌåµÄÓ¡Ïó¡£
¡¡¡¡ÓйØÕû¸ö´ó»áµÄÊý×Ö£º
¡¡¡¡· ½ü4.3ÍòÈ˵½»á
¡¡¡¡· ΪÃÀ¹ ......