Tnsnames.ora

From Web3us, LLC

This is the contents of the file tnsnames.ora in the Oraclehome/network/admin directory.

# TNSNAMES.ORA Network Configuration File: C:\orant9d\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

BVDEV_IBIS =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ibis)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = bvdev)
      (SERVER = DEDICATED)
    )
  )

DES =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = grackle)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SID = des)
      (ORACLE_HOME = /opt/oracle/8.1.7)
      (SERVER = DEDICATED)
    )
  )

BVDEV =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ibis)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = bvdev)
      (SERVER = DEDICATED)
    )
  )

CRDEV =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ibis)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = CRDEV)
      (SERVER = DEDICATED)
    )
  )

CRTST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(Host = beast)(Port = 1521))
    )
    (CONNECT_DATA =
      (SID = CRTST)
      (SERVER = DEDICATED)
    )
  )

DW8 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = shemp)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = dw8)
      (ORACLE_HOME = /opt/oracle/817_64)
      (SERVER = DEDICATED)
    )
  )

DW82 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = shemp)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = dw8)
      (SERVER = DEDICATED)
    )
  )

BVPRD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ODYSSEY)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = bvprd)
    )
  )

CRPRD = 
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ODYSSEY)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = crprd)
    )
  )