X

Oracle Spatial and Graph – technical tips, best practices, and news from the product team

Oracle's Property Graph Database in Shining Armor (4)

Alan Wu
Architect

This is the fourth installment of the series "Oracle's Property Graph Database in Shining Armor." In this blog, I am going to talk about starting PGX server in a few quick steps. Click 1, 2, 3 for previous installments. Note that if you chose Oracle Database 12.2.0.1 during service creation, then you may want to install this patch in order to run PGQL, a powerful graph pattern matching language. If you chose Oracle Database 18.1, then install patch 27639357 instead.

To start PGX server, we first login to the machine running the Oracle Database instance. Here I am assuming you want to run PGX on the same hardware running Oracle Database.

- Login

 [rdf@hqgraph1 ~]$  ssh -i  <key_filename>   opc@<IP_HERE>

 

- Become oracle

[opc@g dbhome_1]$ sudo su - oracle
[oracle@g ~]$ cd /u01/app/oracle/product/12.2.0.1/dbhome_1

 

- Change enable_tls from true to false in the following configuration file

[oracle@g dbhome_1]$ cd md/
[oracle@g md]$ cd property_graph
[oracle@g property_graph]$ cat pgx/conf/server.conf
{
  "port": 7007,
  "enable_tls": false,
  "enable_client_authentication": false
}

 

- Set a few options about number of workers, on-heap, off-heap memory size (explained in this blog).

 [oracle@g property_graph]$ export _JAVA_OPTIONS="-Dpgx.num_workers_io=4 -Dpgx.max_off_heap_size=12000 -Dpgx.num_workers_analysis=4 -Xmx12000m "

 

- Kick off the server.

 [oracle@g property_graph]$ cd pgx/bin/

[oracle@g bin]$ ./start-server
Picked up _JAVA_OPTIONS: -Dpgx.num_workers_io=4 ...
...
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
00:05:09,092 INFO Ctrl$2 - >>> PGX engine running.
May 05, 2018 12:05:11 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-nio-7007"]
...

 

- Verify that the server is listening.

 [oracle@g ~]$ netstat -an |grep 7007
tcp        0      0 0.0.0.0:7007                0.0.0.0:*                   LISTEN     
[oracle@g ~]$

 

- Ping the endpoint.

 [oracle@g ~]$ curl http://127.0.0.1:7007/version
"2.X.0"

 

OK. All done.

Cheers,

Zhe

 

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.