Still OS Authentication

I presented this problem earlier and got some great responses but I'm still not able to authenticate via the OS.

Allow me to elaborate a little further...

We are running Oracle 7.3.4 on AIX 4.1.5

I added the line "os_authent_prefix=OPS$" to my initTEST.ora parameter file.
I restarted the instance.
I created a new Oracle user with the following syntax..

        create user OPS$user identified externally; I created the AIX user "user"
I verified that dba_tables does in fact list user OPS$user as external I verified that the AIX user has the correct ORACLE_SID and has the correct path variables.

Using the AIX user "user" I can successfuly log into sqlplus with the following syntax
sqlplus system/manager
This only works so long as I specify a valid database authenticated username and password.

However, I fail to connect to sqlplus using the following syntax... sqlplus /

All of this takes place locally via telnet session.

The documentation says only that I need to set the OS auth prefix in the init.ora parameter file and restart the instance. Then I should be able to connect to the database with an OS user who's name matches the part of the Oracle username which follows OPS$. The example it gives is "sqlplus /" but this isn't working for me.

Can anyone tell me what I'm missing?

Thanks in advance! (again)
Roger Westbrook, rogue Sys Admin
Dollar General Corp
please reply to rwestbrook_at_dollargeneral.com

>I am attempting to enable OS Authentication for a few selected users and
>am having difficulties.
>
>I am running Oracle 7.3.4 on AIX 4.1.5.
>
>I've set the OS Auth prefix variable (I forget the exact var name at the
>moment but I pulled it out of the docs - even used cut and paste so I
>know it's not spelled wrong) in the init.ora for that instance. I took
>the standard "OPS$". I restarted the instance and added user "OPS$user"
>identified by external. Then, logged into the AIX as user "user", I
>tried to log into SQL*Plus (locally via telnet, not from client) like
>this... "sqlplus /" It denied access as invalid username and password.
>
>What am I missing here?
>
>Thanks in advance!
>Roger Westbrook, rogue Sys Admin
>Dollar General Corp
>
>Please reply-to rwestbrook_at_dollargeneral.com
Received on Fri Jan 22 1999 - 00:00:00 CET