Re: ORA-03113: end-of-file ... during Oracle Streams setup

From: <tamizh_at_optonline.net>
Date: Sun, 26 Oct 2003 14:04:25 -0800
Message-ID: <F001.005D4701.20031026140425@fatcity.com>

No. I did not shutdown the oracle DB. It is an oracle bug.

Problem:-

BEGIN
 DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(

    privilege     => DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, 
    grantee       => 'STRMADMIN', 
    grant_option  => TRUE);
 DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
    privilege     => DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, 
    grantee       => 'STRMADMIN', 

    grant_option => TRUE);
 DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(

    privilege     => DBMS_RULE_ADM.CREATE_RULE_OBJ, 
    grantee       => 'STRMADMIN', 
    grant_option  => TRUE);

END;
/

Solution:-
<<
could ask the customer to re-load as SYS

$OH/rdbms/admin/dbmsread.sql
$OH/rdbms/admin/prvtread.plb

. then try the testcase.
 >>

-tamizh

• Original Message ----- Date: Sunday, October 26, 2003 4:44 pm

> Well, it's easy. You're doing "shutdown immediate" during the
> procedureexecution. do "shutdown abort" and you'll get rid of the
> error message.
>
>
> On 2003.10.26 16:14, tamizh_at_optonline.net wrote:
> > Hi List
> >
> > I am in the process of setting up Oracle Streams and getting the
> following> error
> >
> > <<
> > *** 2003-10-26 17:01:38.417
> > *** SESSION ID:(11.18) 2003-10-26 17:01:37.836
> > OPIRIP: Uncaught error 1089. Error stack:
> > ORA-01089: immediate shutdown in progress - no operations are
> permitted> ORA-00448: normal completion of background process
> > >>
> >
> > while running (OEM generated script to setup Oracle Streams)
> >
> > <<
> > BEGIN
> > DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
> > privilege => DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ,
> > grantee => 'STRMADMIN',
> > grant_option => TRUE);
> > END;
> > /
> > >>
> >
> >
> > Any help would be really appreciated.
> > -tamizh
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author:
> > INET: tamizh_at_optonline.net
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting
> services> ---------------------------------------------------------
> ------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (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).
> >
>
> --
> Mladen Gogala
> Oracle DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: mgogala_at_adelphia.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> -------------------------------------------------------------------
> --
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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.net
-- 
Author: 
  INET: tamizh_at_optonline.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).

Received on Sun Oct 26 2003 - 16:04:25 CST