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@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: [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).
begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
