Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: I can't connect with an user by externally !
Frank.
1. make sure Remote_login_passwordfile=NONE in initBASE.ora then
bounce instance
2. sqlnet.authentication_services=(beq,none) in sqlnet.ora
3. remote_os_authent = TRUE (if you have more than 1 database so you
can do sqlplus /@base2 from base w/o setting ORACLE_SID to base2
otherwise FALSE)
It just worked for me a few mins ago.
Hope this helps.
"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 Fri Jan 09 2004 - 15:06:34 CST