Step-By-Step Configuration of OS Authentication On Windows (Doc ID 750436.1)

Last updated on AUGUST 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
z*OBSOLETE: Microsoft Windows 2000
z*OBSOLETE: Microsoft Windows
z*OBSOLETE: Microsoft Windows XP
z*OBSOLETE: Microsoft Windows Server 2003
z*OBSOLETE: Microsoft Windows Vista (32-bit)
z*OBSOLETE: Microsoft Windows Server 2003 R2 (64-bit AMD64 and Intel EM64T)
Microsoft Windows 2000Microsoft Windows XPMicrosoft Windows Server 2003Microsoft Windows Vista (32-bit)Microsoft Windows Server 2003 R2 (64-bit AMD64 and Intel EM64T)

Goal

How to configure OS authentication for Oracle on Windows, enabling user to connect to sqlplus without specifying username and password: 

  sqlplus /

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms