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


tcp.validnode_checking=yes
tcp.invited_nodes=(ip1,ip2,ip3)

Thanks
A Rahim Khan

Advertisements

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

Continue reading

Advertisements