Re: External authentication problem on Digital Unix

From: Malcolm Dunnett <dunnett_at_mala.bc.ca>
Date: 5 Jan 99 08:28:48 -0700
Message-ID: <IM5gu71y4PZ1@malvm1.mala.bc.ca>

In article <3691F9A8.1D5DF33F_at_i-wave.net>,

John Koo <johnkoo_at_i-wave.net> writes:

> Malcolm Dunnett wrote:
>

>>   I'm having trouble getting external authentication working for
>> Oracle 7.3 on Digital Unix 4.0d.
>>

>
> First of all, are your OS login name equal (exactly equal) to your Oracle
> username ??

yes. I noted ORACLE creates the username in upper case whereas on unix they're in lower case, however this seems to be ok.

> Second, how are you trying to login using SQLplus ?? thru' a dumb terminal ?? a
> xterm session ??

a dumb terminal

> and what is your sqlplus command look like ??
>

It turns out this was the problem ( as someone else pointed out through email ). I'd tried "sqlplus" with no connect string and "sqlplus <username>", but hadn't tried "sqlplus /" ( which is, of course, the correct way ). It works now.

Thanks for the pointer

Malcolm Dunnett    Malaspina University-College     Email: dunnett_at_mala.bc.ca
Computer Services  Nanaimo, B.C. CANADA V9R 5S5       Tel: (250)755-8738

        "OpenVMS is today what Microsoft wants Windows NT v8.0 to be!"
           posted on www.openvms.digital.com on or about Sep 22,1998
                           Quashed on Sep 23,1998

Received on Tue Jan 05 1999 - 09:28:48 CST