Forum Stats

  • 3,817,472 Users
  • 2,259,339 Discussions
  • 7,893,790 Comments

Discussions

Unable to monitor Oracle NOSQL Database via jmx

3504709
3504709 Member Posts: 11
edited Apr 17, 2020 5:09AM in NoSQL Database Discussions

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):

pastedImage_2.png

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

«13

Answers

  • userBDBDMS-Oracle
    userBDBDMS-Oracle Member Posts: 787 Employee
    edited Feb 26, 2020 9:07AM
  • 3504709
    3504709 Member Posts: 11
    edited Mar 2, 2020 9:13AM

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

  • userBDBDMS-Oracle
    userBDBDMS-Oracle Member Posts: 787 Employee
    edited Mar 2, 2020 9:51AM

    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
    romych-JavaNet Member Posts: 2
    edited Mar 6, 2020 4:45AM

    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
    userBDBDMS-Oracle Member Posts: 787 Employee
    edited Mar 9, 2020 12:21PM

    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
    userBDBDMS-Oracle Member Posts: 787 Employee
    edited Mar 10, 2020 2:56PM

    What version of Java is being used?  which JDK?

  • userBDBDMS-Oracle
    userBDBDMS-Oracle Member Posts: 787 Employee
    edited Mar 10, 2020 3:22PM

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

  • 3504709
    3504709 Member Posts: 11
    edited Mar 11, 2020 4:06AM

    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
    romych-JavaNet Member Posts: 2
    edited Mar 11, 2020 5:40AM

    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