On Windows XP

• Log on to any of the School's Windows XP workstations.
• You'll find SQL*Plus in the Oracle folder under Programs folder under the Start button.
• Start SQL*Plus. You will be prompted for your Oracle Username, Password and Host String.
• Your Oracle Username is the same as your CIT login name (for example, if your login name is sbloggs, your Oracle login name is sbloggs).
• Your Oracle password is a plus your student ID number. For example, if your student ID number is 13001234, your oracle password is a13001234.
• Your Oracle Host String is the enterprise database you wish to connect to. To connect to the enterprise database EDBHEAD, enter edbhead as the host string. To connect to the enterprise database EDBBRANCH, enter edbbranch as the host string.
• Once you are in SQL*Plus, you can change your oracle password by typing:
  alter user username identified by new_password;
  For example, if sbloggs wanted to change her password, she would login to sqlplus and type:
  alter user sbloggs identified by wibble;
  (wibble being her new password).
  
• IMPORTANT:Changing your password for one database (e.g. edbhead) does NOT change it for the other one (e.g. edbbranch)
• Type exit to exit sqlplus.

• Log on to any of the School's Unix hosts such as kay or morgana.
• Everytime you want to use Oracle, type either edbhead (to use the EDBHEAD database) or edbbranch (to use the EDBBRANCH database). Both of these commands will set up the Oracle environment variables for you, and (obviously!) select a particular Enterprise Database for you.
• Now test to make sure Oracle is working and you have an Oracle login. Type sqlplus  to load up Oracle's command line interface. You will be asked for a user name and password. Your username is the same as your unix login name (for example, if your login name is sbloggs, your oracle login name is sbloggs), and your password is a plus your student ID number. For example, if your student ID number is 13001234, your oracle password is a13001234.
• You can now change your oracle password by going into sqlplus and typing:
  alter user username identified by new_password;
  For example, if sbloggs wanted to change her password, she would login to sqlplus and type:
  alter user sbloggs identified by wibble;
  (wibble being her new password).
  
• IMPORTANT: Changing your password for one database (e.g. edbhead) does NOT change it for the other one (e.g. edbbranch)
• Type exit to exit sqlplus.