Setting Up Oracle OS Authentication

Note: This procedure is only necessary if you use Oracle OS authentication. If you use Oracle database authentication, continue by setting up the Oracle client.
  1. On the server where the database is located, locate the Oracle Initialization file in the directory where Oracle was installed.
  2. In the Oracle Initialization file, set values for the following parameters:
    • remote_login_passwordfile = none

    • remote_os_authent = true

    • os_authent_prefix = ““

    Note: If any of the parameters and values do not exist, you must add them. In Oracle 11g, the remote_os_authent and os_authent_prefix parameters are set by default.
  3. Locate the SQLNET.ORA file in the directory where Oracle was installed. The file is located in ORACLE_HOME\Network\Admin directory under the main Oracle installation directory where ORACLE_HOME is the name assigned for the Oracle home during installation.
  4. Open SQLNET.ORA and set the value of the following parameter as follows:
    sqlnet.authentication_services = (NTS)
     
    Note: Ensure this parameter is not commented out with a # at the beginning of the line. You may need to add this parameter.
  5. Access the Run dialog box from the Start menu.
  6. In the Open text box, type regedit and then click OK. The Registry Editor dialog box opens.
  7. In the path HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEn (where n is the number associated with the Oracle installation), right-click HOMEn and choose New > String Value. A new string value appears in the right pane of the registry editor.
  8. Replace the default name, New Value #1 with OSAUTH_PREFIX_DOMAIN.
  9. Double-click the string value you just created. The Edit String dialog box opens.
  10. In the Value data text box, type TRUE and then click OK.