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

Posted in Automation, Databases | Tagged , , | Leave a comment

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

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

Posted in Containers, Databases | Tagged , | Leave a comment

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

Posted in Databases | Tagged , | Leave a comment

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

Posted in Databases, Tips/Code Snippets | Tagged , , , , | Leave a comment