Re: TNS names errors

Oracle offers following Actions to resolve the ORA 12154-Problem:   Make the following checks and correct the error:

• Verify that a TNSNAMES.ORA file exists and is in the proper place and accessible. See the operating system specific manual for details on the required name and location.
• Check to see that the service name exists in one of the TNSNAMES.ORA files and add it if necessary.
• Make sure there are no syntax errors anywhere in the file. Particularly look for unmatched parentheses or stray characters. Any error in a TNSNAMES.ORA file makes it unusable. See Chapter 4 in the SQL*Net V2 Administrator's Guide. If possible, regenerate the configuration files using the Oracle Network Manager.

In article <6rd96p$qqq_at_bgtnsc01.worldnet.att.net>,   "Madhu Cherukuri" <Madhu.Cherukuri_at_worldnet.att.net> wrote:
> Look at the tnsnames.ora file (in /var/opt/oracle)
> where all the database connections are defined
> If you do not have an entry for the remote database
> you are trying to access, you need to create one
> Look at the file for example or some configured
> connections. You can copy and pase from one of them
> and change the host and databse names appropriately
>
> HTH
> Madhu Cherukuri
>
> dwbeauregard_at_my-dejanews.com wrote in message
> <6rd635$kg3$1_at_nnrp1.dejanews.com>...
> >Hello,
> >
> >I'm trying to connect to a remote Oracle database (7.3.4.0.1 for Sun
> Solaris)
> >using sqlplus. I get the following error message:
> >
> >ERROR: ORA-12154: TNS:could not resolve service name
> >
> >
> >Any ideas out there?
> >
> >
> >Daryl Beauregard
> >
> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 20 1998 - 06:50:26 CDT