Oracle Listener ¶¯Ì¬×¢²á Óë ¾²Ì¬×¢²á
Ò»£®Ê²Ã´ÊÇ×¢²á
×¢²á¾ÍÊǽ«Êý¾Ý¿â×÷Ϊһ¸ö·þÎñ×¢²áµ½¼àÌý³ÌÐò¡£¿Í»§¶Ë²»ÐèÒªÖªµÀÊý¾Ý¿âÃûºÍʵÀýÃû£¬Ö»ÐèÒªÖªµÀ¸ÃÊý¾Ý¿â¶ÔÍâÌṩµÄ·þÎñÃû¾Í¿ÉÒÔÉêÇëÁ¬½Óµ½Êý¾Ý¿â¡£Õâ¸ö·þÎñÃû¿ÉÄÜÓëʵÀýÃûÒ»Ñù£¬Ò²ÓпÉÄܲ»Ò»Ñù¡£
¡¡¡¡ÔÚÊý¾Ý¿â·þÎñÆ÷Æô¶¯¹ý³ÌÖУ¬Êý¾Ý¿â·þÎñÆ÷»áÏò¼àÌý³ÌÐò×¢²áÏàÓ¦µÄ·þÎñ£¨ÎÞÂÛºÎʱÆô¶¯Ò»¸öÊý¾Ý¿â£¬Ä¬Èϵض¼ÓÐÁ½ÌõÐÅÏ¢×¢²áµ½¼àÌýÆ÷ÖУºÊý¾Ý¿â·þÎñÆ÷¶ÔÓ¦µÄʵÀýºÍ·þÎñ¡££©
¡¡¡¡Ï൱ÓÚÊÇÕâÑù£ºÔÚÊý¾Ý¿â·þÎñÆ÷ºÍ¿Í»§¶ËÖ®¼äÓÐÒ»¼àÌý³ÌÐò£¨Listener£©£¬ÔÚ¼àÌý³ÌÐòÖУ¬»á¼Ç¼ÏàÓ¦Êý¾Ý¿â¶ÔÓ¦µÄ·þÎñÃû£¨Ò»¸öÊý¾Ý¿â¿ÉÄܶÔÓ¦Óжà¸ö·þÎñÃû£©£¬µ±¿Í»§¶ËÐèÒªÁ¬½ÓÊý¾Ý¿âʱ£¬Ö»ÐèÒªÌṩ·þÎñÃû£¬¾Í¿ÉÒÔ½¨Á¢¿Í»§¶ËºÍ·þÎñÆ÷Ö®¼äµÄÁ¬½Ó¡£
¡¡¡¡
¶þ¡¢¶¯Ì¬×¢²á
¡¡¡¡¶¯Ì¬×¢²áÊÇÔÚinstanceÆô¶¯µÄʱºòPMON½ø³Ì¸ù¾Ýinit.oraÖеÄinstance_name,service_namesÁ½¸ö²ÎÊý½«ÊµÀýºÍ·þÎñ¶¯Ì¬×¢²áµ½listenerÖС£
¡¡¡¡Ê×ÏÈÒªÔÚinit.oraÖÐÖ¸¶¨instance_name,service_namesÁ½¸ö²ÎÊýµÄÖµ¡£ÔÚsqlplusÏÂͨ¹ýshow parameter service_names ºÍshow parameter instance_name¿ÉÒԲ鿴ÕâÁ½¸ö²ÎÊýµÄÖµ¡£
¡¡¡¡×¢²áµ½¼àÌýÆ÷ÖеÄʵÀýÖµ´Óinit.oraÎļþÖеÄinstance_name²ÎÊýÈ¡µÃ¡£Èç¹û¸Ã²ÎÊýûÓÐÉ趨ֵ£¬ÄÇôËü½«È¡init.oraÎļþÖеÄdb_nameµÄÖµ¡£Èç¹ûÔÚRACÖÐÅäÖã¬Äú±ØÐ뽫¼¯ÈºÖÐÿ¸öʵÀýµÄinstance_name²ÎÊýÉèÖÃΪһ¸öΨһµÄÖµ¡£
¡¡¡¡×¢²áµ½¼àÌýÆ÷ÖеķþÎñÖµ´Óinit.oraÎļþÖеIJÎÊýservice_namesÈ¡µÃ¡£Èç¹û¸Ã²ÎÊýûÓÐÉ趨ֵ£¬Êý¾Ý¿â½«Æ´½Óinit.oraÎļþÖÐµÄ db_nameºÍdb_domainµÄÖµÀ´×¢²á×Ô¼º¡£Èç¹ûÑ¡ÔñÌṩservice_namesÖµ£¬Äú¿ÉÒÔʹÓÃÍêÈ«ÏÞ¶¨µÄÃû³Æ£¨±ÈÈç orcl.oracle.com)»òËõдµÄÃû³Æ£¨±ÈÈçorcl£©¡£Èç¹ûÑ¡ÔñËõдµÄÃû³Æ²¢ÉèÖÃÁËdb_domain²ÎÊý£¬×¢²áµ½¼àÌýÆ÷ÖеķþÎñ½«ÊÇ service_nameÖµºÍdb_domainÖµµÄÆ´½Ó¡£ÀýÈçÏÂÃæµÄÉèÖý«µ¼Ö·þÎñorcl.oracle.com±»×¢²áµ½¼àÌýÆ÷ÖУº
db_domain=oracle.com
service_names=orcl ;
¡¡¡¡²ÉÈ¡¶¯Ì¬×¢²á·½·¨Ê±£¬listener.oraÖеÄÄÚÈÝÈçÏ£º
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
¡¡¡¡¿ÉÑ¡ÔñµÄÊÇ£¬Äú¿ÉÒÔÔÚservice_names²ÎÊýÖÐÖ¸¶¨¶à¸ö·þÎñÖµ£¬ÖµÖ®¼äÓöººÅ¸ñ¿ª£¬Õâ¶ÔÓÚ¹²Ïí·þÎñÆ÷ÅäÖÃÊǺÜÓÐÓõġ£
¡¡¡¡¶¯Ì¬×¢²áĬÈÏÖ»×¢²áµ½Ä¬Èϵ
Ïà¹ØÎĵµ£º
ʲôÊÇË®Ïß(High Water Mark)?
----------------------------
ËùÓеÄoracle¶Î(segments£¬ÔÚ´Ë£¬ÎªÁËÀí½â·½±ã£¬½¨Òé°Ñsegment×÷Ϊ±íµÄÒ»¸öͬÒå´Ê) ¶¼ÓÐÒ»¸öÔÚ¶ÎÄÚÈÝÄÉÊý¾ÝµÄÉÏÏÞ£¬ÎÒÃÇ°ÑÕâ¸öÉÏÏÞ³ÆΪ"high water mark"»òHWM¡£Õâ¸öHWMÊÇÒ»¸ö±ê¼Ç£¬ÓÃÀ´ËµÃ÷ÒѾÓжàÉÙûÓÐʹÓõÄÊý¾Ý¿é·ÖÅä¸øÕâ¸ösegment¡£HWMͨ³£Ôö³¤µÄ·ù¶ ......
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_PINYIN_M');
¡¡¡¡-- °´²¿Ê×ÅÅÐò
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_STROKE_M');
¡¡¡¡-- °´±Ê»ÅÅÐò
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_RADICAL_M');
¡¡¡¡--ÅÅÐòºó»ñÈ¡µÚ ......
C#ʹÓÃSystem.Data.OracleClientÁ¬½ÓOracleÊý¾Ý¿â¡£Ö®Ç°ÔÚWinXPÉÏÕý³£ÔËÐеijÌÐòÒÆÖ²µ½ Windows 2008 x64ÉÏÖ®ºó¾ÍÁ¬²»ÉÏÊý¾Ý¿âÁË£¬´íÎóÐÅÏ¢ÈçÏ£º
³¢ÊÔ¼ÓÔØ Oracle¿Í»§¶Ë¿âʱÒý·¢BadImageFomatException¡£Èç¹ûÔÚ°²×°32λOracle¿Í»§¶Ë×é¼þµÄÇé¿öÏÂÒÔ64λģʽÔËÐУ¬½«³öÏÖ´ËÎÊÌâ¡£
´íÎóÔÒòÊÇÔÀ´WinXP»ú×ÓÉÏËù°²×°µÄOrac ......
WindowsÏÂORACLE 10g°²×°Óë²Ù×÷ͼ½â
¸Õ¸Õ½Ó´¥ORACLEµÄÈËÀ´Ëµ,´ÓÄÇÀïѧ,ÈçºÎѧ,ÓÐÄÇЩ¹¤¾ß¿ÉÒÔʹÓÃ,Ó¦¸ÃÖ´ÐÐʲô²Ù×÷,Ò»¶¨»Ø¸Ðµ½ÎÞÖú¡£ËùÒÔÔÚѧϰʹÓÃORACLE֮ǰ£¬Ê×ÏÈÀ´°²×°Ò»ÏÂORACLE 10g£¬ÔÚÀ´ÕÆÎÕÆä»ù±¾¹¤¾ß¡£Ë×»°ËµµÄºÃ£º¹¤ÓûÉÆÆäÊ£¬±ØÏÈÀûÆäÆ÷¡£ÎÒÃÇ¿ªÊ¼°É£¡
¡¡¡¡Ê×ÏȽ«ORACLE 10gµÄ°²×°¹âÅÌ·ÅÈë¹âÇý£¬Èç¹û×Ô¶¯ÔËÐÐ ......
ѪҺÃ÷ϸ±íÈçÏ£º
create table "blood"."OC_CarryOrderD" (
ID nvarchar2(20) &n ......