My prefered .bash_profile

export ORACLE_HOME
export ORACLE_HOME_LISTNER=$ORACLE_HOME
export ORACLE_HOSTNAME=`hostname`
export ORA_INVENTORY=/u01/app/oraInventory
export ORACLE_SID=CDB
export PDB_NAME=pdb1
export DATA_DIR=/u02/oradata

export ORACLE_SID
export ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1

export PATH=/usr/sbin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin

PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

ohvers ()
{
echo -n $ORACLE_HOME | sed -n ‘s/.*\/\([[:digit:].]\+\)\/.*/\1/p’
}
#export PS1=$’\\n# [ [email protected]\h:$PWD [\\t] [`ohvers` SID:${ORACLE_SID:-“no sid”}] ]\\n# ‘
PS1=’\[\e[31m\][`ohvers` SID:${ORACLE_SID:-“no sid”}][[email protected]\h:$PWD ]\[\e[0m\] \W\n\$ ‘
export JAVA_HOME=/u01/app/oracle/ODI_JAVA/jdk

echo “############################################### ”
echo “## Instances Currently Running in This Server”
echo “############################################### ”
ps -eaf | grep pmon | sed ‘s/^.*pmon_//g’ | egrep -v ‘//g|grep|+ASM|-MGMTDB’| sort

export NLS_DATE_FORMAT=’DD/MM/YYYY HH24:MI:SS’

Deixe uma resposta

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *