How To Access Oracle from CS machines

1. What is an Oracle account?

   Oracle is a relational database. Your account will allow you to connect to the database. Once connected you can create objects, insert records, and query the database.

   This account is separate from your Windows or Unix account. You will need a login/password combination specific to this database. If you are taking a class or have been told you have an Oracle account you will retrieve your login and password at the my.cs.purdue.edu site, in the "Local Accounts" section.

   After you have logged onto an CS Linux host, the program that will connect you to an Oracle server is sqlplus. The name of the Oracle server is csora (this is not related to a computer name).

2. How to connect to csora from CS Linux systems
   • We have automate the process of setting up the ORACLE environment simply:

     module load oracle

   • You may now connect to the database with the Oracle client

     sqlplus

   • Provide your login and password that you acquired from the  my.cs.purdue.edu site

     Enter user-name: your_oracle_id@csora
     Enter password: your_oracle_password

   • When you have successfully connected to the Oracle server, you will see the following sqlplus prompt:

     SQL>

     You can now start typing in sqlplus commands or SQL statements.