Re: Setting ORACLE_SID With ENV Variables

try an echo "xxx${ORACLE_SID}xxx" in the script before executing sqlplus to see if there's something nasty in the variable. Is $ORACLE_HOME properly set when the script runs?

In general, please check that $ORACLE_HOME is the correct one if you have more than one. And the $PATH has to point to the correct $ORACLE_HOME, too.

Regards
Martin

Am 28.07.2014 14:16, schrieb Dave Morgan:
> 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
>

-- 
Usn's IT Blog for Oracle and Linux
http://www.usn-it.de

performing databases
Your reliability. Our concern.
http://www.performing-databases.com

--
http://www.freelists.org/webpage/oracle-l