• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Archives for August 2019

How to Configure Existing Lvm Volume Group to Use DM-Multipath

by admin

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 […]

Filed Under: CentOS/RHEL 6, CentOS/RHEL 7, Linux

How to convert NON-OMF to OMF files ( Oracle Managed File conversion – NON-ASM )

by admin

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 […]

Filed Under: oracle

ORA-28007: the password cannot be reused

by admin

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 […]

Filed Under: oracle

Beginners Guide to Oracle Password Management Policy

by admin

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 […]

Filed Under: oracle

How to List Tables Per Tablespace In MySQL Cluster

by admin

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

Filed Under: mysql, MySQL Cluster

Understanding Device Persistence and Oracle ASMLib

by admin

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. […]

Filed Under: ASM, Linux, oracle

ASMLib-Managed Disks on Multipathed iSCSI Targets are not Discovered after Server Reboot in CentOS/RHEL 7

by admin

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 […]

Filed Under: ASM, CentOS/RHEL 7, Linux, oracle

How to load SELinux Module For Oracleasm

by admin

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’: […]

Filed Under: ASM, Linux, oracle

“Metadata File Does Not Match Checksum” Issue When Yum Installs or Updates Package

by admin

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 […]

Filed Under: Linux, OEL 6

How to install/get packages from Oracle EPEL Repository on OEL 7

by admin

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 […]

Filed Under: Linux, OEL 7

« Previous Page

Primary Sidebar

Recent Posts

  • protonvpn-cli Command Examples in Linux
  • protonvpn-cli connect Command Examples
  • procs Command Examples in Linux
  • prlimit: command not found

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright