OracleDB‎ > ‎

Windows Local Login

Oracle Windows Privileges

in windows if a user in ora_dba group get the following:

C:> SET ORACLE_SID=InstanceSID C:> sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on Wed Dec 13 10:18:27 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> conn sys/password as sysdba Connected to an idle instance. SQL> startup nomount pfile=C:\location_to_file\init.ora; ORA-01031: insufficient privileges SQL>


Do the following:

simply create (or modify) a file named sqlnet.ora in your ORA_HOME\network\network\admin directory and add to it the following line:

SQLNET.AUTHENTICATION_SERVICES = (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

Comments