Graph database : Oracle Graph Server and Client Installation

August 23, 2025 salem.houali@yahoo.ca Oracle AI Database 26ai, 0

Introduction: Graph databases, part of Oracle’s converged database offering, eliminate the need to set up a separate database and move data. Graphs enable you to find connections and explore relationships in your data. Analysts and developers can perform fraud detection in banking, find connections and link to data, and improve traceability in smart manufacturing, all while gaining enterprise-grade security, ease of data ingestion, and strong support for data workloads.

Oracle Autonomous Database includes Graph Studio, with one-click provisioning, integrated tooling, and security. Graph Studio automates graph data management and simplifies modeling, analysis, and visualization across the graph analytics lifecycle.

In this post. We will go though the installation and configuration

In this post, will see how to install and configure the Oracle Graph Server and then Client.
The prerequisites for installing the Oracle Graph Server are:
Step #4. Check java version installed

[root@oel8 oracle]# java -version
java version “19.0.1” 2022-10-18
Java(TM) SE Runtime Environment (build 19.0.1+10-21)
Java HotSpot(TM) 64-Bit Server VM (build 19.0.1+10-21, mixed mode, sharing)
[root@oel8 oracle]#

Oracle Linux 6 , 7 or 8 x64 or a similar Linux distribution such as RedHat (Using the Machine Learning Library (PgxML) for Graphs requires Oracle Linux 7 or later)
Oracle JDK 8 or JDK 11

Note: Due to a bug in Open JDK, it is recommended to avoid the following Oracle JDK versions:

JDK 11.0.9
JDK 11.0.10
JDK 11.0.11
JDK 11.0.12

See this note for more details.

You can run Oracle Graph Server in standalone mode or using a webserver like Oracle WebLogic Server or Apache Tomcat.
Refer to Apache Tomcat installation post

1.3 Oracle Graph Server and Client Installation

This section explains the various operations that you must perform to install, uninstall or upgrade Oracle Graph Server (PGX). It also includes the steps to install Oracle Graph Client.

Installing Oracle Graph Server
Deploying Oracle Graph Server to a Web Server
Upgrading Oracle Graph Server
Uninstalling Oracle Graph Server
Installing Oracle Graph Client

## Unzip downloaded files

unzip V1033677-01.zip -d /home/oracle/graph
unzip V1033695-01.zip -d /home/oracle/graph
unzip V1033697-01.zip -d /home/oracle/graph
unzip V1033696-01.zip -d /home/oracle/graph
unzip V1033698-01.zip -d /home/oracle/graph
unzip V1033699-01.zip -d /home/oracle/graph
unzip V1033700-01.zip -d /home/oracle/graph

sudo rpm -i oracle-graph-23.1.0.x86_64.rpm
Step #4. Check if the graph server is running
systemctl status pgx

The graph server is now ready to accept requests. If the graph server has not started, then you must check the log files in /var/log/oracle/graph for errors. Additionally, you can also run the following command to view any systemd errors:

[oracle@oel8 ~]$ sudo journalctl -u pgx.service
[sudo] password for oracle:
— Logs begin at Sat 2023-02-18 08:26:18 EST, end at Sun 2023-02-19 12:18:36 EST. —
— No entries —
[oracle@oel8 ~]$

The following post-installation steps are carried out at the time of the RPM file installation:
Creation of a working directory in /opt/oracle/graph/pgx/tmp_data
Creation of a log directory in /var/log/oracle/graph
Note: If Python is not installed in your system, then this step will be skipped.

Step #4. Check if python is installed

root@oel8 oracle]# python –versionPython 3.9.13
[root@oel8 oracle]#

Automatic generation of self-signed TLS certificates in /etc/oracle/graph
Note:
You can also choose to configure and set up transport layer security (TLS) in graph server. See Setting Up Transport Layer Security for more details.

For demonstration purposes, if you wish to disable transport layer security (TLS) in graph server, see Disabling Transport Layer Security (TLS) in Graph Server for more details.

As root or using sudo, add operating system users allowed to use the server installation to the operating system group oraclegraph. For example:

[root@oel8 oracle]# useradd -g oraclegraph graphdev
[root@oel8 oracle]# grep graphdev /etc/passwd
graphdev:x:54322:974::/home/graphdev:/bin/bash
[root@oel8 oracle]#

This adds the specified graph user to the group oraclegraph.Note that <graphuser> must log out and log in again for this to take effect.

As <graphuser>, configure the server by modifying the files under /etc/oracle/graph by following the steps under Prepare the Graph Server for Database Authentication.

Ensure that authentication is enabled for database users that will connect to the graph server, as explained in User Authentication and Authorization.

As a root user or using sudo, start the graph server (PGX) by executing the following command:

sudo systemctl start pgx

7 Graph Visualization Application

The Graph Visualization application enables interactive exploration and visualization of property graphs. It can also visualize graphs stored in the database

https://docs.oracle.com/en/database/oracle/property-graph/22.2/spgdg/graph-visualization-application1.html