Regarding

[binjovi]

Hello Guys
I have a simple problem... I have a system of Oracle 8i, Server loaded on NT and clients in different 95 and 98 but when I loaded developer 2000 forms 6.0 etc... in the client or the Server . Its not getting connected to oracle and show error TNS protocol Adapter error

I tried to copy the listener from server to clients and tried all options it didnt solve

Can you guys help me to get this problem done.

Thanks
bins

 

[lfoata]

If a client can connect to the database via sqlplus, developer should also be able to connect since they both use the same networking software (sqlnet or net8).

If one works, the other one should work.

If neither work, look at the tnsnames.ora file on the client side.
Also, if you want to test the networking, you can do :
tnsping connect_string
where connect_string is the alias defined in the tnsnames.ora for the instance you are trying to connect to.

 

[CRoberts]

Sounds like a perennial Oracle problem. Each version of Oracle client tools wants its own compatible version of Sqlnet, Net8, etc. Do a file Find on Tnsnames.ora. You will undoubtedly will have multiple copies of your Tnsnames.ora. Check also your Sqlnet.ora file, it should specify Tnsnames if that is your environment.

It becomes rather dicey on your client, if that is were you are doing your work. Your Windows path and registry can be come a horror. You may want to edit your path on a client to reflect that one particular Oracle\bin is before another. Another related problem is that various versions of your tools will have different executables, depending on the version of Oracle. SqlNet v2.3 has Tnsping, but in Net80 it is called Tnsping80, which is again renamed back to Tnsping in 8i. So, depending on your path, your call on Tnsping may be a different executable than what you really wanted. To futher enliven this mix, some Oracle tools that are called "6i" may actually be using an older version of SqlNet, so that may have to be looked into.

Hope this helps. Also be aware that some Oracle products will automatically over-write an existing Glogin.Sql, Tnsnames.ora and Sqlnet.ora files. Saves these prior to loading any Oracle client tool.

 

[carp]

You might also try setting the environmental parameter TNS_ADMIN on the client machine so that it points to the NETWORK or NET80 subdirectory you want to use as a common Oracle network file repository. This normally (but not always) suffices for all of your Oracle applications on the machine.

 

[binjovi]

Thanks you very much for the response
But the problem am facing is that when I loaded this developer It is not installing the NET8 so how can I configure the clients...Secondly Is their any way that I can directly connect to a specific user

Thanks
bins

 

[lfoata]

All Oracle CDs have the networking software on.
When you run the installer, check for the netwroking and install it.
Net8 comes with an interface to help you configure the client and is very easy to do.

For your second question, I am not sure I undestand it but if you mean connecting to the database without using the networking, you can by logging on the database server directly and use svrmgrl or another tool.

 

[carp]

Yes - the Oracle tools require the network utilities and you MUST install them. Also, in rereading your original post, I notice you mention copying the listener to all of the clients. This is a waste of time and drive space; the listener only goes on the server. Remove any listener files from your clients, and install/configure the Net8 client software.

 

[binjovi]

Thanks for the answers..

I tried to install again the software in a client of windows 98 it didnt install I mean to say it didnt come in the program shortcut the net8 assistant or clients . Then it started the installer again and then tried the custom installation selected the net8 assistant and tried to install this gives and error ..
So I must do to resolve this you can help it will really appereciated...

Thanks

 

[carp]

It would help if you would mention exactly what the error was.

 

[binjovi]

When I loaded in a client the net8 assistant It showed default window error like Oracle 8 installer error and click details........... That shows some paga fault(normal error which occurs in window).

Thanks