標籤:
TNS Setting:
DEV5.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.1.50.90)
(PORT=1541)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SID=DEV5)
)
)
DEV6.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.1.50.90)
(PORT=1542)
)
(CONNECT_DATA=
(SERVICE_NAME=DEV6)
)
)
DEV7.VIASYSTEMS.PRI=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=amfgora1.viasystems.pri)
(PORT=1543)
)
(CONNECT_DATA=
(SID=DEV7)
)
)
TST5.VIASYSTEMS.PRI=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=amfgora1.viasystems.pri)
(PORT=1545)
)
(CONNECT_DATA=
(SID=TST5)
)
)
TST7.VIASYSTEMS.PRI=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=amfgora1.viasystems.pri)
(PORT=1547)
)
(CONNECT_DATA=
(SID=TST7)
)
)
PRDE.VIASYSTEMS.PRI=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=amfgora3.viasystems.pri)
(PORT=1591)
)
(CONNECT_DATA=
(SID=PRDE)
)
)
CASAMP.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=aphkdb04)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=CASAMP)
)
)
CASAMP_DB08.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.110.1.150)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=CALIVE)
)
)
CAIES.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.110.1.28)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=CAIES)
)
)
CAFIN.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.110.1.32)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=CAFIN)
)
)
CALIVE.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.110.1.32)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=CALIVE)
)
)
HKSAMP.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=aphkdb04)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=HKSAMP)
)
)
HKDEMO.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.110.1.28)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=HKDEMO)
)
)
HKIES.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=aphkdb04)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=HKIES)
)
)
HKIESUAT.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=aphkdb05-1)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=HKIES)
)
)
HKFIN.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.110.1.32)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=HKFIN)
)
)
HKLIVE.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.110.1.32)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=HKLIVE)
)
)
GZSAMP.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.120.80.9)
(PORT=1522)
)
(CONNECT_DATA=
(SERVICE_NAME=GZSAMP)
)
)
GZDEMO.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.135.1.11)
(PORT=1522)
)
(CONNECT_DATA=
(SERVICE_NAME=GZDEMO)
)
)
GZIES.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=apgzdb18.viasystems.pri)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=gzies.viasystems.pri)
)
)
GZFIN.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.120.1.18)
(PORT=1522)
)
(CONNECT_DATA=
(SERVICE_NAME=GZFIN)
)
)
GZLIVE.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.120.1.12)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=GZLIVE)
)
)
ZSSAMP.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=apzsdb06)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=ZSSAMP)
)
)
ZSDEMO.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.125.1.8)
(PORT=1522)
)
(CONNECT_DATA=
(SERVICE_NAME=ZSDEMO)
)
)
ZSIES.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.125.1.18)
(PORT=1522)
)
(CONNECT_DATA=
(SERVICE_NAME=ZSIES)
)
)
ZSFIN.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.125.1.6)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=ZSFIN)
)
)
ZSLIVE.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.125.1.6)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=ZSLIVE)
)
)
SCMP.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.110.1.35)
(PORT=1531)
)
(CONNECT_DATA=
(SERVICE_NAME=SCMP)
)
)
SCMP_UAT.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.110.1.90)
(PORT=1521)
)
(CONNECT_DATA=
(SERVICE_NAME=oracle)
)
)
VIAUAT_APHKDB07.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=APHKDB07)
(PORT=1542)
)
(CONNECT_DATA=
(SERVICE_NAME=VIAUAT)
)
)
VIAPROD_APHKDB06.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=aphkdb06.viasystems.com)
(PORT=1541)
)
(CONNECT_DATA=
(SID=VIAPROD)
)
)
VIAPROD_APHKDB07.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=aphkdb07.viasystems.com)
(PORT=1541)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SID=VIAPROD)
)
)
PRCFA.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.110.1.35)
(PORT=1551)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SID=PRCFA)
)
)
COGNOS.VIASYSTEMS.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.110.1.102)
(PORT=1522)
)
(CONNECT_DATA=
(SERVICE_NAME=COGNOSTD)
)
)
Oracle EBS - TNS