Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OS authentication of user

566500May 2 2007 — edited May 8 2007
hi all,

These are the steps which i followed to authenticate the user using Operating system.But still i am not able to authenticate user using os.

1)create user user1 identified by externally;
2)grant privileges.... to user1;
3)In pfile i edited the following parameter
os_authent_prefix=""
remote_os_authent=true
4)restart db;
5)#groupadd os
6)#useradd -g os -md /home/oracle9i/user1 user1
7)#change the pwd of user1
8)#cp /home/oracle9i/.bash_profile /home/user1/.bash_profile

logout
login as
login:user1
pwd:user1
/home/user1/>$sqlplus
if i give sqlplus then it will display command not found.is it because the s/w is installed in /home/oracle9i?
I am doing this authentication on server machine itself.

Regards,
Chaitra
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 5 2007
Added on May 2 2007
24 comments
1,716 views