Re: Authentication Problem

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Thu, 31 Jan 2008 13:53:59 +1100
Message-ID: <77a615a70801301853h72f3e065r481db274494c0450@mail.gmail.com>


Look Ok to me, but....

When creating the domain user in the database you use double quotes ( "OPS$<domainname>\<username>"
). It than becomes case sensitive as well. Make sure the case is spot on.

log on to the database as a dba user and look in v$session to see exact spelling of your os account.

Jack

On 31/01/2008, Khan, Muhammad S <Muhammad.Khan_at_ca.com> wrote:
>
> Hi Gurus.
>
>
>
>
>
> Its hard to believe what I'm stuck at here right now! I'm testing the OS
> authentication in my test environment with Oracle 9i database on Unix while
> client running on Windows. I set the following parameters in the init file
> for this:
>
>
>
> os_authent_prefix OPS$
>
> remote_os_authent TRUE
>
> remote_login_passwordfile NONE
>
>
>
> I created the user "OPS$<domainname>\<username>" and granted the necessary
> privileges required. This username is the same as my windows client user.
> Now when I'm trying to connect from the client through sqlplus, it prompts
> me for password and doesn't accept null password.
>
>
>
> I made different changes in the values for os_authent_prefix and set to ""
> or remote_os_authent to false but no good.
>
>
>
> What am I missing here? Is there any catch? Please help as I need to
> present the output very soon.
>
>
>
> Thanks,
>
> Khan.
>
>
>

-- 
J.A. van Zanen

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 30 2008 - 20:53:59 CST

Original text of this message