Using SQL*Plus, the Oracle Interface

  1. Check the Oracle SQL*Plus Help Pages.

  2. Apply for a UND Engineering Linux Account.

  3. Apply for an Oracle Accont.

  4. Use VPN (Virtual Private Network) to connect to the UND networks.
    5.  You may not need to do this if you are on campus.

  5. Log in to the Linux server undcemcs02.und.edu .

  6. The cloud Oracle database server is located at 20.185.147.112:1521 .
    7.  The server hosts an Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production, Version 21.3.0.0.0 . Directly accessing the server is prohibited.

  7. Start using Oracle SQL*Plus to manage Oracle.
    8.  The basic Oracle interface is sqlplus, and to start it, enter 
      shell> sqlplus C##user_id/password@xe 

  SQL*Plus: Release 23.0.0.0.0 - Production on Fri Aug 9 20:18:35 2024
  Version 23.4.0.24.05

  Copyright (c) 1982, 2024, Oracle.  All rights reserved.
  Last Successful login time: Fri Aug 09 2024 15:23:29 -05:00

  Connected to:
  Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
  Version 21.3.0.0.0

  SQL> exit; 
    
  Disconnected from Oracle Database 21c Express Edition Release 21.0.0.0.0
    - Production
  Version 21.3.0.0.0
    
  shell>
    You need to change your password with the following command the first time you use Oracle: 
      SQL> alter user C##user_id identified by pwpwpwpw;
    where pwpwpwpw is whatever new password you want. Note that, unlike Linux login names and passwords, Oracle account names and passwords are NOT case sensitive.




      I told my wife she was drawing her eyebrows too high.    
      She looked surprised.