Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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²ÎÊýÖÐÖ¸¶¨¶à¸ö·þÎñÖµ£¬ÖµÖ®¼äÓöººÅ¸ñ¿ª£¬Õâ¶ÔÓÚ¹²Ïí·þÎñÆ÷ÅäÖÃÊǺÜÓÐÓõġ£
¡¡¡¡¶¯Ì¬×¢²áĬÈÏÖ»×¢²áµ½Ä¬Èϵ


Ïà¹ØÎĵµ£º

Oracle dead lock deep research.

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³£Óú¯Êý,sybase³£Óú¯Êý

oracle³£Óú¯Êý-----------------------------------------------
SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(’A’) A,ascii(’a’) a,ascii(’0’) zero,ascii(’ ’) space from dual;
A A ZERO SPACE
--------- --------- - ......

Oracle IO ²âÊÔ¹¤¾ßORION

Ò»Ö±ÏëѧϰÈçºÎµÃµ½Êý¾Ý¿âµÄ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Ö»²âÊ ......

Oracle³£ÓòÙ×÷±Ê¼Ç

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 ......

Windos Ï Oracle Êý¾Ý¿â¹ÜÀí


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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ