Re: Development suite :- create repository problems - please help!

To fix this problem execute the following SQL statements as SYS

grant execute on dbms_lock to repos_owner; grant execute on dbms_pipe to repos_owner; grant create table to repos_owner;
grant create view to repos_owner;
grant create procedure to repos_owner;
grant create synonym to repos_owner;
grant create sequence to repos_owner;
grant select on sys.v_$nls_parameters to repos_owner with grant option; grant select on sys.v_$parameter to repos_owner; grant select on dba_rollback_segs to repos_owner; grant select on dba_segments to repos_owner; grant create any synonym to repos_owner; grant drop any synonym to repos_owner;

where repos_owner is the username of the repository owner.

"David Sutherland" <d_sutherland_at_btconnect.com> wrote in message news:VZacnVfLrc-9vB6jXTWcqA_at_giganews.com...
> I'm installing Oracle9i Development Suite 9.0.2.0.1 on windows 2000
>
> and getting the error
>
> RME-02124 - Failed to execute SQL statement .... JR_WORKAREA
>
> I have tried the workaround as stated in the Installation Guide,
> ie grant select on sys.v_$parameter....
> truncate table RM$REPOSITORIES;
> update CK_INSTALLED_OBJECTS set.......
> and restart installation from point of failure.
>
> BUT the problem remains! Do I have to remove all objects and completely
> restart the installation?
> Are there any other causes of this problem? Have I missed out a step?
>
> Any help would be great
> thanks
> davie
>
>
Received on Mon Mar 31 2003 - 04:10:08 CST