SQL Developer Setup
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.
SQL Developer Export Acceptance: Legal requires that we track users that have downloaded SQL Developer.
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.