Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help!

Re: Help!

From: <narenn_at_my-dejanews.com>
Date: Thu, 22 Apr 1999 18:17:06 GMT
Message-ID: <7fnp2t$tbr$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US