This course makes extensive use of the Oracle-supplied Sample Schemas,
including the HR, OE, and SH schemas.  These must be installed in the
database before class starts.

Each student needs:

- An oracle account, with appropriate privileges.  The account name doesn't
  matter.  If each student has their own Oracle server (that is, Oracle
  Database is installed on each student's classroom PC), then 'STUDENT'
  works fine.  If multiple students will connect to a single Oracle
  instance, then each Oracle account must have a unique name: 'S1',
  'S2', 'S3', etc.

  The accompanying script, create_oracle_user.sql, contains the syntax
  to create the account.  Run the script as the Oracle SYS user with
  SYSDBA privilege.  You must pass the account name on the command line:

    sqlplus sys/syspassword as sysdba @create_oracle_user.sql STUDENT
    sqlplus sys/syspassword as sysdba @create_oracle_user.sql S1
    sqlplus sys/syspassword as sysdba @create_oracle_user.sql S2
    ...

  In addition to such normal privileges as CREATE SESSION, CREATE TABLE,
  etc., the student account needs several higher privileges, including:

    ALTER SESSION
    SELECT ANY TABLE
    INSERT ANY TABLE
    CREATE ANY INDEX
    ALTER ANY TABLE
    ANALYZE ANY
    CREATE MATERIALIZED VIEW
    GLOBAL QUERY REWRITE
    SELECT_CATALOG_ROLE
    OEM_ADVISOR

  These and other permissions can be seen in the provided script,
  create_oracle_user.sql.

- A copy of the student files, extracted to a directory accessible from
  the student's database client.  Usually, the student files are
  distributed as a ZIP file.  In a UNIX environment, this ZIP should be
  extracted into each student's home directory.  On Windows, it can be
  extracted to the C: drive.  The name of the ZIP, and the directory
  into which it extracts, depends on the specific course being set up.

  The student files include online examples, lab solutions, and the
  database setup scripts to create the student's sample tables for use
  during class.

NOTE FOR LINUX ADMINISTRATORS:
  The script setup_linux_accounts.sh is provided as an example of how one
  might automate classroom setup for single or multiple accounts on a
  Linux Oracle Database host system.  It is provided as is, for use or
  adaptation at your own risk.

