Unable to monitor Oracle NOSQL Database via jmx

3504709

Hi all,

I'm facing a problem on monitoring my nosql via the jmx interface.

The problem is that the jmx is active, and I can connect to the jmx interface but I can't see the "Oracle NOSQL Database" section in MBeans tab (look at the screenshot):

We've configured the jmx with this command "plan change-parameters -service <service> -wait -params mgmtClass=oracle.kv.impl.mgmt.jmx.JmxAgent".

More details about the environment:

- OS: Oracle linux 7.7

- Nosql version: 18.1.19

Can someone help me on this?

Thank you.

Marcantonio

userBDBDMS-Oracle

Please move to a more recent version of NoSQL. 

Here is a link for 19.5:  https://docs.oracle.com/en/database/other-databases/nosql-database/19.5/admin/java-management-extensions-jmx.html#GUID-8…

3504709

At the moment is impossible for me to upgrade the version because the DB is used by some live apps.

However, I found the documentation for the 18.1 too: https://docs.oracle.com/en/database/other-databases/nosql-database/18.1/admin/java-management-extensions-jmx.html#GUID-8… https://docs.oracle.com/en/database/other-databases/nosql-database/18.1/admin/java-management-extensions-jmx.html#GUID-8D151ADE-EC10-446B-8242-1EEC0C3BCB52

3504709

Anyone can help me on this? Still having the problem.

userBDBDMS-Oracle

I will be verifying our in-house testing to make sure there are no known issues with this interface on the 18.1 release. 

romych-JavaNet

But I am have same problem. Can not enable JMX on kv-18.1.27.

I am try to turn it on via setting sn property, and via makebootconfig. No any errors or words about jmx in log files.

  <component name="params" type="bootstrapParams" validate="true">

    <property name="capacity" value="1" type="INT"/>

    <property name="dnsCacheTTL" value="-1" type="INT"/>

    <property name="haHostname" value="oranosqltst01" type="STRING"/>

    <property name="haPortRange" value="5010,5025" type="STRING"/>

    <property name="hostingAdmin" value="true" type="BOOLEAN"/>

    <property name="hostname" value="oranosqltest01" type="STRING"/>

    <property name="memoryMB" value="7837" type="INT"/>

    <property name="mgmtClass" value="oracle.kv.impl.mgmt.jmx.JmxAgent" type="STRING"/>

    <property name="numCPUs" value="2" type="INT"/>

    <property name="registryPort" value="5000" type="INT"/>

    <property name="rootDir" value="/app/ondb" type="STRING"/>

    <property name="securityDir" value="security" type="STRING"/>

    <property name="servicePortRange" value="5030,5040" type="STRING"/>

    <property name="softwareVersion" value="18.1.27" type="STRING"/>

    <property name="storageNodeId" value="1" type="INT"/>

    <property name="storeName" value="DB2Test" type="STRING"/>

  </component>

Cluster from 3 sn's

userBDBDMS-Oracle

As stated before, we will be verifying in house if there are issues with JMX and 18.1.27 release.   Once we have this worked through internally, I will pass along what we found.

thanks

userBDBDMS-Oracle

What version of Java is being used?  which JDK?

userBDBDMS-Oracle

please post the commands you used to start/launch the sn's.

3504709

Java version: oracle jdk 1.8.0_231

These are the commands:

java -Xmx64m -Xms64m -jar /kvroot/kv-18.1.19/lib/kvstore.jar start -root /kvroot/kv-18.1.19

\_/usr/java/jdk1.8.0_231/jre/bin/java -cp /kvroot/kv-18.1.19/lib/kvstore.jar -XX:+DisableExplicitGC -Xms96M -Xmx128M -server -Dje.rep.skipHelperHostResolution=true -XX:+PrintGCDetails -XX:+PrintGCDateStamps -XX:+PrintGCApplicationStoppedTime -XX:+UseGCLogFileRotation -XX:NumberOfGCLogFiles=10 -XX:GCLogFileSize=1048576 -Xloggc:/kvroot/kv-18.1.19/vertistore/log/admin1.gc -Dkvdns.networkaddress.cache.ttl=-1 oracle.kv.impl.sna.ManagedService -root /kvroot/kv-18.1.19/vertistore/sn1 -secdir /kvroot/kv-18.1.19/security -store vertistore -class Admin -service admin1

\_/usr/java/jdk1.8.0_231/jre/bin/java -cp /kvroot/kv-18.1.19/lib/kvstore.jar -XX:+UseLargePages -XX:+AlwaysPreTouch -Dje.rep.skipHelperHostResolution=true -XX:+UseG1GC -XX:MaxGCPauseMillis=100 -XX:InitiatingHeapOccupancyPercent=85 -XX:G1HeapRegionSize=32m -XX:G1MixedGCCountTarget=32 -XX:G1RSetRegionEntries=2560 -XX:G1HeapWastePercent=5 -XX:-ResizePLAB -XX:+DisableExplicitGC -XX:+PrintGCDetails -XX:+PrintGCDateStamps -XX:+PrintGCApplicationStoppedTime -XX:+UseGCLogFileRotation -XX:NumberOfGCLogFiles=10 -XX:GCLogFileSize=1048576 -Xloggc:/data/u01/rnlog01/rg1-rn1.gc -Xms17033M -Xmx17033M -XX:ParallelGCThreads=4 -Dkvdns.networkaddress.cache.ttl=-1 oracle.kv.impl.sna.ManagedService -root /kvroot/kv-18.1.19/vertistore/sn1 -secdir /kvroot/kv-18.1.19/security -store vertistore -class RepNode -service rg1-rn1

romych-JavaNet

I am use 3 node cluster :

java version "1.8.0_181"

Java(TM) SE Runtime Environment (build 1.8.0_181-b13)

Java HotSpot(TM) 64-Bit Server VM (build 25.181-b13, mixed mode)

OS: Red Hat Enterprise Linux Server release 7.7 (Maipo)

All processes of Oracle KV store works under "kvstore" user in folders with all rights for this user.

Command to start sn on each node:

nohup /app/java/bin/java -Xmx256m -Xms128m -jar $KVHOME/lib/kvstore.jar start -root $KVROOT &

Where:

KVROOT=/app/ondb

KVHOME=/app/kvstore