Enable/Disable OS authentication for Oracle in Windows Server

It is possible to disable Operating System authentication while connecting Oracle Database. In that case, ORA-01031: insufficient privileges will be thrown as shown below.


C:\>sqlplus / as sysdba;

SQL*Plus: Release 10.2.0.3.0 - Production on Sun Apr 29 18:39:21 2012

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

ERROR:
ORA-01031: insufficient privileges

However, you can enable it by modifying sqlnet.ora.
sqlnet.ora Location
location : F:\oracle\product\10.2.0\db_1\network\ADMIN\sqlnet.ora
Disable OS Authentication
original content : SQLNET.AUTHENTICATION_SERVICES= (none)
Enable OS Authentication
modified content : SQLNET.AUTHENTICATION_SERVICES= (NTS)

Now, try to connect database using Operating System authentication and you will be able to do so.


C:\>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Sun Apr 29 18:42:25 2012

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>

Thanks
A Rahim Khan

Advertisements
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: