Typically, when rolling forward a physical standby database using primary incremental backup, multiple steps are required: Identify the Start SCN on Standby for performing incremental backup on primary Perform incremental backup on primary with FROM SCN clause Move the backup-pieces from primary to standby Catalog the backup-piece on Standby Perform recovery on standby using recover […]
Archives for December 2018
Automatic Stop of Oracle Database (dbshut) not working in CentOS/RHEL 7 with systemd
The Problem On CentOS/RHEL 7 with Oracle database 12.1.0.2 version, when attempting to stop DB during server shutdown the automatic shutdown script getting below error: # cat /u01/app/oracle/product/12.1.0.2/dbhome_1/shutdown.log Processing Database instance “XXXX1”: log file /u01/app/oracle/product/12.1.0.2/dbhome_1/shutdown.log Info: Database instance “XXXX” already down (PMON process not there). Which indicate that PMON is forcefully being closed before the […]
Filesystems Are Not Getting Mounted in Order on CentOS/RHEL 7
The Problem On CentOS/RHEL 7, Any filesystem volumes are not getting mounted in order as per the /etc/fstab entries. The Solution Unlike CentOS/RHEL 6 and earlier versions, on CentOS/RHEL 7 the boot process is faster. Because of the parallel nature of process startup, specific target units startup orders are not deterministic. All the Filesystems are […]
How to control resource (cgroup) with systemd for user process group in CentOS/RHEL 7
The Basics RHEL7 moves the resource management settings from the process level to the application level by binding the system of cgroup hierarchies with the systemd unit tree. The old way of configuring cgroup, by means of editing several /etc/cg*.conf files is still available but no longer recommended. Systemd provides three unit types(slice, scope, service) […]
Solaris : Non-root user can’t run prtdiag command
The Problem Non-root user can’t run prtdiag command, but it works for root user # /usr/sbin/prtdiag picl_initialize failed: Daemon not responding The Solution The issue is caused by wrong permission of file /var/run/picld_door or directory /var/run. Set the permission of file /var/run/picld_door or directory /var/run as follow: # ls -l /var/run/picld_door dr–r–r– 1 root root […]
How to run rsyslog as a non-root user in CentOS/RHEL 7
You can utilize the $PrivDropToUser, $PrivDropToUserID, $PrivDropToGroup, and $PrivDropToGroupID configuration directives to run rsyslog as a non-root user. When these variables are used, rsyslog will start as root, but will drop to the specified user and/or group after initialization. The daemon will then run in accordance with the permissions of the specified user or group. […]
Oracle RAC instabilities due to firewall (netfilter/iptables) enabled on the cluster interconnect
Oracle Clusterware may not startup (root.sh on second node fails with “Failure at final check of Oracle CRS stack.”), due to a firewall (such as iptables on Linux) configured on the cluster interconnect. Other symptoms include moderate to serious performance and stability issues, directly related to such firewalls. Examples are false evictions of nodes, ‘IPC […]
What is the MySQL Enterprise Monitor?
The post provides an overview of what features the MySQL Enterprise Monitor provides and how it can be used to improve MySQL administration and performance. Provided as part of MySQL Enterprise, the MySQL Enterprise Monitor is a Virtual DBA assistant that helps MySQL DBAs manage more MySQL servers, tune MySQL servers, and find and fix […]
Howto Verify If a Bootblk is Installed on the Boot Disk (SPARC)
This can be useful in troubleshooting if the system fails to boot with a suspected bootblk issues, or if you suspect something in the OS keeps overwriting the bootblk. For Solaris 10 Below is the output from a Solaris 10u4 with UFS, Solaris 10u6 with UFS, and a Solaris 10u6 with ZFS bootblock. The bootblk […]
Starting iptables Fails with Error “Another app is currently holding the xtables lock”
The Problem Updating the package iptables to iptables-1.4.7-16.0.3.el6, the service fails to start after a stop. # service iptables stop iptables: Setting chains to policy ACCEPT: filter [ OK ] iptables: Flushing firewall rules: [ OK ] iptables: Unloading modules: [ OK ] # service iptables start iptables: Applying firewall rules: Another app is currently […]