Re: Designer 2000 Install Problem

Using sql*plus, log on as sys and issue the following commands: Vince Cross wrote:
>
> I am trying to install Designer 2000 v1.1 on a Windows NT 3.51
 system with 64M
> of RAM. The server is Oracle v7.1.6 running on a HP 9000/715 with
 128M of RAM.
> I am using SQL*Net v1 TCP/IP to talk between the client and server.
 So far, I
> have two problems:
>
> 1. During the creation of the repository, I have two packages that
 fail to
> compile properly: RMDBG and RMMAC. When I try compile them by
 hand, the
> "show error" output indicates several lines complaining about
 DBMS_PIPE
> and DBMS_LOCK (PLS-201: identifier %s must be declared). Both
 DBMS
> packages show as valid, owned by SYS, and a public synonym with
 the same
> name. The respository owner has been granted execute on both
 packages.
> Why won't these packages compile?
>
> 2. When running the RAU to create the repository, after the objects
 are
> create on the server, it tries to go to the Maintain User tab
 and errors
> out: RME-00223: Failed to open new activity, RME-00222: Failed
 to dispatch
> operation to Repository, RME-00011:Operation 'open' on ACTIVITY
 has failed.
> "Show Cause/Action" does not show any other information. Is this
> somehow related to the first problem?
>
> Any help would be appreciated. After waiting 6 weeks for delivery
 of this
> software, I am pretty anxious to get it up and running. I really
 don't want
> to have to open a TAR and wait for another 4 weeks.
>
> Thanks,
> Vince Cross
> --
> * disclaimer - My views respresent NT/BNR in every way, NOT!
> NOTE - my real email address is bartok_at_bnr.ca, NOT vcross_at_bnr.ca
> * non-work related email to vlcross_at_aol.com (Having an AOL account
 doesn't
> make me a complete idiot. Excessive drinking makes me one.)

SQL> grant execute on dbms_pipe to <repository_owner> SQL> grant execute on dbms_lock to <repository_owner>

After that, log on as the <repository_owner> and recompile the failed scripts Received on Wed Dec 27 1995 - 00:00:00 CET