DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Connecting Client Windows-Server Linux

  1. 08-20-2008, 08:59 AM #1
    abdel
    abdel is offline Junior Member
    Join Date
    Nov 2007
    Location
    Douala, Cameroun.
    Posts
    77

    Connecting Client Windows-Server Linux

    Hello,

    I could set up my oracle db on a server running Linux (RHEL4). I have some client machine that run Windows XP and I have to set'em up so that the can connect to the database server.

    Can somebody tell me how to configure that environment?

    Thanks.
    Reply With Quote Reply With Quote
  2. 08-20-2008, 10:49 AM #2
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Thumbs down WinDoze client

    1) Create database on Linux.
    2) Install Oracle client on WinDoze.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
    Reply With Quote Reply With Quote
  3. 08-20-2008, 11:03 AM #3
    abdel
    abdel is offline Junior Member
    Join Date
    Nov 2007
    Location
    Douala, Cameroun.
    Posts
    77
    Did that allready...with the 'usual' configs i.e configuring the tnsname of the client so that it points to the server(as I use to do when connecting two db in windows). Doesn't work with Linux, that's why am asking for your guidance.
    Reply With Quote Reply With Quote
  4. 08-20-2008, 11:23 AM #4
    gandolf989's Avatar
    gandolf989
    gandolf989 is offline Senior Advisor
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by abdel
    Doesn't work with Linux, that's why am asking for your guidance.
    It should work. It should not matter what operating system you are using for your database and what operating system you are using for your client. On windows there is an NT authentication parameter in the sqlnet.ora file, if it is there comment it out. Are you using domain names in you tnsnames.ora, try it without the domain names. Do you have the right tnsnames entry on the client, check the ip address/servername, sid name and port. If you are using the server name, try pinging it to see if the client can find the right ip address.

    You need to do some really basic troubleshooting to see what the issue is. Like, did you start the listener on the database server? Is the database even running? Are you using ip filtering in the listener? How is anyone else going to know what the problem is, since there could be any number of reasons for this to not work.
    Reply With Quote Reply With Quote
  5. 08-20-2008, 02:43 PM #5
    abdel
    abdel is offline Junior Member
    Join Date
    Nov 2007
    Location
    Douala, Cameroun.
    Posts
    77
    The error I am getting is that 'the target host does not exist'. I'll run all the check you suggested Gandolf, and see how it goes.
    Reply With Quote Reply With Quote
  6. 08-20-2008, 04:58 PM #6
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    then your tnsnames file is wrong as your machine cannot resolve the name used
    Reply With Quote Reply With Quote
  7. 08-21-2008, 03:35 AM #7
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Can you ping the Linux box from the Windows machine using DNS?
    Can you ping the Linux box from the Windows machine using IP address?
    Have you set your oracle_home and sid properly on Windows machine?
    What happens when you tnsping the target database?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
  8. 08-21-2008, 06:01 AM #8
    abdel
    abdel is offline Junior Member
    Join Date
    Nov 2007
    Location
    Douala, Cameroun.
    Posts
    77
    Quote Originally Posted by PAVB
    Can you ping the Linux box from the Windows machine using DNS?
    Can you ping the Linux box from the Windows machine using IP address?
    The ping doesn't work. The network mustn't be properly configured cuz the windows box can't see Linux. I'll fix that first and see how It goes.
    Reply With Quote Reply With Quote
  9. 08-21-2008, 07:30 AM #9
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Talking Firewall

    Quote Originally Posted by abdel
    The ping doesn't work. The network mustn't be properly configured cuz the windows box can't see Linux. I'll fix that first and see how It goes.
    There you go! Also check firewall rules.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width