# www.virginia.edu/integratedsystem # Updated 10/12/09. # Production 11.0.3 Apps instance prod = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=isp-db.admin.Virginia.EDU)(PORT=1565)) (CONNECT_DATA=(SID=isp01)) ) # Prodution 11.5.9 ODS instance iods = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=isp-db.admin.Virginia.EDU)(PORT=1611)) (CONNECT_DATA=(SID=isp11)) )# Production 11.0.3 ODS instance ods = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=isp-ods.admin.Virginia.EDU)(PORT=1565)) (CONNECT_DATA=(SID=isp01)) ) #iqatest isq01 = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=is-stoa.admin.Virginia.EDU)(PORT=1611)) (CONNECT_DATA=(SID=isq01)) ) # Test 11.5.9 ODS instance iodstest = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=is-tholos.admin.Virginia.EDU)(PORT=1611)) (CONNECT_DATA=(SID=isq01)) ) # Prodution 11.5.9 Apps instance iprod = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=is-delphi.admin.Virginia.EDU)(PORT=1611)) (CONNECT_DATA=(SID=isp11)) ) #ALLDEV isd06 = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=isp-dev.admin.Virginia.EDU)(PORT=1595)) (CONNECT_DATA=(SID=isd06)) ) #ALLDEV alldev = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=isp-dev.admin.Virginia.EDU)(PORT=1595)) (CONNECT_DATA=(SID=isd06)) ) # For ADI Log/out viewing ( one entry per host) FNDFS_isp-db.admin.virginia.edu = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=isp-db.admin.virginia.edu)(PORT=1566)) (CONNECT_DATA=(SID=FNDFS)) ) FNDFS_isp-dev.admin.virginia.edu = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=isp-dev.admin.virginia.edu)(PORT=1571)) (CONNECT_DATA=(SID=FNDFS)) ) FNDFS_is-delphi.admin.virginia.edu = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=is-delphi.admin.virginia.edu)(PORT=1716)) (CONNECT_DATA=(SID=FNDFS)) ) # For InformationWarehouse updated 05/21/09. # IW Oracle v.2 10g PROD IWP01 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = bach.itc.virginia.edu) (PORT = 1565)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = iwp01.itc.virginia.edu))) # IW Oracle v.2 10g Development DBD03 = (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = altair.itc.virginia.edu)(PORT = 1541)) (CONNECT_DATA = (SID = dbd03))) # IW Oracle v.1 9i Dev DBD01 = (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = ansel.itc.Virginia.EDU)(PORT = 1521)) (CONNECT_DATA = (SID = dbd01)))