RE: Connection problem if parameter HOME is set

Have you checked the value of SID written out to the sqlnet.log file when that logon fails?
sqlnet.log should be in the directory where sqlplus is called from, either current directory
if logging in from the command line or check the bin directory where sqlplus lives. Also,
try turning on client trace to see what the difference is...do it both ways, then diff the two.

-----Original Message-----
Sent: Friday, July 19, 2002 3:29 PM
To: Multiple recipients of list ORACLE-L

Kirti,

Nope. I did check for that. Also, my friend discovered that revoking execute privs on that directory (/usr/users/oracle) also resolved the problem.

Seems wierd to me but maybe someone will have an explanation.

Stephen

>>> "Deshpande, Kirti" <kirti.deshpande_at_verizon.com> 07/19/02 10:57AM >>>
Does it have any sqlnet.ora, tnsnames.ora file?

• Kirti

> -----Original Message-----
> From: Stephen Andert [SMTP:StephenAndert_at_firsthealth.com]
> Sent: Friday, July 19, 2002 12:53 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Connection problem if parameter HOME is set
>
> A colleague of mine has encountered something strange. When the
HOME
> environement variable is set to the oracle users home
> (/usr/users/oracle) we can't connect to any oracle databases. When
it
> is set to anything else (or to nothing) everything works fine. What
is
> wrong with that directory to cause this?
>
> Also, this is only happening on one host and not on others.
>
> We are on Compaq Tru64 5.1 unix and a variety of 8i databases.
>
> Any clues?
>
> -->$ pwd
> /usr/users/oracle
>
> -->$ echo $HOME
> /usr/users/oracle
>
> -->$ sqlplus oradba_at_web1i
>
> SQL*Plus: Release 8.1.6.0.0 - Production on Fri Jul 19 09:04:10 2002
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
> Enter password:
> ERROR:
> ORA-12505: TNS:listener could not resolve SID given in connect
> descriptor
>
> -->$ unset HOME
>
> -->$ sqlplus oradba_at_web1i
>
> SQL*Plus: Release 8.1.6.0.0 - Production on Fri Jul 19 09:04:58 2002
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
> Enter password:
>
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.3.0 - Production
>
> Stephen
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Stephen Andert
> INET: StephenAndert_at_firsthealth.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Andert
  INET: StephenAndert_at_firsthealth.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Richard Huntley
  INET: rhuntley_at_mindleaders.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).