RE: Trying to write a short script
Date: Thu, 22 Sep 2011 15:52:09 -0500
Message-ID: <EF763CC31BB89B47B435AE02FE42263F0472417D21_at_S009-APEXM05.ds.ad.ssmhc.com>
I hate it when I solve it the moment after I post. I just created an sql file called dbversion.sql with the following:
select banner
from sys.v_$version;
exit
then from inside my unix script I just call it:
sqlplus -s / _at_dbverion
*sigh*
I figured I post my answer for feedback.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Laurent, Vincent
Sent: Thursday, September 22, 2011 3:43 PM
To: oracle-l_at_freelists.org
Subject: Trying to write a short script
I am currently using Oracle 11.2.0.2 on HP-UX 11.31 I have a script that does this:
# Get the path to the trace files
DUMP=`/oracle/$ORACLE_SID/112_64/bin/sqlplus -s / as sysdba <<EOF
set head off
set feedback off
select * from v\\$version;
exit
EOF`
echo $DUMP
but the output comes back like this (all wrapped as one line):
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production PL/SQL Release 11.2.0.2.0 - Production CORE 11.2.0.2.0 Production TNS for HPUX: Version 11.2.0.2.0 - Production NLSRTL Version 11.2.0.2.0 - Production
Instead of like this (each product it's own line):
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for HPUX: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
Ideas to fix?
Confidentiality Notice: This email message, including any
attachments, is for the sole use of the intended recipient(s) and
may contain confidential and privileged information. Any
unauthorized review, use, disclosure or distribution is prohibited.
If you are not the intended recipient, please contact the sender by
reply email and destroy all copies of the original message.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 22 2011 - 15:52:09 CDT