Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý¿âÖзÖÇø±íµÄ²Ù×÷·½·¨


¡¡¡¡ÔÚ´óÁ¿ÒµÎñÊý¾Ý´¦ÀíµÄÏîÄ¿ÖУ¬¿ÉÒÔ¿¼ÂÇʹÓ÷ÖÇø±íÀ´Ìá¸ßÓ¦ÓÃϵͳµÄÐÔÄܲ¢·½±ãÊý¾Ý¹ÜÀí£¬±¾ÎÄÏêϸ½éÉÜÁË·ÖÇø±íµÄʹÓá£
¡¡¡¡
¡¡¡¡ÔÚ´óÐÍµÄÆóÒµÓ¦ÓûòÆóÒµ¼¶µÄÊý¾Ý¿âÓ¦ÓÃÖУ¬Òª´¦ÀíµÄÊý¾ÝÁ¿Í¨³£¿ÉÒÔ´ïµ½¼¸Ê®µ½¼¸°ÙGB£¬ÓеÄÉõÖÁ¿ÉÒÔµ½TB¼¶¡£ËäÈ»´æ´¢½éÖʺÍÊý¾Ý´¦Àí¼¼ÊõµÄ·¢Õ¹Ò²ºÜ¿ì£¬µ«ÊÇÈÔÈ»²»ÄÜÂú×ãÓû§µÄÐèÇó£¬ÎªÁË ......

Oracle¶ÔĿ¼Îļþ(directory)µÄ¶Áд²Ù×÷

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

oracle 10gÖÐºÜÆæ¹ÖµÄµ¥ÒýºÅÎÊÌâ

 
oracleÖУ¬
±í½á¹¹ÈçÏ£º
create table device
(
 id number(10) not null primary key,
 dept varchar2(50)  not null
)
tablespace users
/
 
Òª½«dept×ֶθüгÉÈçÏÂÄÚÈÝ£ºselect * from message where name='tom'
ÎÒÊÔ¹ýʹÓÃÈçϵĸüÐÂÓï¾ä²»ÐУºupdate device set dept='selec ......

ORACLEÖеÄdefault role£¬set role

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

ÔÚORACLEÊý¾Ý¿âÖÐʵÏִӷǹ鵵ģʽµ½¹éµµÄ£Ê½µÄת»¯

Ò»¡¢²é¿´Êý¾Ý¿âÔËÐÐģʽ
¡¡¡¡¿ÉÒÔÓ󬼶Óû§£¨INTERNAL£©ÔÚSQLPLUSÖÐʹÓÃÃüÁîARCHIVE LOG LIST²é¿´
¡¡¡¡SQL> archive log list
¡¡¡¡Database log mode No Archive Mode
¡¡¡¡Automatic archivalDisabled
¡¡¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ