Hi,
I am using this script to load up my Oracle Databases, but when I log in through Exceed, it hangs. Can anyone tell me what else I need to add to make this work??
Details
****************************************************************************************************
# Environment Variables for Oracle 92
export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle/92
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export ORACLE_OWNER=oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH
# Oracle Environment SID Selector
# Script to select From the Multiple SIDs on this machine
echo "The following SIDs reside on this Box"
cat /var/opt/oracle/oratab | awk -F: '{print $1}' | grep -v "#"
ORAENV_ASK="YES"
. /usr/local/bin/oraenv
****************************************************************************************************
This other one , when I try it as a .profile, it logs me out straightaway.
*********************************************************************************************
echo
echo " Welcome Oracle User! "
echo " DATABASES INFORMATION"
echo " ===================== "
echo "Author: Derek Nkansah"
echo
echo
echo "*** Please note that Summit Databases are case-sensitive. Please adhere to those ***"
echo
echo
echo "WHICH INSTANCE DO YOU WANT TO USE (ORACLE9i or ORACLE8i)"
echo "PLEASE CHOOSE ONE:\c"
read v_instance
if [ -z "$v_instance" ]
then
echo "You must choose one of the instances above."
echo "Null value is not allowed."
exit 99
fi
echo
if [ "$v_instance" = ORACLE9i ]
then
echo "Your choice is Oracle9i"
echo "The database for the Oracle 9i are
loncli92, londev92, londqa, londft92)"
echo " Please enter the database you want to use : \c"
read ORACLE_SID
export ORACLE_SID
fi
if [ "$v_instance" = ORACLE8i ]
then
echo "Your choice is Oracle8i"
echo "The database for the Oracle8i are
loncu817, londv817, lonqa817, lonft817)"
echo " Please enter the database you want to use : \c"
read ORACLE_SID
export ORACLE_SID
fi
# The statements below get the oracle home for the given Database.
ORACLE_HOME=`cat /var/opt/oracle/oratab|grep ${ORACLE_SID}:|cut -f2 -d':'`
export ORACLE_HOME
export PATH=$ORACLE_HOME/bin:$PATH
# /usr/ucb/
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORA_NLS33
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export LD_LIBRARY_PATH
echo " Your database choice is : $ORACLE_SID"
echo " The ORACLE_HOME for this database is: $ORACLE_HOME "
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Please help me
Deln