Re: Designer/2000 - Help! ... Cannot create Application System

After spending a whole Saturday night (sad), I have finally found the solution. If you are using Designer (any version) with 8.1.6 you need to set the large_pool_size parameter in init.ora and not shared_pool_size as stated in the manual.

If you are experiencing this problem with anything before 8.1.6 you probably would need to increase the shared_pool_size.

By the way Oracle didn't come back with an solution. It amazes me that Oracle can charge so much for support when they don't provide any. This is third TAR that we have to solve ourselves. That is three out four in two years.

PC

In article <8cl6mm$3s3$1_at_nnrp1.deja.com>,   private_comm_at_my-deja.com wrote:
> I have exactly the same problem but my system is 8.1.6 on NT4SP6. I
> have exactly the same error messages and I've checked for all the
> obvious. I have a TAR with supprt and will post the soloution when
> they they come back to me.
>
> PC
>
> In article <8ckqil$lvm$1_at_nnrp1.deja.com>,
> tomvamos_at_my-deja.com wrote:
> > Yep ... I followed all the 'repos_owner' instructions very
 specifically.
> >
> > In article <8ckl81$fra$1_at_nnrp1.deja.com>,
> > derwin_at_my-deja.com wrote:
> > > You did do the sys grants to DBMS_PIPE and DBMS_LOCKS right? Those
> > > are a must.
> > >
> > > In article <8ckh4t$bob$1_at_nnrp1.deja.com>,
> > > tomvamos_at_my-deja.com wrote:
> > > > Hi Joel,
> > > > Thanks for the advice, but all the checks are OK: the required
> > > > privileges are there and there are no invalid pacakages. I
 recreated
> > > > the repos. but the same thing happens.
> > > > Do you have any other suggestions?
> > > >
> > > > In article <38ECA900.6A7C2268_at_canadapost.ca>,
> > > > Joel Racicot <joel.racicot_at_canadapost.ca> wrote:
> > > > > Tom,
> > > > >
> > > > > Check to make sure that you granted all the required
 privileges
 to
 the
> > > > > repository owner when you created the repository orignally,
 then
 check
> > > > > for any invalid or missing packages.
> > > > >
> > > > > It sounds like you have an invalid package.
> > > > >
> > > > > Hope this helps.
> > > > >
> > > > > Joel
> > > > >
> > > > > tomvamos_at_my-deja.com wrote:
> > > > >
> > > > > > Hi there,
> > > > > > I have a Designer/2000 error I can't get round
> > > > > > regardless of how many times I've reinstalled and
> > > > > > recreated. Please help if you can.
> > > > > >
> > > > > > Having created a repository, I go in to Designer
> > > > > > and try to create an Application System by simply
> > > > > > typing a name and pressing 'Create' in
> > > > > > the 'Application System' dialog. However, I
> > > > > > always get the following error:
> > > > > >
> > > > > > ORA-01403: no data found
> > > > > >
> > > > > > .. which comprises of (please excuse the block of
> > > > > > text) :
> > > > > >
> > > > > > 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 "REPOS_OWNER.RMMES", line 157
> > > > > > ORA-06512: at line 3
> > > > > > ORA-01403: no data found
> > > > > >
> > > > > > Can anyone explain / help with this problem?
> > > > > > Thanks in advance ...
> > > > > >
> > > > > > Tom Vamos
> > > > > >
> > > > > > Sent via Deja.com http://www.deja.com/
> > > > > > Before you buy.
> > > > >
> > > > >
> > > >
> > > > Sent via Deja.com http://www.deja.com/
> > > > Before you buy.
> > > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat May 06 2000 - 00:00:00 CEST