Re: Authentication Problem
Date: Wed, 30 Jan 2008 19:20:04 -0800 (PST)
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 <jack_at_vanzanen.com> To: Muhammad.Khan_at_ca.com Cc: oracle-l_at_freelists.org 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 <Muhammad.Khan_at_ca.com> wrote:
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
http://www.freelists.org/webpage/oracle-l Received on Wed Jan 30 2008 - 21:20:04 CST