Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.9K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 533 SQLcl
- 4K SQL Developer Data Modeler
- 186.9K SQL & PL/SQL
- 21.3K SQL Developer
- 295.5K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.2K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 402 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
Unable to monitor Oracle NOSQL Database via jmx

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
Answers
-
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…
-
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
-
Anyone can help me on this? Still having the problem.
-
I will be verifying our in-house testing to make sure there are no known issues with this interface on the 18.1 release.
-
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
-
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
-
What version of Java is being used? which JDK?
-
please post the commands you used to start/launch the sn's.
-
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
-
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