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

Thanks, I did that. And after that consolidated the users, But then I seemed to have more problems than before. My whole database gave more and more problems, so I de-installed and installed again (and again). Problems not yet solved. Last try just installing the database I got an error message ORA-01119 saying that there was not enough space left for a datafile to be created on the device. I had 1.5 GB free space left for my last datafile, the others were created, and the datafile was to be 500 MB. Please tell me this is not an Oracle bug.

Onno

On Mon, 19 Jun 2000 10:38:25 +0200, "Frank van Bortel" <f.van.bortel_at_vnl.nl> wrote:

>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
>
>
Received on Thu Jun 22 2000 - 00:00:00 CEST