Oracle Windows Privilegesin 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)
|