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

oracleÔ¶³ÌÁ¬½Óµ¼Èëµ¼³öÊý¾Ý¿â

·½Ê½Ò».
Ö´ÐÐÒÔÏÂsqlÓï¾ä´´½¨database link
create database link test_link  --Á´½ÓÃû
  connect to   Óû§Ãû   identified by ÃÜÂë
  using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Êý¾Ý¿â·þÎñÆ÷µØÖ·)(PORT = ¶Ë¿Ú))   –-¶Ë¿ÚĬÈÏ1521
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ctaiscs)    --oracle9iÒÔºóÍÆ¼öʹÓÃÈ«¾ÖÊý¾Ý¿âÃû
    )
  )'
SERVICE_NAME=ctais£¬¿ÉÒÔʹÓà SID = Êý¾Ý¿âSIDµÄ·½Ê½
Ok,ÏÖÔھͿÉÒÔ²éѯԶ³ÌÊý¾Ý¿â£»
Select *  from  employee@test_link
·½Ê½¶þ
a)ÅäÖ÷þÎñÃüÃû
´ò¿ªC:\Oracle\ora92\network\admin\ tnsnames.ora,Ìí¼Ó·þÎñÃüÃû
·þÎñÃû =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.6.30.12)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = È«¾ÖÊý¾Ý¿âÃû)  --Ò²¿ÉÓÃSID=Êý¾Ý¿âSID
    )
 )
b)н¨Êý¾Ý¿âÁ¬½Ó
create database link test_link  --Á´½ÓÃû
  connect to   Óû§Ãû   identified by ÃÜÂë
  using '·þÎñÃû'
ÏÂÃæµÄ´¦Àí·½Ê½Ò»ÑùÁË
ÏÂÃæ¸øÒ»¸öÁ´½ÓÔ¶³ÌÊý¾Ý¿âµ¼ÈëÊý¾ÝµÄÀý×Ó
Create or replace procedure test_proc
IS
Begin
     for x  in (select * from dj_nsrxx@test_link)
     loop
          insert into  dj_nsrxx values  x;
     end loop;
     commit;
end test_proc
³É¹¦Àý×Ó£º
# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
MAXIMO =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = wangjun)(PORT = 1521))
    (CONNECT_DATA =
   &nb


Ïà¹ØÎĵµ£º

OracleÊý¾ÝÎļþµÄÌØÐÔ

ÎÒÃÇ´ó¼Ò¶¼ÖªµÀÿ¸öOracleÊý¾Ý¿â¶¼»áÓÐÒ»¸ö»òÊǶà¸öÎïÀíµÄOracleÊý¾ÝÎļþ,Êý¾Ý¿âÐÅÏ¢(½á¹¹,Êý¾Ý)µÄÖ÷Òª×÷ÓÃÊÇÀ´±£´æÔÚÕâЩÏà¹ØµÄÊý¾ÝÎļþ,¶øÇÒÖ»ÓÐÕâЩÏà¹ØµÄÎļþOracle²ÅÄܹ»½âÊÍÓë¹ÜÀíÕâЩ´æ´¢.OracleÊý¾ÝÎļþ¾ßÓÐÒÔÏÂÒ»Ð©ÌØÐÔ:
1.Ò»¸öÊý¾ÝÎļþ½ö½ö¹ØÁªÒ»¸öÊý¾Ý¿â,OracleÊý¾ÝÎļþÓëÊý¾Ý¿âÖ®¼ä¶ÔÓ¦¹ØÏµÊÇÒ»¶ÔÒ»¹ØÏµ,µ±È»· ......

LinuxϵͳÏÂOracle¼à¿Ø¹¤¾ß

1£®top
topÃüÁî¿ÉʵʱµØÏÔʾLinuxϵͳµÄ½ø³Ì¡¢CPU¡¢ÄÚ´æ¡¢¸ºÔصȵÄÐÅÏ¢¡£ËüÊÇÎÒÃÇÁ˽âϵͳÕûÌå״̬×îºÃµÄ¹¤¾ß¡£
topÃüÁîµÄÔËÐÐ״̬ÊÇÒ»¸öʵʱµÄÏÔʾ¹ý³Ì£¬ÎÒÃÇ¿ÉÔÚÕâ¸ö½çÃæ¼à¿ØÏµÍ³ÔËÐÐÇé¿ö¡£ÎÒÃÇ¿Éͨ¹ý¼¸¸ö°´¼üÀ´¿ØÖÆtopÃüÁÈç°´q¿ÉÍ˳ötopÃüÁî״̬£¬°´s¿ÉÊäÈëÐÅÏ¢µÄ¸üÐÂÆµÂʵȡ£ÕâЩÃüÁî¿É°´h°ïÖú¼ü²éѯ¡£
2£®Ps ......

Oracle ·Çϵͳ±í¿Õ¼ä'noncrit ' ÎÞ·¨Ê¹ÓÃϵͳ»ØÍ˶Î

Ò»£º»Ø¹ö¶Î¸ÅÊö
¡¡¡¡»Ø¹ö¶ÎÓÃÓÚ´æ·ÅÊý¾ÝÐÞ¸Ä֮ǰµÄÖµ£¨°üÀ¨Êý¾ÝÐÞ¸Ä֮ǰµÄλÖúÍÖµ£©¡£»Ø¹ö¶ÎµÄÍ·²¿°üº¬ÕýÔÚʹÓõĸûعö¶ÎÊÂÎñµÄÐÅÏ¢¡£Ò»¸öÊÂÎñÖ»ÄÜʹÓÃÒ»¸ö»Ø¹ö¶ÎÀ´´æ·ÅËüµÄ»Ø¹öÐÅÏ¢£¬¶øÒ»¸ö»Ø¹ö¶Î¿ÉÒÔ´æ·Å¶à¸öÊÂÎñµÄ»Ø¹öÐÅÏ¢¡£
»Ø¹ö¶ÎµÄ×÷ÓÃ
¡¡¡¡ÊÂÎñ»Ø¹ö£ºµ±ÊÂÎñÐ޸ıíÖÐÊý¾ÝµÄʱºò£¬¸ÃÊý¾ÝÐÞ¸ÄǰµÄÖµ£¨¼´Ç°Ó°Ïñ£ ......

oracle ½âËøÓû§ÒÔ¼°ÖØÐÂÉèÖÃÓû§ÃÜÂë

ÔÚ°²×°ÍêOracle 10gÖ®ºó£¬Ïë´ò¿ªsql*plusÀ´Ñ§Ï°£¬È»ºó°´ÕÕÊéÉϵIJ½ÖèÓÃscottÓû§À´Á¬½ÓÊý¾Ý¿â£¬¿ÉÊäÁ˺ü¸´Î¶¼Ìáʾһ¸ö´íÎó¡£
¡¡¡¡error£º the account is locked
¡¡¡¡È»ºóÉÏÍø²éÁËÒ»ÏÂÖ®ºó·¢ÏÖÕâ¸öÓû§±»Ëø¶¨ÁË£¬ÖÁÓÚËüΪʲô±»Ëø¶¨£¬¿ÉÄÜÊÇÏÂÃæ¼¸¸öÔ­Òò¡£
¡¡¡¡1.³¢ÊÔ¶à´ÎµÇ¼δ³É¹¦.(¿ÉÄÜÃÜÂë²»ÕýÈ·)
¡¡¡¡2.´ËÓû§±»¹ ......

oracle°²×°

°²×°…………
ÒýÓõÄhttp://mamaoyuan625.javaeye.com/blog/617502
°²×°oracle 10gºó£¬µÇ¼ ³öÏÖ
the account is locked
Õâ¸ö´íÎ󼸺õËùÓеijõѧÕß¶¼»áÓöµ½.
Æäʵ½â¾ö°ì·¨·Ç³£¼òµ¥.
ÇëÊäÈëÓû§Ãû:  SYSTEM
ÊäÈë¿ÚÁî:admin(×¢Òâ,Õâ¸öÃÜÂëÊÇÄãÔÚ°²×°oracleʱµÚÒ»²½ÉèÖõÄ)
È»ºóϵͳ»áÏÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ