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

ÔÚAIX»·¾³ÏÂʵʩOracle ¼¯ÈºRACµÄ½á¹¹ ÎÄÆ½

  ¡¶oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX/unixÉϵÄʵսÏê½â¡·¼¯ÖÐÌÖÂÛ34£ºÔÚAIX»·¾³ÏÂʵʩOracle ¼¯ÈºRACµÄ½á¹¹   ÎÄÆ½ ¿´À´ÄÜÓÃµÄÆðIBM p·þÎñÆ÷µÄÓû§,¶¼ÄÜÓÃµÄÆðRAC.´ó¼Ò·×·×À´ÐÅ̽ÌÖÔÚAIXÉÏʵʩRACµÄһЩÎÊÌâ,´ó¶àÊýÎÊÌ⼯ÖеĹ¹¼ÜÉÏ. ÕâÀïÎÒ¿ªÒ»¸öרÌ⼯ÖÐÌÖÂÛÖ®! ´ÓOracle 9i¿ªÊ¼£¬OracleÍÆ³öÕæÕýÓ¦Óü¯ÈºReal Application Cluster£¬¼ò³ÆRAC£¬À´ÊµÏÖOracleµÄ²¢ÐзþÎñ¡£ÆäÖ÷Ҫ˼ÏëÊÇÔÚÐèÒªµÄʱºò²åÈëOracle½ÚµãÒÔÖ§³Ö¸ü¶àµÄ¹¤×÷ÔØºÉ£¬ÔÚÇáÔØµÄÇé¿öÏÂɾ³ý½Úµã£¬²¢½«¼ÆËãÄÜÁ¦×ªÒƸøÐèÒªµÄµØ·½¡£ Oracle 10g¡¢11g¶¼°ÑRAC×÷ΪOracle²úÆ·×é³ÉÖеÄÖØÒª²¿·Ö¡£²¢³ÖÐø¼ò»¯½Úµã²Ù×÷µÄ¹ý³ÌºÍ¸´ÔÓ¶È£¬Ôö¼ÓRAC¼¯ÈºÖ§³ÖµÄ½ÚµãÊý¡£ AIX5L¡¢AIX6Öж¼¿ÉÒÔÍêÃÀµØÊµÏÖRAC£¬¶øÇÒÔÚÖڶ಻ͬµÄÓ²¼þÍØÆË½á¹¹ÏÂÖ§³ÖRAC——ÎÞÂÛÊǶàͨµÀ±¾µØÖ±Á¬´æ´¢£¨DAS£©¡¢»¹ÊÇͨ¹ý¹âÏËÁ¬½ÓµÄSAN´æ´¢½á¹¹¡¢»òÕßÊÇiSCSIЭÒéϵÄIP SAN¡¢ÉõÖÁͨ¹ýÍøÂçÎļþϵͳNFS·½Ê½£¬¶¼¿ÉÒÔʵÏÖ¡£ÆäÊý¾Ý¿âÎļþ´æ´¢¸ñʽ£¬Ò²¼´¿ÉÒÔÊÇÂãÉ豸¡¢GPFS¹²ÏíÎļþϵͳ¡¢Òà»òÊÇOracleµÄASM·½Ê½£¬»¹¿ÉÒÔÊÇNFSÎļþϵͳ¡£ ÉÏÃæÁгöÁËRAC¹¹¼ÜµÄËÄÖÖ»ù±¾·½Ê½£ºGPFSģʽϵÄRAC¡¢NFS·½Ê½µÄRAC¡¢ASM·½Ê½ÏµÄRAC¡¢HACMPϵÄRAC¡£Õë¶Ô¾ßÌåÔÚ¹¤³ÌÉϵÄʵʩ£¬ÓÉÓÚÎïÀíÉ豸ÉϵIJîÒìÐԺ͹ÒÔØ·½Ê½µÄ²»Í¬£¬Æä°²×°ÅäÖÿÉÄÜ»áÓв»Í¬£¬×ã¹»µÄÁé»îÐÔÊǼ«Æä±ØÒªµÄ£¡ ÔÚOracle ¼¯ÈºÏ£¬Oracle¼¯Èº·þÎñÊǺÜÖØÒªµÄ£¡   ¹¹ÖþÊý¾Ý¿â¼¯Èº£¬ÐèÒª¼¯Èº¼þµÄÖ§³Ö¡£ÔÚ´«Í³µÄ¼¯ÈºÏµÍ³ÖУ¬ÍùÍùÊÇרҵ´æ´¢³§ÉÌ»ò¼¯Èº¹©Ó¦É̵ȵÚÈý·½ÆóÒµÌṩ¼¯Èº¼þ£¬Oracle½«¼¯Èº·þÎñ¹¹ÖþÔÚÆäÉÏ¡£Ëæ×ÅOracle 10g¡¢11gµÄÍÆ³ö£¬Oracle¿ª·¢ÁË×Ô¼ºµÄ¼¯Èº×é¼þ£¨Cluster Ware£©£¬³ÆÖ®Îª¼¯Èº¾ÍÐ÷·þÎñ×é¼þCRS (Cluster Ready Services)¡£CRSÓÉOracleÌṩ£¬Äܹ»½«¼¯ÈºÖеĸ÷½Úµã£¬Í¨¹ý¹²Ïí´æ´¢µÄÓ²¼þÖ§³Ö£¬¼¯ºÏÔÚÒ»Æð¡£ÆäÖ§³Öƽ̨·½Î»Éæ¼°AIX¡¢HP¡¢Sun¡¢Linux¡¢WindowsµÈÖ÷Á÷ƽ̨¡£Í¨¹ýʹÓÃCRS£¬Oracle¼¯Èº½á¹¹¿ÉÒÔ±ÜÃâʹÓõÚÈý·½µÄ¼¯Èº¼þ£¬½µµÍÁËϵͳ¸´ÔӶȺͷÑÓÃÖ§³ö¡£²»½öÈç´Ë£¬CRSÈÔÈ»¿ÉÒÔÓëµÚÈý·½¼¯Èº¼þ¹²Í¬Ê¹Ó㬽«ÏÖÓеĵÚÈý·½¼¯Èº¼þ¼¯³ÉÔÚOracle¼¯ÈºÖУ¬Ê¹Oracle ¼¯ÈºÊý¾Ý¿â¿ÉÒÔÔËÐÐÔÚÏÖÓм¯ÈºÈí¼þÖ®ÉÏ¡£ ÏÂͼ¼´ÎªOracleʵÏÖ¼¯ÈºµÄÌåϵ½á¹¹Ê¾Òâ¡£ÔÚͨ¹ýÍøÂçÁ¬½ÓµÄ¸÷¸ö½ÚµãÉÏ£¬ÔËÐÐ×Ų»Í¬µÄÊý¾Ý¿âʵÀý£¬Ã¿¸öʵÀý¶¼¿ÉÒÔ²Ù×Ý·ÅÖÃÔÚ¹²Ïí´æ´¢Éϵļ¯ÈºÊý¾Ý¿â£¬Õâͨ¹ýOracleµÄ¼¯Èº¾ÍÐ÷·þÎñʵÏÖ¡£¼¯ÈºÖ®¼äͨ¹ýÄÚ²¿ÍøÂçÁ¬½Ó½øÐÐÊý¾Ý½»»»£¬³ÆÖ®Îª»


Ïà¹ØÎĵµ£º

ORACLEµ¼Èëµ¼³ö

ORACLEµ¼Èëµ¼³ö
¹¦ÄÜ£ºOracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓëoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£´ó¶àÇé¿ö¶¼¿ÉÒÔÓÃOracleÊý¾Ýµ¼Èëµ¼³öÍê³ÉÊý¾ÝµÄ±¸·ÝºÍ»¹Ô­£¨²»»áÔì³ÉÊý¾ÝµÄ¶ªÊ§£©¡£OracleÓиöºÃ´¦£¬ËäÈ»ÄãµÄµçÄÔ²»ÊÇ·þÎñÆ÷£¬µ«ÊÇÄã×°ÁËoracle¿Í»§¶Ë£¬²¢½¨Á¢ÁËÁ¬½Ó£¨Í¨¹ýnet8 assistantÖб¾µØ-->·þÎñÃüÃû Ìí¼ÓÕýÈ·µÄ·þÎñÃüÃû ÆäʵÄã¿É ......

oracleÓÅ»¯ »º´æ¶ÔÏóÓëÊý¾Ý

author£ºskate
time£º2010/03/16
µ±ÏµÍ³³öÏÖÐÔÄÜÆ¿¾±Ê±£¬¾¡Á¿½ÏÉÙ²»±ØÒªµÄ×ÊÔ´ÏûºÄ£¬×îºó¾ÍÊÇÆ½ºâcpu£¬Äڴ棬io£¬networkµÈ×ÊÔ´£¬Ê¹Êý¾Ý¿â
¿ÉÒÔÎȶ¨µÄÔËÐС£
oracleÊý¾Ý¿âÓÅ»¯µÄ¸ù±¾ÊÇ
1.¾¡Á¿¼õÉÙ×ÊÔ´ÏûºÄ£¬ÀýÈçÓÅ»¯sql£¬¼õÉÙsql±¾ÉíµÄ×ÊÔ´ÏûºÄ
2.Èç¹ûÎÞ·¨½øÒ»²½¼õÉÙ×ÊÔ´µÄÏûºÄ£¬ÄǾÍÈÃÊý¾Ý¾¡Á¿¿¿½ücpu£¬Ò²¾ÍÊǰÑÊý¾Ý ......

oracle ´æ´¢¹ý³Ì¼òÊö

´æ´¢¹ý³Ì¾ÍÊÇ×÷Ϊ¿ÉÖ´ÐжÔÏó´æ·ÅÔÚÊý¾Ý¿âÖеÄÒ»¸ö»ò¶à¸öSQLÃüÁî¡£
       ¶¨Òå×ÜÊǺܳéÏó¡£´æ´¢¹ý³ÌÆäʵ¾ÍÊÇÄÜÍê³ÉÒ»¶¨²Ù×÷µÄÒ»×éSQLÓï¾ä£¬Ö»²»¹ýÕâ×éÓï¾äÊÇ·ÅÔÚÊý¾Ý¿âÖеÄ(ÕâÀïÎÒÃÇ̸ֻSQL Server)¡£Èç¹ûÎÒÃÇͨ¹ý´´
½¨´æ´¢¹ý³ÌÒÔ¼°ÔÚASPÖе÷Óô洢¹ý³Ì£¬¾Í¿ÉÒÔ±ÜÃ⽫SQLÓï¾äͬASP´úÂë»ìÔÓ ......

OracleÖÐTO_DATE¸ñʽ

TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02   13:45:25ΪÀý)
  
        Year:     
        yy two digits Á½Î»Äê               ......

ÈçºÎµ¼ÈëORACLE ±¸·ÝÎļþ

--´´½¨Óû§
create user iagent identified by ia
profile default 
default  tablespace users
temporary tablespace temp
account unlock;
 
--¸ø´´½¨µÄÓû§ÊÚȨ
grant create user,drop user,alter user,create any view,drop any view,exp_full_database,imp_full_database,dba,connect,resour ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ