Configure Squirrel SQL to connect to Oracle DB

I'm adding the configuration for setting Squirrel SQL 3.3.0 to connect to Oracle DB 11gr2. I'm using thin connectivity (No need for client installation in your machine).

Steps:
1- Open Driver list from left menu, scroll down till you find "Oracle Thin Driver", you will notice red x mark next to it denoting the driver is still not configured.
2- After selecting "Oracle Thin Driver" click "Modify the Selected Driver" denoted by pencil.
3- Click "Extra Class Path" tab.
4- Click "Add" and select 1 jar file from %Oracle_DB_CLIENT_INSTALL%\jdbc\lib\ojdbc6_g.jar
5- Click Ok, and we are done defining the driver.
6- Now create an alias for the DB using previous driver and providing URL, username, & password.

Note:
No need to have Oracle client for setup, all you need is just the driver jar files. You can download from this Oracle link.

If you are using JDK 5 while running Squirrel SQL, the jar file will be %Oracle_DB_CLIENT_INSTALL%\jdbc\lib\ojdbc5_g.jar

7 comments:

  1. Thank you so much :) !!! Worked right away!

    ReplyDelete
  2. When I do this, I get this error ...

    Unexpected Error occurred attempting to open an SQL connection.
    class oracle.net.ns.NetException: Listener refused the connection with the following error:
    ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

    ReplyDelete