Author Archives: Ajitabh
Using Wrap Utility to Hide the SQL Code in Oracle
At times we may need to encrypt sensitive information in certain columns in Oracle Database. Oracle provides a DBMS_CRYPTO package for the purpose. More details about this package can be found in Oracle Documentation here. The approach I followed is … Continue reading
Posted in Databases
Leave a comment
Apt Pinning in Raspbian
Quite sometime back I wrote a blog entry on apt-pinning to mix multiple repositories in debian and prioritize them. Recently, I felt the need to do the same on my raspberry pi. I use rsnapshot to backup remote systems. Rsnapshot … Continue reading
Ansible Quirks – 4
I was installing ansible on OpenSuSE Leap 42.3 machine and faced a problem with multiple python versions. I have both python 2.7 and python 3.4 installed on this machine. Python 2.7 is the default one. I tried installed ansible with … Continue reading
Running Oracle 11g Release 2 (11.2.0.2) XE in Docker Container
In DockerCon2017 Oracle announced the availability of Oracle containers in the docker hub. This was a great step forward. I have been thinking of trying Oracle in docker from quite a while for some personal projects, but was not finding … Continue reading
Connecting to Oracle Database over SSH using SQLDeveloper 4.1
As a system administrator, I try to follow the principle of least privilege (minimal privilege). Therefore, in the systems I install, I block all incoming and outgoing ports by default and open only when needed. While setting up Oracle XE … Continue reading