Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

11g DBLink Optimization

user12002352May 13 2011
Hi

I'm hoping someone can assist me in to properly configure the Oracle Listener. I currently have a front side interface that clients use today, which I don't what to change. I a second interface enabled with jumbo frames that I would like to use for the DBLink. I have two hosts that share the same switch and both sides have jumbo frames enabled. Is the following correct for the listener.ora?
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = abe-hpsp-02)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

ADR_BASE_LISTENER = /oracle/hpsp/base

LISTENER_DBLINK =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.255.10)(PORT = 1521))
)
)
)

SID_LIST_LISTENER_DBLINK =
(SID_LIST =
(SID_DESC =
(SDU = 9000)
(TDU = 9000)
(SID_NAME = hpsp)
(GLOBAL_DBNAME = hpsp)
)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 10 2011
Added on May 13 2011
0 comments
158 views