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 https://offices.depaul.edu/information-services/security/tools-downloads/Pages/Data-Center-VPN.aspx. Create a ServiceNow incident if you have any VPN issues by going to https://depaul.service-now.com/sp.

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 winx64_12201_client.zip (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 win32_12201_client.zip 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:

• Select Installation Type: Select Administrator and then click Next.
• Select Product Languages: English is the default. Select your preference and then click Next.
• Select Installation Location: Default is c:\app\client\youruserid\product\12.2.0\client_1. Click Next.
• Perform Prerequisite Checks: Installation will check your system requirements. Click Finish.

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

• If this is your first Oracle client installation, you may presented with a Firewall Rule Exception Request asking you to allow the Java platform     binary to communicate on Domain, Public and Private networks. Go ahead and accept this exception.
• Once it is complete, you should see a successful client acknowledgement screen.
• Move your previously copied  tnsnames.ora and sqlnet.ora files (including any new tnsnames.ora connections) from your desktop and copy these files over the existing files in the following installation location: C:\app\youruserid\product\12.2.0\client_x\network\admin (number represented by x may vary depending on previous Oracle client installations).

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 https://depaul.service-now.com/sp?id=kb_article_view&sysparm_article=KB0011104

IV. Troubleshooting Tips for Oracle Client Reinstalls

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

• On the desktop Right-click on This PC and select Properties > Advanced tab
• Click the Environment Variables button.
• In the System variables section click the New button
• Enter a variable name of TNS_ADMIN then enter a variable value of the path to the TNSNAMES.ORA file that will be used as the default.

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


• Click OK
• Reboot the machine for the changes to take effect.

 

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.

• Remove earlier releases first (i.e.Oracle Client 11.2  and then  12.1)
  
  • https://docs.oracle.com/cd/E11882_01/install.112/e47959/deinstall.htm#NTCLI1326
  • https://docs.oracle.com/database/121/NTCLI/deinstall.htm#NTCLI1327

If none of these options resolve the issue, please create a ServiceNow incident at https://depaul.service-now.com/sp.

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.

• • Right-click on the connection.
  • Select the "Reset Password..." option from the popup menu.
  • In the subsequent dialog, enter the current password and the new password with confirmation.
  • Click the OK button.

 

 

*Close the SQL Developer program without saving PASSWORD

 

Syntax for Changing Your Password Manually in 19C Databases:

ALTER USER USERNAME IDENTIFIED BY NEWPASSWORD REPLACE OldPassword#12C;

 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:

 ALTER USER USERNAME IDENTIFIED BY NEWPASSWORD REPLACE OldPassword#12C;

 

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