SQL Developer Setup

Software Download

SQL Developer can be downloaded via the Oracle web site at: http://www.oracle.com/technetwork/developer-tools/sql-developer

You will need to know if you need the 32-bit or 64-bit version.
If you are not sure, please contact the OU Help Desk for assistance in determining.
Be sure to download the version that includes the JDK.

Once you download/install the software, you will need to acknowledge Oracle's Export Compliance.
Additionally, you will need to acknowledge the Export Compliance again for OU legal purposes.
To do this, go to the link below and follow the instructions.

How to create an Oracle connection

Oracle TNS Names File

Oracle TNS Names is required in order to connect to the Oracle Database Server.
This is available on the UTS Shares under the ..oracle\instantclient_x_x\network\admin folder .

This file needs to be copied to the Drive:\oracle\product\10x.x.x\client_x\NETWORK\ADMIN

One can also specify the location in the Tools, Preferences then Database, Advanced, TNSnames Directory section in Oracle SQL Developer.

Creating a connection

Connection Name = PROD (or TEST)
User name = your user name
Password = your oracle/banner password
Connection Type = TNS Role = default
x Network Alias = PROD (or TEST)

Then click the TEST button; when successful click SAVE.