Re: sqlplus

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Tue, 6 Oct 2009 10:33:10 -0500
Message-ID: <e9569ef30910060833h4de46849u5d8e0a012d4ae69a_at_mail.gmail.com>

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_at_tufts.edu> 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_at_tufts.edu<mailto:
>> joan.hsieh_at_tufts.edu>> 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
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>>
>

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

Received on Tue Oct 06 2009 - 10:33:10 CDT