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
Ïà¹ØÎĵµ£º
½ñÌìÔÚ¿ª·¢µÄʱºòÐèÒª²éѯÊý¾Ý¿âÖÐÄÄЩѧÉúÓжà¸öѧºÅ£¬Ð´µÄ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£¬±È½ÏÄÑÒÔÀí½â¡£ÏÂÃæÓÃʵÀý˵Ã÷Ò»ÏÂ×÷Óá£
ÎÒÃÇ¿ÉÒÔ¸øij¸öÓû§·ÖÅäһЩ½ÇÉ«£¬±ÈÈçrole r1,r2,r3,r4£¬¶øÆäÖпÉÒÔ½«Ä³Ð©½ÇÉ«±ÈÈçr1ÉèÖÃΪdefault role£¬ÆäËûµÄ²»ÉèÖóÉdefault role£¬ÕâÑù£¬µ±¸ÃÓû§µÇ¼ʱ£¬×Ô¶¯¾ßÓÐdefault roleÖÐËù°üº¬µÄȨÏÞ£¬ÆäËûµÄ½ÇÉ«Ëù¾ßÓеÄȨÏÞҪͨ¹ýset role ½ÇÉ ......
Fedora10 É쵀 Oracle 10.2.0.1 ÊÖ¹¤½¨¿âÈ«¹ý³Ì
NOTE:
(1)¼Ç×ÅÒªÔÚoracleÓû§Ï¶ø²»ÊÇrootÏÂÖ´ÐÐÕâЩ²Ù×÷£¬·ñÔòÒòΪȨÏÞµÄÎÊÌâ»á´øÀ´ÎÞÇîÎÞ¾¡µÄÂé·³
(2)Òª¼ì²é¹ý³ÌÖÐËùÓгöÏÖµÄĿ¼Ãû¶¼ÊǶÔÓ¦ÕýÈ·ÇÒÓÐЧµÄ£¬·ñÔò¼¸ºõûÓпÉÓõĴíÎóÐÅÏ¢À´²éÕÒÕâÖÖ´íÎó
(3)Òª ......
ÎÒÃÇÖªµÀ,ÔÚOracleÊý¾Ý¿âÖÐ,¿ÉÒÔͨ¹ýkill sessionµÄ·½Ê½À´ÖÕÖ¹Ò»¸ö½ø³Ì,Æä»ù±¾Óï·¨½á¹¹Îª:
alter system kill session 'sid,serial#' ;
±»killµôµÄsession,״̬»á±»±ê¼ÇΪkilled,Oracle»áÔÚ¸ÃÓû§ÏÂÒ»´ÎtouchʱÇå³ý¸Ã½ø³Ì.
ÎÒÃÇ·¢ÏÖµ±Ò»¸ösession±»killµôÒԺ󣬸ÃsessionµÄpaddr±»Ð޸ģ¬Èç¹ûÓжà¸ösession±»kil ......
--Ãû´Ê˵Ã÷£ºÔ´——±»Í¬²½µÄÊý¾Ý¿â
-- Ä¿µÄ——Ҫͬ²½µ½µÄÊý¾Ý¿â
/*Ò»¡¢´´½¨dblink£º*/
--1¡¢ÔÚÄ¿µÄÊý¾Ý¿âÉÏ£¬´´½¨dblin
drop database link dblink_anson;
Create public
database link dblink_an ......