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

Thread: Basic client/server connection

  1. #1
    Join Date
    Mar 2001
    Posts
    77
    How does one do a basic connect from client to server without using Oracle?

    Thanks!

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    An NT work station talking to an NT Server in a domain. No Oracle/no dataabse. Still the configuration is C/S as Server is serving for Client.

    Not Sure. This what you are looking for or something else. Your Question is not supposed to be here if you are not using oracle. Here discussion focus is database products usage and adminstration.
    Reddy,Sam

  3. #3
    Join Date
    Mar 2001
    Posts
    77
    I guess I didn't make myself clear. I am unable to access Oracle and I don't know what the problem is. Thus, I need to trouble shoot each part of the network. For instance, I need to know if the server is running accordingly, the protocol is working properly, the listener has been configured properly, etc. First thing, I am trying to see if I can connect to the server.

    I don't know what the steps are in trying to connect to the server. I know this is too simple for you gurus out there and my improper wording at first make you think harder that you really should. I appreciate the response!



  4. #4
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    We are also working in a C/S environment.
    To troubleshoot the connection :

    1.
    Use TNSPING to check if the SQLNET/NET8 is still OK

    2.
    Use PING to check if you can reach your machine

    If PING not OK
    --> network problem
    If PING ok but TNSPING not ok
    --> check listener on server
    --> check tnsnames.ora / sqlnet.ora on client
    --> check listener.ora on server

    Hope this helps
    Gert

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    [assume]Assuming a tcp/ip network[/assume]
    First, check your network connectivity with ping:
    ping server_IP_address

    If that succeeds, check your network naming:
    ping server_hostname

    If that succeeds, check your net8 connectivity:
    tnsping dbalias 10

    If that succeeds, you network is up and running. Your problem now is either in the tnsnames.ora on the client or listener.ora file on the server. At this point, you would post your error message to dbasupport and we can diagnose from there...
    Jeff Hunter

  6. #6
    Join Date
    Mar 2001
    Posts
    635
    Hi

    Follow the steps to troubleshoot the problem

    1) Ping the server fromt the client to check network connectivity between server and the client

    Ping ipaddress

    replace ipaddress of ur server in ipaddress

    the server responds if it does not then there is a problem with you network connectivity

    2) Next make sure you have the Listner running at the server you can check this by the following command

    lsnrtcl status

    There are different commands for different version of oracle so check out what database version ur running and use the corresponding commands

    3) Make sure there is a TNSNAMES entry available in ur TNSNAMES.ora file and the server ip address, instance name and port correpspond to ur server

    4) Then check the connectivity between the client and the server by using the following command

    tnsping databasealias

    the databasealias is the alias entry which would be entered in ur tnsnames.ora file.The above command will help you to check the connectivity between the database and the client software

    Regards

    Santosh

Posting Permissions

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


Click Here to Expand Forum to Full Width