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

oracle database link

Êý¾Ý¿âÖ®¼äµÄÁ´½Ó½¨Á¢ÔÚDATABASE LINKÉÏ¡£Òª´´½¨Ò»¸öDB LINK£¬±ØÐëÏÈ
ÔÚÿ¸öÊý¾Ý¿â·þÎñÆ÷ÉÏÉèÖÃÁ´½Ó×Ö·û´®¡£ 
1¡¢   Á´½Ó×Ö·û´®¼´·þÎñÃû£¬Ê×ÏÈÔÚ±¾µØÅäÖÃÒ»¸ö·þÎñÃû£¬µØÖ·Ö¸ÏòÔ¶³ÌµÄÊý¾Ý¿âµØÖ·£¬·þÎñÃûȡΪ½«À´ÄãҪʹÓõÄÊý¾Ý¿âÁ´Ãû£º
2¡¢´´½¨Êý¾Ý¿âÁ´½Ó£¬
½øÈëϵͳ¹ÜÀíÔ±SQL>²Ù×÷·ûÏ£¬ÔËÐÐÃüÁ
SQL>create public database link beijing connect to scott identified by tiger
         using 'tobeijing';
Ôò´´½¨ÁËÒ»¸öÒÔscottÓû§ºÍ±±¾©Êý¾Ý¿âµÄÁ´½Óbeijing£¬ÎÒÃDzéѯ±±¾©µÄscottÊý¾Ý:
SQL>select * from emp@beijing;
ÕâÑù¾Í¿ÉÒÔ°ÑÉîÛںͱ±¾©scottÓû§µÄÊý¾Ý×ö³ÉÒ»¸öÕûÌåÀ´´¦Àí¡£
3¡¢½¨Á¢Í¬Òå´Ê£¬ÎªÁËʹÓйطֲ¼Ê½²Ù×÷¸ü͸Ã÷£¬ORACLEÊý¾Ý¿âÀïÓÐͬÒå´ÊµÄ¶ÔÏósynonym
SQL>create synonym bjscottemp for emp@beijing;
ÓÚÊǾͿÉÒÔÓÃbjscottempÀ´Ìæ´ú´ø@·ûºÅµÄ·Ö²¼Ê½Á´½Ó²Ù×÷emp@beijing¡£
4¡¢²é¿´ËùÓеÄÊý¾Ý¿âÁ´½Ó£¬½øÈëϵͳ¹ÜÀíÔ±SQL>²Ù×÷·ûÏ£¬ÔËÐÐÃüÁ
SQL>select owner,object_name from dba_objects where object_type='DATABASE LINK';
¸ÕºÃÓõ½, È¡Ïûdblink
3¡¢²é¿´Êý¾Ý¿âÁ¬½Ó
sql> select owner, db_link from dba_db_links;
ower db_link
public TEST.US.ORACLE.COM
4¡¢É¾³ýÊý¾Ý¿âÁ¬½Ó
ÏÈ´ÓµÚÈý²½Öв鿴Êý¾Ý¿âÁ¬½Ó£¬È¡µÃÆädb_linkµÄÃû³Æ
sql>drop public database link TEST.US.ORACLE.COM
Êý¾Ý¿âÁ¬½ÓËȶªÆú
±ÈÈ磺ÔÚÒ»¸öÊý¾Ý¿âBÖзÃÎÊÊý¾Ý¿âAÖÐµÄ±í£º
1.ÔÚÊý¾Ý¿âBÖд´½¨Êý¾Ý¿âÁ´£º
CREATE PUBLIC DATABASE LINK Êý¾Ý¿âÁ´½ÓÃû CONNECT TO Óû§Ãû identified by ÃÜÂë using 'Á¬½Ó˵Ã÷'
ÆäÖУ¬Á¬½Ó˵Ã÷±ØÐëΪÈçϸñʽ£º
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.142.10.201)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME=ORCL)
)
)
2.·ÃÎÊÁ´½ÓÊý¾Ý¿âÖеĶÔÏóµÄÓï·¨£º
Óû§Ãû.Êý¾Ý¿â¶ÔÏó@Êý¾Ý¿âÁ´½ÓÃû
3.²é¿´ËùÓеÄÊý¾Ý¿âÁ´½Ó£º
select owner,object_name from dba_objects where object_type='DATABASE LINK';
4.Àý×Ó£º
´´½¨Ò»¸öÊý¾Ý¿âÁ´½Ó£º
CREATE PUBLIC DATABASE LINK DBL_ORCL CONNECT TO province identified by province_pwd
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.142.10.201)(PORT = 1521))
)
(CON


Ïà¹ØÎĵµ£º

Oracle¼¼ÊõÈËÔ±ÇóÖ°ÃæÊÔÌ⼯½õ

±¾ÎÄÊÇOracle¼¼ÊõÈËÔ±ÇóÖ°ÃæÊÔÌ⼯½õ£¬´ð°¸½ö¹©²Î¿¼……
¡¡¡¡1. ½âÊÍÀ䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
¡¡¡¡½â´ð£ºÈȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐģʽµÄÊý¾Ý¿â¡£Èȱ¸·ÝµÄÓŵãÔÚÓÚµ±±¸·Ýʱ£¬Êý¾Ý¿âÈԾɿÉÒÔ±»Ê¹Óò¢ÇÒ¿ ......

(ת)oracle 10g xe Îҵݲװʵ¼ù¼°¼òµ¥ÅäÖùý³Ì

Îҵݲװ¹ý³Ì
1¡¢±à¼­ /etc/apt/sources.list £º
    sudo cp /etc/apt/sources.list /etc/apt/sources.list.bak #±¸·Ý
    sudo gedit /etc/apt/sources.list
    ¼ÓÈëÏÂÃæÕâ¸öÔ´£º
        deb http://oss.oracle.com/debian unst ......

Oracle 11g R1 for Linux(RHEL5)°²×°

1 ¡¢°²×°Ç°µÄ×¼±¸
1.1 ¼ì²éÓ²¼þ
ÎïÀíÄڴ棺 # grep MemTotal /proc/meminfo
½»»»¿Õ¼ä£º # grep SwapTotal /proc/meminfo
½»»»¿Õ¼äµÄ´óСÊǸù¾ÝÎïÀíÄÚ´æµÄ´óСÀ´ÉèÖõģ¬ÎïÀíÄÚ´æÉÙÓÚ 2G µÄÔò½»»»¿Õ¼äÉèΪÎïÀíÄÚ´æµÄÁ½±¶£¬ÎïÀíÄÚ´æ´óÓÚ 2G µÄÔò½»»»¿Õ¼äºÍÎïÀíÄÚ´æ´óСһÑù¡£Èç¹û²»·ûºÏÉÏÊö¹æ¶¨£¬ÄÇô¾ÍÐèÒªÖØÐÂÉèÖý ......

ora_01034:oracle not available±¨´í ½â¾ö·½·¨

ÒòΪǿÖƹػú£¬¿ª»úµÄʱºò½øÈëÊý¾Ý¿â±¨´í£º
ora_01034:oracle not available
ora_27101:shared memory realm does not exit
½â¾ö·½·¨£º
1.´ò¿ªCMD
2.ÊäÈë sqlplus "/as sysdba"
3.»Ø³µ
4.ÊäÈë startup
5.½áÊø ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ