Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help!
In article <01be8cd1$78c236c0$f608adc7_at_jmoni.mosakin.com>,
"Jake Moni" <jmoni_at_mosakin.com> wrote:
> Could anyone help me.
> I have created a new oracle instance (oracle 7.3),
> it is up and running but when ever I try to connect
> via SQL* Plus I get this error:
>
> ORA-12154: TNS could not resolve service name.
>
> Any suggestions?
>
> Jake
>
Your tnsnames.ora does not have an entry for the instance you are trying to
connect. Edit this file and add a entry for the service ( mostly oracle sid )
you are trying to connect to.
If this in on UNIX the default tnsnames.ora should be under network/admin/
directory.
Hope this helps
-Naren
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 22 1999 - 13:17:06 CDT