The docker image build files, sample datasets, and use case exmaples, for Oracle Property Graph.

The scripts here are my own. Not Oracle's official material.

Architecture:

After setting up this demo environment, you can also try:

• customer_360 - Customer 360 analysis in banking
• online_retail - Recommendation system in online retail

Clone docker-images repository.

$ cd <your-work-directory>
$ git clone https://github.com/oracle/docker-images.git

Download Oracle Database.

• Oracle Database 19.3.0 for Linux x86-64 (ZIP)

Put LINUX.X64_193000_db_home.zip under:

• docker-images/OracleDatabase/SingleInstance/dockerfiles/19.3.0/

Build the image.

$ cd docker-images/OracleDatabase/SingleInstance/dockerfiles/
$ bash buildDockerImage.sh -v 19.3.0 -e

$ cd <your-work-directory>
$ git clone https://github.com/ryotayamanaka/oracle-pg.git -b 20.4

Go to the following pages and download the packages.

• Oracle Graph Server and Client 20.4
• Apache Groovy 2.4.20

Put the following files to oracle-pg/packages/

• oracle-graph-20.4.0.x86_64.rpm
• oracle-graph-client-20.4.0.zip
• oracle-graph-zeppelin-interpreter-20.4.0.zip
• oracle-graph-plsql-20.4.0.zip
• apache-groovy-binary-2.4.20.zip

Run the following script to extract packages:

$ cd oracle-pg/
$ sh extract.sh

Start the containers for Oracle Database only first.

$ cd oracle-pg/
$ docker-compose up database
...
database_1      | Completing Database Creation
...
database_1      | #########################
database_1      | DATABASE IS READY TO USE!
database_1      | #########################

This job takes time.

Connect to the Oracle Database server. See Appendix 1 if you get an error.

$ cd oracle-pg/
$ docker-compose exec database sqlplus sys/Welcome1@orclpdb1 as sysdba

Configure Property Graph features. This script was extracted from oracle-graph-plsql-xx.x.x.zip.

SQL> @/home/oracle/scripts/oracle-graph-plsql/19c_and_above/catopg.sql

Create user roles (graph_developer, graph_administrator) and users (graph_dev, graph_admin).

SQL> @/home/oracle/scripts/create_users.sql
SQL> EXIT

Build and pull images, create containers, and start them.

$ cd oracle-pg/
$ docker-compose up

This job takes time. Cnt+C to stop all containers.

Access Graph Visualization and Zeppelin to start graph analytics.

• Graph Visualization - http://localhost:7007/ui/ (User: graph_dev, Password: Welcome1)
• Jupyter - http://localhost:8888/
• Zeppelin - http://localhost:8080/#/

To stop, restart, or remove the containers, see Appendix 2.

You need to start the container if it is stopped.

$ cd oracle-pg/
$ docker-compose start database

You will get this error when you try to connect before the database is created.

$ docker-compose exec database sqlplus sys/Welcome1@localhost:1521/orclpdb1 as sysdba
...
ORA-12514: TNS:listener does not currently know of service requested in connect

To check the progress, see logs.

$ cd oracle-pg/
$ docker-compose logs -f database

Cnt+C to quit.

To start, stop, or restart the containers.

$ cd oracle-pg/
$ docker-compose start|stop|restart

To remove the docker containers.

$ cd oracle-pg/
$ docker-compose down