Error creating designer repository owner schema on 8.1.5 server

From: bonminh lam <mailbox_at_online.de>
Date: Sat, 02 Sep 2000 00:16:46 +0200
Message-ID: <39B02ACE.145FF62F@online.de>

I have an 8.1.5 Oracle server running on Linux and I am trying to get some hands-on practice with Designer. The client software could be installed without problem. And I follow the instructions in the HTML installation for the server side installation. That went smoothly as well. However, when I tried to create the repository owner schema from Respository Admin Utility, I hit the following errors (popped in a dialog):

RME-02124: Failed to execute SQL statement: create or replace package body rmand as

procedure dispatch_query(cid IN number,tid IN number,eid IN number) is begin

Element type tcotme... if tid = 4811 then ciotype_constraint_component.traverse_to_root(cid,eid,true);
Element type abtabt... elsif tid = 4814 then ciogeneralisation_association.traverse_to_root(cid,eid,true);
Element type lst... elsif tid = 4816 then ciolob_storage.traverse_to_root(cid,eid,true);
Element type ort... elsif tid = 4819 then ciooracle_type.traverse_to_root(cid,eid,true);
Element type oot... elsif tid = 4820 then ciooracle_object_type.traverse_to_root(cid,eid,true);
Element type appcon... elsif tid = 4834 then cioapp_con_interface.traverse_to_root(cid,eid,true);
Element type itm... elsif tid = 4837 then ciodatastructure_item.traverse_to_root(cid,eid,true);
Element type dat... elsif tid = 4841 then ciodatastructure.traverse_to_root(cid,eid,true);
Element type dbu... elsif tid = 4856 then ciodatabase_user.traverse_to_root(cid,eid,true);
Element type dbugrp... elsif tid = 4857 then ciodatabase_user_role.traverse_to_root(cid,eid,true);
Element type ccd... elsif tid = 4863 then ciocluster_column.traverse_to_root(cid,eid,true);
Element type relend... elsif tid = 4865 then ciorelationship_end.traverse_to_root(cid,eid,true);
Element type vwtab... elsif tid = 4866 then ciorelation_selection.traverse_to_root(cid,eid,true);
Element type oco... elsif tid = 4867 then cioconstraint.traverse_to_root(cid,eid,true);
Element type ind... elsif tid = 4869 then cioindex.traverse_to_root(cid,eid,true);
Element type indcol... elsif tid = 4870 then cioindex_entry.traverse_to_root(cid,eid,true);
Element type mod... elsif tid = 4871 then ciomodule.traverse_to_root(cid,eid,true);
Element type modcol... elsif tid = 4872 then ciomodule_ RME-02123: Failed to parse SQL statement RME-02105: Oracle error occurred... ORA-00604: error occurred at recursive SQL level 2 ORA-04031: unable to allocate 4216 bytes of shared memory ("shared pool","select i.obj#,i.ts#,i.file#,...","sga heap","library cache")

ORA-00604: error occurred at recursive SQL level

It could be some SGA parameter values were not set up big enough. But one cant really deduct this from the shown messages. I would be grateful for some hints. Received on Fri Sep 01 2000 - 17:16:46 CDT