¶ÔÓÚ¸Õ½Ó´¥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
Create directoryÈÃÎÒÃÇ¿ÉÒÔÔÚOracleÊý¾Ý¿âÖÐÁé»îµÄ¶ÔÎļþ½øÐжÁд²Ù×÷£¬¼«´óµÄÌá¸ßÁËOracleµÄÒ×ÓÃÐԺͿÉÀ©Õ¹ÐÔ¡£
ÆäÓ﷨Ϊ:
create or replace directory exp_dir as '/tmp';
Ŀ¼´´½¨ÒԺ󣬾ͿÉÒ԰ѶÁдȨÏÞÊÚÓèÌØ¶¨Óû§£¬ÀýÈç:
grant read, write on directory exp_dir to eygle;
´ËʱÓû§eygle¾ÍÓµÓÐÁ˶ԸÃĿ¼µÄ¶ ......