Skip to Content
avatar image
Former Member

To check database connectivity in sql and oracle

Dear All,

How to check in sql database that database is connected or not? Plz if possible tell how to check in oracle also? My OS is win 2003 server.

Regards

ashok

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Oct 14, 2009 at 10:27 PM

    > How to check in sql database that database is connected or not?

    The database connected to what?

    > Plz if possible tell how to check in oracle also? My OS is win 2003 server.

    You can use

    R3trans -d

    on all systems and databases.

    Markus

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2009 at 05:08 AM

    R3trans -d will give tou return code.

    0000 means , your sap system is able to connect DB.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2009 at 05:08 AM

    R3trans -d will give tou return code.

    0000 means , your sap system is able to connect DB.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2009 at 05:31 AM

    Hi Ashok,

    Could you tell me that which application do you want to connect to the database.

    Although all the applications and the users connect to Oracle database through oracle net services.

    To check that whether you can connect to an oracle DB server first use the tnsping command at the client machine's terminal

    syntax :

    tnsping <connection identifier>

    The connection identifier here is the entry in tnsnames.ora file

    If the tnsping returns OK then you may go ahead and connect to the oracle DB using <DBuser>/<password>@<connection identifier>

    If you do not get an OK after tnsping and the command is working then you have to check entries in tnsnames.ora are correct or not.

    If tnsping command is not found on your machine then oracle client is not installed on the machine.(You need some middle layer to connect you application to Oracle DB , Oracle Client in this case)

    This is a generic method to check the connectivity between oracle client and oracle DB and connecting to oracle database.

    Regards,

    Aditya

    Add comment
    10|10000 characters needed characters exceeded