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!

ORA-01017 OS Authentication

user1175230May 4 2010 — edited May 7 2010
Hello,

I'm trying to get OS authentication to work for os (Solaris) user padss. I'm going through the steps below:

1. Create OS user padss
2. SQL> show parameter os_authent_prefix

NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
os_authent_prefix string OPS$

3. As Oralcle OS user and sys:

CREATE USER "OPS$padss" IDENTIFIED EXTERNALLY;
GRANT CONNECT TO "OPS$padss";

Both are sucessful.

4. sqlnet.authentication_services = (NTS) in sqlnet.ora

5. log in as os user padss

6. sqlplus /

ORA-01017: invalid username/password; logon denied


Any ideas what is going wrong? I think that I've followed the steps correctly, but clearly I've missed something.

Many thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 4 2010
Added on May 4 2010
14 comments
7,837 views