Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: problem in TNS could not resolve service name
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
![]() |
![]() |