Data Warehouse Upgrade to Oracle 19c: Client Requirements and Password Instructions

I. DataCenter VPN

Pulse Secure VPN is required for connection to the Data Warehouse (Oracle 19c). If you are using any other vpn client, please download the Pulse Secure Data Center VPN client from Create a ServiceNow incident if you have any VPN issues by going to

II. Oracle Client (12.2) Install for 19C

1. Save your previous tnsnames.ora and sqlnet.ora files (including any new tnsnames.ora connections) to your desktop.

2. Copy (Oracle Client 12.2) located in this folder: W:\software\Faculty-Staff\Windows\Oracle Client\ to your local drive (C:)

NOTE: If a 32bit ODBC connection is necessary (i.e. links to MS Access/Office 32bit), a 32 bit version can be found at W:\software\Faculty-Staff\Windows\Oracle Client\32 bit version **See section III below RE: ODBC connections.

3. Extract the zip folder to your desktop.

4. Right mouse click on the file Oracle Client\winx64_12201_client\client\setup.exe and choose Run as Administrator.

5. Select "Yes" when asked “Do you want to allow the follow program to make changes to this computer?”

A command prompt dialog box will appear with the message “Starting the Oracle Universal Installer… Please Wait.” This may take a while. Eventually, the following window should pop up:

5. If the window does not appear, look for this icon   in your task bar and click on it.

Installation Options:

         *The installation may take a while. Please be patient.

III. When Using an ODBC Connection

If you are already connecting to the DW using an ODBC connection, you will need to recreate the connection using the newly installed Oracle driver, i.e. Oracle in OraClient12_homex (the number indicated by x must match the Oracle home of your most recent client install). If necessary, refer to the full instructions at

IV. Troubleshooting Tips for Oracle Client Reinstalls

1. Set the TNS_ADMIN environment variable to specify the location of the tnsnames.ora file.

For example:
Variable Name     TNS_ADMIN
Variable Value    C:\app\client\userid\product\12.2.0\client_x\network\admin


2. Open Oracle SQL Developer. Choose Tools from the menu and then select Preferences. Input the correct path for Tnsnames Directory (see below).

3. If your Oracle Client 12.2 installation fails prior to completion, you may want to try removing any previous installations before attempting again.

If none of these options resolve the issue, please create a ServiceNow incident at

V. Oracle 19C Password Guidelines

  • The password is not the same as the user name or the user name reversed.
  • The password is not the same as the database name.
  • The password does not contain the word oracle (such as oracle123).
  • The password differs from the previous password by at least 3 characters.
  • The password contains no fewer than 8 characters and includes at least one alphabetic character, one numeric and one special character.
  • The password contains at least 1 of the special characters allowed below:
# $ _


  • The following internal check is also applied:
    • The first column of password must not be a numeric or special character.
  • Password Login/Entry is Case Sensitive Password
  • Password Expires 365 Days After Reset
  • Password Grace Time Reset 45 Days After Expiration
  • Password History Kept Time 8
  • Password Lock After 10 Failed Attempts


VI. Changing Your Password

Changing Your Password using SQL Developer:

From SQL Developer, do the following.



*Close the SQL Developer program without saving PASSWORD


Syntax for Changing Your Password Manually in 19C Databases:


 Below Are Sample Invalid Password Reset Attempts:


Invalid Password Reset Attempts – The password contains at least 1 special character.


Invalid Password Reset Attempts - The password does not contain the double-quotation character, (!) or (?).:


Invalid Password Reset Attempts – Must use correct syntax and use REPLACE:



Invalid Password Reset Attempts – The password contains no fewer than 8 characters and includes at least one numeric and one alphabetic character.