dincosman

[oracle@oradev01 ~]$ export ORDS_CONFIG=/home/oracle/ordsconfig
[oracle@oradev01 ~]$ export PATH=/home/oracle/ords/bin:/opt/oracle/product/23ai/dbhomeFree/jdk/bin:$PATH
[oracle@oradev01 ~]$ export JAVA_HOME=/opt/oracle/product/23ai/dbhomeFree/jdk
[oracle@oradev01 ords]$ export ORACLE_HOME=/opt/oracle/product/23ai/dbhomeFree
[oracle@oradev01 ~]$ cd ords

[oracle@oradev01 ords]$ ords install

ORDS: Release 24.1 Production on Sat May 04 20:19:24 2024

dincosman

[root@oradev01 ~]# /etc/init.d/oracle-free-23ai configure
  Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
  Confirm the password:
  Configuring Oracle Listener.
  Listener configuration succeeded.
  Configuring Oracle Database FREE.
  Enter SYS user password: 
  *********
  Enter SYSTEM user password: 
  ******

dincosman

[root@oradev01 ~]# dnf install -y oracle-database-free-23ai

Last metadata expiration check: 0:03:50 ago on Sat 04 May 2024 10:42:18 PM +03.
Dependencies resolved.
=========================================================================================================================================
 Package                                   Architecture     Version                                    Repository                   Size
=========================================================================================================================================
Installing:
 oracle-database-free-23ai                 x86_64           1.0-1                                      @commandline                1.3 G
Installing dependencies:

dincosman

[postgres@ferret01 data]$ psql -d ferretdb
psql (16.2)
Type "help" for help.

-- For a mongodb database - a schema created in postgresql
-- For a mongodb collection - a relation/table created in postgresql
ferretdb=# SET schema 'test';
SET
ferretdb=# \dt
                    List of relations

dincosman

osmandinc@192 mongoapi % node 1mri_ferret.js

(node:25327) [DEP0040] DeprecationWarning: The `punycode` module is deprecated. Please use a userland alternative instead.
(Use `node --trace-deprecation ...` to show where the warning was created)
Inserted: 1000000 rows
Operation took: 65403.59325 milliseconds

[root@mongo01 ~]# mongosh mongodb://postgres:[email protected]:27002/ferretdb?authMechanism=PLAIN
Current Mongosh Log ID: 6636743d70a76b19852202d7
Connecting to:          mongodb://<credentials>@192.168.60.202:27002/ferretdb?authMechanism=PLAIN&directConnection=true&appName=mongosh+2.2.5

dincosman

const fs = require("fs");
const mongodb = require("mongodb").MongoClient;
const fastimp = require("fast-csv");

// Start timing
const startTime = process.hrtime();

// Mongo API connection string
let url = "mongodb://postgres:[email protected]:27002/ferretdb?authMechanism=PLAIN";
let stream = fs.createReadStream("measurements.txt");

dincosman

osmandinc@192 mongoapi % node 1mri_mongo.js
(node:23091) [DEP0040] DeprecationWarning: The `punycode` module is deprecated. Please use a userland alternative instead.
(Use `node --trace-deprecation ...` to show where the warning was created)
Inserted: 1000000 rows
Operation took: 21868.841958 milliseconds


[root@mongo01 ~]# mongosh mongodb://insanedba:[email protected]:27001/test
Current Mongosh Log ID: 663681a98dee05e7f72202d7
Connecting to:          mongodb://<credentials>@192.168.1.31:27001/test?directConnection=true&appName=mongosh+2.2.5

dincosman

--- Install SDKMAN
osmandinc@192 ~ % curl -s "https://get.sdkman.io" | bash
osmandinc@192 ~ % source "/Users/osmandinc/.sdkman/bin/sdkman-init.sh"
osmandinc@192 ~ % sdk version
  ...
  SDKMAN!
  script: 5.18.2
  native: 0.4.6

-- Install Java

dincosman

const fs = require("fs");
const mongodb = require("mongodb").MongoClient;
const fastimp = require("fast-csv");

// Start timing
const startTime = process.hrtime();

// Mongodb connection string
let url = "mongodb://insanedba:[email protected]:27001/test";

dincosman

[root@posbckp01 ~]# cd /etc/ssl/
[root@posbckp01 ssl]# mkdir pgbackrest
[root@posbckp01 ssl]# cd pgbackrest/
[root@posbckp01 ~]# cat csr_details.txt 
  [ req ]
  default_bits = 2048
  default_md = sha256
  req_extensions = v3_req
  distinguished_name = dn
  prompt = no