IT Help

Have an IT question?

How can we help you?

Our Best Answer

Using the Oracle Staff Student Interactive Database (SSID) /uploads/SSID1.jpg

SSID is an Oracle database that eSolutions has created for students and staff to develop their IT skills in using and creating applications that use SQL and enterprise standards such as Oracle RDBMS.

This help article explains the different ways to log in, give other users access to your data, and how to back up and restore your data. There are also tips included to optimise your use of the SSID, and provide some help in handling the most common errors.

 

Connecting to the SSID

To connect to the SSID database, SSH to the host interactive.deakin.edu.au.

Upon connecting to the host you will be prompted with the following:

Image of the interactive.deakin menu

Use your arrow keys and go to the line that reads SQLplus to SSID and press enter. You will now be prompted to enter your password.

Connecting via the web

You can access your SSID database from the web in many different ways. One of the most popular ways to access databases from the web is using PHP.

Here is a small example of what you will need to connect to SSID from the web using PHP.

<?
$dbuser = "gary"; // Your user name here
$dbpass = "garyspassword"; // Your password here
$db = "SSID";
$connect = OCILogon($dbuser, $dbpass, $db);
$query = "grant select on phnum to barry";
$command = ociparse($connect, $query);
ociexecute($command);
ocilogoff();
?>

This example will connect to SSID as the user 'gary' and execute the query 'grant select on phnum to barry'.

 

I am unable to login to SSID. What can I do?

If SSID will not accept your username and password it may contain a Unix character.

Oracle does not like passwords with characters that Unix uses in commands, e.g. !@<>.

If you have the @ character in your password you would also need to put your password in quotation marks (e.g. "myh@rdpassword"). Doing this may allow you to login.

Otherwise you will have to change your password. You should restrict your password to upper and lower case letters and numbers and a length of eight characters.

You can change your password from the Deakin Password website.

 

Giving other users access to data

To grant other users access to data in your database, you will need to perform one of the following commands:

  • This example will give the user 'barry' access to view the data within a table called 'phnum'
    SQL> grant select on phnum to barry;
  • This will give 'barry' access to insert data into the table 'phnum'
    SQL> grant insert on phnum to barry;
  • This will allow 'barry' to update/change data that is in the table 'phnum'
    SQL> grant update on phnum to barry;
  • This will allow 'barry' to delete data from the table 'phnum':
    SQL> grant delete on phnum to barry;

To remove access, follow the examples below:

  • This will stop 'barry' from viewing data in the table 'phnum'
    SQL> revoke select on phnum from barry;
  • This will prevent 'barry' from doing anything with the table 'phnum'
    SQL> revoke update, insert, delete on phnum from barry;

 

Backup data in SSID

Each night eSolutions automatically backs up data within the database. However, it is a good idea to create a backup of your data yourself.

Here is an example of how to do it:

bash$ export ORACLE_HOME=/opt/oracle/product/client/11.2.0

bash$ export TWO_TASK=SSID

bash$ $ORACLE_HOME/bin/exp file=~/mybackup.dmp

You will be prompted for your username and password. Once this is completed all your data will now be backed up in the file mybackup.dmp.

Please note that if you do not commit changes to your data, it will not be saved, neither will it be backed up.

 

Restore data from a backup

To restore your data from a backup to the database you will need to do the following:

Ensure the tables you want to recover are not in the database
SQL> select table_name from user_tables;

If the table is in there you will need to drop it before you replace the table from your backup
SQL> drop table phnum;

Insert your table with the following commands 

bash$ export ORACLE_HOME=/opt/oracle/product/client/11.2.0

bash$ export TWO_TASK=SSID

bash$ $ORACLE_HOME/bin/imp file=mybackup.dmp tables=phnum

This command will replace the table phnum and all the data that was in it from the time you performed a backup (as above)

 

I get the following error: "ORA-01536: space quota exceeded for tablespace users"

This means that your database quota is full. Each user within SSID has been given 10MB of storage inside the database.

 

Other Tips

  • The TeraTerm connection settings should look like:
    Image of Tera Term settings
  • To connect using Terminal on a Mac, enter the command ssh username@interactive.deakin.edu.au then type your Deakin password when prompted

    Image of a Terminal window logging in to interactive.deakin.edu.au
  • Oracle does not echo anything when entering the password
  • Ensure you login with just your username and not your email address
  • A good size to set the terminal window on a Deakin computer is 132 x 50. The Oracle command set linesize 132 is also needed to take advantage of the resized window
  • You can paste to Oracle, however if the command is multi-line Oracle may echo back the line numbers after you paste in the command. This is not a problem. Copying out of Oracle will not work without editing, because you also get Oracle's line numbers and any other prompts mixed in with it
  • While students cannot take Oracle home, they can download TeraTerm


Did this answer your question?