• 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 December 2019

Oracle SQL Script to Detect Tablespace Fragmentation

by admin

The following is a script that will determine how many extents of contiguous free space you have in Oracle as well as the total amount of free space you have in each tablespace. From these results, you can detect how fragmented your tablespace is. The ideal situation is to have one large free extent in […]

Filed Under: oracle

MySQL Table Maintenance – InnoDB, MyISAM, MEMORY, ARCHIVE

by admin

InnoDB Table Maintenance If a table check indicates problems, restore the table to a consistent state by dumping it with mysqldump, dropping it, and re-creating it from the dump file. In the event of a crash of the MySQL server or the host on which it runs, some InnoDB tables might be in an inconsistent […]

Filed Under: mysql, MySQL Cluster

Understanding mysqlcheck and myisamchk utilities

by admin

mysqlcheck Client Program In some cases, mysqlcheck is more convenient than issuing SQL statements directly. For example, if you provide it with a database name as its argument, mysqlcheck determines what tables the database contains and issues statements to process them all. You do not need to provide explicit table names as arguments. Also, because […]

Filed Under: mysql, MySQL Cluster

CentOS/RHEL – How to Remove stale ISCSI Target Node Information from ISCSI Initiator Server

by admin

The Problem Stale ISCSI target connections which are still present on Initiator node can lead to various issues like: 1. hung iscsid service which can lead to global outage. 2. flood of messages error like: messages:Jun 3 13:58:00 server1 iscsid: iscsid: Connection5:0 to [target: iqn-name, portal: ip-here,3260] through [iface: default] is shutdown. messages:Jun 3 13:58:00 […]

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

CentOS/RHEL 6 Kernel Panic – “Out of memory” kernel parameter panic_on_oom is enabled

by admin

The Problem CentOS/RHEL 6 system reboot due too out of memory error: DUMPFILE: vmcore [PARTIAL DUMP] CPUS: 2 DATE: Mon Feb 29 05:28:02 2016 UPTIME: 33 days, 09:45:55 LOAD AVERAGE: 1.88, 1.52, 1.41 TASKS: 218 NODENAME: localhost RELEASE: 2.6.32-431.el6.x86_64 VERSION: #1 SMP Sun Nov 10 22:19:54 EST 2013 MACHINE: x86_64 (3000 Mhz) MEMORY: 8 GB […]

Filed Under: CentOS/RHEL 6, Linux

How to enable core dump for Applications on CentOS/RHEL

by admin

1. In CentOS/RHEL core file creation is disabled by default. To enable it, executing the below command: # ulimit -S -c unlimited > /dev/null 2>&1 then execute the program in the same shell environment. 2. To enable it permanently, please follow steps below: – Edit /etc/security/limits.conf. # vi /etc/security/limits.conf * soft core unlimited The ‘*‘ […]

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

How to add additional language support in CentOS/RHEL

by admin

Question: How to add additional language support in CentOS/RHEL? To add specific language support in CentOS/RHEL, you need firstly confirm the correct language group name by “yum grouplist” command. # yum grouplist The available language groups will be displayed in yum output as below: # yum grouplist Loaded plugins: refresh-packagekit, rhnplugin Setting up Group Process […]

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

What are “segfault” messages in /var/log/messages file

by admin

This post explains how to analyse the segfault message in message file and to identify the problem in application or operating system side. What is “segfault”? A segmentation fault (often shortened to segfault) or access violation is a fault raised by hardware with memory protection, to notify operating system (OS) about a memory access violation. […]

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

Unable to login with GUI on CentOS/RHEL 7

by admin

The Problem can’t login to the system via GUI On CentOS/RHEL 7. Also, gdm segfault with below error after which unable to login to GUI. kernel: gdm-simple-slav[4172]: segfault at 0 ip 00007f93d911c7df sp 00007fffecadaac0 error 4 in gdm-simple-slave[7f93d910a000+4a000] kernel: gdm-simple-slav[2645]: segfault at 0 ip 00007f9781f7d7df sp 00007fff672c6980 error 4 in gdm-simple-slave[7f9781f6b000+4a000] The Solution For new […]

Filed Under: CentOS/RHEL 7, Linux

rpm: error while loading shared libraries: invalid ELF header

by admin

The Problem rpm commands issue the following error: rpm: error while loading shared libraries: /usr/lib64/liblzma.so.0: invalid ELF header The Solution In this instance, either liblzma.so or the link to it (/usr/lib64/liblzma.so.0) had gotten overwritten. $ rpm -qa | grep binutils rpm: error while loading shared libraries: /usr/lib64/liblzma.so.0: invalid ELF header To resolve this issue, the […]

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

Next Page »

Primary Sidebar

Recent Posts

  • ncat Command Examples in Linux
  • ncat: command not found
  • nautilus Command Examples in Linux
  • namei: command not found

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright