Graph Database Install

Fail!

So I installed the Spatial and Graph server available on the Marketplace

https://console.uk-london-1.oraclecloud.com/marketplace/application/75067377/overview

It installed, but couldn’t get it to do anything. No connection worked.

So, I thought thats OK I will just install it myself, and I saw the documentation in Oracle database 20c, https://docs.oracle.com/en/database/oracle/oracle-database/20/spgdg/property-graph-overview-spgdg.html#GUID-FF149F69-574D-43B8-B888-4CCD019DAE56 that the graph db is built in.

So I tried to install the Oracle 20. Fail. Oracle 20 is being elusive – I can’t find it. Where are they hiding the latest version??

Thats OK, I thought, I will just use my Autonomous database, and my compute, and install it myself:

So I downloaded the rpm and ran

rpm -i oracle-graph-20.4.0.x86_64.rpm

and edited the conf file (tls setting):

/etc/oracle/graph/server.conf

and set the database connection in pgx.conf:

...
"pgx_realm": {
  "implementation": "oracle.pg.identity.DatabaseRealm",
  "options": {
    "jdbc_url": "jdbc:oracle:thin:@my_identifier_low?TNS_ADMIN=/etc/oracle/graph/wallet",
    "token_expiration_seconds": 3600,
...

started the server.

Nothing.

Now I need to figure out how to connect to it and use it.

Success

By contrast I install neo4j recently.

It was simple, it is up and running – I even embedded it into an Apex app.

Summary

So, Oracle graph is difficult to install and use, neo4j is easy. I prefer easy, but will have learn more about Oracle graph before I give up.

Otherwise this will be the shortest specialist subject series.