ORACLE DATABASE PROBLEM AND SOLUTIONS

Sunday, July 16, 2023

What Is a RACI Matrix ?

RACI matirix is very important when we are working on project and this helps to align who is reposible for what .

Like who will take decision , who will resposible for technical task , what resposiblity of cutomer and what information needs to share with custmers etc .

R => (Responsible) : This member is resposible to taks done ---- like create infrastructure goes to infra team - Person1 ,Person2

A => (Accountable) : This member is taking decision and ensure everythig is aligned and meet all standards ----which tool going to use for database assessment goes to db team - Person2,Person1

C => (Consulted) : Share the outcome and should be meet all criteria with input & feedback to improve the business process - Person 3

I = > (Informed) : Any other team ,team memebers, stakeholder who needs to informed about project status,progress ,blockers etc - Person 4 , Person 5

ANURAG PANDEY

I am Anurag Pandey, working as Cloud Database Architect | Migration & Modernization Expert . Database Administration and Implementation. Provide technical guidance and work with global team. Extensive Experience in Database Installation and Configuration, Real Application Cluster (RAC), ASM, Dataguard , Patching, Upgrade, RMAN, Performance Tuning, Backup and Recovery, Azure, Google, AWS Cloud, AWS RDS, MySQL, Database Migration Service(DMS),CloudEndure - MGN, Azure Site Recovery, Azure Migrate, Datapump, terraform automation, Ansible

Thursday, June 1, 2023

How to check what port MariaDB is running on ?

check what port MariaDB is running on

Option : 1- Login in database

[root@10.1.1.1]#

[root@10.1.1.1]# mysql

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 11

Server version: 10.3.35-MariaDB MariaDB Server

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'PORT';

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| port | 3306 |

+---------------+-------+

1 row in set (0.001 sec)

MariaDB [(none)]>

MariaDB [(none)]> status

--------------

mysql Ver 15.1 Distrib 10.3.35-MariaDB, for Linux (x86_64) using readline 5.1

Connection id: 11

Current database:

Current user: root@localhost

SSL: Not in use

Current pager: stdout

Using outfile: ''

Using delimiter: ;

Server: MariaDB

Server version: 10.3.35-MariaDB MariaDB Server

Protocol version: 10

Connection: Localhost via UNIX socket

Server characterset: latin1

Db characterset: latin1

Client characterset: utf8

Conn. characterset: utf8

UNIX socket: /var/lib/mysql/mysql.sock

Uptime: 35 min 22 sec

Threads: 6 Questions: 15 Slow queries: 0 Opens: 18 Flush tables: 1 Open tables: 11 Queries per second avg: 0.007

--------------

MariaDB [(none)]>

Option :2 - host level command

[root@10.1.1.1]# netstat -tlpn | grep mysql

tcp6 0 0 :::3306 :::* LISTEN 22163/mysqld

[root@10.1.1.1]#

ANURAG PANDEY

How to start MariaDB database ?

Start MariaDB database

[root@10.1.1.1]#

[root@10.1.1.1]# systemctl status mariadb

● mariadb.service - MariaDB 10.3 database server

Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)

Active: inactive (dead)

Docs: man:mysqld(8)

https://mariadb.com/kb/en/library/systemd/

[root@10.1.1.1]#

[root@10.1.1.1]# systemctl start mariadb

[root@10.1.1.1]#

[root@10.1.1.1]# systemctl status mariadb

● mariadb.service - MariaDB 10.3 database server

Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)

Active: active (running) since Thu 2023-06-01 23:09:48 IST; 2s ago

Docs: man:mysqld(8)

https://mariadb.com/kb/en/library/systemd/

Process: 22194 ExecStartPost=/usr/libexec/mysql-check-upgrade (code=exited, status=0/SUCCESS)

Process: 22060 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mariadb.service (code=exited, status=0/SUCCESS)

Process: 22035 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)

Main PID: 22163 (mysqld)

Status: "Taking your SQL requests now..."

Tasks: 30 (limit: 48777)

Memory: 84.7M

CGroup: /system.slice/mariadb.service

└─22163 /usr/libexec/mysqld --basedir=/usr

Jun 01 23:09:48 ip-172-31-19-40.ec2.internal mysql-prepare-db-dir[22101]: which will also give you the option of removing the test

Jun 01 23:09:48 ip-172-31-19-40.ec2.internal mysql-prepare-db-dir[22101]: databases and anonymous user created by default. This is

Jun 01 23:09:48 ip-172-31-19-40.ec2.internal mysql-prepare-db-dir[22101]: strongly recommended for production servers.

Jun 01 23:09:48 ip-172-31-19-40.ec2.internal mysql-prepare-db-dir[22101]: See the MariaDB Knowledgebase at http://mariadb.com/kb

Jun 01 23:09:48 ip-172-31-19-40.ec2.internal mysql-prepare-db-dir[22101]: Please report any problems at http://mariadb.org/jira

Jun 01 23:09:48 ip-172-31-19-40.ec2.internal mysql-prepare-db-dir[22101]: The latest information about MariaDB is available at http://mariadb.or>

Jun 01 23:09:48 ip-172-31-19-40.ec2.internal mysql-prepare-db-dir[22101]: Consider joining MariaDB's strong and vibrant community:

Jun 01 23:09:48 ip-172-31-19-40.ec2.internal mysql-prepare-db-dir[22101]: https://mariadb.org/get-involved/

Jun 01 23:09:48 ip-172-31-19-40.ec2.internal mysqld[22163]: 2023-06-01 23:09:48 0 [Note] /usr/libexec/mysqld (mysqld 10.3.35-MariaDB) starting a>

Jun 01 23:09:48 ip-172-31-19-40.ec2.internal systemd[1]: Started MariaDB 10.3 database server.

[root@10.1.1.1]#

[root@10.1.1.1]# systemctl start mariadb.service

[root@10.1.1.1]#

[root@10.1.1.1]# systemctl status mariadb.service

● mariadb.service - MariaDB 10.3 database server

Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)

Active: active (running) since Mon 2023-06-05 16:32:48 IST; 3s ago

Docs: man:mysqld(8)

https://mariadb.com/kb/en/library/systemd/

Process: 1680 ExecStartPost=/usr/libexec/mysql-check-upgrade (code=exited, status=0/SUCCESS)

Process: 1611 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mariadb.service (code=exited, status=0/SUCCESS)

Process: 1586 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)

Main PID: 1649 (mysqld)

Status: "Taking your SQL requests now..."

Tasks: 30 (limit: 48777)

Memory: 108.7M

CGroup: /system.slice/mariadb.service

└─1649 /usr/libexec/mysqld --basedir=/usr

Jun 05 16:32:48 ip-172-31-19-40.ec2.internal systemd[1]: Starting MariaDB 10.3 database server...

Jun 05 16:32:48 ip-172-31-19-40.ec2.internal mysql-prepare-db-dir[1611]: Database MariaDB is probably initialized in /var/lib/mysql already, not>

Jun 05 16:32:48 ip-172-31-19-40.ec2.internal mysql-prepare-db-dir[1611]: If this is not the case, make sure the /var/lib/mysql is empty before r>

Jun 05 16:32:48 ip-172-31-19-40.ec2.internal mysqld[1649]: 2023-06-05 16:32:48 0 [Note] /usr/libexec/mysqld (mysqld 10.3.35-MariaDB) starting as>

Jun 05 16:32:48 ip-172-31-19-40.ec2.internal systemd[1]: Started MariaDB 10.3 database server.

[root@10.1.1.1]#

Login to MariaDB database

[root@10.1.1.1]#

[root@10.1.1.1]# mysql -u root

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 10

Server version: 10.3.35-MariaDB MariaDB Server

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

+--------------------+

3 rows in set (0.000 sec)

MariaDB [(none)]>

ANURAG PANDEY

How to Install MariaDB database server on Linux ?

Installing MariaDB database server on Linux

Login as root user

yum install mariadb-server mariadb-backup mariadb-common

[root@10.1.1.1]# yum install mariadb-server mariadb-backup mariadb-common

Updating Subscription Management repositories.

Unable to read consumer identity

This system is not registered with an entitlement server. You can use subscription-manager to register.

Last metadata expiration check: 0:55:49 ago on Thu 01 Jun 2023 10:12:01 PM IST.

Dependencies resolved.

=================================================================================================================================================

Package Architecture Version Repository Size

=================================================================================================================================================

Installing:

mariadb-backup x86_64 3:10.3.35-1.module+el8.6.0+15949+4ba4ec26 rhel-8-appstream-rhui-rpms 6.1 M

mariadb-common x86_64 3:10.3.35-1.module+el8.6.0+15949+4ba4ec26 rhel-8-appstream-rhui-rpms 64 k

mariadb-server x86_64 3:10.3.35-1.module+el8.6.0+15949+4ba4ec26 rhel-8-appstream-rhui-rpms 16 M

Installing dependencies:

mariadb x86_64 3:10.3.35-1.module+el8.6.0+15949+4ba4ec26 rhel-8-appstream-rhui-rpms 6.0 M

mariadb-connector-c x86_64 3.1.11-2.el8_3 rhel-8-appstream-rhui-rpms 200 k

mariadb-connector-c-config noarch 3.1.11-2.el8_3 rhel-8-appstream-rhui-rpms 15 k

mariadb-errmsg x86_64 3:10.3.35-1.module+el8.6.0+15949+4ba4ec26 rhel-8-appstream-rhui-rpms 235 k

perl-DBD-MySQL x86_64 4.046-3.module+el8.1.0+2938+301254e2 rhel-8-appstream-rhui-rpms 156 k

perl-DBI x86_64 1.641-4.module+el8.6.0+13388+70c0920f rhel-8-appstream-rhui-rpms 741 k

Installing weak dependencies:

mariadb-gssapi-server x86_64 3:10.3.35-1.module+el8.6.0+15949+4ba4ec26 rhel-8-appstream-rhui-rpms 52 k

mariadb-server-utils x86_64 3:10.3.35-1.module+el8.6.0+15949+4ba4ec26 rhel-8-appstream-rhui-rpms 1.1 M

Enabling module streams:

mariadb 10.3

perl-DBD-MySQL 4.046

perl-DBI 1.641

Transaction Summary

=================================================================================================================================================

Install 11 Packages

Total download size: 31 M

Installed size: 155 M

Is this ok [y/N]: y

Downloading Packages:

(1/11): perl-DBD-MySQL-4.046-3.module+el8.1.0+2938+301254e2.x86_64.rpm 2.6 MB/s | 156 kB 00:00

(2/11): mariadb-connector-c-config-3.1.11-2.el8_3.noarch.rpm 238 kB/s | 15 kB 00:00

(3/11): mariadb-connector-c-3.1.11-2.el8_3.x86_64.rpm 2.9 MB/s | 200 kB 00:00

(4/11): perl-DBI-1.641-4.module+el8.6.0+13388+70c0920f.x86_64.rpm 31 MB/s | 741 kB 00:00

(5/11): mariadb-errmsg-10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64.rpm 11 MB/s | 235 kB 00:00

(6/11): mariadb-server-utils-10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64.rpm 26 MB/s | 1.1 MB 00:00

(7/11): mariadb-gssapi-server-10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64.rpm 2.5 MB/s | 52 kB 00:00

(8/11): mariadb-10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64.rpm 54 MB/s | 6.0 MB 00:00

(9/11): mariadb-common-10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64.rpm 4.9 MB/s | 64 kB 00:00

(10/11): mariadb-backup-10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64.rpm 23 MB/s | 6.1 MB 00:00

(11/11): mariadb-server-10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64.rpm 39 MB/s | 16 MB 00:00

-------------------------------------------------------------------------------------------------------------------------------------------------

Total 59 MB/s | 31 MB 00:00

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

Preparing : 1/1

Installing : mariadb-connector-c-config-3.1.11-2.el8_3.noarch 1/11

Installing : mariadb-common-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 2/11

Installing : perl-DBI-1.641-4.module+el8.6.0+13388+70c0920f.x86_64 3/11

Installing : mariadb-errmsg-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 4/11

Installing : mariadb-gssapi-server-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 5/11

Installing : mariadb-connector-c-3.1.11-2.el8_3.x86_64 6/11

Installing : perl-DBD-MySQL-4.046-3.module+el8.1.0+2938+301254e2.x86_64 7/11

Installing : mariadb-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 8/11

Installing : mariadb-backup-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 9/11

Running scriptlet: mariadb-server-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 10/11

Installing : mariadb-server-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 10/11

Running scriptlet: mariadb-server-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 10/11

Installing : mariadb-server-utils-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 11/11

Running scriptlet: mariadb-server-utils-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 11/11

Verifying : perl-DBD-MySQL-4.046-3.module+el8.1.0+2938+301254e2.x86_64 1/11

Verifying : mariadb-connector-c-config-3.1.11-2.el8_3.noarch 2/11

Verifying : mariadb-connector-c-3.1.11-2.el8_3.x86_64 3/11

Verifying : perl-DBI-1.641-4.module+el8.6.0+13388+70c0920f.x86_64 4/11

Verifying : mariadb-server-utils-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 5/11

Verifying : mariadb-errmsg-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 6/11

Verifying : mariadb-server-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 7/11

Verifying : mariadb-gssapi-server-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 8/11

Verifying : mariadb-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 9/11

Verifying : mariadb-backup-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 10/11

Verifying : mariadb-common-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 11/11

Installed products updated.

Installed:

mariadb-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 mariadb-backup-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64

mariadb-common-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 mariadb-connector-c-3.1.11-2.el8_3.x86_64

mariadb-connector-c-config-3.1.11-2.el8_3.noarch mariadb-errmsg-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64

mariadb-gssapi-server-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 mariadb-server-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64

mariadb-server-utils-3:10.3.35-1.module+el8.6.0+15949+4ba4ec26.x86_64 perl-DBD-MySQL-4.046-3.module+el8.1.0+2938+301254e2.x86_64

perl-DBI-1.641-4.module+el8.6.0+13388+70c0920f.x86_64

Complete!

[root@10.1.1.1]#

Login to MariaDB database using root user

[root@10.1.1.1]#

[root@10.1.1.1]# mysql -u root

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 10

Server version: 10.3.35-MariaDB MariaDB Server

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

+--------------------+

3 rows in set (0.000 sec)

MariaDB [(none)]>

Note : password is not set for root user (MariaDB)

ANURAG PANDEY