Versions Compared

Version Old Version 9 New Version 10
Changes made by

Nianli Ma (Unlicensed)

Nianli Ma (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

I/O Performance: High

API name: m1.large

ORACLE Database instance/schemas

we have three ORACLE database instances setup on the cloud:

  • OLE-ORACLE-2, 7.5GB RAM, 160GB storage, including schemas as following:
    • OLEDBA (we keep our OLE schema here)
    • OLEDEV (schema comes from OLEDBA, setup for OLE DEV site)
    • OLETST (schema comes from OLEDBA, setup for OLE TST site)
    • OLEDM (playground for data modeler, do we need now???)
    • OLELOCAL (the playground for data modeler or developer to play with the schema, refreshed from OLEDBA every morning at 4am)
    • OLECI (playground for unit test)
    • OLERICE_DEV (schema setup for OLE/Rice 2 for DEV site)
    • OLERICE_TST (schema setup for OLE/Rice 2 for TST site)
    • DocStore/JCR tables for DEV
    • DocStore/JCR tables for TST
  • OLE-DEMO-ORACLE-2, 7.5GB RAM, 80GB storage, only has one schema:
    • OLEDEMO
    • DocStore/JCR tables for DEMO
  • OLE-DEV-2
    • Not sure what kinds of schema on this, should be just for dev site

Backup for DEMO, we have two jobs on the cloud to take snapshots for the databases and DocStore file system. The snapshots for OLE-DEMO-ORACLE-2 instance keep on RDS (in the Amazon cloud). But it is only run when loading new data as the baseline. Amazon backup the data for us automatically. The backup data only can be accessed through aws console.

Access Databases: you should have Aqua Data Studio, SQL Plus/Developer or other database client to access the databases on the cloud. The configuration of each schema for the client setup is as following:

  • OLEDEV
    • UserName – oledev
    • Hostname – ole-oracle.ole.kuali.org
    • Port – 1521
    • SID – ole
  • OLETST
    • UserName – oletst
    • Hostname – ole-oracle.ole.kuali.org
    • Port – 1521
    • SID – ole
  • OLEDEMO
    • UserName – olefs
    • Hostname – demo-oracle.ole.kuali.org
    • Port – 1521
    • SID – oledemo
  • OLERICE_DEV
    • UserName  - olerice_dev
    • Hostname – ole-oracle.ole.kuai.org
    • Port - 1521
    • SID - ole
  • OLERICE_TST
    • UserName  - olerice_tst
    • Hostname – ole-oracle.ole.kuai.org
    • Port - 1521
    • SID – ole
  • OLEDBA
    • UserName  - oledba
    • Hostname – ole-oracle.ole.kuai.org
    • Port - 1521
    • SID - ole
  • OLELOCAL
    • UserName  - olelocal
    • Hostname – ole-oracle.ole.kuai.org
    • Port - 1521
    • SID - ole