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

¹ØÓÚOracleÔÚAIXƽ̨ʵʩµÄ ÅàѵÄÚÈݰ²ÅÅ

¡¶oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX/unixÉϵÄʵսÏê½â¡·ÌÖÂÛ38    ¹ØÓÚOracleÔÚAIXÉÏʵʩÅàѵµÄÄÚÈݰ²ÅÅ   Õâ¶Îʱ¼äÓÉÓÚһֱæÓÚÏîÄ¿£¬Ò²¾ÍÊèÓÚÔÚÈÕÖ¾ÉϺͶÁÕߵĻ¥¶¯£¬Òò´ËÓÖ»ýÔÜÏÂÈô¸É¶ÁÕßÀ´ÐÅδ»Ø£¬ÊµÔÚ±§Ç¸¡£ÆäÖÐÓм¸·âÊǹØÓÚOracleÔÚAIXÉÏʵʩÅàѵµÄ£¬ÒªÇóÎÒ¶ÔÅàѵÄÚÈݸøÓë½âÊͺÍ˵Ã÷¡£ÕâÀïÎÒ×öͳһ˵Ã÷ÈçÏ£º   ÕâÃſγ̵ÄÈ«³ÆÊÇ£ºIBM AIXƽ̨ÏÂOracleÊý¾Ý¿â°²×°ÓëÅäÖá¢ÏµÍ³¹ÜÀí¡¢ÐÔÄÜÕï¶ÏºÍÓÅ»¯¼°±¸·Ý»Ö¸´ ÕâÃſγ̵Äʱ¼äÊÇ£ºÈ«ÈÕÖÆ 4 Ìì ÕâÃſγ̵ÄÖ÷½²ÊÇ£º ÎÒ£¨ÎÄÆ½£© ÕâÃſγ̵ĺóÐø¿Î³ÌÊÇ£ºÔÚIBM AIX ƽ̨Ï Oracle10.2  RAC ¼¯ÈºµÄ°²×°¡¢ÅäÖᢹÜÀíʵ¼ù                                         ÔÚIBM AIX HACMP Ë«»úϵͳ°²×°¡¢ÅäÖᢹÜÀíʵ¼ù 
                                        ÔÚIBM AIXƽ̨Ï Oracle 10.2 DataGuardÈÝÔÖÅäÖà £ºÆÕͨ±¸ÓÃÊý¾Ý¿â¡¢½Úµã¹ÜÀí¡¢×Ô¶¯Çл» ÕâÃſγ̵ÄÄÚÈÝÊÇ£º   Oracle For AIXÄ£¿éÒ»£ºOracleµÄ°²×°ºÍÉèÖà Oracle ÔÚAIXÉϵݲװ ²Ù×÷ϵͳµÄÐÞ²¹ ÐÞ²¹Îļþ¼¯ÑéÖ¤ ²Ù×÷ϵͳÄں˵ÄÐÞ¸Ä °²×°ÐèÒªµÄÎļþϵͳ׼±¸ °²×°ÐèÒªµÄÓû§¡¢È¨ÏÞ·ÖÅä °²×°Óû§µÄÉèÖà ´´½¨Êý¾Ý¿âµÄ´æ´¢½éÖÊ£¬×¼±¸ÂãÉ豸 °²×°Oracle10gR2ϵͳ ´´½¨OracleÊý¾Ý¿âϵͳ Æô¶¯ºÍ¹Ø±ÕÊý¾Ý¿â ÉèÖÃÊý¾Ý¿âµÄ×Ô¶¯Æô¶¯ OracleÊý¾Ý¿âµÄ±¾µØ·ÃÎÊ Êý¾Ý¿âÔÚAIXÉÏ»ù±¾ÅäÖà ʵ¼ù£ºOracle ÔÚAIXÉϵݲװ Oracle For AI


Ïà¹ØÎĵµ£º

Éî¶È¶Ô±ÈOracleÓëSQL Server——µÚÒ»²¿·Ö

²Ù×÷ϵͳµÄÖ§³Ö °æ±¾ºÍ·¢Ðаæ ʵÀý¡¢Êý¾Ý¿âºÍ±í¿Õ¼ä ʵÀýÃûºÍSID ϵͳÊý¾Ý¿âºÍϵͳ±í¿Õ¼ä
Ò»°ãµÄ¹«Ë¾Í¨³£»áÔÚËûÃǵÄÐÅϢϵͳ¼Ü¹¹ÖÐÒýÈë¶àÖÖÊý¾Ý¿âƽ̨£¬Í¬Ê±ÒýÈëÈýµ½ËÄÖÖ²»Í¬µÄRDBMS½â¾ö·½°¸µÄÖдóÐ͹«Ë¾Ò²²¢²»ÉÙ¼û£¬µ±È»ÕâЩ¹«Ë¾ÀïÃæµÄDBAÃÇͨ³£Ò²ÐèҪͬʱӵÓйÜÀí¶àÖÖ²»Í¬Æ½Ì¨µÄ¼¼ÄÜÁË¡£
Ö»ÔÚÒ»ÖÖÆ½Ì¨ÉÏÕ¹¿ª¹¤×÷µÄÊý¾Ý ......

ORACLE Óë mysql µÄÇø±ð

1.ÔÚORACLEÖÐÓÃselect * from all_usersÏÔʾËùÓеÄÓû§£¬¶øÔÚMYSQLÖÐÏÔʾËùÓÐÊý¾Ý¿âµÄÃüÁîÊÇshow
databases¡£¶ÔÓÚÎÒµÄÀí½â£¬ORACLEÏîÄ¿À´ËµÒ»¸öÏîÄ¿¾ÍÓ¦¸ÃÓÐÒ»¸öÓû§ºÍÆä¶ÔÓ¦µÄ±í¿Õ¼ä£¬¶øMYSQLÏîÄ¿ÖÐÒ²Ó¦¸ÃÓиöÓû§ºÍÒ»¸ö¿â¡£ÔÚ
ORACLE(db2Ò²Ò»Ñù)Öбí¿Õ¼äÊÇÎļþϵͳÖеÄÎïÀíÈÝÆ÷µÄÂß¼­±íʾ£¬ÊÓͼ¡¢´¥·¢Æ÷ºÍ´æ´¢¹ý³ÌÒ²¿É ......

oracleÎóÓòÙ×÷ϵͳÃüÁîɾ³ýÊý¾ÝÎļþµÄ»Ö¸´·½·¨

ʹÊÔ­Òò:
1.ÓÉÓÚÎó²Ù×÷ÓÃhp unix ÃüÁî rm -f datafilename É¾³ý±í¿Õ¼äµÄÊý¾ÝÎļþ
2.alter tablespace tablespacenaem drop datafile datafile ;
3.drop tablespace tablespacename including content and datafiles;
ÉÏÊöÁ½¸ö²½ÖèÎÒÓÃÁ˽üÈý¸öСʱ¶¼Ã»ÓÐÖ´ÐÐÍ꣬×îºóµ¼ÖÂÊý¾Ý¿âå´»ú¡£ÏÂÃæ°ÑÎÒµ±Ê±Æô¶¯Êý¾ÝµÄºóÌ¨Ò ......

·ÃÎÊoracleÊý¾Ý¿â

1¡£web.config ----appSettings--<add key="LimsConnection" value="data source=yzlims;user id=lims;password = lims"/>
2.  c#´úÂëÖÐ
using System.Data.OracleClient;     
public DataTable  GetLimsTimeInSpace(string S_SAMPLE_NAME, string S_SAMPLING_P_N,Date ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ