Re: tns error with windows

Forget about tnsnames.ora if the database is running on the PC... set an environment variable LOCAL=<sidname> ( replace <sidname> with whatever you called your oracle instance ) Then
Sqlplus uname/password should connect you...  

Nikolaus Volejnik <Nikolaus.Volejnik_at_debis.at> wrote:

>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 - 12:55:09 CST