Unable to connect through OS Authentication on Oracle9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Unable to connect through OS Authentication on Oracle9i

  1. #1
    Join Date
    Oct 2003
    Location
    New Delhi
    Posts
    20

    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.

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Comment this out.

    sqlnet.authentication_services = (NTS)

    and it will work.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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

  5. #5
    Join Date
    Oct 2003
    Location
    New Delhi
    Posts
    20
    Yes we are in the same company
    When everything is lost, future still remains.

  6. #6
    Join Date
    Oct 2003
    Location
    New Delhi
    Posts
    20
    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.

  7. #7
    Join Date
    Jul 2003
    Posts
    30
    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
  •  


Click Here to Expand Forum to Full Width