Ed Chen Logic

How to Resolve ORA-01401: inserted value too large for column

by Ed Chen
September 4, 2014March 23, 2021

We saw a materialized view snapshot error in alert log. ... ORA-12012: error on auto execute of job 854 ORA-12008: error in materialized view refresh… Read More »

How to Resolve ORA-04031: unable to allocate 4216 bytes of shared memory

by Ed Chen
September 3, 2014July 11, 2023
2 Comments

Causes of ORA-04031 Found ORA-04031 in the alert log. ORA-04031: unable to allocate 4216 bytes of shared memory ("shared pool","unknown object","sga heap","library cache") Several kinds… Read More »

How to Resolve MSVCR110.dll is missing from your computer

by Ed Chen
September 2, 2014October 20, 2022

A runtime error thrown by Windows is as below when I was starting an application program: The Program can't start because MSVCR110.dll is missing from… Read More »

How to Enable Administrator Account on Windows

by Ed Chen
August 28, 2014March 27, 2018

First of all, please open a cmd dialog in elevated mode, you may check the following post to see the tutorial:How to Open Command Prompts… Read More »

How to Show Account Information on Windows in Command Line

by Ed Chen
August 28, 2014October 20, 2022

If you are not sure what capabilities of current account can do on Windows 7 or 8, you can use the following command to show… Read More »

How to Open Command Prompts with Administrator Privileges (Elevated Mode) on Windows

by Ed Chen
August 27, 2014February 27, 2021

For opening command prompts in elevated mode, you must be a member of Administrators group. The way how to check account information can be found in… Read More »

How to List Dependencies and Dependents of a Package on Linux

by Ed Chen
August 26, 2014November 22, 2022

The fast way to see dependencies of a package is using yum with deplist option. For example, if we'd like to see the dependencies of… Read More »

How to List All Libraries and Files in a Package on Linux

by Ed Chen
August 24, 2014November 22, 2022

yum is a good tool to resolve dependencies of a package, but it cannot list all the libraries and files with definitive path in a package.… Read More »

How to Open Port Permanently on Linux

by Ed Chen
August 19, 2014June 23, 2023

Open Port There're differences to open port between Enterprise Linux (EL) 6 and 7, although they are IPTABLES operating underneath. EL6 uses iptables to manage… Read More »

How to Combine Multiple Files Into One on Linux

by Ed Chen
August 18, 2014November 22, 2022

In this post, I will introduce several ways to Combine files into one file. Suppose we have 4 files as followings:[root@localhost ~]$ cat 1.txt1. Database.1.… Read More »

JavaScript is not enabled. Please enable it and reload the page.