Re: Authentication Problem

  • From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
  • To: Muhammad.Khan@xxxxxx
  • Date: Thu, 31 Jan 2008 08:49:24 +0100

As far as I remember on windows the username has to be "OPS$<Client Machine
Name>\<Username>".

To be sure, as Jack suggested, check v$session to get the exact form of your
username.

Stefan



On Jan 31, 2008 2:18 AM, Khan, Muhammad S <Muhammad.Khan@xxxxxx> 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.
>
>
>



-- 
=========================

Stefan P Knecht
Senior Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht@xxxxxxxxxxxx
http://www.trivadis.com

OCP 9i/10g SCSA SCNA
=========================

Other related posts: