Task:
In Database A, create a db-link connected to Database B.
Step 1:
In Database B: create user jbian identified by ***
grant connect, resource to jbian
Step 2:
In Database A:
cd $TNS_ADMIN
vi tnsnames.ora
add:
HIST = (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = amxp1-scan)(PORT = 1521)) (CONNECT_DATA = SERVER = DEDICATED) (SERVICE_NAME = HISTPROD)))
Step 3:
In Database A:
create database link HIST_BK connect to jbian identified by *** using ‘HIST’;
DB Link HIST_BK create succesfully
Test:
select SOA_ID from soa_bk@HIST_BK;