BCV (Business Continuance Volume ) is the target volume for EMC Symmetrix TimeFinder/Mirror process. When a BCV is fully synchronized with a data device, the BCV is separated or split, thus becomes available to a host for backup or other host processes. In short, a BCV split is a device to be a clone of another device. Before you use BCV split as oracle backup, you need to narrow down what is contained on the backed up volumes. You can use BCV split to backup only asm disks together with rdbms … [Read more...] about How to split BCV and open oracle ASM database
Archives for November 2019
How to change the interface name in CentOS/RHEL 8 using prefixdevname
This post will help to change the network interface name using prefixdevname utility in CentOS/RHEL 8 systems. Installation and configuration 1. Install the required package using dnf utility: # dnf install prefixdevname 2. Append the net.ifnames.prefix=[ABCD] using grubby command: (ABCD to replaced with own prefix, eg: net). # grubby --update-kernel=$(grubby --default-kernel) --args="net.ifnames.prefix=net" 3. Reboot the system to take effect: # reboot 4. After system rebooted, … [Read more...] about How to change the interface name in CentOS/RHEL 8 using prefixdevname
Beginners Guide to Implementing Table Maintenance in MySQL
Table maintenance operations are useful for identifying and correcting database problems such as the following: – Tables that become damaged as a result of a server crash. – Slow query processing on tables. Many tools are available for performing table maintenance: MySQL Workbench MySQL Enterprise Monitor SQL (DML) maintenance statements Utilities: mysqlcheck and myisamchk Server auto-recovery SQL for Table Maintenance Operations There are multiple SQL statements for performing … [Read more...] about Beginners Guide to Implementing Table Maintenance in MySQL
MySQL – How to Set Maximum Rates for Connections and Queries
There are several options to implement firewall like features for a MySQL instance. Some of these are described below. When an account is mentioned it refers to the combination of a username connected from a given host, i.e. username@hostname. MySQL Enterprise Firewall MySQL Enterprise Firewall will allow you to create a whitelist per account specifying the normalized queries that the account are allowed to execute. It is available in the Enterprise Edition of MySQL Server in versions … [Read more...] about MySQL – How to Set Maximum Rates for Connections and Queries
How to configure EPEL repository in OEL 7
Question: How to install/get packages from EPEL Repository on OEL 7? 1. Create a repo file like /etc/yum/repos.d/epel-yum-ol7.repo. For example: # cat /etc/yum.repos.d/epel-yum-ol7.repo [ol7_epel] name=Oracle Linux $releasever EPEL ($basearch) baseurl=http://yum.oracle.com/repo/OracleLinux/OL7/developer_EPEL/$basearch/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle gpgcheck=1 enabled=1 2. And then run "yum repolist" command to see if repository is in there. # yum … [Read more...] about How to configure EPEL repository in OEL 7
MySQL: How to Set Account Resource Limits
Limit the use of server resources by setting the global MAX_USER_CONNECTIONS variable to a non-zero value. This limits the number of simultaneous connections by any one account but does not limit what a client can do when connected. To set resource limits for an account, use the GRANT statement with a WITH clause that names each resource to be limited. The default value for each limit is zero, indicating no limit. For example, to set limits for user Francis to access the customer database, issue … [Read more...] about MySQL: How to Set Account Resource Limits