Re: sqlplus
- From: Bradd Piontek <piontekdd@xxxxxxxxx>
- To: Joan Hsieh <joan.hsieh@xxxxxxxxx>
- Date: Tue, 6 Oct 2009 10:33:10 -0500
Joan, That's where the first bullet point comes in. You need to run
sqlplus like this 'sqlplus -s / as sysdba' (or 'sqlplus -s "/ as sysdba"
if on 8i or 9i).
Bradd Piontek
"Next to doing a good job yourself,
the greatest joy is in having someone
else do a first-class job under your
direction."
-- William Feather
On Tue, Oct 6, 2009 at 10:31 AM, Joan Hsieh <joan.hsieh@xxxxxxxxx> wrote:
> Hi Bradd,
>
> I did set feedback off, echo off...etc. But I use sqlplus "/as sysdba"
> maybe that's the reason I can't get banner off?
>
> Thanks,
>
> joan
>
> Bradd Piontek wrote:
>
> This is a quick stab:
>> 1. "sqlplus -s" should keep the banner from coming out
>> 2. set feedback off
>> 3. set echo off
>>
>> I may be missing one or two.
>> Bradd Piontek
>> "Next to doing a good job yourself,
>> the greatest joy is in having someone
>> else do a first-class job under your direction."
>> -- William Feather
>>
>>
>> On Tue, Oct 6, 2009 at 10:20 AM, Joan Hsieh <joan.hsieh@xxxxxxxxx<mailto:
>> joan.hsieh@xxxxxxxxx>> wrote:
>>
>> Hi List,
>>
>> I have a shell script report the following output for my daily check
>> routine. I found the SQL> SQL> SQL> is very annoying, is it possible
>> to get rid off the "lines from coonected to:" to 2 3 4...13" ?
>>
>> Thanks,
>>
>>
>> Joan
>>
>>
>> Connected to:
>> Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit
>> Production
>> With the Partitioning, OLAP, Data Mining and Real Application
>> Testing options
>>
>> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 2 3 4 5 6 7
>> 8 9 10 11 12 13
>> Thread LastSeqApp1stti Last Sequence Applied LastSeqRec1stti Last
>> Sequence Received DiffSeq DiffMins
>> ---------- --------------- --------------------- ---------------
>> ---------------------- ---------- ----------
>> 1 06-OCT-09 1428 06-OCT-09
>> 1428 0 0
>> SQL> SQL> SQL> 2
>> CURRENT_LOG_GAP
>> ---------------
>> 0
>> SQL> SQL> 2 3 4
>> PROCESS SEQUENCE# STATUS
>> --------------------------- ----------
>> ------------------------------------
>> ARCH 1426 CLOSING
>> ARCH 1427 CLOSING
>> ARCH 1428 CLOSING
>> RFS 1429 IDLE
>> MRP0 1429 APPLYING_LOG
>> SQL> Disconnected from Oracle Database 11g Enterprise Edition
>> Release 11.1.0.7.0 - 64bit Production
>> With the Partitioning, OLAP, Data Mining and Real Application
>> Testing options
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>>
>
Other related posts:
