Adding SGBD environment script in WebCenter VM

This script is intended to those who use the Vmware WebCenter machine provided by Emiliano P. and need to use sqlplus or imp/exp modules.
First, create a new file db.env in /home/wc directory, and add the following lines:

#!/bin/bash
#
# description:  Environnement for SGBD
#
# change log:
#       Pmonaco 09 Feb 2010 -  Creation
#

# Save LD_LIBRARY_PATH
SAVE_LLP=$LD_LIBRARY_PATH ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
ORACLE_OWNER=oracle
ORACLE_SID=XE
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORACLE_HOME
export LD_LIBRARY_PATH
export ORACLE_SID
export PATH=$ORACLE_HOME/bin:$PATH
export NLS_LANG=American_America.AL32UTF8

Give execute permisions do db.env file:

chmod +x db.env

Then source the above file with the following command line :

. ./db.env

As from this point, it’s possible to use sqlplus or imp/exp executables.