|
In order to connect to your Oracle account you have to:
1. The oracle client binaries are installed on the CSIL linux machines in /usr/dcs/software/applications/Oracle. The oracle SID is oracsil. Students need to set the following environment variables. You can add these lines to your .cshrc file.
setenv ORACLE_HOME /usr/dcs/software/applications/Oracle setenv ORACLE_SID oracsilYou can also add /usr/dcs/software/applications/Oracle/bin to your PATH variable.
2. type at the prompt:
/usr/dcs/software/applications/Oracle/bin/sqlplus
3. type at sql prompt:
Enter user-name: netid@oracsil
4. when prompted, type your password (we will announce your passwords in class)
5. After log in, you can change your password by command "password [username]", where [username] is your netid.
6. In order to access the database through a web application using php,
you need to put your php scripts in the csil-projects/public_html
directory that you will find in your home directories. You can then access
the script with the URL http://csil-projects.cs.uiuc.edu/~netid/scriptname.php.
If you get a message saying you can't use the csil-projects website,
please send email to userhelp@cs.uiuc.edu requesting access.
For a more complete understanding of the Oracle DBMS, please refer to our Oracle resource page.
Here is our sample java program that should help you understand JDBC connection to Oracle.