Re: oracle reports

This isn't the most elegant solution, but it's one I've had to use before, so I'll offer it up...

Oh, and I'm assuming you're running Win95 or NT...

First, copy the correct tnsnames.ora file to someplace safe. You'll need it later.

You can delete the ORAWIN and/or ORAWIN95 directories from your PC, use regedit to go into the registry and delete every Oracle software key. Reboot your machine, reinstall the desired Dev/2000 and other Oracle programs. Move the tnsnames.ora file to your newly-created \ORAWIN95\NETWORK\ADMIN (for Win95) or \ORANT\NETWORK\ADMIN (for NT) directory. Try a tnsping <instance_name> to make sure you can see the desired instance...

Hope this helps,
bob

bdnisv_at_my-deja.com wrote:
> I am relatively new to oracle, and I had a version of enterprise manager
> on my machine, which was quite nice. I had been writing reports from our
> databases just using pl/sql and stored procedures. So I thought it would
> be nice to try out oracle reports and after installation, enterprise
> manager, sql plus and a few other things just don't work any more. I
> get tns unable to resolve service name as an error message. So I found
> about six tnsnames.ora file on my machine, found the right one, copied
> over the other ones thinking that might work and nope. I would really
> like to be able to use these, but being new to oracle and the available
> tools, I have no idea what to do, any suggestions??
Received on Sun Apr 23 2000 - 00:00:00 CEST