Configure Toad and SQL developer with Oracle Database 11gR2

Oracle Database 11gR2 has built-in SQLPLUS batch query tool (A command line user interface). You may use Oracle SQL developer (ntegrated development environment (IDE) for working with SQL in Oracle databases) or Toad for Oracle (tool from Quest Software (www.quest.com) for creating and testing PL/SQL code) instead also. We have installed Oracle Database 11gR2 11.2.0.4 on Oracle linux 6 update 6 with ASM in Previous post.

In this post I am going to configure Toad for oracle and Oracle developer. Toad and SQL developer are more user friendly and has more features.

Before installing Toad you need to install Oracle database 11gR2 Client on your Workstation (Windows 10, Windows 8, Windows 7 etc....). Your workstation and Oracle database server machine has to be on the same network. 

Toad for Oracle:

Download Toad from http://software.dell.com/products/toad-for-oracle/

Toad need Oracle database client to connect to oracle  database You can download the Oracle database client for windows from Oracle. 

Install the client 
Copy then contents of tnsname.ora from /u01/app/oracle/product/11.2.0/db_1/network/admin/ (Database Server)

to
C:\app\araza\product\11.2.0\client_1\network\admin (Windows Machine where you installed Toad)

Just change the IP Address instead of host name. You can leave host name as it is if your DNS server is same for both client machine and Oracle Database machine to resolve the host-name of database server.

Start Toad for Oracle

And you are connect to Oracle Database 11gR2 11.2.0.4 on Oracle Liuux 6. Check with select statement and all is well. 

SQL developer:

For SQL developer you don't need Oracle Database client. Download SQL developer with JDK 8 from Oracle. 

Before running sqldeveloper.exe make sure the Database listener is running on Oracle Database server by running following command. 

[oracle@oel6]$ lsnrctl status

Listener is running. If you face no listener then start the listener by running following command.

[oracle@oel6]$ lsnrctl start

Run sqldeveloper.exe from installed folder.

Click + button

Click Connect and you will see following. 

Lets check with Select statement.

We have successfully configured Toad for Oracle and Oracle SQL Developer. 

That's All

Cheers-:)