Tuesday, October 22, 2013

Monday, June 24, 2013

Oracle Database Instant Client Installation

Oracle Database Instant Client Installation

The Oracle Instant Client software is an easy to use alternative to a full blown Oracle Client installation. Especially if you are mainly interested in the Oracle sqlplus tool.

1. Create an oracle account (if not already available)

# groupadd oracle
# useradd -c "Oracle Instant Client" -d /home/oracle \
          -g oracle -m -s /bin/bash oracle
# password oracle


2. Login as user oracle and unpack the Oracle Instant Client software:

$ unzip instantclient-basiclite-linux.x64-11.2.0.3.0.zip
$ unzip  instantclient-sqlplus-linux.x64-11.2.0.3.0.zip


3. Set the Oracle Instant Client environment

ORACLE_BASE=/home/oracle                    ; export ORACLE_BASE
ORACLE_HOSTNAME=`uname -n`                  ; export ORACLE_HOSTNAME
ORACLE_HOME=$ORACLE_BASE/instantclient_11_2 ; export ORACLE_HOME
ORACLE_SID=dbsecdocs                        ; export ORACLE_SID
TWO_TASK=$ORACLE_SID                        ; export TWO_TASK
TNS_ADMIN=$ORACLE_HOME                      ; export TNS_ADMIN
#
PATH=$ORACLE_HOME:$PATH                       ; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH ; export LD_LIBRARY_PATH

Saturday, August 25, 2012

Simple usage example for class java.lang.ProcessBuilder under Windows (XP, Vista, ...)

It's easy to execute shell scripts under Windows with the help of the ProcessBuilder class: