Install and Configure Radius Login for Windows


Table of contents

Download a later version of the SQL client for Windows. This link downloads a 19c client for Windows x64.

Download and install SQL Developer for Windows

  1. Here is the main SQL Developer 20.41 Downloads page.
  2. On this page, the preferred download link is Windows 64-bit with JDK 8 included.

Top

Install Oracle Client

  1. Extract/Unzip the files in the downloaded .zip file.
  2. Double-click to run the setup.exe file in the Client folder where you have extracted the files.
  3. Choose Runtime option and follow instructions on the screen.

Top

Configure Sql Developer

  1. Add or replace this line in sqlnet.ora, which is under Oracle Client Home/network/admin folder:
    SQLNET.AUTHENTICATION_SERVICES= (RADIUS)
  2. In Sql Developer, complete the following steps:
    1. Click Tools. Select Preferences.
    2. The Preferences window will open. Click Database. Select Advanced to open the Database: Advanced window.
    3. Select Use Oracle Client and Use OCI/Thick driver.
    4. Enter appropriate paths in the Oracle Home and Tnsnames Directory fields.
      NOTE: Use 12c path if you downloaded 12c client.
    5. Click Configure to open the Configure Oracle Client window. Click Test to view any errors.
    6. Click OK to save and exit. Restart computer and launch Oracle Client.
  3. Environmental variable change (update only when previous configuration doesn't work).
    • If some computer configured e Environmental variable TNS_ADMIN before, then this variable may need to be updated to use new Oracle client home/network/admin directory.
    • If Hyperion oracle home variable EPM_ORACLE_HOME was set before, you may want to update this variable to let Hyperion to use new Oracle home as well.
      Configuring the Oracle Client

Top