Re: Still OS Authentication

Sorry, I did leave out the error message I was getting. The only error returned is
"ERROR: ORA-01017: invalid username/password; logon denied" Yes, I have granted connect resources.

It's really very confusing. According to the docs it should work. My suspicion was that it had to be something simple I overlooked but I've stepped you folks through exactly what I did and even you guys haven't spotted a blatant error. :)

Thanks again for the help!
Roger

Roger Westbrook wrote:
>
> 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 Sat Jan 23 1999 - 00:00:00 CET