| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> AW: Using two TNSNAMES.ORA or some other solution.
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:v.schoen_at_inplan.de
http://www.inplan.de
-----Ursprüngliche Nachricht-----
Von: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]
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" <ORACLE-L_at_fatcity.com>
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_at_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>****
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: rgramolini_at_tax.state.vt.us 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: INET: v.schoen_at_inplan.de 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 Tue Apr 16 2002 - 13:33:52 CDT
 |
 |