database-administration

DORSETRIGS

ORA-12528: TNS Listener: all appropriate instances are blocking new connections. Instance "CLRExtProc", status UNKNOWN

ORA 12528 TNS Listener All Appropriate Instances are Blocking New Connections Decoding the Error Problem You re trying to connect to your Oracle database but yo

ORA-12528: TNS Listener: all appropriate instances are blocking new connections. Instance "CLRExtProc", status UNKNOWN

Installing multiple oracle homes on the same machine

Installing Multiple Oracle Homes on the Same Machine A Guide Installing multiple Oracle Homes on the same machine is a common practice particularly in developme

Installing multiple oracle homes on the same machine

systemctl status postgresql.service showing output as differently

Understanding and Troubleshooting systemctl status postgresql service Output Variations Problem You re trying to check the status of your Postgre SQL service us

systemctl status postgresql.service showing output as differently

Oracle audit grant dba role

Auditing DBA Role Grants and Triggering Email Notifications in Oracle 11g R1 This article addresses a common challenge faced by Oracle administrators monitoring

Oracle audit grant dba role

pg_hba.conf rejects connection for host "myip"

Troubleshooting pg hba conf rejects connection for host myip Errors A Comprehensive Guide Encountering an error message stating pg hba conf rejects connection f

pg_hba.conf rejects connection for host "myip"

SHOW FULL FIELDS FROM fails on MySQL when used for views referencing other views

SHOW FULL FIELDS FROM Fails on My SQL Views A Deep Dive Have you ever encountered the frustrating View second view references invalid table s or column s or fun

SHOW FULL FIELDS FROM fails on MySQL when used for views referencing other views

Trouble with only read user in Postgresql

Securely Creating Read Only Users in Postgre SQL A Comprehensive Guide This article delves into the intricacies of creating secure read only users in Postgre SQ

Trouble with only read user in Postgresql

At MariaDB database suddenly huge number of bin log file generated

Unraveling the Mystery of Excessive Bin Log Files in Maria DB Have you ever encountered a sudden surge in binary log files in your Maria DB database This can be

At MariaDB database suddenly huge number of bin log file generated

Postgres query duration peaks

Postgres Query Duration Peaks Diagnosing and Solving Performance Issues Many developers have encountered the frustrating scenario of a seemingly stable Postgre

Postgres query duration peaks

How can i get CPU Usage by Snapshot with DBA_HIST

How to get CPU Usage by Snapshot with DBA HIST This article will guide you on how to retrieve the CPU usage percentage of your database at specific snapshot tim

How can i get CPU Usage by Snapshot with DBA_HIST