Oracle recommends that you do not use these top-level accounts for regular administration tasks; instead, you should give the DV_OWNER and DV_ACCTMGR role to individual administrators who secure them with their own password. If the top-level passwords were forgotten, you could no longer enable or disable Database Vault. This course uses LEO_DVOWNER and BEA_ACCTMGR as sample users. These two roles are very different. The DV_OWNER role is able to change the Database Vault configuration, thus … [Read more...] about What are different Oracle Database Vault Roles
Unable to export realm protected table using data pump
A database user cannot export with expdp if an object is protected by a realm due. This post is intended to explain the fix for this bug and the steps to implement before doing an export or an import using data pump (expdp / impdp) if Database Vault is enabled. A user can use data pump to export in one of the following cases (in all the four cases the user should have standard Data Pump privileges) : 1. When user want to export or import objects from a schema that is not protected by a … [Read more...] about Unable to export realm protected table using data pump
Beginners Guide to Oracle Database Vault
Oracle Database Vault Concepts and Overview Oracle Database Vault enables organizations to transparently increase security without making changes to their application code. Oracle Database Vault provides real-time preventive controls by restricting access to application data from highly privileged users. Oracle Database Vault helps organizations address regulatory compliance, industrial espionage, and insider threats while at the same time enabling the flexibility to deploy IT systems in a … [Read more...] about Beginners Guide to Oracle Database Vault
How to Disable IPv6 on Ubuntu 18.04 Bionic Beaver Linux
Ubuntu 18.04 Bionic Beaver Linux enables Internet Protocol Version 6 (IPv6) by default. However, in certain situations, some users may find it desirable to disable IPv6 support or to re-enable it after it has been disabled. Disabling IPv6 support (Permanently) Disable ipv6 built-in kernel module. 1. Edit /etc/default/grub and append ipv6.disable=1 to GRUB_CMDLINE_LINUX and GRUB_CMDLINE_LINUX_DEFAULT like the following … [Read more...] about How to Disable IPv6 on Ubuntu 18.04 Bionic Beaver Linux
How to Capture More Logs in /var/log/dmesg for CentOS/RHEL
Sometimes not all log messages in /var/log/dmesg can be captured after Linux OS/kernel boots up because of too many block devices attached to the server. This post illustrates another way to record all bootup log messages besides configuring the serial console. Basically kernel parameter "log_buf_len" can be configured to increase kernel log buffer size, Name: log_buf_len, Set the size of the kernel log buffer. Synopsis: log_buf_len= n [ KMG ] Description: Set the size of the … [Read more...] about How to Capture More Logs in /var/log/dmesg for CentOS/RHEL
Unable to Start RDMA Services on CentOS/RHEL 7
The Problem The RDMA service fails to start on CentOS/RHEL 7 machine. 'journalctl -r' command shows the below errors: Oct 11 11:01:15 geeklab systemd-modules-load: Failed to insert 'rds_rdma': Address family not supported by protocol Oct 11 11:01:15 geeklab systemd-modules-load: Failed to insert 'rds_rdma': Address family not supported by protocol Oct 11 11:01:15 geeklab systemd-modules-load: Failed to insert 'resilient_rdmaip': Address family not supported by protocol Oct 11 11:01:15 … [Read more...] about Unable to Start RDMA Services on CentOS/RHEL 7
How to rename a KVM VM with virsh
The syntax is to rename a KVM VM with virsh is as follows: # virsh domrename {domain} {new-name} Let's see an example of renaming a VM using virsh. 1. To rename VM from serverA to serverB, first shutdown the VM: # virsh shutdown serverA 2. Now to rename a VM, run: # virsh domrename serverA serverB Domain successfully renamed 3. To start the VM/domain: # virsh start serverB Rename KVM domain with virsh and XML 1. First get domain information in XML and save it to a new … [Read more...] about How to rename a KVM VM with virsh
How To Create “A CRS Managed” ACFS FileSystem On Oracle RAC Cluster (ASM/ACFS 11.2)
1. Create the mount points on all the nodes (as root user): # mkdir /goldengate 2. Connect to the ASM instance & create the ACFS diskgroup (from the +ASM1 instance): SQL> CREATE DISKGROUP ACFSTEST EXTERNAL REDUNDANCY DISK 'ORCL:ASMDISK18' SIZE 4157 M DISK 'ORCL:ASMDISK19' SIZE 4157 M ATTRIBUTE 'compatible.asm' = '11.2', 'compatible.advm' = '11.2'; Diskgroup created. 3. Create the ACFS volume (from the +ASM1 instance): SQL> ALTER DISKGROUP ACFSTEST ADD VOLUME ACFSTESTVOL SIZE … [Read more...] about How To Create “A CRS Managed” ACFS FileSystem On Oracle RAC Cluster (ASM/ACFS 11.2)
How to Check Storage Type in Engine Database (OLVM)
This is a small how-to post to check the storage type in Engine Database. Table storage_server_connections has all connections information. Run below command on OLVM to get the connection information: $ /usr/share/ovirt-engine/dbscripts/engine-psql.sh -c "select connection,iqn,port,storage_type from storage_server_connections;" connection | iqn | port | storage_type ------------------------------+-----+------+-------------- The field storage_type will give: value 1 for NFS value 3 … [Read more...] about How to Check Storage Type in Engine Database (OLVM)
How to set “max_report_luns” and “max_luns” on CentOS/RHEL 7 to scan more than 16,383 LUNs
From CentOS/RHEL 7, the default value of parameter max_report_luns has been increased from 512 to 16383. Consequently, CentOS/RHEL 7.x can now discover more than 511 LUNs when the system scans the SCSI interconnect using the Report LUNs mechanism. Increasing this value beyond 16383 is generally not required. But if you want to increase it, then change the values for either max_report_luns or max_luns in the kernel options line in /etc/default/grub. Note: The specific kernel option line within … [Read more...] about How to set “max_report_luns” and “max_luns” on CentOS/RHEL 7 to scan more than 16,383 LUNs