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.
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.
*The installation may take a while. Please be patient.
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
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 https://depaul.service-now.com/sp.
|
|||
|
|
From SQL Developer, do the following.
*Close the SQL Developer program without saving PASSWORD
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.