Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: I can't connect with an user by externally !

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

From: Gerry Sinkiewicz <sinkiege_at_snet.net>
Date: Fri, 09 Jan 2004 00:27:41 GMT
Message-ID: <1AmLb.23082$1G3.15075@newssvr33.news.prodigy.com>

"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? Received on Thu Jan 08 2004 - 18:27:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US