Posts Categorized: Technical Blog

fsfreeze in Linux

The fsfreeze command, is used to suspend and resume access to a file system. This allows consistent snapshots to be taken of the filesystem. fsfreeze supports Ext3/4, ReiserFS, JFS and XFS. A filesystem can be frozen using following command: # /sbin/fsfreeze -f /data Now if you are writing to this filesystem, the process/command will be…

Ingest a Single Table from Microsoft SQL Server Data into Hadoop

Introduction This blog describes the best-practice approach in regards to the data ingestion from SQL Server into Hadoop. The case scenario is described as under: Single table ingestion (no joins) No partitioning Complete data ingestion (trash old and replace new) Data stored in Parquet format Pre-requisites This example has been tested using the following versions: Hadoop…

Weblogic patch rollback issues in Oracle EBS R12.2

When you try to rollback a weblogic patch in Oracle EBS R12.2, you might run into issues similar to below: $ ./bsu.sh -remove -patchlist=YIJF -prod_dir=/u01/install/VISION/fs2/FMW_Home/wlserver_10.3 -verbose Checking for conflicts.. No conflict(s) detected Starting removal of Patch ID: YIJF Restoring /d1/V1223B5B/fs1/FMW_Home/modules/com.bea.core.datasource6.binding_1.10.0.0.jar from /u01/install/VISION/fs2/FMW_Home/patch_wls1036/backup/backup.jar Result: Failure Failure condition follows: An error occured while removing patches – run…

Pillars of PowerShell: Profiling

Introduction This is the fourth blog post continuing the series on the Pillars of PowerShell. The previous post in the series are: Interacting Commanding Debugging Profiles This is something I mentioned in the second post and can be a great way to keep up with those one-liners you use most often in your work. A profile…

Keeping Cassandra Alive

Troubleshooting Cassandra Under Pressure This is the second blog post in the series. This is a bit more technical than the first one. I will explain some things that can be made to keep a cluster/server running when you are having problems in that cluster. There were a lot of changes in Cassandra over the…

Pillars of PowerShell: Debugging

Introduction The is the third blog post continuing the series on the Pillars of PowerShell. The first two post are: Interacting Commanding We are going to take a bit of a jump and dig into a particular topic that I think is better to go over up front, instead of later. In this post I…

Disable Lock Escalation in SQL Server

If a lot of rows or pages are locked, the SQL Server escalates to a table-level lock, to save resources. Each single lock takes approx. 100 bytes. So if you have many locks it takes a lot of resources to manage them. (There is a great blog about lock escalation, if you want some more…

Page 2 of 6412345...10...Last Page »