Database triggers are PL/SQL code that executes based on event in the database. A trigger is an Oracle statement (or a group of statements enclosed within BEGIN and END statements) that are automatically executed by Oracle in response to any of these statements: ALTER CREATE DROP DELETE INSERT UPDATE The last three are of the greatest interest—triggers that are executed in response to table row changes. How to enable a trigger To enable a database trigger do the following: SQL> … [Read more...] about How to Enable a Database Trigger
When to use rescan-scsi-bus.sh -i (LIP flag) in CentOS/RHEL
The "rescan-scsi-bus.sh" can be used to scan new LUNs in a CentOS/RHEL machine. When 'rescan-scsi-bus.sh -i' is run, script execute as well a LIP_RESET (ISSUE_LIP) which may cause a disruption in I/O on the server and even cause an outage in case of a system running on heavy load. What is LIP (Loop Initialization Protocol)? LIP scans the interconnect and causes the SCSI layer to be updated to reflect the devices currently on the bus. A LIP is, essentially, a bus reset, and will cause device … [Read more...] about When to use rescan-scsi-bus.sh -i (LIP flag) in CentOS/RHEL
How to Disable rpc.quotad Service in CentOS/RHEL 6 and 7
This post explains how to disable rpc.quotad service on CentOS/RHEL 6 or 7 machines. The protocol used by rpc.rquotad is an unsecured and obsolete protocol and should be disabled. Note: This procedure can disrupt NFS clients relying on disk quotas. To avoid issues, schedule a maintenance outage and stop these NFS clients. For CentOS/RHEL 6 or earlier 1. Edit the configuration file /etc/sysconfig/nfs to have an entry which reads RQUOTAD="no". For example: # grep RQUOTAD … [Read more...] about How to Disable rpc.quotad Service in CentOS/RHEL 6 and 7
User Unable To Edit crontab, Error: “/tmp/crontab.Lm34gsJV: Permission denied”
The Problem A non-privileged user cannot edit their crontab file using the command "crontab -e" $ crontab -e no crontab for oracle - using an empty one /tmp/crontab.Lm34gsJV: Permission denied $ The Solution This can happen mainly due to wrong permission on /tmp directory. When a user tries to edit the crontab using 'crontab -e' command, a temporary crontab file is created in /tmp directory, which is overwritten on the actual crontab file when the user saves the changes. Incorrect … [Read more...] about User Unable To Edit crontab, Error: “/tmp/crontab.Lm34gsJV: Permission denied”
showmount Command Examples in Linux
showmount command shows information about an NFS server. This information is maintained by the mountd server on the host. The default value for the host is the value returned by the hostname. With no options, show the clients that have mounted directories from the host. showmount is usually found in /usr/sbin, which is not in the default search path. showmount Command Options The options available with the showmount command are as follows: OptionDescription -a, --allPrint all remote … [Read more...] about showmount Command Examples in Linux
How to Enable Debug Mode for Chronyd Service in CentOS/RHEL 8
What is Chronyd Service In CentOS/RHEL 7 and 8, the operating system's time is set on every boot based on the hardware clock, which is a small-battery driven clock located on the motherboard of your computer. Often, this clock is too inaccurate or has not been set right, therefore it's better to get your system time from a reliable source over the Internet (that uses real atomic time). The chrony daemon, chronyd, sets and maintains system time through a process of synchronization with a remote … [Read more...] about How to Enable Debug Mode for Chronyd Service in CentOS/RHEL 8