-
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]
-
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
-
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
-
Make sure:
remote_os_authent = true
Jeff Hunter
-
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
-
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
-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|