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.
Commentaires