Staff Student Interactive Database (SSID)

What is SSID?
How do I connect to SSID from Unix?
When I connect to interactive.deakin.edu.au, the menu does not appear
How do I connect directly from the Unix prompt?
How can I give other users access to my data within the database?
How can I connect to SSID via the web?
How do I backup my data in SSID?
How do I restore data back from a backup?
How do I remove a user's access to my data?
I am unable to login to SSID. What can I do?
I have changed my password recently and I still can't login. What can I do?
I get the following error when I try to create/insert/update a table: ORA-01536: space quota exceeded for tablespace users

What is SSID?

SSID is an Oracle 10g database that ITSD 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.

How do I connect to SSID from Unix?

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:
Pdmenu in TeraTerm
You should 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.

When I connect to interactive.deakin.edu.au, the menu does not appear

If you connect to the the interactive host and the menu does not appear, it is most likely that you have corrupt .bashrc files. To fix these corrupt files, please go to the Renew Bash pages and click the appropriate link to fix files in your home directory.

How do I connect directly from the Unix prompt?

To connect directly from the unix prompt you must do the following:

Ensure your Oracle environment is setup correctly:

bash$ export ORACLE_HOME=/opt/oracle/product/server/10.2.0.3

bash$ export ORACLE_SID=SSID

Run the SQLplus program and begin your session in SSID:
```
bash$ $ORACLE_HOME/bin/sqlplus
```

How can I give other users access to my data within the database?

To grant other users access to your data, 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;
```

How can I connect to SSID 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". Note: ITSD does not and will not be able to assist students with connecting to the database in this manner. This example is here simply for a guide.

How do I backup my data in SSID?

Each night ITSD automatically backs up data within the database. However, it is a great idea to create a backup of your data yourself. Here is a small example of how to do it:

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

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

How do I restore data back 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 command:
```
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)

How do I remove a user's access to my data?

Here are a few examples of how to stop a user accessing your data:

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;
```

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

If SSID will not accept your username and password, you probably have not changed your password recently. You can change your password from here.

I have changed my password recently and I still can't login. What can I do?

It may be possible that you have an odd character in your password for example, if I had the character @ in my password I would also need to put my password in quotation marks, e.g. "myh@rdpassword". Doing this will allow you to login.

I get the following error when I try to create/insert/update a table: ORA-01536: space quota exceeded for tablespace users

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