Linux - NetworkingThis forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
Well, I managed a successful installation of Oracle 10g on White Box EL 3 using Werner Puschitz tutorial few days back. The next step is to connect clients running Windows 2K/XP with my database server. However, when I try to log in with username scott, password tiger and Host String=test (the Oracle SID), I get the error
TNS: no listener
I have searched for this error on google and noticed that there are 3 files that are important in context of Oracle Client connectivity -
Listener.ora, sqlnet.ora and tnsnames.ora
Now, I also noticed that my client has sqlnet.ora and tnsnames.ora only. Can the absence of Listener.ora on my client machine be the reason for the above error ?
As far as Oracle Installation and client connectivity goes, I am a beginner, so thats why I dont have much idea about the above 3 files.
I have used the following commands on the oracle server when logging in as oracle
However, till now, I havent come across any document that could guide me at connecting a Windows client to linux database server.....So I'd needing some help here...can anyone tell me where am I going wrong ?
Well, I expected someone to help me out here as I know that there are lot of people Installing and using Oracle 10g all around the world.....Even after 48 views, no one suggested anything.....
Anyways, I have found out the solution...Hope you friends will benefit from this information....
As I wrote in my first post, there are 3 files that are important with respect to Oracle
1. Listener.ora
2. tnsnames.ora
3. sqlnet.ora
So, I will start from the beginning...
(I'd like to inform u that I am just a beginner as far as Oracle goes...)...I chose the 'CUSTOM' method of Oracle 10g client installation and selected Oracle SQL*Plus, Oracle Network tools, Oracle 10g Client and few others that looked relevant to me
After Installating the Client, I copied Listener.ora from the server to my client. The files tnsnames.ora and sqlnet.ora were auto-generated by Oracle Configuration tools...
( After Creating this file 'listener.ora' on the client machine, restart the listener on Oracle Server using the command 'lsnrctl stop' and then 'lsnrctl start')
Now run SQL*Plus and connect as user scott/tiger and use host string as your SID ('test' in my case)
I used the user 'system' to connect to SQL*Plus and I had set the password for users 'system', 'sys' , 'dba' ..etc at the time of oracle server installation on WBEL 3.0, so u should keep that in mind when using any of these users to connect to the database....
Thats it, the windows client should now be able to connect to your linux server........I would like to hear if this information helped you guys.....
Please feel free to correct me if I have been wrong anywhere....
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.