RE: connect / as sysdba - What am I missing?

Yes.  The user is in the ORA_DBA group on the server.

Jeremy Sheehan
Oracle DBA
Jeremy.Sheehan@xxxxxxxxxxxxxxxxx<mailto:Jeremy.Sheehan@xxxxxxx>
(561) 304-5769 - office
(561) 625-7196 - fax
DBA Requests: [cid:[email protected]] <notes:///85256DFF006B0BA9>

From: David Pintor [mailto:painterman@xxxxxxxxx]
Sent: Monday, November 15, 2010 11:20 AM
To: Sheehan, Jeremy
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: connect / as sysdba - What am I missing?

Hi,

Does your Windows user belong to the DBA group?

David


On 15 November 2010 16:14, Sheehan, Jeremy 
<JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx<mailto:JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>> 
wrote:
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<http://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

GIF image

Other related posts: