ÔÚOracleÖÐʵÏÖÊý¾Ý¿âµÄ¸´ÖÆ
ÔÚInternetÉÏÔË×÷Êý¾Ý¿â¾³£»áÓÐÕâÑùµÄÐèÇ󣺰ѱ鲼ȫ¹ú¸÷³ÇÊÐÏàËÆµÄÊý¾Ý¿âÓ¦ÓÃͳһÆðÀ´£¬Ò»¸ö½ÚµãµÄÊý¾Ý¸Ä±ä²»½öÌåÏÖÔÚ±¾µØ£¬»¹·´Ó³µ½Ô¶¶Ë¡£¸´ÖƼ¼Êõ¸øÓû§ÌṩÁËÒ»ÖÖ¿ìËÙ·ÃÎʹ²ÏíÊý¾ÝµÄ°ì·¨¡£
Ò»¡¢ÊµÏÖÊý¾Ý¿â¸´ÖƵÄǰÌáÌõ¼þ
1¡¢Êý¾Ý¿âÖ§³Ö¸ß¼¶¸´Öƹ¦ÄÜ
Äú¿ÉÒÔÓÃsystemÉí·ÝµÇ¼Êý¾Ý¿â£¬²é¿´v$optionÊÓͼ£¬Èç¹ûÆäÖÐAdvanced replicationΪTRUE£¬ÔòÖ§³Ö¸ß¼¶¸´Öƹ¦ÄÜ£»·ñÔò²»Ö§³Ö¡£
2¡¢Êý¾Ý¿â³õʼ»¯²ÎÊýÒªÇó
¢Ù¡¢db_domain = test.com.cn
Ö¸Ã÷Êý¾Ý¿âµÄÓòÃû(ĬÈϵÄÊÇWORLD)£¬ÕâÀï¿ÉÒÔÓÃÄú¹«Ë¾µÄÓòÃû¡£
¢Ú¡¢global_names = true
ËüÒªÇóÊý¾Ý¿âÁ´½Ó(database link)ºÍ±»Á¬½ÓµÄÊý¾Ý¿âÃû³ÆÒ»Ö¡£
ÏÖÔÚÈ«¾ÖÊý¾Ý¿âÃû£ºdb_name+”.”+db_domain
¢Û¡¢ÓиúÊý¾Ý¿âjobÖ´ÐÐÓйصIJÎÊý
job_queue_processes = 1
job_queue_interval = 60
distributed_transactions = 10
open_links = 4
µÚÒ»Ðж¨ÒåSNP½ø³ÌµÄÆô¶¯¸öÊýΪn¡£ÏµÍ³È±Ê¡ÖµÎª0£¬Õý³£¶¨Ò巶ΧΪ0¡«36£¬¸ù¾ÝÈÎÎñµÄ¶àÉÙ£¬¿ÉÒÔÅäÖò»Í¬µÄÊýÖµ¡£
µÚ¶þÐж¨Òåϵͳÿ¸ôNÃ뻽ÐѸýø³ÌÒ»´Î¡£ÏµÍ³È±Ê¡ÖµÎª60Ã룬Õý³£·¶Î§Îª1¡«3600Ãë¡£ÊÂʵÉÏ£¬¸Ã½ø³ÌÖ´ÐÐÍ굱ǰÈÎÎñºó£¬¾Í½øÈë˯Ãß״̬£¬Ë¯ÃßÒ»¶Îʱ¼äºó£¬ÓÉϵͳµÄ×ܿظºÔð½«Æä»½ÐÑ¡£
Èç¹ûÐÞ¸ÄÁËÒÔÉÏÕ⼸¸ö²ÎÊý£¬ÐèÒªÖØÐÂÆô¶¯Êý¾Ý¿âÒÔʹ²ÎÊýÉúЧ¡£
¶þ¡¢ÊµÏÖÊý¾Ý¿âͬ²½¸´ÖƵIJ½Öè
¼ÙÉèÔÚInternetÉÏÎÒÃÇÓÐÁ½¸öÊý¾Ý¿â£ºÒ»¸ö½ÐÉîÛÚ(shenzhen)£¬Ò»¸ö½Ð±±¾©(beijing)¡£
¾ßÌåÅäÖüûÏÂ±í£º
Êý¾Ý¿âÃû
shenzhen
beijing
Êý¾Ý¿âÓòÃû
test.com.cn
test.com.cn
Êý¾Ý¿âsidºÅ
shenzhen
beijing
Listener¶Ë¿ÚºÅ
1521
1521
·þÎñÆ÷ipµØÖ·
10.1.1.100
10.1.1.200
1¡¢È·ÈÏÁ½Ì¨Êý¾Ý¿âÖ®¼ä¿ÉÒÔ»¥Ïà·ÃÎÊ£¬ÔÚtnsnames.oraÀïÉèÖÃÊý¾Ý¿âÁ¬½Ó×Ö·û´®¡£
¢Ù¡¢ÀýÈ磺ÉîÛÚÕâ±ßµÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®ÊÇÒÔϵĸñʽ
beijing =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.200)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = beijing)
)
)
ÔËÐÐ$tnsping beijing
³öÏÖÒÔÏÂÌáʾ·û£º
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.200)(PORT=1521))
OK£¨nºÁÃ룩
±íÃ÷ÉîÛÚÊý¾Ý¿â¿ÉÒÔ·ÃÎʱ±¾©Êý¾Ý¿â¡£
¢Ú¡¢ÔÚ±±¾©ÄDZßҲͬÑùÅäÖã¬È·ÈÏ$tnsping shenzhen ÊÇͨµÄ¡£
2¡¢¸ÄÊý¾Ý¿âÈ«¾ÖÃû³Æ£¬½¨¹«¹²µÄÊý¾Ý¿âÁ´½Ó¡£
¢Ù¡¢ÓÃsystemÉí·ÝµÇ¼shenzhenÊý¾Ý¿â
SQL>alter database rename global_name to shenzh
Ïà¹ØÎĵµ£º
ºÜ¶àÅóÓÑÒªÎÒ°ïÃ¦ÍÆ¼öÒ»ÏÂOracleµÄÈëÃÅÊé¼®£¬Äܹ»Á˽âOracleµÄ»ù±¾¸ÅÄî¡¢»ù±¾ÖªÊ¶µÄÄÇÖÖ¡£
ÎÒ¾ÍÃâΪÆäÄÑ£¬ÍƼö¼¸±¾¡£
Ê×ÏÈÎÒÏëÇ¿µ÷µÄÒ»µãÊÇ£¬ÈκÎÒ»±¾ÏµÍ³µÄOracleÊé¼®Ö»ÒªÈÏÕæ¶ÁÏÂÀ´£¬¶¼»áÓв»´íµÄÊÕ»ñ£¬¶ÁÊé×î¼É»äµÄÊÇ»¢Í·Éßβ£¬Ç³³¢ÔòÖ¹¡£
1.µÚÒ»±¾ÒªÍƼö¸ø´ó¼ÒµÄÊÇOracleµÄ¸ÅÄîÊֲᣬÕâ±¾ÊÖ²áÊÇÎÞÊýDBAѧϰµÄÆðµã£ ......
ÎÒÓõÄÊÇCentos5.4 DVD¹âÅ̰²×°µÄlinux²Ù×÷ϵͳ£¬°²×°linuxµÄʱºòÑ¡ÉÏ¿ª·¢¹¤¾ß£¬Xmanager,ÓëÊý¾Ý¿âÏà¹ØµÄ°ü¡£
²Ù×÷ϵͳ°²×°Íê³ÉÖ®ºóÐèÒª½øÐÐһϵÁеÄÅäÖòÅÄܰ²×°oracle10g£¬ÏÂÃæ°ÑÖ÷Òª²½Öè¼Ç¼ÏÂÀ´¡£
1.°²×°Íê²Ù×÷ϵͳ֮ºó»¹ÊÇÓÐЩ°üûÓа²×°£¬È»¶ø°²×°oracle10gµÄʱºòÐèÒªÓõ½£¬Ã»Óа²×°µÄ°üÓÐ:
libXp-1.0.0-8.i386.rp ......
¶ÔÏó³Ö¾Ã»¯£¬Ò²¾ÍÊÇ¿ÉÒÔ°ÑÕâ¸ö¶ÔÏóÓÀÔ¶µÄ±£´æÆðÀ´£¬ÕâÀïµÄ±£´æ²»½öÊǶÔÏó±¾Éí£¬»¹°üÀ¨ËûµÄÊôÐÔºÍËùÒÀÀµµÄÆäËûÀࡣͨ³££¬¶ÔÏó¿ÉÒԳ־û¯µ½Îļþ»òÕßÊÇÊý¾Ý¿âÖС£ÎÒÕâÀïÖ»½éÉÜÈçºÎ½«¶ÔÏó´æ´¢µ½Êý¾Ý¿âÖС£Ç¡ÇÉOracleÊý¾Ý¿âΪÎÒÃÇÌṩÁËÕâÑùµÄ·½±ã¡£
ÔÚOracleÖУ¬ÓÐÒ»ÖÖblogµÄ×Ö¶ÎÀàÐÍ£¬ËüÊÇÓÃÀ´´æ´¢´óÁ¿µÄ¶ ......
ÏîÄ¿´ÓmysqlÇ¨ÒÆµ½ORACLEÖÐÓöµ½ÒÆÖ²ÎÊÌ⣬mysqlÖÐÖ§³Ölimit ¶øORACLE say no .
½â¾ö·½·¨ ÀûÓÃORACLEµÄαÁÐ rownumÀ´¿ØÖÆ¡£¡£
Mysql : select * from table limit 10
equl
ORACLE£º select * from table where rownum <= 10
ORACLE αÁнéÉÜ£º
ËæÊý¾Ý×ÖµäÒ»Æð×Ô¶¯´´½¨µÄÒ»¸ö±í,ÊôÓÚsysģʽ,ÈκÎÓû§¶¼¿ÉÒÔ·ÃÎÊ,&nbs ......