Question: PV called “/dev/sdb” that was created over a single device path, need to set this PV to have effective multipath functionalities (Migration of PV from single path to multipath names) How to configure existing lvm volume group to use DM-Multipath? It is required to use the existing Volume Group and the existing Logical Volume […]
Archives for August 2019
How to convert NON-OMF to OMF files ( Oracle Managed File conversion – NON-ASM )
1. Who Can Use Oracle Managed Files? Oracle Managed Files are most useful for the following types of databases: A logical volume manager that supports striping/RAID and dynamically extensible logical volumes. A file system that provides large, extensible files Low end or test databases. Initialization Parameters That Enable Oracle Managed Files for Datafiles, Redo and […]
ORA-28007: the password cannot be reused
The Problem You attempt to alter a user’s password to a previously used one and get the following error when attempting to reuse the old password: SQL> alter user med identified by med * ERROR at line 1: ORA-28007: the password cannot be reused The password ‘med’ has been assigned to this user previously. The […]
Beginners Guide to Oracle Password Management Policy
Overview Password Management is setup by DBAs using Oracle Profiles. A general recommendation is to assign only those schemas a profile with password aging and expiration features if the users have the ability to independently change their password from their end-user application when the password expires, usually, this means the application they use must have […]
How to List Tables Per Tablespace In MySQL Cluster
Question: How to list tables inside tablespaces in a MuSQL cluster? The following query meets the aim of the question, lists the database, table name and the corresponding tablespace: SELECT DISTINCT t.table_schema, t.table_name, p.tablespace_name FROM partitions p JOIN TABLES t ON (t.table_schema=p.table_schema and t.table_name = p.table_name) WHERE t.engine=’ndbcluster’ and tablespace_name IS NOT NULL
Understanding Device Persistence and Oracle ASMLib
Basics This post describes some advantages the Linux specific ASM library provided by Oracle (herein “ASMLib”) brings to the administration of a Linux system running Oracle. Linux often presents the challenge of disk name persistence. Change the storage configuration and a disk that appeared as /dev/sdg yesterday can appear as /dev/sdh after a reboot today. […]
ASMLib-Managed Disks on Multipathed iSCSI Targets are not Discovered after Server Reboot in CentOS/RHEL 7
The Problem Oracle Real Application Clusters (RAC) servers run on CentOS/RHEL 7 and utilizing ASMLib-managed iSCSI multipathed disks. Upon server reboot, Oracle ASMLib disks are not automatically discovered at boot time causing Oracle Cluster Ready Services (CRS) to fail to start. ASM disks are, however, correctly discovered when manually running the oracleasm scandisks command soon […]
How to load SELinux Module For Oracleasm
Question: How to load the SELinux module for oracleasm? When searching for the selinux oracleasm module with the locate command it may return as if the file exists: # locate /oracleasm.pp /etc/selinux/targeted/modules/active/modules/oracleasm.pp However, when running the command semodule to load the oracleasm.pp module it fails: # semodule –verbose -i /etc/selinux/targeted/modules/active/modules/oracleasm.pp Attempting to install module ‘/etc/selinux/targeted/modules/active/modules/oracleasm.pp’: […]
“Metadata File Does Not Match Checksum” Issue When Yum Installs or Updates Package
The Problem Scenario 1: The user is unable to perform “yum install oracle-rdbms-server-11gR2-preinstall”. The yum tries to download the latest metadata (“http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/repodata/primary.xml.gz” ) and rejects it with the error message “[Errno -1] Metadata file does not match checksum”. Upon this, yum tries the next mirror where it encounters the same error and goes to the […]
How to install/get packages from Oracle EPEL Repository on OEL 7
Question: How to install/get packages from Oracle EPEL Repository on OL7? 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 repolist Loaded plugins: langpacks repo id […]