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²ÎÊýÖÐÖ¸¶¨¶à¸ö·þÎñÖµ£¬ÖµÖ®¼äÓöººÅ¸ñ¿ª£¬Õâ¶ÔÓÚ¹²Ïí·þÎñÆ÷ÅäÖÃÊǺÜÓÐÓõġ£
¡¡¡¡¶¯Ì¬×¢²áĬÈÏÖ»×¢²áµ½Ä¬Èϵ
Ïà¹ØÎĵµ£º
Update SQLS will lead dead lock exception. Because by default, it use optimistic lock but not pessimistic lock.
Below description is exceprted from the attachment(It exceeds my image that this blog can not upload the attachment,hehe)
Optimistic locking offers an elegant solution to the problems o ......
oracle³£Óú¯Êý-----------------------------------------------
SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(’A’) A,ascii(’a’) a,ascii(’0’) zero,ascii(’ ’) space from dual;
A A ZERO SPACE
--------- --------- - ......
Ò»Ö±ÏëѧϰÈçºÎµÃµ½Êý¾Ý¿âµÄIOÊý¾Ý£¬ORIONÊÇÒ»¸ö²»´íµÄ·ÂÕæ²âÊÔOracle IOµÄ¹¤¾ß¡£
ÏÂÃæÊÇÎҵIJâÊԵIJ½Ö裺
1 ´ÓoracleµÄÍøÕ¾ÉÏÏÂÔØORIONµÄÈí¼þ£¨11.1.0.7£©
2 ½âѹorion_linux_x86-64.gz
3 ½¨Á¢²ÎÊýÎļþ mytest.lun£¬ ÕâÀïµÄÁгöµÄÊÇ·ÖÇøÉ豸£¬ÎÒÔÚÉÏÃæ½¨Á¢ÁËasmÎļþϵͳ¡£ÒòΪÓÐÊý¾ÝÔÚÀïÃæ£¬ËùÒÔÎÒÓÃwrite=0Ö»²âÊ ......
select name from v$datafile;
create dataspace tablespace datafile '/oracle/oradata/orcl/data01.dbf' size 1024m,'/oracle/oradata/orcl/data02.dbf' size 1024m autoextend on next 100m maxsize unlimited;
alter tablespace dataspace add datafile '/oracle/oradata/orcl/da ......
1. ´´½¨ÐµÄÊý¾Ý¿âʵÀý£º
D:\oracle\product\10.2.0\admin\adidb\scripts>dbca
2.Æô¶¯ºÍ¹Ø±ÕʵÀý
D:\oracle\product\10.2.0\admin\adidb\scripts>net start oracleserviceorcl
D:\oracle\product\10.2.0\admin\adidb\scripts>net stop oracleserviceorcl
3.Á¬½ÓÊý¾Ý¿âʵÀý
1> ÉèÖÃoracle_sid (set o ......