Setting the NLS_LANG Environment Variable for Oracle Databases

Setting the NLS_LANG Environment Variable for Oracle Databases:

  • On Window
    set NLS_LANG=AMERICAN_AMERICA.UTF8
  • On Unix (Solaris and Linux, CentOS, Ubuntu etc.)
    export NLS_LANG=AMERICAN_AMERICA.UTF8

It would also be advisable to set env variable in your .bash_profile [on start up script]

This is the place where other ORACLE env variables (ORACLE_SID, ORACLE_HOME) are usually set.

Installing Oracle XE with Docker

Nicest way to install Oracle XE on any operating system (for development) is Docker. Docker is an application container for Mac, Linux and Windows. It is based on LXC and gives you the ability to package complete application including their dependencies to a self-containing file (called an image). These images can be exchanged and run on every Linux machine where Docker is installed! Awesome!

Continue reading