Linux memory script

Below is a simple script to check the total memory and cpu used by process

MY_USER=`id -u -n`
> /tmp/my_mem_$MY_HOST.txt
echo `date` >> /tmp/my_mem_$MY_HOST.txt
ps -e -o rss,vsz,pcpu,user,args | grep $MY_USER > /tmp/$MY_HOST_prcs.txt
cat /tmp/$MY_HOST_prcs.txt | awk ‘{a=$1;b=$2;c=$3;x=x+a;y=y+b;z=z+c;ma=x/1024;mb=y/1024;{printf(”   Resident memory size is:   %s MB\n   CPU for Processes:        %s %%\n   Virtual memory size is:    %s MB\n”,ma,z,mb)}}’  | tail -3 >> /tmp/my_mem_$MY_HOST.txt
cat /tmp/my_mem_$MY_HOST.txt

which will report the total memory and virtual memory used together with CPU % by the particular user.

Mon Jul 25 01:45:40 EDT 2016
Resident memory size is:   12664.8 MB
CPU for Processes:        19.4 %
Virtual memory size is:    49755.9 MB

Can be modified and place inside a loop for monitoring.


 EPM tools

We are currently maintaining a number of servers for our EPM applications. When you are dealing with tons of servers, it is important to keep an inventory to keep track of the software component installed and the associated environment and servers. 

Since i’m a fan of automation, i created a tool for our inventory with Excel as my usual weapon of choice. The attached video contains the demo of the tool. Feature such as automated login and integration to Linux servers, sqlplus and nt servers are not included due to security reason

Weblogic startup hanging

I’ve encountered this before but somehow keep on forgetting. When booting up weblogic and it started to hang, it is normally caused by corrupted datafiles under /domains/<domain name/servers/AdminsServer/data

Deleting the data directory should resolve the issue. Don't worry as the directory gets recreated during startup

Windows insider Experience


Enrolled myself to the windows insider program and was able to take the new Microsoft OS for a spin. Initially tested the release on Oracle Virtual box, installation went smoothly.

I then  decided to jump the gun and upgrade my windows 8.1 on my acer iconia w700 to windows 10 release, installation was a success but errors were encountered left and right, a bit expected and waited for a new build to be released.

Proceed with the upgrade of windows 8.1 to windows 10 mobile on my lumia 920. Corrupted my OS, have to plugin to my PC to perform recovery. Was able to recover and install, my lumia 920 is now running windows 10 preview.

A new windows 10 build was released, upgraded my windows 10 VM first. Seen a lot of improvement. Upgraded my w700, Encountered a boot loop issue. I have to reformat my w700 and reinstall windows 8.1 then upgrade to windows 10 build. This time the upgrade works and a more stable windows 10 runs smoothly on my w700. Impressed with the UI and the performance.

Signup for the August 29 windows 10 release on my asus laptop.the same laptop which host my Windows 10 VM.

Dday, August 29. Downloaded windows 8.1 upgrade on my PC which took about an hour or so. After the download and install. Windows 10 start downloading and was able to upgrade my asus from windows 8.1 to 10

Still testing, my setup are as follows:

1. Windows 10 preview on Oracle virtual box 5, guest OS on asus gaming laptop

2. Windows 10 home on ASUS gaming laptop

3. Windows 10 professional on my afer iconia w700 touch

4. Windows 10 mobile preview on my Lumina 920

System integration

Like many enterprise application. Many companies are very much liberal in the installation and deployment guide that they normally published specially for products requiring large scale installations and integrations. After all, it is hard to account for multiple scenarios that can take place on the implementing side of the fence. Due dilligence should be made and fingers cross the approach you’ve chosen works! At the end of the day, you can’t test every possible scenario anyway.

Oracle VM virtual box 5

Back in the days dual booting OS is a “in” thing. Yes i belong to that generation. I’ve been playing around with virtual machine for quite sometime using Oracle VM. It’s open source and free for those who like to play around with virtualization, OSes and networking. To date i have around 9 VMs configure in the machine i’m using

Version 5 were recently released and can be downloaded on the following url:

not forgotten

been busy with work lately but you are not forgotten. currently working on other Oracle product besides peoplesoft as part of the project requirements. Embrace the change yay! I’ll find some time to update this blog with some of the stuff i’m working on

PS/NVision with Active Data Guard

Active Data Guard(ADG) is one of the key feature introduced in PeopleTools 8.51, steps to configure ADG is discussed in the Peoplebooks Data Management section:

I made the recommendation to configure ADG in order to maximize the PeopleTools 8.53 feature as part of an Ongoing Upgrade project. Besides the PeopleTools documentation, it is also one of the highlight in the Release value proposition for PeopleTool 8.53 especifically the ability to offload processing to standby database via ADG. Imagine my surprise when we raise an SR to oracle to address an issue we are encountering when running PS/nVision on the standby database and was advised that the functionality is not supported by ADG contradicting the previously published document.

Not entirely convinced by the information provided, I performed some troubleshooting and managed to make PS/nVision run against the standby database. It turned out that additional process are required besides the one outlined in PeopleBooks. The highlevel wil be:

1. create DBlink- script provided by oracle createdblinktoprimary.sql
2. create local synonyms- scripts provided by oracle createlocalsynonyms.sql
3. create remote synonyms- scrips provided by oracle createremotesynonyms.sql

The missing steps for DML redirection requires a trigger to be created which switch the primary schema user to standby schema user each time it login to the standby database. The details can be found in