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 tnsnames   Doc ID:63577
Owner:MST Support .Group:Identity and Access Management
Created:2016-05-23 09:27 CDTUpdated:2023-03-01 12:58 CDT
Sites:Identity and Access Management
Feedback:  0   0