Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Connection problem if parameter HOME is set
Do you have a ".tnsnames.ora" or ".sqlnet.ora" in /usr/users/oracle?
-----Original Message-----
Sent: Friday, July 19, 2002 1:53 PM
To: Multiple recipients of list ORACLE-L
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: Toepke, Kevin M INET: ktoepke_at_trilegiant.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 Fri Jul 19 2002 - 13:28:30 CDT