Oracle is a relational database.
Currently Oracle is only available on bajor.
To access bajor, type the following command:
At bajor, type the following command to start oracle:
See "helpme setup" for
information on finding out what versions are available or
what to do if the
setup statement does not
After setup oracle, the command
sqlplus" will run a
command-line-based SQL interface.
When being asked for user name and password, your user-name is the same as your Unix username, and your initial password is also your username. For example:
Students are encourged to change their passwords at first time login.
To change password, type either "
The following parameters should be used when setting up JDBC or other web-based access to the Oracle database.
To open a connection to database, use the static
method of the JDBC
This method returns an object of the JDBC
Connection class which
needs as input a userid, password, connect string that identifies the JDBC driver to use, and the name of
the database to which you want to connect.
Connecting to a database is a step where you must enter Oracle JDBC driver-specific
information in the
Specifying a Database URL, Userid, and password:
where the URL is of the form:
The following example connects user
tiger to a database with
db9i through port
1521 of host
NOTE: When building/testing your JDBC application from the command-line, you must first type 'setup jdk' to put the proper JDK (with Oracle JDBC driver support) into your PATH. If you do NOT run 'setup jdk' first, you will get the locally installed jdk which does NOT have the JDBC Oracle driver.
PHP on the Linux student webserver can access Oracle data via the OCI8 PHP-Oracle connector. (http://linux.students.engr.scu.edu)
NOTE: There is currently no support for PHP access to Oracle on the Solaris web server. (http://students.engr.scu.edu or http://sol.students.engr.scu.edu)
Information necessary to connect to the DB from PHP:
(remember the user/pass are your Oracle user/pass, which may differ from your Unix or Windows user/pass)
For further information on actually using Oracle data from PHP, refer to the OCI8 documentation.
NOTE: For PHP to process your code, you need to give your file a ".php" extension.
Currently Oracle accounts are available only to students taking a database class or using a database for Senior Design work. Accounts will be removed by the start of the subsequent quarter. Students are encouraged to retain backups of their work as we will not be able to recover this data once accounts are removed.