August 14, 2001 at 10:46 am
We currently have a test server running Windows 2000 that is happily connected to an Oracle box as a Linked Server.
I have now tried to configure another server by running the same Oracle Client installation routine. I then copied over the TNSNAMES.ORA file that I know works.
I then went into SQL*Net and attempted to connect using the User Name, Password and Host String that works just fine on the first box.
The new server won't connect.
The only difference is that when installing on the new machine, I didn't take the suggested default path of D:\ORANT - I selected C:\ORANT instead.
Should this have made such a difference?
Can anyone suggest what else I could look at / change to get it going.
I have tried uninstalling in order to re-install using the default path, in case that's it but it doesn't want to shift!
Any suggestions gratefully received.
Nigel.
August 14, 2001 at 8:37 pm
Hi Nigel,
No experience on Oracle - hoping one of our readers does! If you dont mind, could you offer a bit of background on what TNSNAMES.ORA does - just because Im curious?
Andy
August 16, 2001 at 9:30 am
Andy,
TNANAMES.ORA contains connection definitions for each of the Destination Servers in the following format:
BANANA.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = 110.110.1.10)(Port = 1521))
(CONNECT_DATA = (SID = b1b2))
)
SID is the instance of oracle on the Host that is being referenced.
We are still troubleshooting at the moment, but these have been the steps so far:
Steps taken to resolve this issue:
Find the location that the Oracle Client is using for TNSNAMES.ORA
Start ‘Oracle Net8 Easy Config’
Add a new Service – e.g. ‘BANANA’, TCP/IP, B1B2, 1521, TOP
Save this Service and see where TNSNAMES.ORA is located
Copy TNSNAMES.ORA and SQLNET.ORA to the correct location on to the new server, as defined above
Ping each of the Destination servers
Use TNSPing80 to ping each of the Destination Servers by their TNS name (e.g. BANANA)
There's a prize for anyone who can mail me the 'real-life' relevance of B1B2 to Banana.
August 16, 2001 at 5:41 pm
Thanks for posting that info Nigel. But I have no bananas!
Andy
August 29, 2001 at 2:36 am
A brief update - Oracle have informed me that the earliest version of Oracle supported on Windows 2000 Advanced Server is 8.1.7.
Also, the easiest way of un-installing the version that currently exists is to delete the Oracle home directory (ouch!) I think a regclean is in order after that.
The new version is on order and I will update when it's successful!
August 29, 2001 at 5:00 am
Gee, an upgrade will fix it? Who woulda thought??
Thanks for the follow up!
Andy
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply