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

Unix For Oracle DBA

     ¶ÔÓÚ¸Õ½Ó´¥unixµÄÈ˶øÑÔ,ÀûÓùܵÀ½«¸÷ÖÖÃüÁî×éºÏÔÚÒ»ÆðÀ´ÊµÏÖij¸ö¹¦ÄÜ,ÊDZȽÏÄÑÊÊÓ¦µÄÒ»¼þÊÂÇé,ÏÂÃæ£¬ÎÒ¾ÍÓÃÒ»¸ö¾ßÌåµÄÀý×Ó,Ïêϸ½²ÏÂ×ÅÀïÃæµÄÓ÷¨ºÍ˼·.¿´¿´µ½µ×ÎÒÃǰÑÃüÁî¶¼°óÔÚÒ»Æð,unix¶¼×öÁËʲô.
     ¾ÍÓÃÒ»¸öoracle¹ÜÀíÖÐ,¿ÉÄÜ»áÓöµ½µÄÀý×Ó°É,Èç¹ûoracle¹ÒÁË£¬ÎÒÃÇͨ¹ýËùÓÐÕý³£·½·¨¶¼ÎÞ·¨½«ÆäÕý³£¹Ø±Õ,°üÀ¨shutdown abort¶¼ÎÞЧ,ÀàËÆÕâÖÖÇé¿ö,ÓпÉÄܾÍos×ÊÔ´ÅäÖóöÁËÎÊÌâ,µ¼ÖÂoracleµÄij¸öºËÐÄprocess¹Òס¶øµ¼ÖµÄ,ÄÇÕâ¸öʱºò£¬ÎÒÃǾÍÒª²ÉÈ¡±©Á¦´ëÊ©,Ôõô±©Á¦ÄØ£¬¾ÍÊÇͨ¹ýunixµÄkillÃüÁîÖ±½Ó½áÊøos¼¶±ðµÄprocessÀ´Ç¿ÖƽáÊøoracle,µ±È»,Èç¹ûÓöµ½oracleµÄpmonûÓм°Ê±ÇåÀísessionµÄ×ÊÔ´£¬ÎÒÃÇÒ²¿ÉÒÔ²ÉÈ¡ÀàËÆµÄ·½·¨,ÔÚºóÃæ»á¶Ô´Ë½øÐÐ˵Ã÷.
     Ê×ÏÈ¿´¿´Õâ¸öÃüÁî :   ps -ef|grep "ora_"|grep -v grep|awk '{ print $2 }'|xargs kill -9
     Õâ¸öÃüÁîËùÒªÍê³ÉµÄÈÎÎñ£¬¾ÍÊǰѵ±Ç°ÏµÍ³ÖÐËùÓÐoracleµÄprocessÈ«²¿É±µô,ÀïÃæÓõ½ÁËps , grep , awk , xargs , killÕ⼸¸öÃüÁî.ÆäÖÐawkÊǸöºÃ¶«Î÷,ºÇºÇ,²»ÖªµÀ´ó¼ÒÖª²»ÖªµÀregular expressionÕâ¸ö¶«Î÷,ÖÐÎÄ·­Òë³ÉÕýÔò±í´ïʽ,ÎÒÒ»Ö±¾õµÃ²»ÊÇÊ®·Ö׼ȷ,¿ÉÒ²²»ÖªµÀ¸Ã·­Òë³Éʲô²Å¾«È·£¬¾ÍÓÃÓ¢ÎİÉ,ºÇºÇ,¼ò³ÆRE.ÎÒÕâÀïÏÈÌáÒ»ÏÂ,µÈ˵ÍêÕâ¸öÀý×Óºó,ÔÚÉÔ΢½²Ò»Ï¹ØÓÚREµÄ¶«Î÷£¬ÉîÈëµÄ£¬»¹ÊÇÒª¿¿´ó¼ÒÑо¿£¬O'ReillyÓб¾ÊéÊÇרÃŽ²Õâ¸öµÄ£¬¿ÉÒԲο¼,ºÃÑÔ¹éÕý´«.ÎÒÃÇÀ´·ÖÎöÒ»ÏÂ,ΪʲôÕâ¸öÃüÁî´®¿ÉÒÔ´ïµ½Õâ¸öÄ¿µÄ.
     killÊÇunixÖÐÖÕÖ¹processµÄÃüÁî,ͨ³££¬ÎÒÃÇÈç¹ûÖªµÀÒ»¸öprocessµÄpid,Èç¹ûÏëÖÕÖ¹Ëü,¾Í¿ÉÒÔÓà kill -9 pidÀ´ÊµÏÖ,ÄÇͬÑù,¼ÈÈ»oracleÊÇ͸¹ý¸÷ÖÖprocessÔËÐÐÔÚosÉϵģ¬ÎÒÃÇÊDz»ÊÇÒ²¿ÉÒÔͬÑùÀ´¶Ô´ýËüÄØ£¬´ð°¸Êǿ϶¨µÄ,ÎÒÃÇ¿ÉÒÔÓÃkill -9 pidµÄ·½Ê½À´ÖÕÖ¹oracle½ø³Ì,ok,»Øµ½ÎÒÃǵÄÀý×ÓÖÐ,ÎÒÃÇÒѾ­ÖªµÀÁËÇå³ýoracle processµÄ·½·¨£¬ÏÖÔھͲîoracle process µÄpid ÁË,Ö»ÒªÄܰÑËûÃÇÕÒ³öÀ´£¬¾ÍÍòÊ´ó¼ªÁË.
     ÈçºÎÈ¥ÕÒËüµÄpidÄØ,Õâʱºò,ps¾ÍµÇ³¡ÁË,psÕâ¸öÃüÁî,ÊÇÓÃÀ´²é¿´µ±Ç°ÏµÍ³ÔËÐеÄprocessµÄ,×î³£ÓõIJÎÊýÊÇ-eºÍ-f,Á¬ÔÚÒ»Æð¾ÍÊÇps -ef ,ÎÒÃÇÔÚunixÏÂÔËÐÐ,ÆÁÄ»ÉϾͻáÏÔʾ³öµ±Ç°ÏµÍ³ÔËÐеÄprocess:
   [oracle@blade /etc]$ ps -ef
     UID   PID  PPID  C    STIME


Ïà¹ØÎĵµ£º

OracleÖÐNOT INµÄÎÊÌâ

     ½ñÌìÔÚ¿ª·¢µÄʱºòÐèÒª²éѯÊý¾Ý¿âÖÐÄÄЩѧÉúÓжà¸öѧºÅ£¬Ð´µÄsqlÈçÏ£º
     select * from(
  select count(t1.xh) as xhs,t2.uuid,t3.xm as xsxm,t3.sfzjh, t1.xjzt as xjzt from hust_xs_jb t1
   INNER JOIN hust_xx_identity t2 on t1.sfid ......

ORACLEÖеÄdefault role£¬set role

oracleȨÏÞÌåϵÖÐÓиödefault role£¬±È½ÏÄÑÒÔÀí½â¡£ÏÂÃæÓÃʵÀý˵Ã÷Ò»ÏÂ×÷Óá£
ÎÒÃÇ¿ÉÒÔ¸øÄ³¸öÓû§·ÖÅäһЩ½ÇÉ«£¬±ÈÈçrole r1,r2,r3,r4£¬¶øÆäÖпÉÒÔ½«Ä³Ð©½ÇÉ«±ÈÈçr1ÉèÖÃΪdefault role£¬ÆäËûµÄ²»ÉèÖóÉdefault role£¬ÕâÑù£¬µ±¸ÃÓû§µÇ¼ʱ£¬×Ô¶¯¾ßÓÐdefault roleÖÐËù°üº¬µÄȨÏÞ£¬ÆäËûµÄ½ÇÉ«Ëù¾ßÓеÄȨÏÞҪͨ¹ýset role ½ÇÉ ......

Oracle ¿ìÕÕ¼° dblinkʹÓà £¨Á½Ì¨·þÎñÆ÷Êý¾Ýͬ²½£©


--Ãû´Ê˵Ã÷£ºÔ´——±»Í¬²½µÄÊý¾Ý¿â
--          Ä¿µÄ——Ҫͬ²½µ½µÄÊý¾Ý¿â
/*Ò»¡¢´´½¨dblink£º*/
--1¡¢ÔÚÄ¿µÄÊý¾Ý¿âÉÏ£¬´´½¨dblin
drop database link dblink_anson;
Create public
database link dblink_an ......

Oracle Transparent Geteways To MSSQL


oracleͨ¹ý͸Ã÷Íø¹Ø£¨Oracle Transparent Geteways£©£¬·ÃÎÊms sql serverºÍÆäËûÊý¾Ý¿â
»·¾³£º
    1¡¢ÔÚ°²×°ÓÐoracle·þÎñÆ÷¶Ë£¬ms sql serverµÄ¿Í»§¶Ë£¬Í¨¹ýoracleµÄ͸Ã÷Íø¹Ø·ÃÎÊms sql serverÊý¾Ý¿â
    2¡¢ÔÚms sql ser ......

Oracle Flashback Technology


Oracle Flashback Technology
Oracle Flashback Technology reduces recovery time from hours to minutes.
from: http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm
According to many studies, 40% of application outages are caused by operator or user errors. Part of be ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ