ACC 682 Fall, 1998
Oracle Username/Password Information Sheet
Each student in ACC682 as been assigned a username and password to use with NT as well as the Oracle server (named cayley). This handout will show you how to log on and manage your password.
First, you have to logon to one of the Windows NT workstations in the lab using the username/password as explained in class (the username will be your Unix-ID and the initial password will be your ID in reverse (backwards), which you are prompted to change upon first logon. Note that the NT system is case sensitive, i.e. upper and lower case in both username and password make a difference! If you wish to change the NT password at some later date, you can do that by hitting Ctrl+Alt+Delete. Select Change Password as one of the six options.
Second, start the program SQL Plus 8.0, which can be found as follows:
Start – Programs - Oracle for Windows NT – SQL Plus 8.0
A dialog box will appear on the screen. You are asked to enter username, password and host string. See below for username and password. ENTER "cayley" FOR THE HOST STRING.
The format for the oracle username looks like this:
Username Example: Matt Schmuecker SS# xxx-xx-7986
Username Format: AMS7986
Password upon first logon: oracle
Oracle Logon Notes:
SQL>ALTER USER ams7986 IDENTIFIED BY daisy2;
Attention Home-Users: Unfortunately, you cannot use Oracle SQL from home, since you need the oracle client software installed on your computer.
Have fun with your project!