Re: Still OS Authentication

Ok, I think I've solved my problem but now I'm not sure why. :) I've been attempting to test all this using the AIX root user. Everything worked fine except, as I said, I couldn't connect using "$ sqlplus / ". I've tried everything you guys said and it still wouldn't work so I tried creating another user called "test" in AIX and "OPS$test" in Oracle. It worked fine! I went back and recreated the oracle user "OPS$root" the same way I created the OPS$test user and it still did not work for root.

At any rate, it's working (I used root for testing purposes only so I really don't care that it doesn't work for that username) though I'm still curious as to why it wouldn't work for root.

Thanks again!
Roger Westbrook, rogue Sys Admin
Dollar General Corp

OraSaurus wrote:

> In article <36AB7F6C.78DB96E8_at_home.net>, Roger Westbrook <sidhe_at_home.net> wrote:
> >Yes, that is exactly what I'm saying and thank you for your
> >clarification.
> >
> >I tried your examples and while logged into the OS as user "joe" I can
> >connect with
> >"$ sqlplus ops\$joe/blow" and "SQL> connect ops$joe/blow"
> >but still cannot connect with "$ sqlplus / "
> >
> >Do OS groups which joe belongs to matter? User joe does not belong to
> >the dba group but I didn't see anything in the documentation to lead me
> >to believe that this was an issue. (I'd have tested that already but
> >we're having phone line troubles so I can't use my dial-up)
>
> "joe" does not need to belong to the dba group. For this case, the OS groups
> don't matter. You are positive that you are logged in as the Unix user "joe"
> and "$ sqlplus / " doesn't work? You are not doing something like
> "$ sqlplus /_at_some_script.sql..." are you? Sorry to ask such basic
> questions, but this is puzzling! I'll have to get back to it...
>
> -- OraSaurus
> --
> -- Remove "not_" to reply...
> --
Received on Mon Jan 25 1999 - 00:00:00 CET