DBA Hub

📋Steps in this guide1/1

create db link w/o modifying tnsnames.ora

create public database link IMFP connect to iwf identified by thr3iwf USING '(DESCRIPTION=(ADDRESS_LIST=( ADDRESS=(PROTOCOL=TCP)(HOST=testoracle.com)(PORT=1522))) (CONNECT_DATA=(SERVICE_NAME=IMFP)))';

oracle configurationintermediate
by OracleDba
11 views
1

create db link w/o modifying tnsnames.ora

Code/Command (click line numbers to comment):

1
2
3
4
create public database link IMFP connect to iwf identified by thr3iwf USING
'(DESCRIPTION=(ADDRESS_LIST=(
ADDRESS=(PROTOCOL=TCP)(HOST=testoracle.com)(PORT=1522)))
(CONNECT_DATA=(SERVICE_NAME=IMFP)))';

Comments (0)

Please to add comments

No comments yet. Be the first to comment!