Re: What's wrong with tnsnames.ora?

From: Craig Kelley <ink_at_inconnu.isu.edu>
Date: 2000/03/30
Message-ID: <m1g0t7wwih.fsf@inconnu.isu.edu>#1/1

pojpl_at_ais.ucla.edu (Jim Lewis) writes:

> RedHat 6.1
> Oracle8i 8.1.5
> Problem: Getting error 12514 TNS: listener could not resolve
> SERVICE_NAME given in connect description.
>
>
> Oracle8i is installed. The sample database is installed and working
> -- I can connect as scott/tiger on the RedHat machine and run sql
> against the emp table.
>
> I have used Net8 Assistant to create listener.ora, tnsnames.ora and
> sqlnet.ora files on the RedHat server and on the NT4.0 client machine.

The Net8 Assistant is not always nice. I had to hand-edit it afterwards: http://inconnu.isu.edu/~ink/oracle

I've successfully used this against the 8.0.5 client for NT.

-- 
The wheel is turning but the hamster is dead.
Craig Kelley  -- kellcrai_at_isu.edu
http://www.isu.edu/~kellcrai finger ink@inconnu.isu.edu for PGP block

Received on Thu Mar 30 2000 - 00:00:00 CST