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 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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? |
| ||||
| 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 |