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

OracleÆô¶¯¹ý³ÌÏê½â ½éÉܼ°ÃüÁ»¹ÓйرÕ

OracleÆô¶¯¹ý³Ì½éÉܼ°ÃüÁ»¹Óйرա£
дÔÚÇ°Ãæ£ºÆô¶¯Êý¾Ý¿âǰ£¬ÇëÏÈÆô¶¯¼à³ÌÐò¡£
lsnrctl start
Æô¶¯µÄÈý¸ö²½Ö裬ÒÀ´ÎΪ1.´´½¨²¢Æô¶¯ÊµÀý¡¢2.×°ÔØÊý¾Ý¿â¡¢3.´ò¿ªÊý¾Ý¿â¡£
¿ÉÒÔͨ¹ýÃüÁîstartupÀ´ÊµÏÖ¡£
startup ÃüÁî¸ñʽ
startup [ nomount | mount | open | force ] [ restrict ] [ pfile=filename ];
·½·¨1 -- startup nomount ; alter database mount ;alter database open
·½·¨2 -- startup mount ; alter database open
·½·¨3 -- startup »ò startup open
ÔÚ½øÈëijÖÖģʽºó£¬¿ÉÒÔͨ¹ýalter databaseÀ´ÌáÉýµ½¸ü¸ßµÄģʽ¡£µ«ÊÇÎÞ·¨½µµÍÖÁÇ°ÃæµÄģʽ¡£
ÊéÉÏдµÄտĥߴ£¬¾ÍÊÇ˵ÄãÔÚstep2ÕâÀÄã¿ÉÒÔͨ¹ýalter databaseµ½step3,µ«ÊÇÄã²»Äܵ½step 1.
startup force
Ç¿ÖÆÆô¶¯£¬¿ÉÓÃÓÚ¸÷ÖÖģʽ¡£Õý³£µÄÆð²»À´£¬¾ÍÊÔÊÔÕâ¸ö¡£
startup restrict
restrictģʽ»á½«Êý¾Ý¿âÖÃÓÚopenģʽ£¬´ËʱֻÓÐrestricted sessionȨÏÞµÄÓû§²ÅÄÜ·ÃÎÊÊý¾Ý¿â¡£
ÓÃÓÚά»¤¶¯×÷¡£Î¬»¤Íê³Éºó£¬Çë½ûÓÃrestricted sessionȨÏÞ£¬ÒÔ±ãÆÕͨÓû§µÄÁ¬½Ó¡£ÈçÏ£º
alter system disable restricted session
1:´´½¨²¢Æô¶¯ÊµÀý stratup nomount
´ËģʽÏÂÖ´ÐÐά»¤¶¯×÷£º
a:ÔËÐÐÒ»¸ö´´½¨ÐÂÊý¾Ý¿âµÄ½Å±¾
b:ÖØ½¨¿ØÖÆÎļþ
2:×°ÔØÊý¾Ý¿â startup mount
´ËģʽÏÂÖ´ÐÐά»¤¶¯×÷£º
a:ÖØÃüÃûÊý¾ÝÎļþ
b:Ìí¼Ó¡¢É¾³ý¡¢ÖØÃüÃûÖØ×öÈÕÖ¾Îļþ
c:Ö´ÐÐÊý¾Ý¿âÍêÈ«»Ö¸´²Ù×÷
d:¸Ä±äÊý¾Ý¿âµÄ¹éµµÄ£Ê½¡£
3:´ò¿ªÊý¾Ý¿â stratup µÈͬÓÚ startup open
´Ëģʽ״̬Ï¡£ÈκξßÓÐcreate sessionȨÏÞµÄÓû§¶¼¿ÉÒÔÁ¬½Óµ½Êý¾Ý¿â¡£½øÐг£¹æÊý¾Ý¿â²Ù×÷¡£
¹Ø±ÕÊý¾Ý¿â,ͨ¹ýshutdownÃüÁî
shutdown ÃüÁî¸ñʽ
shutdown [ normal | transactional | immediate | abort ];
normal:
a:×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó
b:µÈ´ýÁ¬½ÓµÄÓû§Ö÷¶¯¶Ï¿ª£¬ÕýÔÚÁ¬½ÓµÄÓû§¿ÉÒÔ¼ÌÐø¹¤×÷£¬ÉõÖÁÌύеÄʵÎñ¡£
c:Ò»µ©ËùÓеÄÓû§¶Ï¿ªÁ¬½Ó£¬²Å½øÐйرգ¬Ð¶ÔØÊý¾Ý¿â£¬²¢ÖÕֹʵÀý¡£
Ó°Ï죺µÈºÜ¾Ã¡£
transactional:
a:×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó,ͬʱ×èÖ¹²úÉúеÄÊÂÎñ¡£
b:µÈ´ýδÌá½»µÄʵÎñ£¬Ìá½»Íê±Ïºó£¬ÇжÏÓû§µÄÁ¬½Ó¡£
c:Ò»µ©ËùÓеÄÓû§¶Ï¿ªÁ¬½Ó£¬²Å½øÐйرգ¬Ð¶ÔØÊý¾Ý¿â£¬²¢ÖÕֹʵÀý¡£
Ó°Ï죺×îºÃµÄ¹Ø±ÕÊý¾Ý¿âµÄ·½Ê½¡£
immediate:
a:×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó,ͬʱ×èÖ¹²úÉúеÄÊÂÎñ¡£
b:ÈκÎδÌá½»µÄʵÎñ¶¼»á±»»Ø¹ö¡£
c:Oracle²»ÔٵȴýÓû§Ö÷¶¯¶Ï¿ªÁ¬½Ó£¬¶øÊÇÖ±½Ó¹Ø±Õ¡¢Ð¶ÔØÊý¾Ý¿â£¬²¢ÖÕֹʵÀý¡£
Ó°Ï죺ÓÐЩ


Ïà¹ØÎĵµ£º

OracleÊý¾Ý¿âÉè¼Æ

Êý¾ÝownerºÍÊý¾Ý²Ù×÷ÕßÒÔ¼°´úÂë·ÃÎÊʹÓò»Í¬µÄÓû§·ÃÎÊ£¬Ê¹ÓÃÊÚȨµÄ·½Ê½½øÐзÃÎÊ¡£
Êý¾Ý±í´´½¨Ê±Ê¹ÓÃͬÒå´Ê´´½¨
ÊÚȨʱ×îºÃ²»ÒªÊ¹ÓÃwith grant option
ÒÔǰ²»Ì«Ã÷°×ͬÒå´ÊµÄʹÓã¬ÏÖÔÚÖªµÀÁË¡£±È½ÏºÃµÄÓ¦ÓþÍÊÇ´´½¨±íµÄ±ðÃû
create public ͬÒå´Ê tableName for owner.tableName
 ¸øÊÓͼÊÚȨ¿ÉÒÔʹµÃÓû§·ÃÎʲ»¾ß ......

Oracle Listener ·þÎñ²»ÄÜÆô¶¯µÄÁíÒ»·¢ÏÖ

    ×î½üʱ¼ä£¬¸ü»»ÁËÏîÄ¿×飬×î½üͻȻ·¢ÏÖOracle Listener²»ÄÜÆô¶¯¡£ÒÔǰ·¢ÏÖ²»ÄÜÆô¶¯µÄÔ­ÒòÊÇ£¬ÖØ×°ÁËOracleºóûÓÐɾ³ýÒÔǰµÄ×¢²á±í£¬ÒÔÖÁÓÚĬÈÏÆô¶¯·þÎñµÄÃüÁîÎļþÖ¸ÏòµÄÒÀÈ»ÊÇÒÔǰµÄλÖã¬ËùÒÔ²»ÄÜÆô¶¯£¬µ«Õą̂µçÄÔµÄOracleÖ»×°ÁËÒ»´Î¡£
    ×òÌìͻȻ·¢ÏÖ£¬ÔÚlistener.oraÎļþÖеÄHostÅ ......

oracleÖеĽÇÉ«


oracle
ÖеĽÇÉ«
Ò»¡¢ºÎΪ½ÇÉ«£¿
¡¡¡¡ÎÒÔÚÇ°ÃæµÄƪ·ùÖÐ˵Ã÷ȨÏÞºÍÓû§¡£ÂýÂýµÄÔÚʹÓÃÖÐÄã»á·¢ÏÖÒ»¸öÎÊÌ⣺Èç¹ûÓÐÒ»×éÈË£¬
ËûÃǵÄËùÐèµÄȨÏÞÊÇÒ»ÑùµÄ£¬µ±¶ÔËûÃǵÄȨÏÞ½øÐйÜÀíµÄʱºò»áºÜ²»·½±ã¡£ÒòΪÄãÒª¶ÔÕâ×éÖеÄÿ¸öÓû§µÄȨÏÞ¶¼½øÐйÜÀí¡£
¡¡¡¡ÓÐÒ»¸öºÜºÃµÄ½â¾ö°ì·¨¾Í
ÊÇ£º½ÇÉ«¡£½ÇÉ«ÊÇÒ»×éȨÏ޵ļ¯ºÏ£¬½«½ÇÉ«¸³ ......

Àí½âoracleÖÐÁ¬½ÓºÍ»á»°

1.
     
¸ÅÄͬ£º
Á¬½ÓÊÇÖ¸ÎïÀíµÄ¿Í
»§¶Ëµ½oracle·þÎñ¶ËµÄÁ¬½Ó¡£Ò»°ãÊÇͨ¹ýÒ»¸öÍøÂçµÄÁ¬½Ó¡£
ÔÚÒѽ¨Á¢µÄÁ¬½Ó
ÉÏ£¬½¨Á¢¿Í»§¶ËÓëoracle
µÄ»á»°£¬ÒÔºó¿Í
»§¶ËÓëoracle
µÄ½»»¥¶¼ÔÚÒ»¸ö»á»°»·¾³ÖÐ
½øÐС£
2.  
¹ØÏµÊǶà¶Ô¶à£º[ͬÒâÍøÓѵÄÒâ¼û£¬Ó¦¸ÃÊÇ1¶Ô
¶à¡£Ò»¸ö»á»°ÒªÃ´ ......

oracleÆô¶¯¹ý³Ì

Æô¶¯¸÷¸öģʽµÄ¹ý³Ì£º
1.nomount ----¶Á²ÎÊýÎļþ---À©ÄÚ´æ/Æô½ø³Ì£¨Ö÷ÒªÊÇÖØ½¨¿ØÖÆÎļþ£©
2.mount ------¶Á²ÎÊýÎļþ---ÕÒ¿ØÖÆÎļþ---¿ª¿ØÖÆÎļþ---ÕÒÊý¾ÝÎļþ/ÈÕÖ¾ÎļþλÖÃÓëÃû³Æ---ÁªÏµÊµÀýÓëÊý¾Ý¿â
  £¨Ö÷ÒªÊǻָ´Êý¾Ý¿â£©
3.open--------´ò¿ªÊý¾ÝÎļþ---´ò¿ªÈÕÖ¾Îļþ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ