Using Oracle Database 12c

  1. Check the Oracle Help Pages.

  2. Apply for a UND Engineering Linux Account.

  3. Log in to the Linux Server undcemcs02.und.edu .

  4. Apply for an Oracle Accont.

  5. The Server 65.52.222.73:1521
    6.  The server hosts an Oracle Database 12c Enterprise Edition Release 12.1.0.2.0–64bit Production. Directly accessing the server is prohibited.

  6. Using Oracle SQL Developer or SQL*Plus to Manage Oracle
    7.
    Using Oracle SQL Developer
    1. Download and install Oracle SQL Developer from here.

    2. Start using Oracle SQL Developer to manage the Oracle Database 12c.



    Using SQL*Plus
    1. Log in to the Linux Server: undcemcs02.und.edu .

    2. Modifying the ~/.profile file
      ~/.profile is the shell startup file and gets executed whenever you log in to undcemcs02. It is located in a user’s home directory and tilde slash (~/) is the beginning of a path to a file or directory below the user’s home directory. To use Oracle, you need to set environment variables in ~/.profile file by including the following script:

      ~/.profile 
      # To set up the Oracle environment for your shell account
CLASSPATH=.:/usr/lib/oracle/12.1/client64
CLASSPATH=$CLASSPATH:/usr/lib/oracle/12.1/client64/lib/ojdbc7.jar
CLASSPATH=$CLASSPATH:/usr/lib/oracle/12.1/client64/lib/ottclasses.zip
export CLASSPATH

# To set up the Oracle environment for SQL*Plus
export ORACLE_HOME=/usr/lib/oracle/12.2/client64
export LD_LIBRARY_PATH=${ORACLE_HOME}/lib
export PATH=${ORACLE_HOME}/bin:$PATH
export CLASSPATH

    3. Compiling the ~/.profile file
      Enter the following command after updating the .profile file: 
        undcemcs02> source ~/.profile 
    4. Logging in to Oracle Database 12c from the server undcemcs02
      The basic Oracle interface is sqlplus, and to start it, enter 
        undcemcs02> sqlplus C##userid/password@//65.52.222.73:1521/cdb1 

  SQL*Plus: Release 12.1.0.2.0 Production on Mon Aug 23 17:36:09 2021

  Copyright (c) 1982, 2014, Oracle.  All rights reserved.

  Last Successful login time: Mon Aug 23 2021 14:22:37 -05:00

  Connected to:
  Oracle Database 12c Enterprise Edition Release 12.1.0.1.0
    - 64bit Production
  With the Partitioning, OLAP, Advanced Analytics 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.

    5. Exiting from Oracle 12c
        SQL> exit 
  Disconnected from Oracle Database 12c Enterprise Edition Release
    12.1.0.1.0 - 64bit Production
  With the Partitioning, OLAP, Advanced Analytics and Real
    Application Testing options

  undcemcs02>