Re: tns error with windows

hi eric,

it doesn´t matter if you are running oracle on a standalone machine or not. You have to identify your database in the tnsnames.ora file to connect to the database.

My mistake, i didn´t read, that you are installing on win98, here is the answer for win98: It will not work
You will have to use WinNT.

Little help when installing O8i again, use the example database during install. After install, start the net8assistant to identify your database in the tnsnames.ora file.
The net8assistant is a comfortable GUI for describing a database in tnsnames.ora.

good luck,
nik

Eric schrieb:

> 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 - 10:01:25 CST