Re: Using Designer after upgrade to 816 and full database import

[Quoted] You will need to regrant to the sys packages: as SYS or INTERNAL, do:
grant execute on sys.dbms_pipe to (repository owner); grant execute on sys.dbms_lock to (repository owner);

This is because export cannot export grants on that level, you probably did it as SYSTEM.

--
Kind Regards,
Frank
"Onno" <omv_at_hetnet.nl> wrote in message
news:3948e2da.4935827_at_news.cistron.nl...


> Hi,

>

> I did a new install of Oracle 816 and a full database import,


> including a Designer 60 repository coming from a 815 database.

>

> I can see all objects in my application systems, but when I try to

> update or add anyting, I get

>

> RME-00224: Failed to close activity

> RME-00222: Failed to dispatch operation to Repository

> RME-00020: Internal API error - ORA-06500: PL/SQL: storage error

> ORA-06512: at "REP_OWNER.RMMES", line 44

> ORA-06512: at "REP_OWNER.RMOACTIVITY", line 313

> ORA-04031: unable to allocate 8192 bytes of shared memory ("large

> pool","unknown object","sort subheap","sort key")

> RME-02124: Failed to execute SQL statement: begin

>   rmmes.getall(:errutil,:errcode,

>     :errp0,:errp1,:errp2,:errp3,

>     :errp4,:errp5,:errp6,:errp7);

> end;

> RME-02105: Oracle error occurred...

> ORA-01403: no data found

> ORA-06512: at "REP_OWNER.RMMES", line 163

> ORA-06512: at line 2

>

> ORA-01403: no data found

>

> Oops. I used to get only two errors, but now that I try again just to

> write this message I get this whole list. I will look at them, but in

> the mean time perhaps somebody else can give me a hint.

>

> So far I got the errors ORA-04031 without the details it gives now,

> and I doubled the size of my shared pool; and ORA-01403, which seems

> to have no meaning at all.

>

> I am working locally on NT with 128 MB

> shared pool 28 MB

> large pool 6 MB

> open cursors 400

> max_enabled roles 30

> processes 100

> log_buffer 65536

>

> Who knows?

>

> Onno