Re: Development suite :- create repository problems - please help!
From: David Sutherland <d_sutherland_at_btconnect.com>
Date: Fri, 28 Mar 2003 09:58:49 -0000
Message-ID: <YUidnSv_EetGgRmjXTWcpg_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 Fri Mar 28 2003 - 10:58:49 CET
Date: Fri, 28 Mar 2003 09:58:49 -0000
Message-ID: <YUidnSv_EetGgRmjXTWcpg_at_giganews.com>
Ok I managed to fix this problem by,
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
"David Sutherland" <d_sutherland_at_btconnect.com> wrote in message news:nsednQP-SO65jh6jXTWc3A_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 Fri Mar 28 2003 - 10:58:49 CET