The Geek Diary

Archives for May 2019

How To Change A Dictionary Managed Tablespace To A Locally Managed Tablespace

by

Question: How to migrate Dictionary Managed Tablespace (DMT) to a Locally Managed Tablespace (LMT) using DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL procedure? Warning: It is highly recommended to test the steps in similar test environment to have an estimate of the time required for migration before implementing in Production. You can use the DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL procedure to migrate a tablespace from […]

How to install/remove/query/update RPM packages in Linux (Cheat Sheet)

by

Maintaining Software Using RPM (Red Hat Package Manager) RPM is a powerful software manager which can be used to build, install, query, verify, update, and uninstall individual software packages. An RPM package consists of an archive of files, and package information such as name, version, a description and information about dependencies on other RPM packages. […]

How To Disable Ksplice Service on OEL

by

This post will assist you to disable ksplice service or when ULN registration time enabled this service unknowingly. 1. Login to URL with ULN credentials https://status-ksplice.oracle.com/status/ -> Allow/Deny Policies -> Select your hostname > then choose all or deny. Once denied, cannot do operations with uptrack or ksplice. For example: [root@client ~]# uptrack-upgrade -n This […]

Volume “test_vg/lvol0” is not active locally – Error while running lvcreate

by

The Problem While trying to create a logical volume, lvcreate fails with error “Volume “test_vg/lvol0″ Is Not Active Locally” even though the volume group is active, with an error output such as the following: # lvcreate -L 4G test_vg Volume “test_vg/lvol0” is not active locally. Aborting. Failed to wipe start of new LV. The Root […]

Command ntpstat Shows unsynchronised (CentOS/RHEL)

by

The ntpstat command output shows “unsynchronised”: # ntpstat unsynchronised time server re-starting The “ntpq -p ” command output shows none of ntp servers is chosen: # ntpq -p ========================================== remote refid st t when poll reach delay offset jitter =============================================== ntp-server .INIT. 16 u – 16 0 0.000 0.000 0.000 ntp-server .INIT. 16 u – […]

How To Check Swap Usage of Each Processes in Linux

by

This post shows how to check swap usage of each process, answering “How can I know what process would consume the largest swap space?” For all kernels Swap usage is shown as “Swap” columns in /proc/[PID]/smaps. This indicates swapped memory size of the each memory ranges, thus the sum of all of these values shows […]