Connections to Administrative Oracle Databases

Issue/Question

  • How do I make a connection to an administrative database?
  • My query, report or database connection suddenly shows a connection error
  • I get an error when trying to get Banner or data warehouse data.
  • I've been told to update my tnsnames.ora file.  What do I need to change?
  • I see a BI Query User - #1459 error when connecting to OSU's Data Warehouses

Environment

  • Oregon State University
  • Queries, reports and extracts

Explanation

This document applies to applications or vendors who have accounts allowing them to establish a connection to an administrative database.  The connection may be embedded in an application, in a tnsnames.ora file or configured manually within a tool.

With the migration of administrative computers and databases to Oracle's cloud infrastructure in October-November 2021, server names will change, and users who are responsible for an application that connects to those databases or those who have installed software on their systems to do so (such as BI Query, Tableau, MS Access or SQL developer) will need to update their connection strings.  The new connection strings are outlined below and can be updated at any time before the systems moveWe encourage you to do this now!  After migration, only the new connection strings will be valid. 

Database move proposed schedule:

  • October 18, 2021 - October 26, 2021 (development move):             DEVL, ODDEVL, OSDEVL, SEED, DWDEVL
  • October 27 2021 - November 6, 2021 (development move):            DEV2, ODDEV2, OSDEV2
  • November 8, 2021 - November 16, 2021 (pre-production move):    PPRD, OSPPRD
  • Week of November 22-24:                                                                Go/No-go Decision
  • November 25, 2021 - November 28, 2021 (production move):      PROD, ODPROD, OSPROD

Administrative applications supported by UIT Administrative Technologies (such as Banner, AWA, MyDegrees, Hyland OnBase and Online Services) will be updated centrally. 

Additional related documentation:

 

Resolution

Updating software with a connection that existed prior to September 30, 2021:

  1. If you do not have administrative access, work with whomever helped install or configure the software on your machine.
  2. For software like BI Query or SQL Developer that rely on a tnsnames.ora file, locate and edit that file.  There may be more than one file installed on a computer.  The file most commonly resides in C:\Oracle\Ora11\network\admin
  3. Edit the file with an editor such as Notepad, change any host names listed in the "Old host name" column, below, to the "New host name" (in tnsnames.ora, only the "ecs-cluster.ucsadm.oregonstate.edu" portion of the connection string needs to change).
  4. Save the file as a plain text file.
  5. For software where connection strings are configured within the application, consult product documentation for establishing or editing an existing database connection to change any strings listed in the "Old Connection String" column, below, to the "New Connection String" 

Table of connection string changes

Old Connection String = connection strings that will stop working in October 2021 (*DEV* and *PPRD* systems) or November 25, 2021 (*PROD* systems).
New Connection String = connection strings that are valid and can be used any time from September 2021 onward.

Old host name New host name
ecs-cluster.ucsadm.oregonstate.edu:1521/act_dev2.ecs.osu dev2.isadm.oregonstate.edu:1521/act_dev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ban_dev2.ecs.osu dev2.isadm.oregonstate.edu:1521/ban_dev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/brm_dev2.ecs.osu dev2.isadm.oregonstate.edu:1521/brm_dev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/bxe_dev2.ecs.osu dev2.isadm.oregonstate.edu:1521/bxe_dev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/cfn_dev2.ecs.osu dev2.isadm.oregonstate.edu:1521/cfn_dev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/inb_dev2.ecs.osu dev2.isadm.oregonstate.edu:1521/inb_dev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/mid_dev2.ecs.osu dev2.isadm.oregonstate.edu:1521/mid_dev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/nlj_dev2.ecs.osu dev2.isadm.oregonstate.edu:1521/nlj_dev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/osu_dev2.ecs.osu dev2.isadm.oregonstate.edu:1521/osu_dev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/qry_dev2.ecs.osu dev2.isadm.oregonstate.edu:1521/qry_dev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ssb_dev2.ecs.osu dev2.isadm.oregonstate.edu:1521/ssb_dev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/act_devl.ecs.osu devl.isadm.oregonstate.edu:1521/act_devl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ban_devl.ecs.osu devl.isadm.oregonstate.edu:1521/ban_devl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/brm_devl.ecs.osu devl.isadm.oregonstate.edu:1521/brm_devl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/bxe_devl.ecs.osu devl.isadm.oregonstate.edu:1521/bxe_devl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/cfn_devl.ecs.osu devl.isadm.oregonstate.edu:1521/cfn_devl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/inb_devl.ecs.osu devl.isadm.oregonstate.edu:1521/inb_devl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/mid_devl.ecs.osu devl.isadm.oregonstate.edu:1521/mid_devl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/nlj_devl.ecs.osu devl.isadm.oregonstate.edu:1521/nlj_devl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/osu_devl.ecs.osu devl.isadm.oregonstate.edu:1521/osu_devl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/qry_devl.ecs.osu devl.isadm.oregonstate.edu:1521/qry_devl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ssb_devl.ecs.osu devl.isadm.oregonstate.edu:1521/ssb_devl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/act_dwdevl.ecs.osu dwdevl-db.isadm.oregonstate.edu:1521/act_dwdevl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ban_dwdevl.ecs.osu dwdevl-db.isadm.oregonstate.edu:1521/ban_dwdevl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/odw_dwdevl.ecs.osu dwdevl-db.isadm.oregonstate.edu:1521/odw_dwdevl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/qry_dwdevl.ecs.osu dwdevl-db.isadm.oregonstate.edu:1521/qry_dwdevl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/act_dwprod.ecs.osu dwprod-db.isadm.oregonstate.edu:1521/act_dwprod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ban_dwprod.ecs.osu dwprod-db.isadm.oregonstate.edu:1521/ban_dwprod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/odw_dwprod.ecs.osu dwprod-db.isadm.oregonstate.edu:1521/odw_dwprod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/qry_dwprod.ecs.osu dwprod-db.isadm.oregonstate.edu:1521/qry_dwprod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/act_oddev2.ecs.osu oddev2.isadm.oregonstate.edu:1521/act_oddev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ban_oddev2.ecs.osu oddev2.isadm.oregonstate.edu:1521/ban_oddev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ods_oddev2.ecs.osu oddev2.isadm.oregonstate.edu:1521/ods_oddev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/qry_oddev2.ecs.osu oddev2.isadm.oregonstate.edu:1521/qry_oddev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/act_oddevl.ecs.osu oddev2.isadm.oregonstate.edu:1521/act_oddevl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ban_oddevl.ecs.osu oddevl.isadm.oregonstate.edu:1521/ban_oddevl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ods_oddevl.ecs.osu oddevl.isadm.oregonstate.edu:1521/ods_oddevl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/qry_oddevl.ecs.osu oddevl.isadm.oregonstate.edu:1521/qry_oddevl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/act_odprod.ecs.osu odprod.isadm.oregonstate.edu:1521/act_odprod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ban_odprod.ecs.osu odprod.isadm.oregonstate.edu:1521/ban_odprod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ods_odprod.ecs.osu odprod.isadm.oregonstate.edu:1521/ods_odprod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/qry_odprod.ecs.osu odprod.isadm.oregonstate.edu:1521/qry_odprod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/act_osdev2.ecs.osu osdev2.isadm.oregonstate.edu:1521/act_osdev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ban_osdev2.ecs.osu osdev2.isadm.oregonstate.edu:1521/ban_osdev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/dgw_osdev2.ecs.osu osdev2.isadm.oregonstate.edu:1521/dgw_osdev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/osu_osdev2.ecs.osu osdev2.isadm.oregonstate.edu:1521/osu_osdev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/qry_osdev2.ecs.osu osdev2.isadm.oregonstate.edu:1521/qry_osdev2.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/act_osdevl.ecs.osu osdevl.isadm.oregonstate.edu:1521/act_osdevl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ban_osdevl.ecs.osu osdevl.isadm.oregonstate.edu:1521/ban_osdevl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/dgw_osdevl.ecs.osu osdevl.isadm.oregonstate.edu:1521/dgw_osdevl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/osu_osdevl.ecs.osu osdevl.isadm.oregonstate.edu:1521/osu_osdevl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/qry_osdevl.ecs.osu osdevl.isadm.oregonstate.edu:1521/qry_osdevl.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/awa_ospprd.ecs.osu ospprd.isadm.oregonstate.edu:1521/awa_ospprd.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ban_ospprd.ecs.osu ospprd.isadm.oregonstate.edu:1521/ban_ospprd.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/dgw_ospprd.ecs.osu ospprd.isadm.oregonstate.edu:1521/dgw_ospprd.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/osu_ospprd.ecs.osu ospprd.isadm.oregonstate.edu:1521/osu_ospprd.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/qry_ospprd.ecs.osu ospprd.isadm.oregonstate.edu:1521/qry_ospprd.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/act_osprod.ecs.osu osprod.isadm.oregonstate.edu:1521/act_osprod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/awa_osprod.ecs.osu osprod.isadm.oregonstate.edu:1521/awa_osprod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ban_osprod.ecs.osu osprod.isadm.oregonstate.edu:1521/ban_osprod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/dgw_osprod.ecs.osu osprod.isadm.oregonstate.edu:1521/dgw_osprod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/osu_osprod.ecs.osu osprod.isadm.oregonstate.edu:1521/osu_osprod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/qry_osprod.ecs.osu osprod.isadm.oregonstate.edu:1521/qry_osprod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/act_pprd.ecs.osu pprd.isadm.oregonstate.edu:1521/act_pprd.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/b13_pprd.ecs.osu pprd.isadm.oregonstate.edu:1521/b13_pprd.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ban_pprd.ecs.osu pprd.isadm.oregonstate.edu:1521/ban_pprd.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/bxe_pprd.ecs.osu pprd.isadm.oregonstate.edu:1521/bxe_pprd.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/cfn_pprd.ecs.osu pprd.isadm.oregonstate.edu:1521/cfn_pprd.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/inb_pprd.ecs.osu pprd.isadm.oregonstate.edu:1521/inb_pprd.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/mid_pprd.ecs.osu pprd.isadm.oregonstate.edu:1521/mid_pprd.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/nlj_pprd.ecs.osu pprd.isadm.oregonstate.edu:1521/nlj_pprd.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/osu_pprd.ecs.osu pprd.isadm.oregonstate.edu:1521/osu_pprd.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/qry_pprd.ecs.osu pprd.isadm.oregonstate.edu:1521/qry_pprd.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ssb_pprd.ecs.osu pprd.isadm.oregonstate.edu:1521/ssb_pprd.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/act_prod.ecs.osu prod.isadm.oregonstate.edu:1521/act_prod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/b13_prod.ecs.osu prod.isadm.oregonstate.edu:1521/b13_prod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ban_prod.ecs.osu prod.isadm.oregonstate.edu:1521/ban_prod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/brm_prod.ecs.osu prod.isadm.oregonstate.edu:1521/brm_prod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/bxe_prod.ecs.osu prod.isadm.oregonstate.edu:1521/bxe_prod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/cfn_prod.ecs.osu prod.isadm.oregonstate.edu:1521/cfn_prod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/inb_prod.ecs.osu prod.isadm.oregonstate.edu:1521/inb_prod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/mid_prod.ecs.osu prod.isadm.oregonstate.edu:1521/mid_prod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/nlj_prod.ecs.osu prod.isadm.oregonstate.edu:1521/nlj_prod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/osu_prod.ecs.osu prod.isadm.oregonstate.edu:1521/osu_prod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/qry_prod.ecs.osu prod.isadm.oregonstate.edu:1521/qry_prod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/ssb_prod.ecs.osu prod.isadm.oregonstate.edu:1521/ssb_prod.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/act_seed.ecs.osu seed.isadm.oregonstate.edu:1521/act_seed.ecs.osu
ecs-cluster.ucsadm.oregonstate.edu:1521/qry_seed.ecs.osu seed.isadm.oregonstate.edu:1521/qry_seed.ecs.osu

Assistance

For assistance, contact the Service Desk.

 

Details

Article ID: 134408
Created
Tue 9/21/21 2:25 PM
Modified
Thu 10/14/21 12:26 PM