-
Unable to connect through OS Authentication on Oracle9i
hi,
I am trying to connect to an Oracle9i database which is on NT, using NT user acccount.
NT user nodba
Platform : Oracle on NT with Windows NT clients.
Initialization Parameters:
===========================
os_authent_prefix string
remote_os_authent boolean TRUE
entry for sqlnet.ora (client)
==============================
sqlnet.authentication_services = (NTS)
Now if i issue :
c:> sqlplus /@ i get ORA-01017
When everything is lost, future still remains.
-
Comment this out.
sqlnet.authentication_services = (NTS)
and it will work.
Amar
"There is a difference between knowing the path and walking the path."
-
Meet me in the lobby or call me at 1043 and ill see to ur problem...
Amar
"There is a difference between knowing the path and walking the path."
-
Originally posted by adewri
Meet me in the lobby or call me at 1043 and ill see to ur problem...
Do you work in the same company :-)
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Yes we are in the same company
When everything is lost, future still remains.
-
On commenting
sqlnet.authentication_services = (NTS)
in sqlnet.ora i am able to connect to as through OS authentication.
There should be an OS user and the database user in the database for OS authentication
However sqlnet.authentication_services parameter was required in the previous release of Oracle.
Why do we need to comment it in sqlnet.ora?Any ideas?
When everything is lost, future still remains.
-
When you set
sqlnet.authentication_services = (NTS)
IT allows for user authentication via the native operating system.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|