Gene,
Yep, I noticed the env vars are different in the text below (due to fat
fingers). They are the same in the script. For whatever reason, HPUX (or
oracle) doesn't like the variable $PASSWORD as a password.
I worked around it by splitting the task up into a:
svrmgrl << EOF "here doc"
and a seperate:
sqlplus user/$PASSWORD << FOE "here doc" immediately following. (this
works fine - go figure).
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Grāce via your Ninja
Death Touch, you step on a beer bottle and fall backwards into the juke box
and get your head stove in by a drunk with a pool cue." --Jay Trigg
> -----Original Message-----
> From: Gene Sais [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 29, 2001 2:20 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: OT Unix shell variable question
>
> Scott - I have used it w/out problems, sample below:
>
> <snip ksh script>
>
> PFILE=$ORACLE_HOME/dbs/initorsp.ora
>
> svrmgrl <<EOF
> connect internal
> startup nomount pfile=$PFILE
> EOF
>
> </snip ksh script>
>
> PS. You have noticed your env. variables are different, right?
>
>
> >>> [EMAIL PROTECTED] 05/29/01 03:41PM >>>
> I am trying to pass a shell variable into a "here document" in a unix
> shell
> script, i.e.,
>
> export PASSWORD=the_pass
>
> svrmgrl << EOF
> connect user/$PASS
> do_stuff_here;
> commit;
> exit
> EOF
>
> I have tried: "$PASS" , \$PASS , and just plain $PASS - no dice.
> Anyone know how to do this? I spent too many hours in the sun this past
> weekend and am drawing a blank...
>
> Thanks,
>
> Scott Shafer
> San Antonio, TX
> 210-581-6217
>
> "And no amount of training or preparedness can eliminate the almost
> certainty that in the middle of your Angry Crane stance, as you transition
> to your Combative Monkey to administer the Coup de Grāce via your Ninja
> Death Touch, you step on a beer bottle and fall backwards into the juke
> box
> and get your head stove in by a drunk with a pool cue." --Jay Trigg
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
