Re: Oracle Designer 6.0: RME-00011, RME-02124, RME-02105, ORA-01403

André Hartmann wrote:

> Hi everyone,
>
> I am trying to employ Oracle Designer 6.0 with an Oracle 8.1.6 Server
> instance.. all on Windows 2000.

8.1.6 wasn't certified for Win2k, AFAIK. If it works - ok. Designer requires EE, not standard, tho

After installing client software and feeding
> the database schema,

Assume this means you actually built a repository?

I get an error when I try to start Oracle designer and
> try to create an application system (there is no applications ystem at the
> moment). So I type something in the "Application System" text box and press
> "Create".... then I get the following:
>
> RME-00011: Operation 'INS' on ci_application_systems has failed
> RME-02124: Failed to execute SQL statement: begin
> :errcnt := rmmes.getsize;
> 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 "DESIGNER2000.RMMES", line 157
> ORA-06512: at line 3
>
> ORA-01403: no data found
>
> Can someone help... did I forget to install something ?? I user teh
> Respository administration utility to isntall the schema. When i start this
> utility now that everything should be installed fine, I get
>
> RME-00220: Failed to connect to Repository
> ORA-04031: unable to allocate bytes of shared memory ("","","","")
>
What are the init.ora settings? You need quite a lot of memory assigned

to the shared pool (18MB is absolute minimum!) and some other stuff.

Read the installation html files carefully about these settings; scan

archives (I did put up a whole script once, init.ora included). Apart from that: create a user (e.g. d603), and assign that user Manager rights in RepAdmin util. Do a full reconcile. Connect as d603 (*not* the administrator you used when installing the repository), and try to create an application.

Good luck!
Frank Received on Sun Apr 07 2002 - 18:03:48 CEST