¡¶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-
Ïà¹ØÎĵµ£º
Ï൱ÓÚalias(±ðÃû),±ÈÈç°Ñuser1.table1ÔÚuser2Öн¨Ò»¸öͬÒå´Êtable1
create synonym table1 for user1.table1;
ÕâÑùµ±ÄãÔÚuser2Öвéselect * from table1ʱ¾ÍÏ൱ÓÚ²éselect * from user1.table1;
Óŵã×Ô¼º×ܽá°É¡£
ÀýÈ磺
ÔÚoracleÖжÔÓû§µÄ¹ÜÀíÊÇʹÓÃȨÏ޵ķ½Ê½À´¹ÜÀíµÄ£¬Ò²¾ÍÊÇ˵£¬Èç¹ûÎÒÃÇÏëʹÓÃÊý¾Ý¿â£¬ÎÒà ......
ÿ¸ô¼¸ÃëÖÓlistenerÈÕÖ¾ÖоͳöÏÖÒ»´Î¸Ã´íÎóµÄ¼Ç¼£¬¼´Ê¹ÊÇÔÚûÓÐÈËʹÓõÄÇé¿öÏÂÒ²ÊÇÈç´Ë£¬²»¹ý²¢Ã»Óз¢ÏÖ¿Í»§¶Ë»úÆ÷²»ÄÜÕý³£Á¬½ÓÊý¾Ý¿âµÄÇé¿ö¡£
Oracle¹ØÓÚTNS-12502´íÎóµÄ½âÊÍ:
Error: ORA-12502 / TNS-12502
Text: TNS:listener received no CONNECT_DATA from client
Cause: No CONNECT_DATA was ......
Êý¾Ý¿âµÄÄÚ´æ½á¹¹£º
Memory structures are allocated to the Oracle instance when the instance is started.
The two major memory structures are known as the System Global Area(Also called the shared
Global Area)and the Program Global Area(also called the Private Global Area or the ......
The following items are available in the network listener configuration file (listener.ora).
* Listener Address Section
* SID_LIST_listener_name Static Service Section
* Control Parameters
The listener.ora file is located in $ORACLE_HOME/n ......
±¾ÉíÕâ¸ö²½ÖèºÜ¶à¸ßÊÖ¶¼ÒѾÌù¹ýÁË£¬Ö»ÊÇÎÒÔÚʹÓÃÖз¢ÏÖ´óÌåÉÏ´ó¼ÒдµÄ¶¼ÓÐЩ¸´ÔÓ£¬ÓÚÊÇ£¬ÎÒ×ܽáÁ˸ö³¬¼¶¼ò»¯°æµÄ£¬·½±ã´ó¼ÒʹÓãº
1.°²×°LOGMNR°ü£¬ÐèÒª±¾²½Öèûʲô¿É¶à˵µÄ£¬Ö»ÊÇÐèҪעÒâÔÚÁ¬½ÓÊý¾Ý¿âµÄʱºòĬÈÏ×îºÃʹÓñ¾µØÑéÖ¤·½Ê½
C:\>sqlplus /nolog
SQL> conn / as sysdba
SQL> @D:\oracle\product\10 ......