Skip to main content

Store information with Oracle

Oracle is an object-relational database you can use to store private transaction payloads for Orion. Use a relational database to support your disaster recovery strategy.

Prerequisites​

Set up your Oracle database​

In your database:

  1. Create the store table by using the provided DDL script, as shown in the following example. Substitute your own values for USER-NAME, PASSWORD, DATABASE-NAME, and INSTALLATION-DIRECTORY.

     sqlplus <USER-NAME>/<PASSWORD>@<DATABASE-NAME> @<INSTALLATION-DIRECTORY>/orion/database/oracle_ddl.sql

  2. Specify the users for the store table and assign permissions to them.

Configure Orion to use Oracle​

In your Orion configuration file, specify oracle for the storage property, as shown in the following example. Substitute your own values for USER-NAME, PASSWORD, HOST, PORT, and SID. SID identifies a specific Oracle database.

storage="jdbc:oracle:thin:<USER-NAME>, <PASSWORD>, <HOST>, <PORT>, <SID>"

Test your updated configuration​

  1. Send the payload to Orion by running the following request:

    curl -X POST \
    http://localhost:8888/send \
    -H 'Content-Type: application/json' \
    -d '{
          "payload": "SGVsbG8sIFdvcmxkIQ==",
          "from": "<KEY-IN-NODEKEY>.PUB",
          "to": ["<KEY-IN-NODEKEY>.PUB"]
         }'

  2. Using SQL*Plus, the terminal-based front-end to Oracle, retrieve the new row in the store table.

  3. Receive the payload by running the following request:

     curl -X POST \
     http://localhost:8888/receive \
     -H 'Content-Type: application/json' \
     -d '{
          "key": "<KEY-RETURNED-IN-STEP-1>",
           "to": "<KEY-IN-NODEKEY>.PUB"
         }'

  4. Using SQL*Plus, retrieve the data in the store table.