EOF problem

[MCubitt]

I have an AIX script which I am trying to use, but the following part provides an unexpected end of file error. Clearly the EOF is giving grief:

udump_dest=´${ORACLE_HOME}/bin/sqlplus -s <<EOF
/ as sysdba
set heading off  feedback off
select value from v\\$parameter
where name='user_dump_dest';
exit
EOF´

I have a feeling it's related to those pesky ` ' " thing.

kind regards





Applications Support
UK

 

[MikeLacey]

that last line, should read

EOF

but it looks as if it reads

EOF'

(or some weird quote char anyway)

What's that doing there?

Mike

"Deliver me from that bane of civilised life; teddy bear envy."

Want to get great answers to your Tek-Tips questions? Have a look at faq219-2884

 

[MCubitt]

Good spot, I thought it was closing the opening ´ between udump_dest= and ${ORACLE_HOME}.




Applications Support
UK

 

[MikeLacey]

Mr Cubitt.... You're in the UK - Have you seen this private group here at TT? TTUK

Mike

"Deliver me from that bane of civilised life; teddy bear envy."

Want to get great answers to your Tek-Tips questions? Have a look at faq219-2884

 

[MCubitt]

Mike, Is there a benefit )or cost) to using either? is it a mirror or a subset?

Thanks


Applications Support
UK

 

[KenCunningham]

It's a free (excepting Mike, who foots the bill I think) social forum for UK-based TT'ers. Come and join us!

 

[Ogzilal]

Hi,

If you have root access, try this variant

export VDP='v\$parameter'
su - oracle <<-!EORA | read udump_dest
export ORACLE_SID=TPGEDRTE
${ORACLE_HOME}/bin/sqlplus -s <<-EOF
/ as sysdba
set heading off feedback off
set newpage none
select value from $VDP
where name='user_dump_dest';
exit
EOF
!EORA

# print the value of your var
print $udump_dest

Ali

 

[MCubitt]

I would be runnign the scriot as user ORACLE but thanks.



Applications Support
UK