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 entire class is assigned into
a single database,
Each student is assigned a user account within the cisora
database. The Oracle account names are of the form C331001nn where nn is a
serial number 00, 01, 02, 03, ... assigned to you.
You should change the default password the first time you access your
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.