Unix Technical Forum

connect / as sysdba

This is a discussion on connect / as sysdba within the Oracle Miscellaneous forums, part of the Oracle Database category; --> Thanks Joel. It works now as local user. It didn't work as a domain user when logged on from ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database > Oracle Miscellaneous

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #11 (permalink)  
Old 04-08-2008, 10:26 AM
Raj
 
Posts: n/a
Default Re: connect / as sysdba

Thanks Joel. It works now as local user. It didn't work as a domain
user when logged on from domain cache.

+++++++++++++++++++++++++

First of all, what version are you on?
How did you create the password file? Are you absolutely sure you
spelled the filename correctly? *pwd* instead of *pw* will blow you
off.
Have you tried remote_login_passwordfile=none? The parameters changed
from 9i to 10g. Are you conversant with the differences between pfile
and spfile?
What are the _exact_ commands you are entering?
What happens when you try it in quotes from the shell, like
sqlplus "/ as sysdba"
How are you setting up your environment? Do you have an environment
chooser?

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #12 (permalink)  
Old 04-08-2008, 10:26 AM
Rauf Sarwar
 
Posts: n/a
Default Re: connect / as sysdba


Raj wrote:
> Thanks. It works now. I used to login as a domain user without being
> connected to domain. I had logged in as cad\raj from the domain cache.
> It did not work then.
>
> Now i created a local user raj and added it to ORA_DBA group. Now it
> works for the local user. I am not sure if being actually connected to
> the domain would help.


Connected to the domain won't help either if you are on 2000/XP/2003.
M$ changed the way server handles authentication from WinNT to Win2000
and beyond.

If you are interested to learn then google on "Pre-Windows 2000
compatible access".

Regards
/Rauf

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 06:28 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com