Blog for Database and System Administrators

This blog is a collection of articles on analyzing and troubleshooting for all system and database administrators. These guides come from my experience, I hope they can help everyone.

MENU
  • Oracle
  • MariaDB
  • Linux
  • MongoDB
  • Mysql
  • Oracle Linux Virtualization Manager
  • ClickHouse
Skip to content
  • Oracle
  • MariaDB
  • Linux
  • MongoDB
  • Mysql
  • Oracle Linux Virtualization Manager
  • ClickHouse
Oracle Database 20c

Kill, cancel and resume or restart datapump expdp and impdp jobs

The expdp and impdp utilities are command-line driven, but when starting them from the OS-prompt, one does not notice it. When you want to kill, cancel, start or resume a… Read more »

Oracle    datapump, expdp, impdp, oracle, oracle 12c
Oracle Database 20c

Shrink the Space Usage of the SQL Management Base in the SYSAUX Tablespace

You are on an 11g/12c Oracle Database and wish to reduce the usage of space in the SYSAUX tablespace dedicated to the SQL Management Base (SMB), which is where SQL… Read more »

Oracle    oracle, Shrink, SPM, SQL Management Base
Oracle Database 20c

How To Configure OCR Backups

BACKGROUND The Oracle Cluster Registry (OCR) contains important cluster and database configuration information for RAC and Oracle Clusterware. One of the Oracle Clusterware instances in the cluster, the CRSD master,… Read more »

Oracle    Cluster, GRID, OCR, oracle 12c, RAC
Oracle Database 20c

Exadata Storage list of commands

It is not an easy to remember the commands since most of the UNIX administrators are working on multiple Operating systems and different OS flavors. Exadata adding additional responsibility to… Read more »

Oracle    commands, exadata, oracle, oracle 12c, storage
Oracle Database 20c

How to optimize size the Oracle undo tablespace

Overview Starting in Oracle9i, rollback segments are re-named undo logs. Traditionally transaction undo information was stored in Rollback Segments until a commit or rollback statement was issued, at which point… Read more »

Oracle    optimize, oracle, size, tablespace, undo
MariaDB logo

MariaDB MaxScale 2.1.0 Beta

MariaDB MaxScale 2.1 introduces the following key new capabilities: Dynamic Configuration Server, Monitor and Listeners: MaxScale 2.1 supports dynamic configuration of servers, monitors and listeners. Servers, monitors and listeners can be… Read more »

MariaDB    Load Balancer, MariaDB, MaxScale
MariaDB logo

How to Configure Mariadb Maxscale Master-Slave with Galera Cluster

In this article we will install MariaDB galera cluster with MaxScale proxy database by MariaDB corporation. MaxScale is inteligent proxy database that can route database statements from cluster to one… Read more »

MariaDB    Galera Cluster, Load Balancer, MariaDB, MaxScale, Tuning
Linux Logo

Open Source Cross Platform RAT: Pupy

Pupy is an opensource, cross-platform (Windows, Linux, OSX, Android), multi function RAT (Remote Administration Tool) and post-exploitation tool mainly written in python. It features a all-in-memory execution guideline and leaves… Read more »

Cross Platform    Android, Cross Platform, Linux, RAT, Windows
Linux Logo

iptables blacklist script

A Bash shell script which uses ipset and iptables to ban a large number of IP addresses published in IP blacklists. ipset uses a hashtable to store/fetch IP addresses and… Read more »

Linux    bash, Bash script, Blacklist, Centos, Debian, firewall, geoip, iptables, Linux, Oracle Linux, Redhat, Ubuntu
Linux Logo

X2Goserver an alternative for VNC

Finally a good alternative of VNC. I will install and configure X2Goserver on CentOS 7.3 X2Go enables us to access a graphical desktop of a computer over a low bandwidth… Read more »

Linux    Linux, VNC, X2GO

Posts pagination

« Previous 1 … 7 8 9 10 Next »

Recent Posts

  • Flatpak Search not working on Oracle Linux/Red Hat 9.4 June 3, 2024
  • Configuring and Using Oracle Global Data Services: Optimizing Distributed Workloads October 3, 2023
  • OCFS2 File system and Snapshot with REFLINK February 25, 2023
  • Oracle UEK7 Oracleasm kernel module has been removed May 30, 2022
  • How do fsck at corrupted vm guest in Oracle OVM or Xen Server from vm images. May 2, 2022
  • Oracle Dataguard queries check April 12, 2022
  • Unable to open ‘/boot/vmlinuz-*-dpkg-new’: Operation not permitted March 10, 2022
  • Pre-built Oracle Database 12.2/19c/21c Virtualbox Image January 23, 2022
  • Upgrading Oracle Linux 7 to 8 using Leapp January 21, 2022
  • Oracle Database tracing LDAP from CMU to AD November 15, 2021
Copyright 2020
dbsysupgrade.com
Ribosome by GalussoThemes.com
Powered by WordPress
Social Media Auto Publish Powered By : XYZScripts.com