HOW TO CONNECT ORACLE ON LAPTOP
UTS: DATABASE PROGRAMMING
SQL Developer is an Oracle client tool used for creating and managing database objects. You should do all of your work in this subject using SQL Developer. SQL Developer is installed in labs at UTS and for use outside UTS you can download SQL Developer from:
http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html
When you use Oracle on your laptop, you need to SSH tunnel to Oracle server.
1. Set up SSH tunnel to Oracle server
Step1: Start SQL Developer
Step 2: Select SSH from the View menu
Step 3: In the SSH panel right-click on SSH Hosts and select New SSH host and
Enter the following information into the SSH panel substituting your FEIT username for Username,
Username:hofang
Step 4: Now click on the + sign in the Connections panel (left-hand corner of the screen) to
add a connection. Enter the following information into the New Database Connection panel
using your Oracle login credentials (received via email):
Username:99189274
Password:19931014uts.
Step 5: Notice that the Connection Type is set to SSH.
Test the connection by clicking on Test, enter your Oracle password. Finally, save the Connection by clicking on Save.
Note: Make sure that you are using your FEIT login name when setting up the SSH tunnel