How to Install Oracle Database API for MongoDB

Oracle Database Api for MongoDB Installation Steps

Oracle Database 23ai, previously known as Oracle Database 23c, has been released on May 2, 2024. I am happy that i could have a chance to test it in action in the first weeks. I have installed it using rpm method and also this is the first I have installed Oracle Database Software with a rpm package.

First i will download the latest Generally Available setup file.

[root@oradev01 ~]# curl -L -o oracle-database-free-23ai-1.0-1.el8.x86_64.rpm https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23ai-1.0-1.el8.x86_64.rpm

After downloading the required setup file. I will install it using dnf package manager.

After installation completed, modify the parameters in ‘/etc/sysconfig/oracle-free-23ai.conf’ and then run ‘/etc/init.d/oracle-free-23ai configure’ as root. I have changed the default listener port to 1426. This is my school number.

[root@oradev01 ~]# vi /etc/sysconfig/oracle-free-23ai.conf
...
# LISTENER PORT used Database listener, Leave empty for automatic port assignment
LISTENER_PORT=1426
..
# DB Domain name
DB_DOMAIN=localdomain
...

I’m going to establish a directory for ORDS and a separate directory for its configuration. Specifically, I’ve opted for /home/oracle/ords and /home/oracle/ordsconf

[root@oradev01 ~]# mkdir -p /home/oracle
[root@oradev01 ~]# chown -R oracle:oinstall /home/oracle
[oracle@oradev01 ~]$ mkdir /home/oracle/ordsconfig
[oracle@oradev01 ~]$ mkdir /home/oracle/ords

Download latest ORDS (Oracle Rest Data Service) setup file and unzip it.

[oracle@oradev01 ~]$ curl -L -o ords-latest.zip https://download.oracle.com/otn_software/java/ords/ords-latest.zip
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100  116M  100  116M    0     0  10.3M      0  0:00:11  0:00:11 --:--:-- 10.2M

[oracle@oradev01 ~]$ unzip /home/oracle/ords-latest.zip -d /home/oracle/ords

After setting environment variables, I will install it with the commands provided below.

Next, I’ll proceed to configure ORDS, enabling the MongoDB API and setting it to serve on a custom port (27003).

Now that ORDS Installation and Configuration is complete, I’ll proceed to create a database user tailored for utilizing the MongoDB API and hosting JSON collections. This user will be granted the CONNECT, RESOURCE, and SODA_APP role privileges, along with an appropriate tablespace quota. I’ve chosen to name this user ‘INSANEDBA’. Once the user is created, I’ll connect to the database using that user and enable ORDS for that schema. Below are the sql commands I’ve used.

My server is called 192.168.60.203, my database username is ‘insanedba’ and my database password is ‘insane’ . If you are running ORDS over HTTP or over HTTPS with a self-signed certificate, you will need to to specify –tlsAllowInvalidCertificates

Let’s connect it.

[root@mongo01 ~]# mongosh --tlsAllowInvalidCertificates 'mongodb://insanedba:insane@192.168.60.203:27003/insanedba?authMechanism=PLAIN&authSource=$external&ssl=true&retryWrites=false&loadBalanced=true'
Current Mongosh Log ID: 6636b1260bdb82c3d72202d7
Connecting to:          mongodb://<credentials>@192.168.60.203:27003/insanedba?authMechanism=PLAIN&authSource=%24external&ssl=true&retryWrites=false&loadBalanced=true&tlsAllowInvalidCertificates=true&appName=mongosh+2.2.5
Using MongoDB:          4.2.14
Using Mongosh:          2.2.5

For mongosh info see: https://docs.mongodb.com/mongodb-shell/

Hope it helps.