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, [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
