Error :
ERROR ojdbc7.jar driver mentioned in agent.properties was not found. Exiting.
Solution Details:
uncomment line server.driversLocation = drivers[oracle@veridata agent1]$ sh agent.sh start agent.properties
In
this QuickStart, we learn how to:
1] Create LVM storage.
·
list
existing partition
[root@lvm_node ~]# fdisk -l
·
create
new partition for LVM Disk Group
- Enter P to display the existing Partitions
- Create New partition of 10GB size
- Change the partition to LVM system
- Use partprobe command to change the partition table
-
Move
newly created disk to lvm PV
- create the volume group
-
create
lvm on volume group
- Format the LVM file system to use
2] Download mongoDB 4.4.0
software and unzip
https://www.mongodb.com/try/download/enterprise
[mongo@lvm_node tmp]$ pwd
/tmp
[mongo@lvm_node tmp]$
[mongo@lvm_node ~]$ cd /tmp
[mongo@lvm_node tmp]$ ls -ltr
total 128900
-rw-rw-r--. 1 mongo mongo 131986084 Aug 22 15:40
mongodb-linux-x86_64-enterprise-rhel70-4.4.0.tgz
-rw-------. 1 root
root 0 Aug 25 21:16
yum.log
-rwx------. 1 root
root 836 Aug 25 21:30
ks-script-9cUA9D
[mongo@lvm_node tmp]$ tar -xvzf mongodb-linux-x86_64-enterprise-rhel70-4.4.0.tgz
mongodb-linux-x86_64-enterprise-rhel70-4.4.0/LICENSE-Enterprise.txt
mongodb-linux-x86_64-enterprise-rhel70-4.4.0/MPL-2
mongodb-linux-x86_64-enterprise-rhel70-4.4.0/README
mongodb-linux-x86_64-enterprise-rhel70-4.4.0/THIRD-PARTY-NOTICES
mongodb-linux-x86_64-enterprise-rhel70-4.4.0/bin/install_compass
mongodb-linux-x86_64-enterprise-rhel70-4.4.0/bin/mongo
mongodb-linux-x86_64-enterprise-rhel70-4.4.0/bin/mongocryptd
mongodb-linux-x86_64-enterprise-rhel70-4.4.0/bin/mongod
mongodb-linux-x86_64-enterprise-rhel70-4.4.0/bin/mongodecrypt
mongodb-linux-x86_64-enterprise-rhel70-4.4.0/bin/mongokerberos
mongodb-linux-x86_64-enterprise-rhel70-4.4.0/bin/mongoldap
mongodb-linux-x86_64-enterprise-rhel70-4.4.0/bin/mongos
mongodb-linux-x86_64-enterprise-rhel70-4.4.0/snmp/MONGOD-MIB.txt
mongodb-linux-x86_64-enterprise-rhel70-4.4.0/snmp/MONGODBINC-MIB.txt
mongodb-linux-x86_64-enterprise-rhel70-4.4.0/snmp/README-snmp.txt
mongodb-linux-x86_64-enterprise-rhel70-4.4.0/snmp/mongod.conf.master
3] Install net-snmp package
[root@lvm_node ~]# yum install net-snmp*
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base:
mirrors.raystedman.org
* extras:
distro.ibiblio.org
* updates:
mirror.cs.uwp.edu
base
| 3.6 kB 00:00:00
extras
| 2.9 kB 00:00:00
updates
|
2.9 kB 00:00:00
Resolving Dependencies
--> Running transaction check
---> Package net-snmp.x86_64 1:5.7.2-48.el7_8.1 will be
installed
--> Processing Dependency: libsensors.so.4()(64bit) for package:
1:net-snmp-5.7.2-48.el7_8.1.x86_64
---> Package net-snmp-agent-libs.x86_64 1:5.7.2-48.el7_8.1
will be installed
-
-
-
-
-
-
Dependency Updated:
e2fsprogs.x86_64
0:1.42.9-17.el7
e2fsprogs-libs.x86_64 0:1.42.9-17.el7 elfutils.x86_64 0:0.176-4.el7 elfutils-libelf.x86_64
0:0.176-4.el7
elfutils-libs.x86_64
0:0.176-4.el7 krb5-libs.x86_64
0:1.15.1-46.el7 libcom_err.x86_64
0:1.42.9-17.el7 libdb.x86_64
0:5.3.21-25.el7
libdb-utils.x86_64
0:5.3.21-25.el7 libselinux.x86_64
0:2.5-15.el7
libselinux-python.x86_64 0:2.5-15.el7 libselinux-utils.x86_64 0:2.5-15.el7
libss.x86_64 0:1.42.9-17.el7 openssl.x86_64 1:1.0.2k-19.el7 openssl-libs.x86_64
1:1.0.2k-19.el7 rpm.x86_64
0:4.11.3-43.el7
rpm-build.x86_64
0:4.11.3-43.el7
rpm-build-libs.x86_64 0:4.11.3-43.el7 rpm-libs.x86_64 0:4.11.3-43.el7 rpm-python.x86_64 0:4.11.3-43.el7
rpm-sign.x86_64
0:4.11.3-43.el7
Complete!
[root@lvm_node ~]#
4] create user and directory structure
[root@lvm_node ~]# adduser mongo
[root@lvm_node ~]# passwd mongo
Changing password for user mongo.
New password:
BAD PASSWORD: The password is shorter than 8 characters
Retype new password:
passwd: all authentication tokens updated successfully.
[root@lvm_node ~]#
[root@lvm_node ~]# chown mongo:mongo /u01/app
[root@lvm_node ~]# chmod 775 /u01/app
[root@lvm_node ~]#
[root@lvm_node ~]# su - mongo
Last login: Sat Aug 29 17:29:23 EDT 2020 on pts/0
[mongo@lvm_node ~]$
[mongo@lvm_node ~]$ mkdir -p /u01/app/mongo/product
[mongo@lvm_node
4.4.0]$
[mongo@lvm_node 4.4.0]$ mkdir -p /u01/app/mongo/etc
[mongo@lvm_node 4.4.0]$ mkdir -p /u01/app/mongo/data
[mongo@lvm_node 4.4.0]$ mkdir -p /u01/app/mongo/log
[mongo@lvm_node 4.4.0]$
5] Copy binary to mongo home
[mongo@lvm_node tmp]$ mv
mongodb-linux-x86_64-enterprise-rhel70-4.4.0 /u01/app/mongo/product/
[mongo@lvm_node tmp]$ cd /u01/app/mongo/product/
[mongo@lvm_node product]$ ls -ltr
total 4
drwxrwxr-x. 4 mongo mongo 4096 Aug 29 17:36
mongodb-linux-x86_64-enterprise-rhel70-4.4.0
[mongo@lvm_node product]$ mv
mongodb-linux-x86_64-enterprise-rhel70-4.4.0 4.4.0
[mongo@lvm_node product]$ cd 4.4.0
[mongo@lvm_node 4.4.0]$ pwd
/u01/app/mongo/product/4.4.0
[mongo@lvm_node 4.4.0]$
6] Set variable for mongoDB in
Bash profile
[mongo@lvm_node 4.4.0]$ cd /u01/app/mongo/etc/
[mongo@lvm_node etc]$ pwd
/u01/app/mongo/etc
[mongo@lvm_node etc]$ vi mongoDB.conf
[mongo@lvm_node etc]$ cat mongoDB.conf
# mongod.conf
# for documentation of all options, see:
#
http://docs.mongodb.org/manual/reference/configuration-options/
# where to write logging data.
systemLog:
destination: file
logAppend: true
path:
/u01/app/mongo/log/mongod.log
# Where and how to store data.
storage:
dbPath:
/u01/app/mongo/data
journal:
enabled: true
# engine:
# mmapv1:
# wiredTiger:
# how the process runs
processManagement:
fork: true # fork and run in background
pidFilePath:
/u01/app/mongo/data/mongod.pid #
location of pidfile
# network interfaces
net:
port: 27017
bindIp: localhost # Listen to local interface only, comment to
listen on all interfaces.
security:
authorization: enabled
keyFile:
/u01/app/mongo/pkey/dev1-key
#security:
#operationProfiling:
#replication:
8] Start mongo daemon using
config file
[mongo@lvm_node etc]$ pwd
/u01/app/mongo/etc
[mongo@lvm_node etc]$ ls -ltr
total 4
-rw-rw-r--. 1 mongo mongo 783 Aug 29 18:40 mongoDB.conf
[mongo@lvm_node etc]$ mongod -f /u01/app/mongo/etc/mongoDB.conf
about to fork child process, waiting until server is ready for
connections.
forked process: 16097
child process started successfully, parent exiting
[mongod@localhost ~]$
9] validation
[mongo@lvm_node etc]$ mongo
MongoDB shell version v4.4.0
connecting to: mongodb://127.0.0.1:27017/?compressors=disabled&gssapiServiceName=mongodb
Implicit session: session { "id" :
UUID("fcec5d01-62d1-40e2-9d38-a12e8d6529b0") }
MongoDB server version: 4.4.0
MongoDB Enterprise > db.version()
4.4.0
MongoDB Enterprise >
Error:
Error: error: {
"ok" : 0,
"errmsg" : "Executor error during find command: OperationFailed: Sort operation used more than the maximum 33554432 bytes of RAM. Add an index, or specify a smaller limit.",
"code" : 96,
"codeName" : "OperationFailed"
}
Solution:
when you execute query on large collection that time error will come. use limit() method to get data.
db.employees.find().sort({employee_id: 1 } ).limit(1)
Error:
Error: [INS-08101] Unexpected error while executing the action at state: 'supportedOSCheck'
Solution:
[oracle@node1 dbhome_1]$ cd $ORACLE_HOME/cv/admin
[oracle@node1 admin]$ vi cvu_config
un-comment the below parameter and set value as your OS version
# Fallback to this distribution id
CV_ASSUME_DISTID=OEL8.2 #my OS version is CentOS Linux release 8.2.2004 (Core)
Chapter 1: Introduction
Problem:
If you haven't downloaded Compass yet then please go back to this lecture Connecting to MongoDB Using Compass in Chapter 0 and follow the instructions mentioned there for downloading Compass and connecting to the class Atlas cluster.
If you have already downloaded Compass then please use this connection string for connecting to the class Atlas cluster :
mongodb+srv://m001-student:m001-mongodb-basics@cluster0-jxeqq.mongodb.net/test
Question:
Which of the following field names appear in documents in the movies collection of the video database. Check all that apply.
Problem:
Problem:
Problem:
Lab 1.6: Scavenger Hunt, Part 2
Problem:
How many documents in video.movieDetails match the filter {genres: "Comedy"}?
Problem:
If the collection video.myMovies is currently empty, how many documents would be inserted by the following call to insertMany().
Problem:
Explore the movieDetails collection that you loaded into your Atlas sandbox cluster and then issue a query to answer the following question. How many movies in the movieDetails collection list "Family" among its genres?
You will find the count() method useful in answering this question using the mongo shell.
Problem:
Explore the movieDetails collection that you loaded into your Atlas sandbox cluster and then issue a query to answer the following question. How many movies in the movieDetails collection list "Western" second among its genres?
You will find the count() method useful in answering this question using the mongo shell.
Problem:
To work on this lab, you need to connect to the sandbox cluster in which you have imported the video.movieDetails collection.
Suppose you wish to update the value of the plot field for one document in our movieDetails collection to correct a typo. Which of the following update operators and modifiers would you need to use to do this?
Chapter 3: Deeper Dive into the MongoDB Query Language
Solution: for shell => db.score.find({results:{$elemMatch: {$gte: 70},{$lte: 80 }}})
For compass =>{results: {$elemMatch: {"score": {$gte: 70}, "score": {$lte: 80 }}}}
Final Exam
Problem:
Connect to our class Atlas cluster from Compass and view the citibike.trips collection.
Use the schema view and any filters you feel are necessary to determine the range of values for the usertype field. Which of the following are values found in this collection for the field usertype?
Solution:
Problem:
Connect to our class Atlas cluster from Compass and view the 100YWeatherSmall.data collection.
Using the Schema view, explore the wind field. The wind field has the value type of document. Which of the following best describes the schema of this embedded document?
Problem:
Connect to our class Atlas cluster from Compass and view the 100YWeatherSmall.data collection.
What is the value type of the "wind.speed.rate" field?
Problem:
Please connect to our class Atlas cluster and view the citibike database.
How many documents in the citibike.trips collection have the key tripduration set to null? Ignore any documents that do not contain the tripduration key.
Problem:
Please connect to our class Atlas cluster from the mongo shell or Compass and view the video.movies collection.
How many movies match the following criteria? - The cast includes either of the following actors: "Jack Nicholson", "John Huston". - The viewerRating is greater than 7. - The mpaaRating is "R".
