# Integrated System tnsnames.ora file. Updated  11/1/2012

# Production IBM
iprod = (DESCRIPTION=
          (ADDRESS=(PROTOCOL=tcp)(HOST=e1prdc1.admin.Virginia.EDU)(PORT=1611))
          (CONNECT_DATA=(SID=isp11))
       )

# ODS IBM
iods = (DESCRIPTION=
          (ADDRESS=(PROTOCOL=tcp)(HOST=e1odpc1.admin.Virginia.EDU)(PORT=1611))
          (CONNECT_DATA=(SID=isp11))
       )

# QA Test IBM
isq01 = (DESCRIPTION=
          (ADDRESS=(PROTOCOL=tcp)(HOST=e2qatc1.admin.virginia.edu)(PORT=1611))
          (CONNECT_DATA=(SID=isq01))
        )

# ODS Test IBM
odstest = (DESCRIPTION=
          (ADDRESS=(PROTOCOL=tcp)(HOST=e2odtc1.admin.Virginia.EDU)(PORT=1611))
          (CONNECT_DATA=(SID=isq01))
       )

# Dev1 IBM
isd10 = (DESCRIPTION=
          (ADDRESS=(PROTOCOL=tcp)(HOST=e2devc1.admin.Virginia.EDU)(PORT=1593))
          (CONNECT_DATA=(SID=isd10))
         )

# Dev2 IBM
isd20 = (DESCRIPTION=
          (ADDRESS=(PROTOCOL=tcp)(HOST=e2devc2.admin.Virginia.EDU)(PORT=1583))
          (CONNECT_DATA=(SID=isd20))
         )

CSRPT = (DESCRIPTION =
   (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = spdr1.admin.Virginia.edu)(PORT = 1630))
   )
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = CSRPT))
   )
CSRPQ = (DESCRIPTION =
   (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = spdr1.admin.Virginia.edu)(PORT = 1630))
   )
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = CSRPQ))
   )
CSDEV =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sndd1.admin.virginia.edu)(PORT = 1630))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = CSDEV)
    )
  )
CSTST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sndd1.admin.virginia.edu)(PORT = 1630))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = CSTST)
    )
  )