Oracle Accounts
Posted by Demian Lessa on 01-24-2011.
Oracle Accounts Created
Oracle accounts have been created for all students currently registered for CSE462.
- Please, change your password as soon as possible.
- Monday recitation (R1) students must connect using the password cse462r1.
- Friday recitation (R2) students must connect using the password cse462r2.
- Please send a message directly to ascit-dba@buffalo.edu if you ever need to reset your password.
- Accounts for students joining after the start of the semester will be added on 01/28/2011.
Connecting to Your Database.
1. Connect to either nickelback (on-campus) or timberlake (off-campus) using ssh. Windows users can use Putty; Linux and Mac users may use the native ssh client. Here is how I connect from my Linux box when I am off-campus:
> ssh dlessa@timberlake.cse.buffalo.edu
password:
timberlake:~
2. Define the environment variables ORACLE_HOME and TWO_TASK using the setenv command. If you wish to have these variables defined automatically every time you log in, simply add them to the .login file located in your home folder.
timberlake:~ setenv ORACLE_HOME /util/oracle/product/current/client_1
timberlake:~ setenv TWO_TASK aos.buffalo.edu
3. In order to connect to your Oracle database, one option is to use the SQL*Plus command line client. When prompted for your credentials, use your UBIT user name (the same from step 1 above) and password. If this is the first time you are connecting to Oracle you must change your password (see step 4 below).
timberlake:~ sqlplus
SQL*Plus: Release 11.1.0.6.0 - Production on Mon Jan 18 12:58:18 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter user-name: dlessa
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
4. You must change your password immediately after you login for the first time. Type password on the command prompt and provide the old and new passwords as requested:
SQL> password
Changing password for DLESSA
Old password:
New password:
Retype new password:
Password changed
SQL>
5. In order to close your SQL*Plus session, type quit on the command prompt:
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
timberlake:~
For information on Oracle, check Oracle's online documentation (see links on the side) or check the notes on Oracle in the textbook's supplementary web site:
http://infolab.stanford.edu/~ullman/fcdb/oracle.html
For further information, refer to the CSE Oracle wiki page:
https://wiki.cse.buffalo.edu/services/content/oracle
If you still cannot get it to work, stop by the TA's office hours.
-- Demian Lessa