Re: Authentication Problem

From: Dan Norris <>
Date: Wed, 30 Jan 2008 19:20:04 -0800 (PST)
Message-ID: <>

There are some details missing, like what you passed as the login username (/) and your sqlnet.ora settings on server and client.

When I've debugged cases like this in the past, I find full sqlnet tracing on the server side (trace_level_server=16) to be very helpful.


  • Original Message ---- From: Jack van Zanen <> To: Cc: Sent: Wednesday, January 30, 2008 8:53:59 PM Subject: Re: Authentication Problem

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.    


On 31/01/2008, Khan, Muhammad S <> 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.  




J.A. van Zanen

-- Received on Wed Jan 30 2008 - 21:20:04 CST

Original text of this message