Re: tns error with windows

Hi Eric,

maybe it´s a simple Windows error.
the server to which you connect, must be clear for windows. example: if your oracle server has a fully domain like oraserver.eric.domain.us

in the tnsnames.ora is only oraserver. edit the hosts file of your client and add "oraserver ip-address" into it.
try again, maybe it helps.

regards
nik

Eric schrieb:

> I have just installed Oracle 8i ent in win98 but when I start sqlplus I get
> the following error:
> ORA-12560: TNS:protocol adapter error
> in the documentation it says:
>
> Verify that the ADDRESS in the TNSNAMES.ORA file or the *LISTENER.ORA
> file is correct.
> Verify that the listener on the remote node has been started. You may check
> its status with the STATUS command of the Listener Control Utility, and
> start
> it with the START command if necessary.
>
> My questions are:
> 1. what should the address be and where do I change it it the files? -for
> win 98, no network.
> 2 Also how do I start the "listener"?, what command?
> 3. Will I have the same problems if I use NT4?
> Any help will be appreciated as I am a novice but am trying to learn more.
> thanking you in advance
> Eric.
Received on Tue Mar 27 2001 - 07:34:37 CST