Error creating designer repository owner schema on 8.1.5 server
Date: Sat, 02 Sep 2000 00:19:32 +0200
Message-ID: <39B02B74.32DF2B7E_at_online.de>
[Quoted] 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 Sat Sep 02 2000 - 00:19:32 CEST