Re: ORA-12545 - Netware/Oracle/SQL*Net v2 Problem
Date: 1996/10/10
Message-ID: <53j4f3$jgg_001_at_news.psi.net>#1/1
In article <325BD653.4B15_at_orca.alaska.edu>,
"Maureen T. English" <snmte_at_orca.alaska.edu> wrote:
>4) I tried to connect to the database using the connect string
> SID.net.alaska.edu, and got the error message
> ORA-12545 TNS:name lookup failure. The manual says that there is
> something wrong with either the TNSNAMES.ORA or the LISTENER.ORA.
if you connected from a client machine, be sure the oracle sql*net client software was installed properly. be sure you copied the .ora files corresponding to the protocol community to the client. be sure the host machine can be identified by your DNS if you have one, or that it's defined in your local hosts files. try replacing host=blah.blah.alaska.edu with host=111.222.333.444 in the TNSNAMES.ORA (i.e, use the correct IP number).
if you are still stuck, try this: remove all domain references like "blah.blah.alaska.edu"; just use names without dots. remove them from all the .ora files in /network/admin. you don't need the domain names in a simple network.
Dave Mausner, Managing Consultant, Braun Technology Group, Chicago. Received on Thu Oct 10 1996 - 00:00:00 CEST