Re: Development suite :- create repository problems - please help!
From: David Sutherland <d_sutherland_at_btconnect.com>
Date: Mon, 31 Mar 2003 11:10:08 +0100
Message-ID: <WC-dnQmV9Y2fiRWjXTWc2Q_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 - 12:10:08 CEST
Date: Mon, 31 Mar 2003 11:10:08 +0100
Message-ID: <WC-dnQmV9Y2fiRWjXTWc2Q_at_giganews.com>
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 - 12:10:08 CEST