Using Oracle11g

  1. Check the Oracle Help Pages.

  2. The Server oracle.cs.und.edu Hosts an Oracle Database 11g Enterprise Edition Release 11.1.0.7.0–Production.

  3. Oracle Accounts
    4.  Request an Oracle account from your instructor. Oracle accounts and Unix (shell) accounts are different. They are valid for only one semester. Save your databases at some other places at the end of each semester.

  4. Use Oracle SQL Developer or SQL*Plus to Manage Databases.
    5.
    Using Oracle SQL Developer

    1. Download and Install Oracle SQL Developer and Start Using the Oracle11g.


    Using SQL*Plus

    1. Logining into the server shell
      You may use an SSH client such as PuTTY to access the shell.


    2. Logining into Oracle11g from shell
      The basic Oracle interface is sqlplus, and to start it, enter 
        shell> sqlplus userid/password@oracle.cs.und.edu:1521/orcl
  SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 11 13:40:50 2013
  Copyright (c) 1982, 2009, Oracle.  All rights reserved.

  Connected to:
  Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
  With the Partitioning, OLAP, Data Mining and Real Application Testing options

  SQL>
      You need to change your password with the following command the first time you use Oracle: 
        SQL> alter user userid identified by pwpwpwpw;
      where pwpwpwpw is whatever new password you want. Note that, unlike Unix login names and passwords, Oracle account names and passwords are NOT case sensitive.

    3. Exiting from Oracle11g
        SQL> exit
  Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
  With the Partitioning, OLAP, Data Mining and Real Application Testing options

  shell>