It's Sun 10. SQLNET.AUTHENTICATION_SERVICES is set to (NONE)

-----Original Message-----
From: Tina Massmann
[mailto:oracledba-ezmlmshield-x88993474.[Email address protected]
Sent: Wednesday, August 02, 2006 6:39 AM
To: LazyDBA Discussion
Subject: RE: ORA-01031 when login as sysdba

Is this on Windows?
If so make sure the sqlnet.ora file contains
SQLNET.AUTHENTICATION_SERVICES= (NTS)
Instead of
SQLNET.AUTHENTICATION_SERVICES= (NONE)
This is what worked for me.
Good Luck.
Tina

-----Original Message-----
From: Krupetsky Milana
[mailto:oracledba-ezmlmshield-x76732345.[Email address protected]
Sent: Tuesday, August 01, 2006 2:58 PM
To: LazyDBA Discussion
Subject: ORA-01031 when login as sysdba

Hi All,



Got the ORA-01031 when try to login as sysdba. All other logins as sys
work fine. Other databases on server are fine. Recreated password file,
restarted db, reset pass for sys. Can not find in any docs on e-net what
else could help. Please give me an unorthodox idea! Everything else I
already tried:-)



mdb] /opt/oracle/product/10.2.0.1/network/admin > sqlplus [Email Address Removed] as
sysdba



SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 1 14:52:32 2006



Copyright (c) 1982, 2005, Oracle. All rights reserved.



Enter password:

ERROR:

ORA-01031: insufficient privileges



Thanks,

mia



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Confidentiality Notice: This email transmission may contain confidential
or legally privileged information that is intended only for the
individual or entity named in the e-mail address. If you are not the
intended recipient, you are hereby notified that any disclosure,
copying, distribution, or reliance upon the contents of this e-mail is
strictly prohibited. If you have received this e-mail transmission in
error, please reply to the sender, so that arrangements can be made for
proper delivery, and then please delete the message from your in-box.




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html





Oracle LazyDBA home page