Home » Infrastructure » Windows » Too many Oracle installs on WinXP
Too many Oracle installs on WinXP [message #115893] Thu, 14 April 2005 19:35 Go to next message
rkirchg2
Messages: 1
Registered: April 2005
Junior Member
I have a strange issue.
We have a user who has installed OraForms on their Windows XP.
Prior to this, SQL*Net was installed already and working.
We have an unnamed 3rd party application which requires SQL*Net with TNSNAMES to connect to an Oracle database on an intranet server within the company firewall. This 3rd party application worked fine prior to the installation of OraForms.
We can connect to our Oracle database using the following path successfully:
Start|Programs|Oracle for Windows NT|SQLPlus 3.3
When you run Net8, even though TNSNAMES exists, the SID in TNSNAMES does not show up in Net8 Config.
When we run the following, we get the error noted below:
Start|Programs|Oracle - OraHome81|Application Development|SQLPlus
error = Message File SP1 <lang>.msb not found.
We are not in a position to reimage the harddrive.
Any suggestions on how to get this instance of SQLPlus working correctly?

Re: Too many Oracle installs on WinXP [message #116068 is a reply to message #115893] Sun, 17 April 2005 07:55 Go to previous message
Maaher
Messages: 7064
Registered: December 2001
Senior Member
Check how many TNSNAMES.ORA files you have on your box.
Check the default home.
Check the TNS_ADMIN registry value. This should point to the right directory (i.e. the one with the correct tnsnames.ora file)

To align the different TNSNAMES files, you can just use one and let the other(s) link to this files using the phrase:
IFILE=location of original tnsnames.ora file


HTH,
MHE
Previous Topic: Oracle 9i help
Next Topic: Oracle 9iR2 Patch Set 9.2.0.5.0
Goto Forum:
  


Current Time: Mon Aug 15 07:32:21 CDT 2022