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: Franck <nospam_at_toto.com>
Date: Thu, 08 Jan 2004 22:38:54 +0100
Message-ID: <pan.2004.01.08.21.38.53.236528@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 :-( Received on Thu Jan 08 2004 - 15:38:54 CST

Original text of this message

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