DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: OS AUTHENTICATION

  1. #1
    Join Date
    May 2001
    Posts
    736
    Hello friends,
    I got a problem while configuring users through OS,my OS is Win2000 and Oracle version is 8.1.6. I followed the same principle what i followed in my production database consisting of Oracle 8.0.5. As Iam doing it on my Test machine.Is there any special considerations to be taken into account while authorizing client through OS,even i added them in ORA_DBA.I kept the the parameter Remote_login_passwordfile=none. Whats went wrong?
    Regards
    akhadar

    [Edited by akhadar on 08-01-2001 at 03:01 AM]

  2. #2
    Join Date
    Jul 2001
    Location
    Netherlands (Utrecht)
    Posts
    21
    Please be more specific...

    You followed the same priciple as on your production db. What are those priciples?? Just tell what you did and wich errors you ran into.

    Best Regards,
    JJ
    J.Jongman - DBA

  3. #3
    Join Date
    May 2001
    Posts
    736
    Hello jjongman

    In parameter file OS authentication the symbol i used is OPS$ as in Production and made the Remote_login_password as None and created the user with this authentication and made the user as External and given the proper privileges.When i tried to login with OS authentication as '/' followed by connecting string it says that invalid username and password.
    ERROR:
    ORA-01017: invalid username/password; logon denied
    But the user with password able to login.
    Now u understand what i mean
    Regards
    akhadar

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Make sure:
    remote_os_authent = true
    Jeff Hunter

  5. #5
    Join Date
    May 2001
    Posts
    736
    Hello marist89
    Sorry to reply as i was not on the forum
    Even after modifying the parameter
    remote_os_authent = true
    Still iam not able to login with OS auhtentication
    Regards
    akhadar

  6. #6
    Join Date
    Mar 2001
    Posts
    635
    Hi

    I think you have to create ans OPS$ account for them in the database did you do that.And make sure you have the following parameter in your initialisation file

    os_authent_prefix="OPS$"
    remote_os_authent=true

    Regards
    Santosh

  7. #7
    Join Date
    May 2001
    Posts
    736
    Hello santoshym

    yes indeed I created the users with suffix 'OPS$' and also

    os_authent_prefix="OPS$"
    remote_os_authent=true

    But still iam facing the same error and not able to login with OS authentication.
    Regards
    akhadar

  8. #8
    Join Date
    Mar 2001
    Posts
    635
    Hi

    Create users with prefix 'OPS$ not suffix 'OPS$' for example
    here is a create user statement

    CREATE USER "OPS$SANTOSH" IDENTIFIED EXTERNALLY DEFAULT TABLESPACE "USER_TS" TEMPORARY TABLESPACE "TEMP_TS" PROFILE DEFAULT ACCOUNT UNLOCK;

    Regards
    Santosh

  9. #9
    Join Date
    May 2001
    Posts
    736
    Hello friends
    Again posting the same problem since iam unable login with OS auhtentication,shortly iam going to install Oracle 8i on Windows 2000.If any one who is successfully implementing OS authentication with Oracle 8i on Win2000 will be of a greate help.
    Regards
    akhadar

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