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 너 좀 맞자.....