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²ÎÊýÖÐÖ¸¶¨¶à¸ö·þÎñÖµ£¬ÖµÖ®¼äÓöººÅ¸ñ¿ª£¬Õâ¶ÔÓÚ¹²Ïí·þÎñÆ÷ÅäÖÃÊǺÜÓÐÓõġ£
¡¡¡¡¶¯Ì¬×¢²áĬÈÏÖ»×¢²áµ½Ä¬Èϵ
Ïà¹ØÎĵµ£º
ÌìÓв»²â·çÔÆ£¬
IBM µÄÖж˴ÅÅÌÕóÁÐÕâ´ÎÓÖÈÇ»öÁË¡£ÔÚ΢ÂëÉý¼¶µÄʱºò£¬
DS4800 ·¢Éú¹ÊÕÏ¡£IBM¹¤³Ìʦ°ÑÕóÁйÊÕϻָ´ºó£¬ÅÄÅÄƨ¹É×ßÈË£¬ÁôÏÂÁËÕóÁÐÉϲ»Ò»ÖµÄÊý¾Ý¡£
û°ì·¨£¬ÕóÁÐÉϵÄÊý¾ÝÓÖµÃÎÒÃÇÀ´Ïë°ì·¨ÇÀ¾ÈÁË¡£¡£¡£¡£
»¹ºÃÓÐoracle supportµÄÖ§³ÖÎÒÃÇ×îÖÕ»¯½âÁËÕâ´ÎΣ»ú¡£ÏÂÎÄÏêϸ½éÉÜÁËÕû¸ö»Ö¸´µÄ¹ý³Ì¡£
&nbs ......
C#ʹÓÃSystem.Data.OracleClientÁ¬½ÓOracleÊý¾Ý¿â¡£Ö®Ç°ÔÚWinXPÉÏÕý³£ÔËÐеijÌÐòÒÆÖ²µ½ Windows 2008 x64ÉÏÖ®ºó¾ÍÁ¬²»ÉÏÊý¾Ý¿âÁË£¬´íÎóÐÅÏ¢ÈçÏ£º
³¢ÊÔ¼ÓÔØ Oracle¿Í»§¶Ë¿âʱÒý·¢BadImageFomatException¡£Èç¹ûÔÚ°²×°32λOracle¿Í»§¶Ë×é¼þµÄÇé¿öÏÂÒÔ64λģʽÔËÐУ¬½«³öÏÖ´ËÎÊÌâ¡£
´íÎóÔÒòÊÇÔÀ´WinXP»ú×ÓÉÏËù°²×°µÄOrac ......
дЩ»ù´¡µÄ! ¶Ô×Ô¼º»¹ÊÇÓкô¦µÄ.
shutdownÓÐËĸö²ÎÊý£ºnormal¡¢transactional¡¢immediate¡¢abort¡£È±Ê¡²»´øÈκβÎÊýʱ±íʾÊÇnormal
Ò»:
shutdown normal:
²»¶Ï¿ªÏÖÔÚÁ¬½ÓµÄÓû§,×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó£¬°üÀ¨¹ÜÀíÔ±ÔÚÄÚ¡£ÒѾÁ¬½ÓµÄÓû§Äܹ»¼ÌÐøËûÃǵ±Ç°µÄ¹¤×÷,ÈçµÝ½»ÐµĸüÐÂÊÂÎñ,Ö±µ½´ËÓ ......
²éѯµ±Ç°Ê¹ÓõÄÓαêÊý¾Ý£ºselect count(*) from v$open_cursor
²éѯµ±Ç°×î´óÓαêÊý£ºshow parameter open_cursors;
ÐÞ¸Ä×î´óÓαêÊý£ºalter system set open_cursors=1000 scope=spfile;
=========================================================
²éѯµ±Ç°×î´ó»á»°Êý£ºshow parameter sessions;
ÐÞ¸Ä×î´ó»á»°Êý£ºalt ......
ѪҺÃ÷ϸ±íÈçÏ£º
create table "blood"."OC_CarryOrderD" (
ID nvarchar2(20) &n ......