Using Max OS X to tunnel ReRun Overview By Josh Hanley You can’t use Putty on a Mac, as it is a windows program, to use ReRun to tunnel into the Oracle Database on Smaug. But it can still be accessed using either • Terminal • SSH Tunnel Manager Along with • SQL Developer Client Software Setting up Terminal To access you need Username: Your FEIT Username TunnelServer: In our case rerun.it.uts.edu.au DBServer: smaug.it.uts.edu.au DBPort: 1522 Local_Port: Try 5555 or use netstat to find a non-used port on local computer Use this info and replace into this command ssh -N -p 22 -c 3des Username@TunnelServer -L Local_Port/DBServer/DBPort NB: Place this whole command on one line For example ssh -N -p 22 -c 3des [email protected] -L 5555/smaug.it.uts.edu.au/1522 Hit ENTER, the insert password, ENTER and you will be connected. Nothing will happen in the terminal after “Password:” this is ok, it means you are connected, otherwise you will get an error thrown to screen. Open up SQL Developer and follow the Normal steps and connect to you database. OR Setting up SSH Tunnel Manager Download SSH Tunnel Manager from http://www.macupdate.com/info.php/id/10128 Copy into Applications Folder and Open it You should see If not in the menu bar up the top click Window>Show tunnels or Keyboard shortcut Command + T Click Configuration The Preferences panel should then appear: Click the plus sign to add a new Server and add in the details from the next screen shot (with own username and local port 5555 In the screen shot): Once Filled in close the window to get back to You should now see an entry. Click the arrow to the right of the entry and you will be asked for your password. This is to access rerun (FEIT Password). You will now be connected. Now continue with SQL Developer as per normal instructions