Re: Designer 2000 / Pb with installation

Hi Sylvie,

Did you grant execute privilegies on SYS.DBMS_SQL and SYS.DBMS_LOCK to the repository owner directly (not via role)? Check it and try to install the repository again. I remember this problem...

Let me know if you still have the problem.

Good Luck!
Valeri

Sylvie Picouet wrote:
>
> It was Designer 2000 v2.1.1. for NT4.
>
> The problem occured during the installation of the repository at a time
> where the installation should proceed without any intervention.
>
> I had the following messages :
> ORA-00942: table or view does not exist
> RME-02124: Failed to execute SQL statement: UPDATE CK_INSTALLED_OBJECTS CI
> SET CI.CI_CREATED='Y' WHERE CI.CI_STAGE='PRECHECK' AND EXISTS(SELECT 1 FROM
> ALL_SOURCE AO WHERE AO.NAME=CI.CI_NAME AND AO.TYPE= 'PACKAGE')
> RME-02123: Failed to parse SQL statement
> RME-02105: Oracle error occurred...
> CDI-21239 : Error while populating CK_installed_objects
>
> But, with Designer 2000 on my machine, and before I tried to install the
> Designer Repository, I already had some problems with database connections,
> because even If I was with an Oracle 7 version, it tried to use
> a tnsname.ora file in a directory for version 8 (I had to copy the
> listener.ora and tnsname.ora files from 'network' (oracle 7) to net80
> (oracle 8)). I was wondering If the problem for the installation of the
> Designer Repository could'nt come from the same point ...
>
> Do you have enough information to understand my problems ?
>
> Thanks,
>
> Sylvie.
>
> Kekko wrote in message <37318E97.5E77EBB8_at_adr.it>...
> >Which are exactly your problems?
> >J have some problems with the installation of release 2.1.2. The October
> 1998
> >Patch doesn't install.
> >Ciao,
> >Francesco
> >
> >Sylvie Picouet wrote:
> >
> >> Hi,
> >>
> >> Does Designer 2000 work on Oracle 7 ?
> >>
> >> I could'nt manage to install it. I had problems when I wanted to install
> the
> >> Repository.
> >>
> >> I dropped Oracle7, and I did install Designer 2000 on Oracle 8, with non
> >> problem at all.
> >> I need to install it on Oracle7.
> >> Does anyone manage to install Designer 2000 on Oracle 7 ?
> >>
> >> Thanks,
> >>
> >> Sylvie.
> >

-- 
Valeri Sorokine
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
http://www.dd.ru