Category Archives: Databases
Get Oracle XE-ORDS-APEX Up and Running Quickly with Ansible
Oracle APEX is a rapid application development tool and from what I have seen its quite powerful. Clubed together with ORDS, it is a powerful tool to develop enterprise applications which are highly scalable.
I wrote an ansible playbook, which will quickly setup the entire stack. Read to find more. Continue reading
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
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
Installing Oracle Instant Client for Mac OSX
I came across few links for installing Oracle Instant Client on Mac OS X namely – this and this. But I don’t like to tinker with the System paths while installing any s/w manually. I did the same with perl … Continue reading