RE: connect / as sysdba - What am I missing?
- From: "Uzzell, Stephan" <SUzzell@xxxxxxxxxx>
- To: "'JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx'" <JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 15 Nov 2010 11:18:22 -0500
Hi Jeremy,
Two things I would recommend:
1) Change sqlnet.authentication_services to (NTS)
2) In local user manager (lusrmgr.msc) add your windows user to the
ora_dba group
HTH,
stephan
_____________________________________________________________________________
Stephan Uzzell | MICROS Systems, Inc.
Database Administrator - OPERA Global Technical Services
7031 Columbia Gateway Dr, Columbia, MD 21046 | * 443.285.8000x2760 | 7
443.285.6505
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Sheehan, Jeremy
Sent: Monday, 15 November, 2010 11:15
To: oracle-l@xxxxxxxxxxxxx
Subject: connect / as sysdba - What am I missing?
Hello,
I'm trying to get
Sqlplus /nolog
Connect / as sysdba <-- has to be like this, script does not work otherwise
To work on a Windows 2003 server, but keep on getting an ORA-01031 -
Insufficient privileges error.
I've followed 3 different notes on metalink, looked all over the web and still
can't get it working.
Here are the stats....
Windows 2003 SP3, 64-bit
Oracle 10.2.0.3 Enterprise
2 DB's on the server using a shared listener
Does not work for BOTH DB's on the server
Rebuild password file
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
SQLNET.ora file (tried commeting out sqlnet.auth..., also tried with NTS)
# SQLNET.ORA Network Configuration File
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = fpl.com
SQLNET.AUTHENTICATION_SERVICES=(NONE)
NAMES.DIRECTORY_PATH=(TNSNAMES,LDAP)
I can't figure this out for the life of me. If anyone has any ideas on what
I'm doing wrong or some hints in the right direction, I'd be much appreciative!
Thank you!
Jeremy
Other related posts:
