Oracle³õѧ±Ê¼Ç(1)
°²×°Oracleºó£¬¸ü¸ÄWindows¼ÆËã»úÃû£¬µ¼Ö²¿·ÖOracleµÚÈý·½¹¤¾ß£¬Èç:PLSQL
DeveloperÎÞ·¨µÇ½£¬²¢ÌáʾORA-12541:TNS:no listener»òORA-12547:TNS:¶ªÊ§ÁªÏµµÈ´íÎóÐÅÏ¢µÄ½â¾ö·½·¨¡£
´ð£º´ÓOracleµÄ´íÎóÌáʾÀ´¿´,ÊÇ˵TNS:no listener
£¬¹À¼ÆÊÇijÖÖ·þÎñûÓÐÆô¶¯£¬´ò¿ªwindows¹ÜÀí¹¤¾ß->·þÎñ£¬Ò»¿´£¬ÓÐÒ»¸öOracleOraHome90TNSListenerÕâÑùµÄ·þÎñ£¬
ºÍ´íÎóÐÅÏ¢ÌâÊÇÒ»Ö£¬»ù±¾¾Í¿ÉÒԿ϶¨ÊÇÕâ¸ö·þÎñËùÒý·¢µÄÎÊÌâ¡£ÔÙÒ»¿´£¬¸Ã·þÎñûÓÐÆô¶¯£¬ËìÊÖ¹¤Æô¶¯£¬Ë¢ÐºóÒ»¿´£¬¸Ã·þÎñ¾ÓÈ»ÂíÉϾÍ×Ô¶¯¹Ø±ÕÁË¡£ÖØÊÔN´Î£¬
½á¹ûÒ»Ñù¡£µ½GoogleËÑË÷¿´¿´£¬Ã»Ïëµ½Õ⻹ÊÇÒ»¸öÆÕ±éµÄÎÊÌ⣬ÓÐÒ»¸öÈËÌá³ö£¬°Ñ°²×°Ä¿Â¼ÏµÄlistener.ora´ò¿ª²ì¿´¡£
È磺d:\oracle\ora90\network\admin\listener.ora¡£
´ò¿ª¸ÃÅäÖÃÎļþºó·¢ÏÖÈçÏÂÒ»¶ÎÅäÖÃÐÅÏ¢£º
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = local)(PORT = 1521))
)
)
)
µ±¿´µ½ÕâÒ»ÐÐHOST=local
µÄʱºò£¬ÎÊÌâ½â¾öÁË¡£ÔÀ´ÊÇÓÉÓÚ¼¸Ìì×°ºÃOracleºó£¬ÓÖ¸ÄÁËWindowsµÄ¼ÆËã»úÃû£¬¶øÕâ¸öÅäÖÃÎļþÖмǼµÄ¼àÌýÖ÷»úÃû»¹ÊÇÔÀ´µÄÃû³Æ£¬ÕâÒ²¾Í¹Ö²»
µÃ£¬OracleOraHome90TNSListener·þÎñÎÞ·¨Æô¶¯ÁË£¬ÂíÉÏÐÞ¸ÄΪÏÖÔڵļÆËã»úÃû£¬ÔÙ´ÎÆô¶¯
OracleOraHome90TNSListener·þÎñ³É¹¦£¬PL/SQL DeveloperÁ¬½ÓOracleÊý¾Ý¿â³É¹¦£¬²»Äܵǽ¹ÊÕÏÅųý¡£
Ïà¹ØÎĵµ£º
¾Û¼¯(cluster)ÊÇ´æ´¢±íÊý¾ÝµÄ¿ÉÑ¡ÔñµÄ·½·¨¡£Ò»¸ö¾Û¼¯ÊÇÒ»×é±í£¬½«¾ßÓÐͬһ¹«¹²ÁÐÖµµÄÐд洢ÔÚÒ»Æ𣬲¢ÇÒËüÃǾ³£Ò»ÆðʹÓá£ÕâЩ¹«¹²Áй¹³É¾Û¼¯Âë¡£
¾³£±»Í¬Ê±·ÃÎʵıíÔÚÎïÀíλÖÃÉÏ¿ÉÒÔ´æ´¢ÔÚÒ»Æð¡£ÎªÁ˽«ËüÃÇ´æ´¢ÔÚÒ»Æ𣬾ÍÒª´´½¨Ò»¸ö´Ø( c l u s t e r )À´¹ÜÀíÕâЩ±í¡£±íÖеÄÊý¾ÝÒ»Æð´æ´¢ÔÚ´ØÖУ¬´Ó¶ø×îС»¯±ØÐëÖ´ÐеÄI ......
1 ¾Û¼¯(cluster)
1.1 ¸ÅÄ
ÓÃÓÚ½«²»Í¬±íÖеÄÊý¾Ý´æ´¢µ½ÏàͬµÄÎïÀíÊý¾Ý¿éÖУ¬ÓÃÓÚ¶à±íÊý¾ÝÐèҪƵ·±½øÐÐÁªºÏ²éѯµÄÇé¿öÏ¡£¶à±íÊý¾Ý´æ´¢ÔÚÏàͬÊý¾Ý¿éºó£¬ÔÚ¶Ô¶Ô±í½øÐÐÁªºÏ²éѯʱ£¬ËùÐè¶ÁÈ¡µÄÎïÀí¿éÊý¼õÉÙ£¬´Ó¶øÌá¸ß²éѯÐÔÄÜ¡£
ÐèҪעÒâµÄÊǶԾۼ¯Öе¥±íµÄ²éѯºÍ¶Ô¾Û¼¯ÖбíÊý¾Ý½øÐÐÐ޸Ļò²åÈëµÈÊÂÎñ²Ù×÷ʱ£¬ÐÔÄܽ«Ê ......
Ò»£®Ïà¹ØµÄ¸ÅÄî
RowidµÄ¸ÅÄrowidÊÇÒ»¸öαÁУ¬¼ÈÈ»ÊÇαÁУ¬ÄÇôÕâ¸öÁоͲ»ÊÇÓû§¶¨Ò壬¶øÊÇϵͳ×Ô¼º¸ø¼ÓÉϵġ£¶Ôÿ¸ö±í¶¼ÓÐÒ»¸örowidµÄαÁУ¬µ«ÊÇ
±íÖв¢²»ÎïÀí´æ´¢ROWIDÁеÄÖµ¡£²»¹ýÄã¿ÉÒÔÏñʹÓÃÆäËüÁÐÄÇÑùʹÓÃËü£¬µ«ÊDz»ÄÜɾ³ý¸ÄÁУ¬Ò²²»ÄܶԸÃÁеÄÖµ½øÐÐÐ޸ġ¢²åÈë¡£Ò»µ©Ò»ÐÐÊý¾Ý²åÈëÊý¾Ý¿â£¬Ôò
rowidÔÚ¸ÃÐ ......
About parent vs child latches. There is no fundamental low level difference between parent and child latches, they are all small regions of memory modified with atomic test-and-set style opcodes.
You see parent (and solitary) latches from x$ksll ......
Õâ¸öOracleµÄ·ÖÒ³ÏÔʾ¾Ý˵ÊÇ×îÂé·³µÄ£¨MySQL×î¼òµ¥£©£¬µ«ÊÇÕâ¸ö·ÖÒ³ÏÔʾºÜÓÐÓá£ÏÖÔںܶàÍøÕ¾ÉϵÄÌõÄ¿¶¼·Ç³£¶à£¬ÀýÈçÐÂÎÅ£¬¿ÉÄܾ͸ոüеľÍÓÐÉÏ°ÙÌõ£¬ÔÙ¼ÓÉÏÒÔÇ°µÄ£¬Ò»ÕÅÒ³Ãæ¿Ï¶¨¾ÍÊǷŲ»ÏÂÁË£¬ËùÒÔ·ÖÒ³µÄºÃ´¦¾ÍÊÇ¿ÉÒÔ½â¾öÕâ¸öÎÊÌâ¡£
ÏÂÃæÒ»ÅÅÅŵĽÐÄãÑ¡ÔñµÚ¼¸Ò³£¬Ò»Ñ¡Ôñ£¬Ö±½Ó¾ÍÌøµ½ºóÃæµÄ¼¸Ò³È¥ÁË£¬²»ÓÃÕâÑù´ÓÉÏÒ ......