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 126.96.36.199 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.
[rdf@hqgraph1 ~]$ ssh -i <key_filename> opc@<IP_HERE>
- Become oracle[opc@g dbhome_1]$ sudo su - oracle
- Change enable_tls from true to false in the following configuration file[oracle@g dbhome_1]$ cd md/
- 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
- Verify that the server is listening.[oracle@g ~]$ netstat -an |grep 7007
- Ping the endpoint.[oracle@g ~]$ curl http://127.0.0.1:7007/version
OK. All done.