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

Not sure about the first part

Connect / as sysdba  <-- has to be like this, script does not work
otherwise

For ORA-1031 - do you have the requisite group (ORA_DBA) defined 

And you may also need to change 

SQLNET.AUTHENTICATION_SERVICES=(NONE)

To 

 

SQLNET.AUTHENTICATION_SERVICES=(NTS)

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sheehan, Jeremy
Sent: Monday, November 15, 2010 11:15 AM
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 


Please visit our website at 
http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html 
for important disclosures and information about our e-mail 
policies. For your protection, please do not transmit orders 
or instructions by e-mail or include account numbers, Social 
Security numbers, credit card numbers, passwords, or other 
personal information.

Other related posts: