Re: Help on Designer/2000 on UNIX

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Thu, 28 Oct 1999 11:27:33 -0700
Message-ID: <38189595.D5CC258F_at_vnl.nl>


mdimper wrote:

> In article <3808E98D.FCD8614D_at_tin.it>, Pasquito <p.campo_at_tin.it> wrote:
> > I have installed Designer/2000 on NT 4.0 for Server UNIX HP-UX
> > 10.20
> > Oracle 8.0.5.
> > All rigth. No errors message. But when i try to make first
> > application
> > the system send me a error:
> > "operation 'INS' on ci_application_systems has fallied".
> > I have controlled package RMDBG and result INVALID, errors are for
> > package UTL_FILE (more that one) and DEFAULT_SWITCHES.
> > Can i do for fix this problem?
> > Tanks at all.
> > Pasquito
>
> You can use Repository administration utility to check and recreate
> designer package.
> You can recompile package with alter package command.
>
> If connection is made by an user that is not the owner of repository,
> check execution permission on package.
>
> You can create designer users by repository administration utility
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!

If RMDBG stays invalid, you miss execution rights on SYS.DBMS_PIPE and SYS.DBMS_LOCK. Have the dba grant execute rights on these two packages to the repository owner, and do a 'Full Reconcile' from the admin option.

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle

Work:                                Home:
----------------------------------   ----------------------------
Inter Access V&L                     Hunzestraat 4
Palatijn 3, 7521 PN Enschede         7555 WB Hengelo
PoBox 545, 7500 AM Enschede          (31)074-2425046
053-4341500
Received on Thu Oct 28 1999 - 20:27:33 CEST

Original text of this message