Have a look on 'ORACLE_HOME/network/admin/sqlnet.ora'.
I think following statement has to be set:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
Good luck!
Vera
-----Ursprüngliche Nachricht-----
Von: Daniel Woodruff/EmCare
[mailto:oracledba-ezmlmshield-x78115785.[Email address protected]
Gesendet: Dienstag, 05. Juli 2005 18:28
An: LazyDBA Discussion
Betreff: Re: Conn / as sysdba
Make sure you are in the user group "dba" on the linux box. If you are not
you cannot use / as sysdba;
"jsf"
<oracledba-ezmlms
hield-x66898237.x To
[Email Address Removed] "LazyDBA Discussion"
A.com> <[Email address protected]
cc
07/05/2005 01:43
PM Subject
Conn / as sysdba
Hi there,
2 questions:
1) I'm logging in linux as the 'oracle' user but when trying to 'connect /
as sysdba' it gives me 'insufficient privileges' error...
All environment variables (ORACLE_SID, ORACLE_HOME, etc) are set, and the
param REMOTE_LOGIN_PASSWORDFILE = exclusive.
Shouldn't I be able to login using '/ as sysdba' wher logged in OS with the
'oracle' user? The manager said 'conn / as sysdba' used to work, but another
DBA did something wrong and it doesn't work anymore... Any ideas about what
to check and how could I fix it?
2) This should be easy but I don't know how to connect as sysdba without
issuing 'sqlplus /nolog' -> 'conn / as sysdba'
Ex:
c:\> sqlplus
LOGIN: <what do I put here to login as sysdba?>
PASSWORD: <what do I put here to login as sysdba?>
I hope you can help me. Thanks so much!
Juliano Freitas
--------
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
--------
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