Computer

DB LINK

알 수 없는 사용자 2010. 8. 12. 02:11

EPS_T =
  (DESCRIPTION =
    (ADDRESS_LIST =
    (LOAD_BALANCE = ON)
    (FAILOVER = YES)
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.88.27)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.88.26)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEFICATED)
      (SERVICE_NAME = OBU)
      (FAILOVER_MODE =
        (TYPE = SELECT)(METHOD = BASIC))
    )
  )


CREATE DATABASE LINK EPSLNK6
 CONNECT TO QCS IDENTIFIED BY QCS
 USING 'EPS_T';


DB link 때문에 하루를 날렸다 .. 아오 !!!



CREATE DATABASE LINK dblink명
 CONNECT TO id IDENTIFIED BY password
 USING 'tnsnames에서세팅해준tnsnames';



ㅡ,.ㅡ SID 너 좀 맞자.....