Shell script to connect to Oracle from shell
Posted: Fri Nov 06, 2020 3:32 pm
Code: Select all
ORACLE_SID=ora111db ; export ORACLE_SID
ORACLE_HOME=/usr/oracle/11.1.0; export ORACLE_HOME
ORACLE_BIN="/usr/oracle/11.1.0/bin";export ORACLE_BIN
#TWO_TASK=ORCL;export TWO_TASK
PATH=$PATH:$ORACLE_HOME;export PATH
PATH=$PATH:$ORACLE_BIN;export PATH
oraname=ora111db
orapwd=AR#Admin#
orasid=ora111db
oradefaultuser=AERADMIN
oralogin="${oradefaultuser}@${oraname}/${orapwd}"
#oralogin="${oradefaultuser}/${orapwd}"
echo "Connecting as $oralogin"
sqlplus -S $oralogin