Add the following info into the listener.ora file
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME=LinkPollTStage)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/gtw_1)
(PROGRAM=dg4msql)
)
(SID_DESC =
(SID_NAME=LinkPollETLControl)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/gtw_1)
(PROGRAM=dg4msql)
)
(SID_DESC =
(SID_NAME=LinkPollETLControl2)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/gtw_1)
(PROGRAM=dg4msql)
)
(SID_DESC =
(SID_NAME=LinkPollDimETL)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/gtw_1)
(PROGRAM=dg4msql)
)
(SID_DESC =
(SID_NAME=LinkPollFactETL)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/gtw_1)
(PROGRAM=dg4msql)
)
)
Stop and start the listener
Add the following files to the /u01/app/oracle/product/11.2.0/gtw_1/dg4msql/admin/ directory
initLinkPollDimETL.ora
initLinkPollETLControl2.ora
initLinkPollETLControl.ora
initLinkPollFacETL.ora
initLinkPollTStage.ora
initLinkPollDimETL.ora – Contents
HS_FDS_CONNECT_INFO=[172.18.92.9]:1433//dimetl
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
initLinkPoll ETLControl2.ora – Contents
HS_FDS_CONNECT_INFO=[172.18.92.9]:1433//etlcontrol2
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
initLinkPoll ETLControl.ora – Contents
HS_FDS_CONNECT_INFO=[172.18.92.9]:1433//etlcontrol
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
initLinkPollFactETL.ora – Contents
HS_FDS_CONNECT_INFO=[172.18.92.9]:1433//factetl
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
initLinkPollFactETL.ora – Contents
HS_FDS_CONNECT_INFO=[172.18.92.9]:1433//factetl
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
initLinkPollTStage.ora – Contents
HS_FDS_CONNECT_INFO=[172.18.92.9]:1433//tstage
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
Add the following entries into the tnsnames.ora file
##########ADDING TNSNAMES FOR Heterogeneous services
LinkPollFactETL=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = 10.24.0.11))
)
(CONNECT_DATA = (SID = LinkPollFactETL))
(HS=OK)
)
LinkPollETLControl2=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = 10.24.0.11))
)
(CONNECT_DATA = (SID = LinkPollETLControl2))
(HS=OK)
)
LinkPollTStage=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = 10.24.0.11))
)
(CONNECT_DATA = (SID = LinkPollTStage))
(HS=OK)
)
LinkPollETLControl=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = 10.24.0.11))
)
(CONNECT_DATA = (SID=LinkPollETLControl))
(HS=OK)
)
LinkPollDimETL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = 10.24.0.11))
)
(CONNECT_DATA = (SID = LinkPollDimETL ))
(HS=OK)
)
DimETL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = 10.24.0.11))
)
(CONNECT_DATA = (SID = DimETL ))
(HS=OK)
)