Academic Oracle Service (AOS)

Introduction

This Academic Oracle Service (AOS) is decommissioned as of February 8, 2022. If you need Oracle for a database-related course, please contact cse-consult@buffalo.edu.

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 this address if you need a password reset or other account help. For fastest service, include the text "Please route to EIS Database Team" in the body of your message.
  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