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.
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
Oracle Database 12.2.0.1 on-premises for Exadata is now available for download from Oracle eDelivery/SoftwareCloud!! Connect to eDelivery and login: Search for: “Oracle Database” and mark “Oracle Database Enterprise Edition …”… Read more »