Note:

Get Started with AsterionDB on Oracle Roving Edge Infrastructure and Oracle Compute Cloud@Customer

Introduction

Oracle Roving Edge Infrastructure enables customers to distribute their cloud workloads beyond their Oracle Cloud Infrastructure (OCI) tenancy to deliver cloud services and run application workloads at retail, satellite, and other edge locations. As a result, customers can process data faster and closer to their users and at the points of data ingestion to generate timely insights from their data.

Oracle Compute Cloud@Customer (OC3) is a fully managed, rack-scale infrastructure that lets organizations consume common OCI services at customer sites, on-premises and satellite locations. Gain the benefits of cloud automation and economics in your data center by running OCI Compute with storage and networking services on Oracle Compute Cloud@Customer. It is the simplest way for you to run applications on cloud infrastructure while meeting your needs for data residency, security, and low-latency connections to existing resources and real-time operations.

AsterionDB provides products and technologies that allow for the storage, manipulation and access of unstructured data within the Oracle relational database. AsterionDB utilizes the security features of the Oracle Database and extends them to create a zero trust compliant system. For more information, see AsterionDB, Oracle Database Security Solutions, and DoD Zero-Trust Execution Roadmap.

Audience

Oracle Roving Edge Infrastructure and Oracle Compute Cloud@Customer administrators, developers, and users.

Objectives

Prerequisites

Task 1: Set up the Demonstration Environment for Object Detection and Object Tracking on the AsterionDB Instance

  1. Determine the public IP address of the compute instance running on AsterionDB.

    • On Oracle Compute Cloud@Customer.

      Image 1

    • On Oracle Roving Edge Infrastructure.

      Image 2

  2. Use the public IP address and ssh to login and create a port tunnel to the AsterionDB instance on port 8080.

    Image 3

    Note: Your public ssh key should be on the instance from the launch configuration.

  3. Run the script demoBoxSetup.sh.

    Image 4

    Note: The script sets up everything, and starts related services. You will need to hit the return key until about 53 to 55 lines passes. You should see dbTwig, dbStreamer, dbObscura, and dbPluginServer services have started.

Task 2: Explore the AsterionDB WebUI

  1. Open the browser, enter the address http://localhost:8080 and log in with credentials.

    • Identity: asterionDB.
    • Password: password.

    Image 5

  2. Explore the different menus, and drop-down lists. Go to the Objects menu, open a new file, and move to the Upload tab to drag and drop a new file.

    Image 6

    Note: All files are stored in a secure Oracle Database.

  3. Double-click on an object row, notice the different tabs. Select a PDF document and go to the Viewer tab to view the document.

    Image 7

Task 3: Explore the Object Detection Demo

  1. Open a browser and enter the address http://localhost:8080/demo/ and click Process Headshots to run the demo.

    Sample object detection demo: AsterionDB on Roving Edge Infrastructure Object Detection.

  2. After running the demonstration, click Reset Demo.

Task 4: Explore the Object Tracking Demo

  1. In the same browser as Task 3, navigate to the Object Tracking tab and click Object Tracking Demo.

    Sample object tracking demo: AsterionDB Object Tracking Demo on roving Edge Infrastructure and Compute Cloud@Customer.

    Note: Depending on your instance size, it may take a few minutes to load all of the Python libraries and start the pop out window for the object tracking demo.

  2. Use ESC to stop the video.

Task 5: Optional Prepare the Application Integration or React Demo

Note: Make sure you have completed the optional prerequisites for the React demo.

  1. Use the public IP address and ssh to log in and create a port tunnel to the AsterionDB instance on ports 8080 and 5000.

    Image 8

  2. Use sudo to stop and disable the dbObscura gateway service.

    Image 9

  3. Edit the /home/asterion/asterion/oracle/config/dbObscura.config file and change the following lines.

    • username asteriondb_runtime
    • password password
    • queueConnection true

    The updated lines in the file should look like this.

    username 		asteriondb_runtime
password		password
queueConnection true

    Note: The file is much larger, above we show only the lines that are changed in the file.

  4. Use sudo to install LibreOffice.

    yum install libreoffice

  5. Disable locking in LibreOffice, run cd /usr/lib64/libreoffice/share/registry command.

  6. Create a file named disable-file-locking.xcd with the following code.

    <?xml version="1.0" encoding="UTF-8"?>
<oor:data xmlns:oor="http://openoffice.org/2001/registry">
<dependency file="main"/>
<oor:component-data oor:package="org.openoffice.Office" oor:name="Common">
   <node oor:name="Misc">
      <prop oor:name="UseLocking">
      <value>false</value>
      </prop>
   </node>
</oor:component-data>
</oor:data>

  7. Change to the directory /home/asterion/asterion/oracle/dbObscura/admin and use the script startDbObscura.sh to start dbObscura.

    Image 10

  8. Open another terminal window on your laptop or local system and run ssh -o ForwardX11=yes asterion@<instance IP address> command, this will allow you to interact with the graphical interface on the AsterionDB instance.

Task 6: Run the Application Integration or React Demo

  1. Return to your web browser from Task 3, go to the App Integration.

  2. Click View to view the mock maintenance manual.

  3. Click Edit to open the parts spreadsheet, try editing by adding or deleting a part and then click Save.

    Sample React demo run with spreadsheet editing: AsterionDB React Demo Run with Spreadsheet Editing for Hybrid Edge.

    Note: Loading LibreOffice can take a while depending on network bandwidth due to X11 forwarding.

Acknowledgments

More Learning Resources

Explore other labs on docs.oracle.com/learn or access more free learning content on the Oracle Learning YouTube channel. Additionally, visit education.oracle.com/learning-explorer to become an Oracle Learning Explorer.

For product documentation, visit Oracle Help Center.