1 2 Previous Next 24 Replies Latest reply on Apr 17, 2020 9:09 AM by 3504709

Unable to monitor Oracle NOSQL Database via jmx

3504709 Feb 26, 2020 9:34 AM

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

1. Re: Unable to monitor Oracle NOSQL Database via jmx

userBDBDMS-Oracle Feb 26, 2020 2:07 PM (in response to 3504709)

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…
Like Show 0 Likes(0)

Actions
2. Re: Unable to monitor Oracle NOSQL Database via jmx

3504709 Feb 26, 2020 2:39 PM (in response to userBDBDMS-Oracle)

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
Like Show 0 Likes(0)

Actions
3. Re: Unable to monitor Oracle NOSQL Database via jmx

3504709 Mar 2, 2020 2:13 PM (in response to 3504709)

Anyone can help me on this? Still having the problem.
Like Show 0 Likes(0)

Actions
4. Re: Unable to monitor Oracle NOSQL Database via jmx

userBDBDMS-Oracle Mar 2, 2020 2:51 PM (in response to 3504709)

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

Actions
5. Re: Unable to monitor Oracle NOSQL Database via jmx

romych-JavaNet Mar 6, 2020 9:45 AM (in response to userBDBDMS-Oracle)

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
Like Show 0 Likes(0)

Actions
6. Re: Unable to monitor Oracle NOSQL Database via jmx

userBDBDMS-Oracle Mar 9, 2020 4:21 PM (in response to romych-JavaNet)

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
Like Show 0 Likes(0)

Actions
7. Re: Unable to monitor Oracle NOSQL Database via jmx

userBDBDMS-Oracle Mar 10, 2020 6:56 PM (in response to userBDBDMS-Oracle)

What version of Java is being used? which JDK?
Like Show 0 Likes(0)

Actions
8. Re: Unable to monitor Oracle NOSQL Database via jmx

userBDBDMS-Oracle Mar 10, 2020 7:22 PM (in response to userBDBDMS-Oracle)

please post the commands you used to start/launch the sn's.
Like Show 0 Likes(0)

Actions
9. Re: Unable to monitor Oracle NOSQL Database via jmx

3504709 Mar 11, 2020 8:06 AM (in response to 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
Like Show 0 Likes(0)

Actions
10. Re: Unable to monitor Oracle NOSQL Database via jmx

romych-JavaNet Mar 11, 2020 9:40 AM (in response to userBDBDMS-Oracle)

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
Like Show 0 Likes(0)

Actions
11. Re: Unable to monitor Oracle NOSQL Database via jmx

userBDBDMS-Oracle Mar 11, 2020 1:07 PM (in response to romych-JavaNet)

see https://docs.oracle.com/en/database/other-databases/nosql-database/18.1/admin/makebootconfig.html

toward the bottom you will see [-mgmt {jmx|none}]

Add -mgmt parameter to makebootconfig. that should correct the issue.

I am filing an internal doc bug on this issue as the documentation is not as clear as it could be.

thanks
Like Show 0 Likes(0)

Actions
12. Re: Unable to monitor Oracle NOSQL Database via jmx

3504709 Mar 11, 2020 1:49 PM (in response to 3504709)

My makebootconfig is an xml "config.xml" where I can find this string:

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

Where I've to add -mgmt jmx?
Like Show 0 Likes(0)

Actions
13. Re: Unable to monitor Oracle NOSQL Database via jmx

userBDBDMS-Oracle Mar 11, 2020 2:49 PM (in response to 3504709)

Review this section of the docs on configuration. -mgmt is another config parameter to passed to makebootconfig.

https://docs.oracle.com/en/database/other-databases/nosql-database/18.1/admin/installation-configuration-parameters.html…
Like Show 0 Likes(0)

Actions
14. Re: Unable to monitor Oracle NOSQL Database via jmx

3504709 Mar 11, 2020 3:49 PM (in response to 3504709)

I've regenerated the config file via makebootconfig adding "-mgmt jmx", but the problem is still present.
Like Show 0 Likes(0)

Actions

1 2 Previous Next

Go to original post