| Too many Oracle installs on WinXP [message #115893] |
Thu, 14 April 2005 19:35  |
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  |
 |
Maaher
Messages: 7065
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
