Mas DB2 Notes
Wednesday, March 13, 2024
Error starting mongodb
Thursday, January 26, 2023
Silent mode install - Oracle Client ( [INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’)
Download here:
https://www.oracle.com/sg/database/technologies/oracle19c-linux-downloads.html
ORACLE_HOSTNAME=unica-vm-2
UNIX_GROUP_NAME=dba
INVENTORY_LOCATION=/u01/app/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
ORACLE_BASE=/u01/app/oracle
oracle.install.client.installType=Administrator
oracle.installer.autoupdates.option=SKIP_UPDATES
./runInstaller -ignoreSysPrereqs -showProgress -silent -responseFile /directory/client_install.rsp
once completed then using root: /u01/app/oraInventory/orainstRoot.sh
If you face this error:
INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’
Chefck this:
https://www.martinberger.com/2020/05/install-oracle-19c-rdbms-on-oracle-linux-8-avoid-warning-ins-08101-unexpected-error-while-executing-the-action-at-state-supportedoscheck/
Tuesday, November 30, 2021
Installing mongodb
Reference: Install MongoDB Community Edition on Red Hat or CentOS — MongoDB Manual
Configure the package management system (yum
).
Create a /etc/yum.repos.d/mongodb-org-5.0.repo
file so that you can install MongoDB directly using yum
:
[mongodb-org-5.0] name=MongoDB Repository baseurl=https://repo.mongodb.org/yum/redhat/$releasever/mongodb-org/5.0/x86_64/ gpgcheck=1 enabled=1 gpgkey=https://www.mongodb.org/static/pgp/server-5.0.asc
[root@unicaapdemo yum.repos.d]# yum install -y mongodb-org
MongoDB Repository 14 kB/s | 14 kB 00:00
Dependencies resolved.
======================================================================================================================================================================
Package Architecture Version Repository Size
======================================================================================================================================================================
Installing:
mongodb-org x86_64 5.0.4-1.el8 mongodb-org-5.0 11 k
Installing dependencies:
mongodb-database-tools x86_64 100.5.1-1 mongodb-org-5.0 47 M
mongodb-mongosh x86_64 1.1.4-1.el7 mongodb-org-5.0 43 M
mongodb-org-database x86_64 5.0.4-1.el8 mongodb-org-5.0 11 k
mongodb-org-database-tools-extra x86_64 5.0.4-1.el8 mongodb-org-5.0 16 k
mongodb-org-mongos x86_64 5.0.4-1.el8 mongodb-org-5.0 19 M
mongodb-org-server x86_64 5.0.4-1.el8 mongodb-org-5.0 28 M
mongodb-org-shell x86_64 5.0.4-1.el8 mongodb-org-5.0 15 M
mongodb-org-tools x86_64 5.0.4-1.el8 mongodb-org-5.0 11 k
Transaction Summary
======================================================================================================================================================================
Install 9 Packages
Total download size: 153 M
Installed size: 559 M
Downloading Packages:
(1/9): mongodb-org-5.0.4-1.el8.x86_64.rpm 39 kB/s | 11 kB 00:00
(2/9): mongodb-org-database-5.0.4-1.el8.x86_64.rpm 39 kB/s | 11 kB 00:00
(3/9): mongodb-org-database-tools-extra-5.0.4-1.el8.x86_64.rpm 66 kB/s | 16 kB 00:00
(4/9): mongodb-org-mongos-5.0.4-1.el8.x86_64.rpm 4.7 MB/s | 19 MB 00:04
(5/9): mongodb-mongosh-1.1.4.el8.x86_64.rpm 4.0 MB/s | 43 MB 00:10
(6/9): mongodb-org-server-5.0.4-1.el8.x86_64.rpm 4.5 MB/s | 28 MB 00:06
(7/9): mongodb-org-tools-5.0.4-1.el8.x86_64.rpm 41 kB/s | 11 kB 00:00
(8/9): mongodb-org-shell-5.0.4-1.el8.x86_64.rpm 4.6 MB/s | 15 MB 00:03
(9/9): mongodb-database-tools-100.5.1.x86_64.rpm 3.3 MB/s | 47 MB 00:14
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 11 MB/s | 153 MB 00:14
warning: /var/cache/dnf/mongodb-org-5.0-85529b2afce6c228/packages/mongodb-database-tools-100.5.1.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID e2c63c11: NOKEY
MongoDB Repository 1.6 kB/s | 1.6 kB 00:00
Importing GPG key 0xE2C63C11:
Userid : "MongoDB 5.0 Release Signing Key <packaging@mongodb.com>"
Fingerprint: F567 9A22 2C64 7C87 527C 2F8C B00A 0BD1 E2C6 3C11
From : https://www.mongodb.org/static/pgp/server-5.0.asc
Key imported successfully
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : mongodb-org-database-tools-extra-5.0.4-1.el8.x86_64 1/9
Installing : mongodb-org-shell-5.0.4-1.el8.x86_64 2/9
Running scriptlet: mongodb-org-server-5.0.4-1.el8.x86_64 3/9
Installing : mongodb-org-server-5.0.4-1.el8.x86_64 3/9
Running scriptlet: mongodb-org-server-5.0.4-1.el8.x86_64 3/9
Created symlink /etc/systemd/system/multi-user.target.wants/mongod.service → /usr/lib/systemd/system/mongod.service.
Installing : mongodb-org-mongos-5.0.4-1.el8.x86_64 4/9
Installing : mongodb-org-database-5.0.4-1.el8.x86_64 5/9
Installing : mongodb-mongosh-1.1.4-1.el7.x86_64 6/9
Running scriptlet: mongodb-database-tools-100.5.1-1.x86_64 7/9
Installing : mongodb-database-tools-100.5.1-1.x86_64 7/9
Running scriptlet: mongodb-database-tools-100.5.1-1.x86_64 7/9
Installing : mongodb-org-tools-5.0.4-1.el8.x86_64 8/9
Installing : mongodb-org-5.0.4-1.el8.x86_64 9/9
Running scriptlet: mongodb-org-5.0.4-1.el8.x86_64 9/9
Verifying : mongodb-database-tools-100.5.1-1.x86_64 1/9
Verifying : mongodb-mongosh-1.1.4-1.el7.x86_64 2/9
Verifying : mongodb-org-5.0.4-1.el8.x86_64 3/9
Verifying : mongodb-org-database-5.0.4-1.el8.x86_64 4/9
Verifying : mongodb-org-database-tools-extra-5.0.4-1.el8.x86_64 5/9
Verifying : mongodb-org-mongos-5.0.4-1.el8.x86_64 6/9
Verifying : mongodb-org-server-5.0.4-1.el8.x86_64 7/9
Verifying : mongodb-org-shell-5.0.4-1.el8.x86_64 8/9
Verifying : mongodb-org-tools-5.0.4-1.el8.x86_64 9/9
Installed products updated.
Installed:
mongodb-database-tools-100.5.1-1.x86_64 mongodb-mongosh-1.1.4-1.el7.x86_64 mongodb-org-5.0.4-1.el8.x86_64
mongodb-org-database-5.0.4-1.el8.x86_64 mongodb-org-database-tools-extra-5.0.4-1.el8.x86_64 mongodb-org-mongos-5.0.4-1.el8.x86_64
mongodb-org-server-5.0.4-1.el8.x86_64 mongodb-org-shell-5.0.4-1.el8.x86_64 mongodb-org-tools-5.0.4-1.el8.x86_64
Complete!
[root@unicaapdemo yum.repos.d]# vi /etc/mongod.conf
[root@unicaapdemo mongodb]# sudo semanage fcontext -a -t mongod_var_lib_t '/apps/mongodb/data'
[root@unicaapdemo mongodb]# sudo chcon -Rv -u system_u -t mongod_var_lib_t '/apps/mongodb/data'
changing security context of '/apps/mongodb/data'
[root@unicaapdemo mongodb]# sudo restorecon -R -v '/apps/mongodb/data'
[root@unicaapdemo mongodb]#
[root@unicaapdemo mongodb]# sudo semanage fcontext -a -t mongod_log_t '/apps/mongodb/logs'
[root@unicaapdemo mongodb]# sudo chcon -Rv -u system_u -t mongod_log_t '/apps/mongodb/logs'
changing security context of '/apps/mongodb/logs'
[root@unicaapdemo mongodb]# sudo restorecon -R -v '/apps/mongodb/logs'
[root@unicaapdemo mongodb]# ls -ld /apps/mongodb/logs
drwxr-xr-x. 2 mongod mongod 6 Dec 1 14:11 /apps/mongodb/logs
[root@unicaapdemo mongodb]# ls -ld /apps/mongodb/data
Sunday, November 28, 2021
mariadb truncate table with foreign constraints
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE usm_configuration;
SET FOREIGN_KEY_CHECKS = 1;
Thursday, November 25, 2021
Migrate SQLServer Windows to Unix
https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-migrate-restore-database?view=sql-server-ver15
https://www.sqlshack.com/move-sql-database-files-in-sql-server-2019-on-linux/
https://www.mssqltips.com/sqlservertip/5346/migrate-sql-server-database-from-windows-to-sql-server-on-linux-in-cloud-part-3/
[root@database-rhel84 data]# mkdir mssql-data
[root@database-rhel84 data]# ls -l
total 1260160
-rw-r--r--. 1 root root 1290392111 Nov 22 18:16 dmdb.sql.gz
drwxr-xr-x. 2 root root 6 Nov 26 06:40 mssql-data
drwxr-xr-x. 3 root root 4096 Nov 24 14:07 mssqldbbackup
drwxr-xr-x. 13 mysql mysql 4096 Nov 26 01:52 mysql-data
Tuesday, November 23, 2021
Increase mariadb max connections
in
[root@database-rhel84 my.cnf.d]# vi server.cnf
[root@database-rhel84 my.cnf.d]# pwd
/etc/my.cnf.d
# this is only for the mysqld standalone daemon
[mysqld]
datadir=/data/mysql-data
socket=/data/mysql-data/mysql.sock
innodb-page-size=32768
character-set-server=utf8
sql_mode='NO_BACKSLASH_ESCAPES'
innodb_strict_mode=0
lower_case_table_names = 1
max_connections=500