Re: Connection Problem

DTMAX <XXX_at_hotmail.com> schrieb in im Newsbeitrag: ZkAk5.6$3G6.1608_at_news0.optus.net.au...
> Hi all,
>
> Hopefully someone could help me with this problem.
>
> I am getting this error message when trying to connect to a Oracle
 database
> through WAN - "ERROR: ORA-12154: TNS:could not resolve service name". This
> message came up after installing Novell Client for NT or MS NetWare
 Client.
> The reason why I have to install the NetWare client is to map drives on
 the
> NT Workstation box. The NT Workstation has TCP/IP installed as the main
> protocol to communicate with the database over the WAN.
> I can ping the Oracle Server with the Novell Client installed but when I
> tried to use SQL Plus 3.3 to connect the database, I will get the above
> error message. ????
>

Hi,

you must install a service for connecting to Oracle. For Oracle8 there is a tool Net8EasyConfig, which does that, on the other hand you can search a file called "tnsnames.ora". There can be more such files, you can edit one and then copy it to all other locations, the responsible file is in the Folder which is named after your Database-name. There you enter a service-name, SID and IP-address (or hostname) of the server and the next connect should work.

Greetings,

Michael Oswald
Siemens Austria
Space Business Unit Received on Thu Aug 10 2000 - 00:00:00 CDT