ÔÚ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µÄ¼¯Èº¾ÍÐ÷·þÎñʵÏÖ¡£¼¯ÈºÖ®¼äͨ¹ýÄÚ²¿ÍøÂçÁ¬½Ó½øÐÐÊý¾Ý½»»»£¬³ÆÖ®Îª»
Ïà¹ØÎĵµ£º
rlwrapʹÓ÷½·¨
¹Ø¼ü×Ö: rlwrapʹÓ÷½·¨
ÔÚWindows²Ù×÷ϵͳÉÏ,µ±ÔÚDOSÃüÁî´°¿ÚÖÐÔËÐÐSQL*PlusµÄʱºò,¿ÉÒÔʹÓÃÏòÉÏ,ÏòϼüÀ´Ìø»ØÖ®Ç°ÒѾִÐйýµÄSQLÓï¾ä.Äã¿ÉÒÔ¸ù¾ÝÐèÒªÐÞ¸ÄËûÃÇ,È»ºó°´Enter¼üÖØÐÂÌá½»Ö´ÐÐ.
È»¶ø,µ±ÔÚLinux ShellÖÐÔËÐÐSQL*PlusµÄʱºò,²¢²»Ìṩä¯ÀÀÀúÊ·ÃüÁîÐеŦÄÜ.
ΪÁËÔÚLinuxÖдﵽͬÑùµÄÄ¿µÄ,Ä ......
ÈÕǰÓöµ½Ò»¸öÎÊÌ⣬ÐèÒª¶ÔÔÚOracleÊý¾Ý¿âÖвéѯ³öÀ´µÄÊýÖµ½øÐбÈÂʵļÆËã¡£ÀàËÆÓÚÈçϵÄSQL£º
Select Round((discount/Amount),2) from dual;
ÕâÑùËã³öÀ´µÄÊý×Ö¿ÉÒÔÂú×ã¾ø´ó²¿·ÖµÄÐèÇó¡£µ«ÊǶÔÓÚ²»µ½1µÄÊý×Ö£¬ÎÊÌâ³öÀ´ÁË......ÏÔʾµÄÀàËÆÓÚ .45Ñù×ÓµÄÊý¾Ý¡£0.45Ç°ÃæµÄ0²»¼ûÁË¡£
ÒÔÏÂ×ܽáÁËÁ½ÖÖ·½·¨À´½â¾öȱ0µÄÎÊÌâ¡£
µÚ ......
1. select * from emp;
2. select empno, ename, job from emp;
3. select empno ±àºÅ, ename ÐÕÃû, job ¹¤×÷ from emp;
4. select job from emp;
5. select distinct job from emp;
6. select distinct empno, job from emp;
˵Ã÷:ÒòΪ¹ÍÔ±±àºÅ²»Öظ´, ËùÒÔ´Ëʱ֤Ã÷ËùÓеÄÁÐûÓÐÖØ¸´,ËùÒÔ²»ÄÜÏû ......
SELECT ID,
col_name,
SUBSTR(col_name, 1, INSTR(col_name || ',', ',', 1, 1) - 1) C1,
SUBSTR(col_name,
......
ÎÒдµÄ½Å±¾£¬ÓеãÂý£¬½«¾Í×ÅÓðÉ
--kill sessionÓï¾ä
alter system kill session'50,492';
--ÒÔϼ¸¸öΪÏà¹Ø±í
SELECT * from v$lock;
SELECT * from v$sqlarea;
SELECT * from v$session;
SELECT * from v$process ;
SELECT * from v$locked_object;
SELECT * from all_ ......