Oracle Designer 6.0: RME-00011, RME-02124, RME-02105, ORA-01403
André Hartmann
I am trying to employ Oracle Designer 6.0 with an Oracle 8.1.6 Server
instance.. all on Windows 2000. After installing client software and feeding
the database schema, 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 ("","","","")
I guess something is messed up..how to mend ?? I did a re-install
already... same endup :(
André
:O
Frank
> 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