tnsnames.ora entries for Oracle
# C:\ORACLE\ORA92A\NET80\ADMIN\TNSNAMES.ORA Configuration File:C:\oracle\ora92a\net80\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant
DEV =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = opwdbs04.opwftg.com)(PORT = 1581))
(CONNECT_DATA = (SID = dev))
)
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = OPWDBS01.OPWFTG.COM)(PORT = 1571))
)
(CONNECT_DATA =
(SID = test)
)
)
PROD =
(DESCRIPTION =
(address = (protocol = tcp)(host = OPWDBS10.OPWFTG.COM)(port = 1521))
(CONNECT_DATA = (SID = prod))
)
SBY =
(DESCRIPTION =
(address = (protocol = tcp)(host = opwsby01.opwftg.com)(port = 1521))
(CONNECT_DATA = (SID = prod))
)
FNDFS_OPWAPS10 =
(description=
(address=(protocol=tcp)(host=opwaps10.opwftg.com)(port=1626))
(connect_data=
(sid=fndfs)
)
)
FNDFS_OPWAPS10.OPWFTG.COM =
(description=
(address=(protocol=tcp)(host=opwaps10.opwftg.com)(port=1626))
(connect_data=
(sid=fndfs)
)
)
FNDFS_OPWAPS11 =
(description=
(address=(protocol=tcp)(host=opwaps11.opwftg.com)(port=1626))
(connect_data=
(sid=fndfs)
)
)
FNDFS_OPWAPS11.OPWFTG.COM =
(description=
(address=(protocol=tcp)(host=opwaps11.opwftg.com)(port=1626))
(connect_data=
(sid=fndfs)
)
)
FNDFS_OPWAPS12 =
(description=
(address=(protocol=tcp)(host=opwaps12.opwftg.com)(port=1626))
(connect_data=
(sid=prod)
)
)
FNDFS_OPWAPS12.OPWFTG.COM =
(description=
(address=(protocol=tcp)(host=opwaps12.opwftg.com)(port=1626))
(connect_data=
(sid=prod)
)
)
VAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = OPWDBS03.OPWFTG.COM)(PORT = 1591))
)
(CONNECT_DATA =
(SERVICE_NAME = VAL)
)
)
INSP=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.0.252)(PORT=1558))
(CONNECT_DATA=
(SERVICE_NAME=INSP)
(INSTANCE_NAME=INSP)
)
)# C:\ORACLE\ORA92A\NET80\ADMIN\TNSNAMES.ORA Configuration File:C:\oracle\ora92a\net80\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant
DEV =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = opwdbs04.opwftg.com)(PORT = 1581))
(CONNECT_DATA = (SID = dev))
)
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = OPWDBS01.OPWFTG.COM)(PORT = 1571))
)
(CONNECT_DATA =
(SID = test)
)
)
PROD =
(DESCRIPTION =
(address = (protocol = tcp)(host = opwdbs05.opwftg.com)(port = 1521))
(CONNECT_DATA = (SID = prod))
)
SBY =
(DESCRIPTION =
(address = (protocol = tcp)(host = opwsby01.opwftg.com)(port = 1521))
(CONNECT_DATA = (SID = prod))
)
FNDFS_OPWAPS10 =
(description=
(address=(protocol=tcp)(host=opwaps10.opwftg.com)(port=1626))
(connect_data=
(sid=fndfs)
)
)
FNDFS_OPWAPS10.OPWFTG.COM =
(description=
(address=(protocol=tcp)(host=opwaps10.opwftg.com)(port=1626))
(connect_data=
(sid=fndfs)
)
)
FNDFS_OPWAPS11 =
(description=
(address=(protocol=tcp)(host=opwaps11.opwftg.com)(port=1626))
(connect_data=
(sid=fndfs)
)
)
FNDFS_OPWAPS11.OPWFTG.COM =
(description=
(address=(protocol=tcp)(host=opwaps11.opwftg.com)(port=1626))
(connect_data=
(sid=fndfs)
)
)
FNDFS_OPWAPS12 =
(description=
(address=(protocol=tcp)(host=opwaps12.opwftg.com)(port=1626))
(connect_data=
(sid=prod)
)
)
FNDFS_OPWAPS12.OPWFTG.COM =
(description=
(address=(protocol=tcp)(host=opwaps12.opwftg.com)(port=1626))
(connect_data=
(sid=prod)
)
)
VAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = OPWDBS03.OPWFTG.COM)(PORT = 1591))
)
(CONNECT_DATA =
(SERVICE_NAME = VAL)
)
)
INSP=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=opwdbs11.opwftg.com)(PORT=1558))
(CONNECT_DATA=
(SERVICE_NAME=INSP)
(INSTANCE_NAME=INSP)
)
)