Re: TNS could not resolve service name? how to solve it?

Hi william,
did you configure the database connection in the file TNSNAMES.ORA at the client?

When you try to connect the client looks into the file TNSNAMES.ORA and looks for the connect string. There it will find the address of the machine, the port number of the listener and the name of the instance. You can check it with the command
tnsping xxxxx ... where xxxx is the connect string. e.g
H:\>tnsping wien

TNS Ping Utility for 32-bit Windows: Version 2.3.4.0.0 - Production on 24-JUN-99

 21:28:58

Copyright (c) Oracle Corporation 1995. All rights reserved.

Attempting to contact (ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(Host=hp01)(Po

rt=1526))
OK (570 msec)

You can manually edit the file or use the tool "SQL-NET Easy Configuration".

For your Database you should find something like that: WIEN.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = TCP.world)

          (PROTOCOL = TCP)


          (Host = hp01)

          (Port = 1526)

        )

       (SID = WIEN)
       (GLOBAL_NAME = WIEN.world)

I hope this helps.

roland
DI Roland Schaar
Gosch Consulting GmbH

A-8010 Graz, Schützenhofgasse 8
Tel.: ++43 (0) 316 - 84 31 57 - 0
Fax: ++43 (0) 316 - 84 31 57 - 8

A-1190 Wien, Gunoldstraße 16
Tel.: ++43 (0) 1 - 367 89 90 - 0
Fax: ++43 (0) 1 - 367 89 90 - 8

office_at_gosch.com
http://www.gosch.com

william 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