Graduate Windows Lab

All students can access the Oracle server from outside the department firewall from the following link:
https://rdb.translab.cs.sunysb.edu:5500/isqlplus.

A security alert will popup and users must accept the certificate by clicking "YES".

A secure connection via SSL will then be established and users can connect to the Oracle server.

Students can additionally access the Oracle Database Server from outside Computer Science Department using the following procedure.

1. Use SSH Secure Shell Client to connect to one of the Unix machines with your network login names and passwords.

2. If you do not have a copy of SSH download SSH Client 3.x from the downloads area of our Services via Secure Sign On
3.Read the instructions at the following URL to setup SSH on your personal PCs or Laptops.
http://www.cs.sunysb.edu/facilities/faq.html

4. Successful login will take you to your home directory. At the Unix Prompt type the following:
source /usr/local/pkg/instantclient/setup.csh
The script sets up the Oracle client environment and you are ready to connect to the database server.

5. At the prompt now type in:
sqlplus

6. A Enter user-name: prompt comes up. Type your database username, for example if you were to connect to "hr" schema you would type in at the username prompt
hr@oraserv
7. Then at the password prompt, type the password corresponding to your login name. In this case we would type in
password: hr

8. Once you receive the SQL> prompt you are connected to your database.

Local Documentation for Oracle

• To access the PDF documentation from the local server click here: PDF documentation

Please note that you will need to repeat the above steps everytime you reconnect to the database server from outside the department. The environment variables are no longer valid once you logout of the unix system.