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: problem in TNS could not resolve service name

Re: problem in TNS could not resolve service name

From: <ennaadu_at_my-deja.com>
Date: Wed, 23 Jun 1999 04:57:57 GMT
Message-ID: <7kppgi$t3v$1@nnrp1.deja.com>


In article <7kl2a6$5e0$1_at_news5.jaring.my>,   "william" <stamfod_at_po.jaring.my> wrote:
> may i know how to solve this error : TNS could not resolve service
name? i
> try to connect my oracle's client pc link to oracle database server.
it came
> out this problem. how to solve it? i started my lsnrctl already and
database
> server but i still can not solve it. pls help me. thank you.
> pls email to me : william43_at_hotmail.com
>

 All u need to do is to set up your client machine's SQL*net. If u have 7.x client installed then u'll have SQL*Net easy configuration utility. If you have 8.x client then you will have Net8 Assistant. Run these utilities depending on your client's version. You will have to give a name for the service which will be used in the connect string while connecting to the database. then you have to select a protocol that you use to connect to the oracle server. Then you have to specify the server name or the ip address of the server. The port is by default 1521. Once you finish this you can test your service by using the connect string as user/password_at_service. All the best!!

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 22 1999 - 23:57:57 CDT

Original text of this message

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