magritton
6/9/2014 - 3:35 PM

tnsnames.ora entries for Oracle

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)
            )
        )