Re: Using two TNSNAMES.ORA or some other solution.

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Tue, 16 Apr 2002 10:13:29 -0800
Message-ID: <F001.004459D7.20020416101329@fatcity.com>

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>**************************************************************************

**
> 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: Dharminder.Kumar_at_bmonb.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: 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).

Received on Tue Apr 16 2002 - 13:13:29 CDT