Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: tns error with windows

Re: tns error with windows

From: Eric <eric_thebee_at_hotmail.com>
Date: Tue, 27 Mar 2001 23:50:08 +0930
Message-ID: <3ac0a167$1_2@news.chariot.net.au>

Thanks for the reply.
I should be more specific- I want to run Oracle on a stand-alone pc. Why do I even need the tns and adapter in this case? Can I uninstall this part of Oracle that wants this to be configured to make life simpler?
any help appreciated
regards
Eric.
Nikolaus Volejnik <Nikolaus.Volejnik_at_debis.at> wrote in message news:3AC096ED.1B246A1A_at_debis.at...
> 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 - 08:20:08 CST

Original text of this message

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