Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: multiple versions of SQLPlus.exe

RE: multiple versions of SQLPlus.exe

From: Kevin Kostyszyn <kevin_at_dulcian.com>
Date: Tue, 29 May 2001 11:37:38 -0700
Message-ID: <F001.003126B6.20010529114126@fatcity.com>

That is the case, I agree, then you should still be able to use both of you sqlplus's, not that it really matters though. Kev

-----Original Message-----
DeUrioste
Sent: Tuesday, May 29, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L

Dave,

It seems to me that you are having a problem reading the proper TNSNAMES.ORA for

the different DBs. What I would do in your situation is to search for all TNSNAMES.ORA files in your PC, since you have products installed in more than
one home and more than one version you should have multiple. Edit them and see
which ones contain the entries that you need, in one or more of them some entries will be missing, what you can do is copy/paste the missing entries, once

you have the file you want then copy it to all the different "Homes" and you should be able to connect to the different DB's.

Hope it helps.

Luis Octavio

"Farnsworth, Dave" wrote:

> I have a server NT4.0, SP5 that has two versions of Oracle installed. On
> drive J is Oracle 8.0.5 which is used by a third party app and has been up
> and running for about a year. This last week I installed on drive E
Oracle
> 8i 8.1.7 and have not yet created a database. This Saturday on of the
> operations people re-booted this server. That night the app using 8.0.5
had
> an error. From what I can tell the following happened to cause the app to
> fail.
> When the server was re-booted, it reset the PATH setting in the
environment
> in the win.ini file to point oracle to the 8.1.7 version.
>
> PATH=E:\ORA817\bin;E:\ORA817\Apache\Perl\5.00503\bin\mswin32-x86;
> E:\ORA817\Oracle\jre\1.1.7\bin;E:\ORANT\bin;c:\DMI\win32\bin;
> C:\WINNT\system32;C:\WINNT;E:\COBOL32\EXEDLL;E:\orawin\bin;
> j:\merant\net express\base\bin;e:\cobol32\exedll
>
> The app then tried to execute a batch file that calls sqlplus.exe. This
is
> where the error occurs and the app sits at a sceen wanting a login name
and
> password for sqlplus. Below is the batch file.
>
> J:
> cd \logility\Ora_sql
> set oracle_sid=LV54
> SqlPlus user/pass_at_lv54 @Qry_Log.sql
> Notepad.exe qry_log.txt
> ::Qry_log_show.bat
>
> I get this error when the batch file is executed, "ora-12154 TNS: Could
not
> resolve service name". I assume that because the path is now set to point
> at 8.1.7 that sqlplus is now looking at the 8.1.7 tnsnames.ora which
> currently has no entries for databases. If I edit the PATH setting and
put
> a reference to the 8.0.5 version on J drive, then it works fine but now I
> get the 8.0.5 sqlplus when I try go to e drive and type sqlplus at the
> command prompt.
> Can I have multiple versions of sqlplus that can be called from the
command
> prompt on the same box? Can I have multiple versions of tnsnames.ora?
> Would I need to include all the database names for each version in every
> tnsnames.ora file?
>
> Thanks,
>
> Dave
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Farnsworth, Dave
> INET: DFarnsworth_at_Ashleyfurniture.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: Kevin Kostyszyn
  INET: kevin_at_dulcian.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 Tue May 29 2001 - 13:37:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US