| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Connection problem if parameter HOME is set
Waleed,
HOME=/usr/users/oracle
export HOME
echo $HOME
But that doesn't explain why we saw this behaviour.
Stephen
>>> Waleed.Khedr_at_FMR.COM 07/19/02 01:28PM >>> I do not know how can you change the HOME variable?
This is an UNIX environmental variable that's maintain by your shell
and
probably affects many things!
Waleed
-----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?
> -----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: Khedr, Waleed INET: Waleed.Khedr_at_FMR.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).Received on Sun Jul 21 2002 - 02:23:21 CDT
 |
 |