Oracle Spatial and Graph – technical tips, best practices, and news from the product team
-
Graph Features,
Spatial and Graph
May 5, 2018
Oracle's Property Graph Database in Shining Armor (4)
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-serverPicked 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 7007tcp 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