Posts Tagged ‘ SQLNET.ORA ’

sqlnet.ora Modification for connection timeout and Invited Nodes

To set a Connection Time out in SQLNET.ORA put this line in file and reload Listener.

sqlnet.expire_time = 10

To enable valid Node checking


A Rahim Khan

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 - Production on Sun Apr 29 18:39:21 2012

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

ORA-01031: insufficient privileges

Continue reading