Academic Oracle Service (AOS)

Introduction

UB Computing and Information Technology (CIT)'s Academic Oracle Service (AOS) hosts the Oracle accounts used in CSE courses.

Students registered in CSE database courses automatically receive Academic Oracle Service (AOS) accounts. The accounts are active for the durations of the each course:

  • CSE 462: Database Concepts
  • CSE 560: Data Models and Query Languages
  • CSE 562: Database Systems
  • CSE 601: Data Mining and BioInformatics
  • CSE 636: Data Integration

Your Oracle username is the same as your UBITName. Your professor will give you your default password in class. Change your password to a secure, private password the first time you log in to your Oracle account.

If you have problems or questions concerning your AOS Oracle account, see:

http://www.buffalo.edu/ubit/service-guides/accounts/accounts-for-special...

If you want an Oracle account but are not registered in a course that automatically gives you one, you must ask a CSE faculty to sponsor your Oracle account. Ask your professor to email cse-consult@buffalo.edu to request your Oracle account. If you need your password reset, email cit-oracle-req@buffalo.edu.

How to Connect to Academic Oracle Service (AOS) with SQL*Plus

SQL*Plus is Oracle's branded command-line interface database client.

  1. Login to any CSE 64-bit Linux system (a system whose OS=Linux and whose Processor=x86_64).
  2. Set the ORACLE_HOME and TWO_TASK environment variables:

    
    % setenv ORACLE_HOME /util/oracle/product/current/client_1
    % setenv TWO_TASK aos.buffalo.edu
    
    

  3. Invoke the Oracle sqlplus client and connect to the AOS service:

    
    % sqlplus
    
    SQL*Plus: Release 11.1.0.6.0 - Production on Tue Jan 6 17:55:48 2009
    
    Copyright (c) 1982, 2007, Oracle.  All rights reserved.
    
    Enter user-name: cwmiller
    Enter password: 
    
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
    With the Partitioning, OLAP and Data Mining options
    
    SQL> 
    
    

  4. Interact with Oracle. CIT has documented some Oracle commands in this Oracle tutorial:

    http://wings.buffalo.edu/computing/documentation/unix/oracle.html

  5. When you're done, quit:
    
    SQL> quit
    Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
    With the Partitioning, OLAP and Data Mining options
    
    

How to Connect to Academic Oracle Service (AOS) with Oracle SQL Developer

Oracle SQL Developer is Oracle's branded integrated development environment (IDE) or graphical user interface (GUI) database client.

  1. Invoke Oracle SQL Developer:
    
    % /util/bin/sqldeveloper
    
    or
    
    % sh /util/sqldeveloper/sqldeveloper.sh
    
    
  2. The first time you invoke Oracle SQL Developer, configure it to connect to Academic Oracle Service (AOS). Follow this procedure:
    1. In the Connections tab, right-click the Connections item. Or click the green + symbol.
    2. In the New / Select Database Connection dialog box, set these values:
      VariableValue
      Connection NameAcademic Oracle Service
      Username[Your UBITName]
      Password[Your Oracle Password]
      Save Passwordchecked
      Connection TypeBasic
      Role default
      Hostnameaos.acsu.buffalo.edu
      Port1521
      Service Name aos.buffalo.edu
    3. Click Save.
    4. Click Connect.
  3. Explore the GUI's features to execute your data management and data reporting tasks.

People

  1. ubithelp@buffalo.edu. Email support alias that eventually reaches the Academic Oracle Service (AOS) Database Administrators (DBAs). Email this address if you need a password reset.
  2. cse-consult@buffalo.edu. CSE IT staff.

References

  1. http://wings.buffalo.edu/computing/documentation/unix/oracle.html
  2. http://www.buffalo.edu/ubit/service-guides/accounts/accounts-for-special...
  3. http://www.buffalo.edu/ubit/service-guides/software/by-title/oracle.html