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

¡¶Oracle DBAÊּǡ· 24СʱСÑùµ½ÊÖ


×÷Õߣºeygle |English Version ¡¾×ªÔØÊ±ÇëÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷¡¿
Á´½Ó£ºhttp://www.eygle.com/archives/2010/01/oracle_dba_notebook.html
½ñÌ죬ÊÕµ½Á˳ö°æÉç¿ìµÝ¶øÀ´µÄ¡¶Oracle DBAÊּǡ·Ò»ÊéµÄ24СʱСÑù£¬Õâ¸öСÑùͨ¹ýÖ®ºó£¬Êé¾Í¿ÉÒÔ³ÉÅúÓ¡Ë¢£¬Ö¸ÈÕ¿É´ýÁË¡£×î¿ìµÄ¹À¼ÆÊÇÏÂÖÜ¿ÉÒÔÉÏÊÐÁË¡£
Äõ½Õâ±¾Êéʱ£¬ÐÄÀïµÄ¸Ð¾õÊÇÒìÑù¶øÐÀϲµÄ¡£ÖÜÀÏʦ˵Ëý·ÅÏÂÐÄÀ´£¬ÎÒµÄÐÄÈ´ÊÇÌø¶¯ÆðÀ´¡£
µ±ÎÒ¶ÁÁËÑîСÇÚ£¨²©ÎÄÊÓµãÉè¼Æ×ܼ࣬±¾ÊéÃÀ±à£©µÄÉè¼ÆË¼Â·Ê±£¬Ã÷°×ÁËÕâÖÖÒìÑùµÄÀ´Ô´¡£Õâ±¾ÊéµÄÃû×ÖÀïÓÐÊÖ¼ÇÁ½¸ö×Ö£¬ËùÒÔСÇÚ½«Êé±¾µÄÉè¼Æ´´Ò⳯×Å"¼Çʱ¡"µÄ·½Ïò·¢É¢£¬ÎÒÄÃÔÚÊÖÉϵÚÒ»¸öÒìÑùµÄ¸Ð¾õ¾ÍÊÇÓɴ˶øÀ´£º·Â·ðÊÇÒ»¸ö±Ê¼Ç±¾Ò»ÑùÊìϤ£¬Ã»ÓÐÊé±¾µÄÉúÓ²¡£
ÎÒϸϸÌåζÁËСÇÚµÄÉè¼ÆË¼Â·£¬Ïë²»µ½·âÃæµÄÿһ¸öÔªËØ¶¼ÊÇ×ÔÓÐÆäº¬ÒåµÄ¾«ÐÄ֮˼£¬Õâ¾ÍÊÇÉè¼Æ£¬ÎÒ´Ó²»ÊìϤµÄÁìÓòµÃµ½ÁËÉè¼ÆµÄÖʸкʹ¥ÊÖÄÇÒ»¿ÌÉè¼Æ¸øÎҵĶîÍâÌåÑé¡£
ÐÀϲÀ´×ÔÓÚÊé¼®µÄÅŰæÓëÓ¡Ë¢£¬ÇåÎú¡¢ÇåÐãµÄ°åʽ£¬´úÂëµÄ´¦Àí£¬Í¼Æ¬µÄÅÅÁУ¬ÉõÖÁÿ¸öÕ½ڵIJ¼¾Ö£¬¶¼ÊǾ«ÐÄÉè¼ÆµÄ£¬ÕâÒ»ÇÐÔ¶Ô¶³¬³öÎÒµÄÔ¤ÆÚ£¬KamusÔÙҲûÓÐÀíÓɳ°Ð¦ÎÒµÄÊé¶¼ÊÇ´òÓ¡°æµÄWordÎĵµÁË¡£ÄÇÒ»¿ÌµÄÐÀϲÈÃÎÒ²úÉúÁËÔÙдһ±¾ÊéµÄ³å¶¯£¬Èç¹ûÒ»±¾ÊéÄÜÏñÒÕÊõÆ·Ò»°ã¾«Ö£¬ÍêÈ«»á¼¤·¢×÷ÕߵĴ´ÔìÈÈÇé¡£
Õâ¾ÍÊÇÎÒÄõ½Õâ±¾ÑùÊéµÄÁ½¸ö¸Ð¾õ£¬¸Õ¸Õ×øÔÚɳ·¢ÉÏ£¬¶ÁÁËÀÏÑîµÄһƪÎÄÕ£¬Éî¸ÐÔĶÁµÄÀÖȤ¡£
ÏÖÔÚ£¬Õâ¸ö¼ÒÀïÒѾ­ÓÐÕâÑùÒ»ÞûÊé±¾ÁË£º
¶¨ÏèÔÚÊéÄ©¼ÇÐðÁËÕâ±¾ÊéµÄµ®Éú¹ý³Ì£¬¶ÔÕÕÎÒÔÚǰÑÔÀïµÄÃèÊö£¬´ó¼Ò¿ÉÒÔÁ˽âÕâ±¾ÊéµÄǰÊÀ½ñÉú¡£¸Ðл²©ÎÄ´ó¼Ò»ïµÄÐÁ¿àÈÏÕæ£¬²ÅÓÐÁËÕâ±¾ÁîÎҸе½ÒìÑùºÍÐÀϲµÄÊé¡£
˵ʵ»°Õâ±¾ÊéµÄ³ö°æ¹ý³ÌÔø¾­ÈÃÎҸе½Èß³¤£¬¶øÇÒ×îºóÔÚDeadlineʱ°Ñ²»ÉÙѹÁ¦Áô¸øÁËÎÒ£¬µ«ÊÇÏÖÔÚ¿´ÆðÀ´Ò»ÇÐŬÁ¦¶¼ÊÇÖµµÃµÄ¡£
×öÒ»±¾¶ÔµÃÆð¶ÁÕßµÄÊ飬³ö°æÉçÒѾ­Íê³ÉÁËËûÃǵÄÖ°Ôð£¬Ê£ÏµľÍÊÇÊé±¾µÄÄÚÈÝÁË£¬Õ⣬Ҫ¿¿ÎÒÃÇÎå¸öÐÖµÜÈ¥½ÓÊܶÁÕߵļìÑé¡£Ok£¬We are Ready£¡
-The End-


Ïà¹ØÎĵµ£º

Oracle±í¿Õ¼ä¹ÜÀí

extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î»      --segment    management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......

Oracle ʱ¼ä²Ù×÷´óÈ«

ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ãë
¡¡¡¡sysdate+(5/24/60/60)
¡¡¡¡ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5·ÖÖÓ
¡¡¡¡sysdate+5/24/60
¡¡¡¡ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Сʱ
¡¡¡¡sysdate+5/24
¡¡¡¡ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ìì
¡¡¡¡sysdate+5
¡¡¡¡ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5ÔÂ
¡¡¡¡add_months(sysdate,-5)
¡¡¡¡ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Äê
¡¡¡¡add_months ......

oracleͬÒå´Ê

Ï൱ÓÚalias(±ðÃû),±ÈÈç°Ñuser1.table1ÔÚuser2Öн¨Ò»¸öͬÒå´Êtable1
create synonym table1 for user1.table1;
ÕâÑùµ±ÄãÔÚuser2Öвéselect * from table1ʱ¾ÍÏ൱ÓÚ²éselect * from user1.table1;
Óŵã×Ô¼º×ܽá°É¡£
ÀýÈ磺
ÔÚoracleÖжÔÓû§µÄ¹ÜÀíÊÇʹÓÃȨÏ޵ķ½Ê½À´¹ÜÀíµÄ£¬Ò²¾ÍÊÇ˵£¬Èç¹ûÎÒÃÇÏëʹÓÃÊý¾Ý¿â£¬ÎÒà ......

oracle 10gÏÂÔØµØÖ·

¼Ç¼һÏÂORACLE 10gR2µÄÈí¼þÏÂÔØµØÖ·£¬±¸Óá£
ÏÂÔØOTNÉϵÄÕâЩÈí¼þ£¬ÄãÐèÒªÒ»¸öOTNÃâ·ÑÕʺţ¬²»¹ýÈç¹ûͨ¹ýѸÀ×½øÐÐÏÂÔØ£¬¾Í²»ÓõǽOTNÁË£º
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database ......

Oracle ListenerµÄTNS 12502´íÎó

ÿ¸ô¼¸ÃëÖÓlistenerÈÕÖ¾ÖоͳöÏÖÒ»´Î¸Ã´íÎóµÄ¼Ç¼£¬¼´Ê¹ÊÇÔÚûÓÐÈËʹÓõÄÇé¿öÏÂÒ²ÊÇÈç´Ë£¬²»¹ý²¢Ã»Óз¢ÏÖ¿Í»§¶Ë»úÆ÷²»ÄÜÕý³£Á¬½ÓÊý¾Ý¿âµÄÇé¿ö¡£
   Oracle¹ØÓÚTNS-12502´íÎóµÄ½âÊÍ:
Error: ORA-12502 / TNS-12502
Text: TNS:listener received no CONNECT_DATA from client
Cause: No CONNECT_DATA was ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ