Re: O8i on Linux: identified externally

Hi lothar:

        I think U made two simple mistakes [ I am sorry it can also be two incorrect actions.. :) ]. When U want to have a os authentication U as Fuzzy mentioned U should have OS_AUTHENT_PREFIX set to something usually U have to just uncomment the line in the init file which defaults to ops$. Which means that U should create a db account as ops$la identified externally. Also I just posted a similar reply where U can check out some more details. I think the question was some thing like "can't sqlplus / "

HTH Vinayak
-- Luck is the dividend of Sweat, The more U sweat the more luckier U get.
--Ray Kroc.

In article <381e0e09.87503984_at_newshost.interact.net.au>,   granta_at_nospam.student.canberra.edu.au (Fuzzy) wrote:
> On 01 Nov 99 20:36:14 +0100, "Lothar Armbrüster"
> <lothar.armbruester_at_rheingau.netsurf.de> wrote:
>
> >Hello out there,
> >
> >I cannot get the OS authentification to work on my Oracle 8i
8.1.5.0.1
> >installation on Linux.
> >I have a Linux user called 'la'. So I logged into Oracle as system
and did
> >
> >create user la identified externally default tablespace ...
> >grant connect to la;
> >
> >Now from another xterm I try the following:
> >
> >sqlplus la
> >
> >(I'm logged in as la)
> >But it asks for a password. What do I do wrong? I did not find a
solution
> >in the docs. Do I have to set some environment variables?
> >I even tried to create a Linux user 'LA' but LInux gives some strange
> >results with that. Then I tried an Oracle user in lower case:
> >
> >create user "la" ...
> >
> >But it did not work either.
> >
> >Who can help?
>
> Assuming you have os_authent_prefix and sqlnet.authentication_services
> set properly, then you just need to type
>
> sqlplus /
>
> to connect.
>
> Ciao
> Fuzzy
> :-)
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 02 1999 - 06:36:21 CST