Setting ORACLE_SID With ENV Variables
From: Dave Morgan <oracle_at_1001111.com>
Date: Mon, 28 Jul 2014 06:16:05 -0600
Message-ID: <53D63F05.3060506_at_1001111.com>
Hello All,
Date: Mon, 28 Jul 2014 06:16:05 -0600
Message-ID: <53D63F05.3060506_at_1001111.com>
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_at_1001111.com
403 399 2442
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 28 2014 - 14:16:05 CEST