Use TNS_ADMIN variable in your shell profile. Let TNS_ADMIN point to the tnsnames.ora you want to use.
I don't know if it works on unix, it works on Windows. regards Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -----Ursprüngliche Nachricht----- Von: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 16. April 2002 20:13 An: Multiple recipients of list ORACLE-L Betreff: Re: Using two TNSNAMES.ORA or some other solution. Just put all of the databases into every server and pc where you have a database and/or want to connect from. HTH, Ruth ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, April 16, 2002 1:28 PM > Hey all, > In my work place, usually I do the development of Oracle database > running on > HP-UX platform. But I also have an Oracle server(PC) running on my PC > running Windows NT. To connect to Oracle server running on my PC from > Unix box, I do the following on Unix box. > > $export > DB_LOGIN=dkumar/dkumarl@(DESCRIPTION=(ADDRESS_LIST=ADDRESS=COMMUNITY=tcp.wor > ld)(PROTOCOL=TCP)(Host=10.110.1 > 44.73)(Port=1521)))(CONNECT_DATA=(SID=DHARM))) > $ sqlplus $DB_LOGIN > and I am able to connect to sqlplus session without any problem. > > The reason I do this because I do not have permission to changes the > tnsnames.ora file on the Unix box.. So the access to oracle server > (PC) works fine using client sqlplus from Unix box. But the problem is > that if use the utilities like sqlloader, import and export and tries > to connect Oracle Server (PC), this approach does not work as the > following lines show > it. > > $sqlldr userid=$DB_LOGIN > LRM-00116: syntax error at 'dkumar/dkumar@(D' following '=' > > SQL*Loader: Release 8.1.6.2.0 - Production on Tue Apr 16 12:18:24 2002 > > (c) Copyright 1999 Oracle Corporation. All rights reserved. > > SQL*Loader-100: Syntax error on command-line > > So let me know if there is a way by which I can use two tnsnames.ora > on Unix > box and if that is possible then I can set description for Oracle > server > (PC) in the second file because I have tested that if DB_LOGIN is set to > dkumar/dkumar@corpdb where corpdb is the entry in tnsnames.ora then all the > utilities work fine. > > If somebody has some other ideas, let me know. > > Thanks. > > Dharminder Kumar > > > > > <FONT SIZE = 1>********************************************************************** 1>**** ** > This e-mail and any attachments may contain confidential and > privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorized and may be illegal. Unless otherwise stated, opinions expressed in this e-mail are those of the author and are not endorsed by the author's employer.</FONT> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kumar, Dharminder > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Ruth Gramolini INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).