Re: PLEASE HELP!!! Error ORA-12154

From: Declan Smith <D.Smith_at_itss.nerc.ac.uk>
Date: 1998/10/23
Message-ID: <36304347.0@news.nwl.ac.uk>#1/1

Hi,

If you look under ORACLE_HOME/network/admin you will find a file called TNSNAMES.ORA. SQL*Net 2 uses this file to work out which database you want to connect to. It translates your connect string into a machine and database sid.

On Windows there is a program called SQL*Net easy Config. Use this to add a database to the file, or if you are confident go in and edit it yourself so that your database is in there.

If your database is already in the file and you are still getting problems try using the database machine's IP address instead of it's name. Sometimes PC's have problems converting the name into the IP address.

Hope this helps.
Dec. Received on Fri Oct 23 1998 - 00:00:00 CDT