Oracle Database at Temple

The Oracle database system is set up in the following way:

• In Oracle, a database is a logical structure that can be subdivided into accounts, where each account can define its own schema.  A schema is a set of objects that include tables, column (field) definitions and table relations.

• The labs that you can use are 108, 200, and 209 in Wachman Hall.

• The entire class is assigned into a single database, named cisora.   Each student is assigned a user account within the cisora database.   The Oracle account names are of the form C661001nn where nn is a serial number 00, 01, 02, 03, ... assigned to you.  You should change your password for Oracle after you login to each.  The first character of the password must be a letter.  To change your password in the database, log onto the database under the old password using SQL*Plus or SQLPlus Worksheet.  Then enter the SQL command:
  
  Alter User <User Name> Identified By <New Password>
  
  Remember to start your new password with a letter.
  
  Every Oracle client application (tool) must connect to a database; therefore, you will be asked to login every time you run a client (or when the client needs to connect to the database).  The login requires three items: Your account name, password and a connect string, which is the database name, cisora.