Multiple Oracle Homes

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs
export CATALINA_HOME=/home/oracle/apache-tomcat
PATH=/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:/bin/bash:$CATALINA_HOME/bin.
export PATH
EDITOR=vi
export EDITOR=vi

if [ -s “$MAIL" ] # This is at Shell startup. In normal
then echo “$MAILMSG" # operation, the Shell checks
fi # periodically.

echo " "
echo " "
echo " ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"
echo " Database options"
echo " "
echo " "
echo " 1) DATABASE 12cR2″
echo " "
echo " 2) DATABASE 12cR1″
echo " "
echo " "
echo " ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"
echo " "
echo " "
echo " Enter Choice:\c"
read env
if [ $env -eq 1 ] ; then
export ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_SID=ora12cr2
PS1=’$PWD:12cR2–>’

else
if [ $env -eq 2 ] ; then
export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_SID=ora12cr1
PS1=’$PWD:12cR1–>’
fi
fi
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/lib
export LIBPATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib:/usr/lib:/lib
export PATH=$PATH:$ORACLE_HOME/bin:/u01/app/12.1.0.2/grid/bin:$ORACLE_HOME/OPatch
stty erase ^?
TMOUT=0;TIMEOUT=600;export readonly TMOUT TIMEOUT
set -o vi

echo "
echo "
clear
echo
echo “ORACLE_SID=$ORACLE_SID"
echo

alias tsmd=’cd /opt/tivoli/tsm/client/oracle/bin64/’
alias ob=’cd $ORACLE_BASE’
alias oh=’cd $ORACLE_HOME’
alias tns=’cd $ORACLE_HOME/network/admin’
alias ch=’cd $CATALINA_HOME’
alias envo=’env | grep ORACLE’
alias sqld=’rlwrap sqlplus “/as sysdba"‘
export PATH
umask 022

envo

What does DEPRECATED mean? And DESUPPORTED?

Deprecated

Especially this message puzzled a lot of customers stating that the non-CDB architecture is deprecated in Oracle Database 12c.

In the Database Upgrade Guide we clearly explain what deprecated means:

“By deprecate, we mean that the feature is no longer being enhanced but is still supported"

So for you it means just be aware that we don’t further develop or enhance something. But you are still fully supported by using this feature.

Another well known example is Oracle Streams which is fully supported in Oracle Database 12c– but not in Oracle Multitenant – and is deprecated and therefore not enhanced or developed any further.

Or to name another example, Oracle Restart, which is deprecated for some time – but still not desupported. And I know a good bunch of customers using it in production even with Oracle Database 12.1.0.2 on several hundred databases.
.

Desupported

Even if something is desupported – remember the Rule Based Optimizer? – you can still use a feature being desupported. But on your own risk as we don’t fix any bugs or issues anymore.

Again the Database Upgrade Guide clarifies the term:

“By desupported, we mean that Oracle will no longer fix bugs related to that feature and may remove the code altogether"

Other common examples in Oracle Database 12c are the Enterprise Manager Database Controlwhich simply does not exist anymore in Oracle Database 12c or the desupport of Raw Devices.
.

Summary

Deprecated is a signal that something may disappear in the future and does not get enhanced anymore. No activity required except of taking note for your future plans. Desupported means that we don’t fix anything anymore for a desupported feature or product – and it may even disappear. But often desupported features are still there and can be used on your own risk only.