OraFAQ Forum: Streams & AQ » Oracle streams Error on executing the DBMS_RULE

Home » Server Options » Streams & AQ » Oracle streams Error on executing the DBMS_RULE_ADM package

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle streams Error on executing the DBMS_RULE_ADM package [message #75710]

Thu, 03 June 2004 02:23

Benki
Messages: 1
Registered: June 2004

Junior Member

Hi,

I am exploring on oracle streams. I was trying out the example for�configuration/setup on the site http://www.oracle-base.com/articles/9i/Streams9i.php.

am getting the errors when i try to execute the procedure under 'stream administrator setup':

SQL>

BEGIN
� DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
�� privilege�� => DBMS_RULE_ADM.CREATE_RULE_SET_OBJ,
�� grantee�� => 'strmadmin',
�� grant_option => FALSE);
END;
/
ERROR at line 1:
ORA-00931: missing identifier
ORA-24000: invalid value , USER/ROLE should be of the form [[SCHEMA.]]NAME
ORA-06512: at "SYS.DBMS_RULE_ADM", line 167
ORA-06512: at line 2

am quite new to 'oracle streams', can someone educate me on this? what am i doing wrong?..

Thanks in Advance, Benki

Report message to a moderator

Re: Oracle streams Error on executing the DBMS_RULE_ADM package [message #75713 is a reply to message #75710]

Mon, 21 June 2004 07:44

Sreeni
Messages: 6
Registered: January 2000

Junior Member

Try this..

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;
/

- Sreeni

Report message to a moderator

Re: Oracle streams Error on executing the DBMS_RULE_ADM package [message #75728 is a reply to message #75713]

Mon, 26 July 2004 23:16

Tugrul
Messages: 2
Registered: July 2004

Junior Member

I got the same error, then I tried your suggestion,
when I execute for CREATE_EVALUATION_CONTEXT_OBJ
I get ora-03114. Any more suggestions??

Report message to a moderator

Re: Oracle streams Error on executing the DBMS_RULE_ADM package [message #75768 is a reply to message #75710]

Fri, 28 January 2005 11:29

Stretch
Messages: 1
Registered: January 2005

Junior Member

I solved this problem by running catpatch.sql which is one of the post installation instructions after loading a patch. If you look at the README.doc in your patch release, it will give you what you need to execute this.

Report message to a moderator

Re: Oracle streams Error on executing the DBMS_RULE_ADM package [message #111231 is a reply to message #75768]

Mon, 14 March 2005 18:38

youssef77
Messages: 5
Registered: March 2005

Junior Member

my past experience on this is ..... if your platform is M$ Windows ... don't use 9i for streams .... you will get into alot of trouble ... go directly to 10g ... or alternatively .. choose better platform Smile

Report message to a moderator

Previous Topic:	Capture aborting
Next Topic:	Can Streams help to EXTRAC ( PULL ) data from MS SQL Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 07:24:29 CST 2024