Oracle Update - version 19C

The purpose of this update is to ensure compliance with the June 2023 deadline for the Financial Services Modernization Act (GLBA) which requires protection of security, confidentiality, and integrity of non-public customer information. The Oracle 19C update provides native encryption for all clients accessing UW Oracle databases including Banner, ODS, and BI databases.  This article provides instructions for installing and configuring Oracle 19C for SQLPLUS, Toad for Oracle, and SQL Developer.

Note:

• The Oracle 19C update is 1.2GB in size.  Please ensure there is sufficient space on your hard drive to accommodate this update.
• Windows 10 or 11
• If you access Oracle applications on an Apple device, please contact the Help Desk at 307-766-4357 (option 1) for assistance

Install Oracle 19C

1. Open Software Center and select the Oracle 19C update.
2. Click Install

 

3. A Terminal window will open.  Installation will take a few minutes.  Software is done installing when you see Successfully Setup Software

 

---

Configure Oracle 19C on SQLPLUS

1. Open Terminal
2. Launch and log into SQLPLUS
3. Run the following query in SQLPLUS to verify the Oracle database agrees that Native Encryption is being used:

select distinct network_service_banner from v$session_connect_info where sid=sys_context('USERENV', 'SID');

4. Results should be:

 

---

Configure Oracle 19C on Toad

1. Launch Toad for Oracle (64 bit) and log in
2. Click on the dropdown menu for Connect using Oracle Client and select OraClient19Home1 and click Connect

3. Next, test for encryption by entering the following query and running it

select distinct network_service_banner from v$session_connect_info where sid=sys_context('USERENV', 'SID');

Results should indicate: 

 

---

Configure Oracle 19C on SQL Developer

1. Launch and log in to SQL Developer as an Administrator
2. Connect to your desired database
3. In the top menu bar, click on Tools and then Preferences

 

4. Then click on Database > Advanced 
5. Next, click on the checkbox Use Oracle Client, and click on Configure

6. Client Type should be: Oracle Home
7. Click Browse to select the Client Location

 

8. Browse to C:\app > 19c > client_1 and click Select

 

9. Click Test... Success! will appear in blue
10. Click OK

 

 

11. Check the box for Use OCI/Thick driver and click Browse to select the Tnsnames Directory

 

12. Browse to: C: \app > 19c > client1 > network > admin and click Select
13. Click OK

 

14. A restart of SQL Developer will be required now
15. Log in to SQL Developer and test for encryption by entering the following query and running it

select distinct network_service_banner from v$session_connect_info where sid=sys_context('USERENV', 'SID');

Results should indicate: 

16. If this output is not produced it means encryption did not work.  In these cases, the following can be added to the sqldeveloper.conf file (located in \sqldeveloper\sqldeveloper\bin  sqldeveloper.conf).  Find this file and open with NotePad to edit and add the following at the end of the code that is already there.

##added for encryption 

AddVMOption -Doracle.net.encryption_client=REQUIRED

AddVMOption -Doracle.net.encryption_types_client=(AES256)

AddVMOption -Doracle.net.crypto_checksum_client=REQUIRED

AddVMOption -Doracle.net.crypto_checksum_types_client=(SHA256)

17. Save the file and repeat steps 14 and 15.