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: ORA-12154 TNS:could not resolve service name

Re: ORA-12154 TNS:could not resolve service name

From: jhy <jhy_at_earthling.net>
Date: 7 Aug 1998 21:34:32 GMT
Message-ID: <35CB72EA.A0B7409@earthling.net>


Try using 2:PROD for your connect string.

Franklin wrote:

> hi folks:
> i'm new on installing Oracle, i just installed oracle 7.3 on NT4
> server w/ SP3.
> i created a new service and database named PROD and PROD_DB, and able to
> connect to it after i modified
> registery key ORACLE_SID to PROD and leave the Host String blank when i
> tried to connect with SQL*Plus. if i put PROD in host string field, it
> gives "ERROR: ORA-12154: TNS:could not resolve service name" msg. I
> tried to use SQL*net Easy Config, it gives a different msg complaining
> about not founding the service on remote destination, or something like
> that.
>
> How do i correct this?
> Thanks for any help,
> Franklin
> fxu1_at_hotmail.com
Received on Fri Aug 07 1998 - 16:34:32 CDT

Original text of this message

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