RE: Connection problem if parameter HOME is set - SOLUTION

Thanks to all for your suggestions.

Looking at the log file gave me a clue that the wrong tnsnames.ora was being used. It was tricky since the host that it was connecting to has been renamed but the old name is still supported through DNS, so when I saw that the log file had the old name, I knew it wasn't using the right tnsnames.ora file.

Turns out there was a .tnsnames.ora in the /usr/users/oracle directory which was old. Since it had the leading . it was invisible and I didn't think to look for it. When I renamed it, everything worked fine.

Thanks again for all your suggestions.
Stephen

>>> kirti.deshpande_at_verizon.com 07/19/02 12:08PM >>> 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: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.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).