Setting ORACLE_SID With ENV Variables
- From: Dave Morgan <oracle@xxxxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 28 Jul 2014 06:16:05 -0600
Hello All,
I am having a problem setting ORACLE_SID using env variables.
For example, in a bash script:
export SS_DB=ABCDB
export TT_DB=DEFDB
export ORACLE_SID=$SS_DB
sqlplus fails with Oracle not available, no shared memory. However,
echo $ORACLE_SID returns ABCDB.
If I then set ORACLE_SID directly:
export ORACLE_SID=ABCDB
sqlplus works fine
What am I missing?
TIA
Dave
--
Dave Morgan
Senior Consultant, 1001111 Alberta Limited
dave.morgan@xxxxxxxxxxx
403 399 2442
--
//www.freelists.org/webpage/oracle-l
Other related posts:
