Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsgate.cistron.nl!xs4all!feeder1.cambrium.nl!feed.tweaknews.nl!proxad.net!cleanfeed2-b.proxad.net!nnrp2-1.free.fr!not-for-mail
Date: Tue, 06 Jun 2006 18:05:57 +0200
From: Michelle <rr@somewhere.com>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: fr, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.tools
Subject: Re: Designer 10g/XE - Repository Installation fails at CKSYSFOL
References: <4485819a$0$12367$626a54ce@news.free.fr> <44858614$0$4516$9b4e6d93@newsread2.arcor-online.net> <44859916$0$12367$626a54ce@news.free.fr> <4485a009$0$11079$9b4e6d93@newsread4.arcor-online.net>
In-Reply-To: <4485a009$0$11079$9b4e6d93@newsread4.arcor-online.net>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 28
Message-ID: <4485a7e3$0$12357$626a54ce@news.free.fr>
Organization: Guest of ProXad - France
NNTP-Posting-Date: 06 Jun 2006 18:05:55 MEST
NNTP-Posting-Host: 82.245.192.44
X-Trace: 1149609955 nnrp2-1.free.fr 12357 82.245.192.44:3430
X-Complaints-To: abuse@proxad.net
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.tools:70934

> To grant the privileges simply connect via commandline sqlplus as sysdba:
> SQL>connect / as sysdba
> SQL>grant execute on utl_file to <YOUR REPOSITORY OWNER>;
> 
> Whether you should rebuild the repository, i can't tell you - i never 
> hitted this problem before. Maybe , if you recompile invalid objects , 
> things are ok, but i personally would prefer to rebuild it from scratch...
> 
:-) That's what i did !
I found the grant command, used the "View Objects" tool
to mark invalid objects to reload, and recompiled the invalid packages.
When I closed the tool, The RAU poped up it detected "reloads" and it 
seemed ok.

But now I'm trying to add a Repository User, and I get another error:

ORA-01919: Role 'CKR_REPOS_MANAGER' does not exist.
ORA-06512: at "REPOS_MANAGER.JR_SYS_PRIVS", ligne 236

but the role is indeed present in SYS.dba_roles

... ok, that's just for info. I think I'll follow your suggestion and 
rebuild.

--
Thanks again.

Michelle