1.
Create multiple initSID.ora
inithsodbc.ora
HS_FDS_CONNECT_INFO = hsodbc
HS_FDS_TRACE_LEVEL = 0
initz.ora
HS_FDS_CONNECT_INFO = z
HS_FDS_TRACE_LEVEL = 0
2.
(SID_DESC =
(SID_NAME = hsodbc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = hsodbc)
)
(SID_DESC =
(SID_NAME = z)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = hsodbc)
)
3.
HSODBC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA = (SID = hsodbc))
(HS = OK)
)
z =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA = (SID = z))
(HS = OK)
)
4.
CREATE DATABASE LINK hsodbc USING 'hsodbc';
CREATE DATABASE LINK z USING 'z';
source : https://knowledgebase.progress.com/articles/Article/6177
