Database Management - Editing a SQLNet.ora File for Oracle Database Client Security

This document describes how to edit the sqlnet.ora file on your workstation computer to allow direct connections to an Oracle database.

Background

With increased demands for data security, University of Wisconsin has tightened our security on data-in-transit between database servers and clients.

If you are accessing an Oracle database directly, you likely have an Oracle database client installed on your workstation, and likely a file called sqlnet.ora. The security must be enabled by modifying this file using the process described below.

Procedure

  1. Open your Windows Start screen (Windows 8 and above) or Start menu (Windows 7).
  2. Type Notepad to perform a search. When the application appears in your results, right-click on Notepad and select Run as administrator.
  3. In Notepad, click File > Open.

    In the left-side panel, select This PC (Windows 8 and above) or My Computer (Windows 7). In the lower right-hand corner, change the dropdown from Text Documents (*.txt) to All Files.

  4. In the upper right-hand corner, type sqlnet.ora to perform a search.

    • If you do not find any results (i.e. the file does not exist on your computer), click Cancel, then click here to proceed with creating a new file.
    • If you have multiple results, open the file whose file path ends in product\11.2.0\client_1\network\admin.
  5. Click File > Save As....

    Set the "File name" to sqlnet.ora.old, change the "Save as type" dropdown to All Files, then click Save. Doing this will create a backup copy of this file in case any problems occur later on.

  6. Go back to the open file in Notepad, then copy and paste the following in NotePad. If you are editing an existing file, paste them below the current file contents, otherwise, simply paste them into a blank file:

    Below is an example of a file that has been appended with these three lines:

    Image shows that the original lines in the file have not been removed, and the new lines have simply been appended.
  7. Click File > Save As....

    Because you did not have a sqlnet.ora file when you began, you will first need to locate the correct folder where your new file should be saved:

    1. In the upper right-hand corner of the window that opened, perform a search for client_1. This should return a folder of the same name.
    2. Double-click to open this folder, then navigate to the network folder.
    3. Finally, navigate to the admin folder and double-click to open it. This is where you will save your new file.

    Set the "File name" to sqlnet.ora, change the "Save as type" dropdown to All Files, then click Save. If you are prompted to replace the existing file, choose Yes.




Keywords:db epm interactive reporting infoaccess odbc connections ORA-12650 “No common encryption or data integrity algorithm” encryption required configuration   Doc ID:81764
Owner:Leah S.Group:Database Management
Created:2018-04-20 13:13 CDTUpdated:2018-06-01 15:54 CDT
Sites:Database Management, DoIT Help Desk
Feedback:  2   0