Database concepts

Oracle links

Logging on and off 



Using SQL Developer


Logging on
  1. Start SQL Developer: click OK and Close to the opening windows
     
  2. Click the New Connection button on the Connections tab

    3. Click the New Connection button on the Connections tab
     

  3. The following dialog box comes up. Enter the information shown below:

    4. Enter the following information: Enter a name for your connection in the "Connection name" field. The user name is a lowercase s followed by your student number. The password is Monday (with a capital M), followed by a lowercase s and your student number. Select the "save password" check box. In the "Hostname" field type in "redstart 'dot' CDU 'dot' EDU 'dot' AU." The port field should read 1521. Select the "SID" radio button and type "redstart" in the field.

  4. Click Save - this will save the information
     
  5. Click Connect to connect to the database. The following screen will come up:

    6. Type your SQL commands in the large "Enter SQL Statement field

Saving your work before logging off

The area you have been typing your commands in is known as a worksheet. You can save these worksheets and retreive these worksheets.

To save your worksheet:

  1. Click the Save button (the normal disc icon)
  2. Give your file a .sql extension (the convention for files with sql commands)
  3. Save it in the location you wish

Using PuTTY

Logging on

Logging onto SQL*Plus is a two-step process:

  1. Log on to redstart
  2. Log on to SQL*Plus

Foro redstart your username and password are the same as for your student log in.

For Oracle your username and  password are:
     Username: sXXXXXX
     Password: MondaysXXXXXX (with capital M, where XXXXXX is your student number).


  1. Start PuTTY by double clicking on PuTTY.exe. PuTTY does not need to be installed.
    Set the following variables:
         Host Name: redstart.cdu.edu.au
         Port Number: 22
         Protocol: SSH

    PuTTY configuration

  2. Click Open
    If the following message comes up, click Yes

    PuTTY Security Alert

  3. Enter your details:
         login: s+yourstudentnumber
         password: MondaysXXXXX (with capital M, where XXXXXX is your student number).

    4. If all is well the prompt will now be [sXXXXXX@redstart sXXXXXX]

  4. Once you are on redstart (using PuTTY), you can then log on to SQL*Plus by:
    1. Type: sqlplus
    2. Press: Enter
    3. Enter your username and password when prompted
Logging off

You will need to log off both redstart and Oracle.

Log off SQL*Plus

  1. Type: quit

Log off redstart

Either:

  1. Type ctrl-d (press the ctrl and d key at the same time)

    2. or

  2. Close SSH/PuTTY