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

From: Gerry Sinkiewicz <sinkiege_at_snet.net>
Date: Tue, 06 Jan 2004 02:45:07 GMT
Message-ID: <TipKb.4053$0F7.2372@newssvr16.news.prodigy.com>

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
>
Received on Mon Jan 05 2004 - 20:45:07 CST