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: Tom <mytmai99_at_yahoo.com>
Date: 9 Jan 2004 13:06:34 -0800
Message-ID: <55580640.0401091306.3027e874@posting.google.com>


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

Original text of this message

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