Re: I can't connect with an user by externally !

From: Franck <nospam_at_toto.com>
Date: Fri, 09 Jan 2004 19:00:20 +0100
Message-ID: <pan.2004.01.09.18.00.18.739727@toto.com>

Le Fri, 09 Jan 2004 00:27:41 +0000, Gerry Sinkiewicz a écrit :

>
> "Franck" <nospam_at_toto.com> wrote in message
> news:pan.2004.01.08.21.38.53.236528_at_toto.com...

>> Le Tue, 06 Jan 2004 02:45:07 +0000, Gerry Sinkiewicz a écrit :
>>
>> > You might want to make sure your ORACLE_SID is set properly.
>> >
>> > remote_os_authentication is not needed for a local connection as in

> "sqlplus

>> > /", but you
>> > might need IPC included in your listener.ora.
>> >
>> > Also remote OS authent  can be spoofed (security vulnerability) with

> older

>> > client software.
>> >
>> > "Franck" <nospam_at_toto.com> wrote in message
>> > news:pan.2004.01.05.17.10.34.257909_at_toto.com...
>> >> I created 2 users, one identified by password he can connect
>> >> and an another one identified by externally on Redhat 9, he can't

> connect,

>> >> there is the error :
>> >> [franck_at_DBA franck]$ sqlplus /
>> >>
>> >> SQL*Plus: Release 9.2.0.1.0 - Production on Mon Jan 5 17:59:38 2004
>> >>
>> >> Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
>> >>
>> >> ERROR:
>> >> ORA-01017: invalid username/password; logon denied
>> >>
>> >>
>> >> Enter user-name:
>> >>
>> >> until the account lock !
>> >>
>> >> in initSID.ora, I put :
>> >> remote_os_authent = TRUE
>> >> os_authent_prefix = ""
>> >>
>> >> there is something wrong or something miss me !
>> >>
>> >> thanks to help me
>> >>
>> ORACLE_SID=base
>> base is the name of the database, it is ok but it doesn't work :-(
>>

>
> Do you have a password file set up, which might be required for remote os
> authent?

I found, I made a mistake, I had created user by externally and not externally then oracle thought the password was "externally". "by" is used only for authentification by oracle ;-)

thanks Received on Fri Jan 09 2004 - 12:00:20 CST