0

I have two Oracle Client installed in my machine. One is Oracle 11g another one is ORACLE 8.1. I was trying to connect Business Objects to Oracle 8.1, but it fails as while connecting through TNS entries it is alwas hitting the Oracle 11G's TNS entry.

I tried TNSPING ICS.WORLD, It is working fine in the other machines where only one instance(Oracle 8.1) of oracle is available. But for me it is prompting failed to resolve name.

Would you please suggest what changes should I made so that TNSPING would hit the Oracle 8.1's TNSNAMES.ORA? Following is the error I am getting

'Microsoft Windows XP [Versione 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\Deys>tnsping ICS.WORLD TNS Ping Utility for 32-bit Windows: Version 11.2.0.2.0 - Production on 05-DIC-2 012 16:01:06 Copyright (c) 1997, 2010, Oracle. All rights reserved. Used parameter files: D:\ORACLEXE\app\oracle\product\11.2.0\server\network\admin\sqlnet.ora TNS-03505: Failed to resolve name'
Subhamoy
  • 116
  • 5
  • 21
  • I guess you're using the tnsping from your 11g client installation - try to run the 8i tnsping (either by cd'ing to the bin subdir of the installation directory or by providing the complete path to the binary). – Frank Schmitt Dec 05 '12 at 11:21
  • @FrankSchmitt Thanks a lot, Sorry May be I was not clear enough...I dont know how to run 8i TNSPING instead of Oracle 11G. Would you please tell me the details or any documentation where I could refer to? – Subhamoy Dec 05 '12 at 11:33
  • For each of your clients, you should have an installation directory c:\oracle\product\\client\ (or similar, depending on your OS and installation parameters). Change to your 8i installation directory's bin\ subdirectory, and run tnsping from there - then you should see the tnsping Version 8i banner, and it should tell you which files it uses to resolve the TNS names. – Frank Schmitt Dec 05 '12 at 11:56
  • @FrankSchmitt, I know where the TNSNAMES.ORA file is for Oracle 8i. It is in the C:\ORACLE\ORA81\network\ADMIN folder. But whenever I am doing TNSPING to any of the Names Specified there, I am getting prompt suggesting that TNSPING utility is using Version Oracle 11G. I also set the TNSADMIN variable I set it to the "C:\ORACLE\ORA81", i.e my actual directory of oracle 8i. But still no avail :( – Subhamoy Dec 05 '12 at 14:02
  • Did you run c:\oracle\ora81\bin\tnsping.exe, as I had suggested? – Frank Schmitt Dec 05 '12 at 14:44
  • @FrankSchmitt... Yes Indeed. I already run that as per your suggesion. But yet still it is connecting through Oracle 11 and failing to resolve names of ORA81 directory's TNSNAMES. I have edited my main post to describe the error. – Subhamoy Dec 05 '12 at 15:38
  • You are not running the correct tnsping - "TNS Ping Utility for 32-bit Windows: Version 11.2.0.2.0" clearly indicates you are running the 11g version. Please do as I suggested and run the tnsping utility from the 8i version: c:\oracle\ora81\bin\tnsping.exe – Frank Schmitt Dec 05 '12 at 18:07

0 Answers0