IAM Database Connection Information

Public connection entries for Middleware databases.

Note: Access to data in the following databases are available by express permission only. The databases are protected by network and application level firewalls and requires an approved IDI request that can be found here: IDI Request

Requesting Changes to Existing Connections: You can request a change via email to IAM Support. You will need to include:

  • application name
  • account it uses
  • view or other objects it uses (so we can verify grants)
  • IP address(es) or range(s) it will connect from (all addresses so that we can make sure that old authorizations are cleaned up.)
    • For Windows Hosting IP ranges, we will need the user that IIS runs the site as.

PHEXPORT Production (PHEXPP)

PHEXPP =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = phexpp1.db.doit.wisc.edu)(PORT = 1521))
      (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = phexpp1_pdb_srv.doit.wisc.edu))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = phexpp2.db.doit.wisc.edu)(PORT = 1521))
      (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = phexpp2_pdb_srv.doit.wisc.edu))
    )
  )

IAA / UWPDR

IAA =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = iaa.db.doit.wisc.edu)(PORT = 1521))
    (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = iaa_pdb_srv.doit.wisc.edu))
  )

UWPDR =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = iaa.db.doit.wisc.edu)(PORT = 1521))
    (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = iaa_pdb_srv.doit.wisc.edu))
  )

PHEXPORT Test (PHEXPT)

PHEXPT =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = phexpt1.db.doit.wisc.edu)(PORT = 1521))
      (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = phexpt1_pdb_srv.doit.wisc.edu)
      )
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = phexpt2.db.doit.wisc.edu)(PORT = 1521))
      (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = phexpt2_pdb_srv.doit.wisc.edu)
      )
    )
  )

MSTTST

MSTTST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = msttst.db.doit.wisc.edu)(PORT = 1521))
    (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = msttst_pdb_srv.doit.wisc.edu))
  )


Keywords:
phexport phexpp phexpp1 phexpp2 uwpdr phexpt1 phexpt2 msttst phexpd mstdev gamsdb gamstsdb gamsdvdb iamdb iamtsdb oimdvdb tns tnsnames string 
Doc ID:
63577
Owned by:
MST Support in Identity and Access Management
Created:
2016-05-23
Updated:
2024-07-15
Sites:
Identity and Access Management