Re: Authentication Problem
- From: Dan Norris <dannorris@xxxxxxxxxxxxx>
- To: jack@xxxxxxxxxxxx, Muhammad.Khan@xxxxxx
- 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.
Dan
----- Original Message ----
From: Jack van Zanen <jack@xxxxxxxxxxxx>
To: Muhammad.Khan@xxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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.
Jack
On 31/01/2008, 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.
--
J.A. van Zanen
Other related posts:
