Re: Error Installing Repository Instance with 9.0.2

On Thu, 6 Jun 2002 10:35:31 -0400, "Erik Wynn" <ewynn_at_wsdgnet.com> wrote:

>Hi,
>
>I have just installed Oracle Developer Suite (9.0.2), and am trying to
>install a new repository. I am connecting to an Oracle 9i Server (running
>on Windows 2000), and am getting the following error message when I try to
>install a repository intance with the Repository Administration Utility:
>
> ERROR
> You do not have SELECT Privilege on sys.V_$PARAMETER view.
> This process cannot proceed.
>
>The view sys.V_$PARAMETER does exist (verified by the Oracle Enterprise
>Manager Console on the server).
>
>I tried to do a:
>
> grant select on sys.V_$PARAMETER to pmfadmin
>
>from SQL Plus, when logged on a system/manager (where pmfadmin is the user
>name that will be installing the repository), but I get an "insufficient
>privileges" error from SQL Plus. FWIW, pmfadmin already has pretty much
>full dba priviliges.
>
>Has anynone else had this kind of problem? Any idea what I can do to get
>around it?
>
>Thanks!
>
>Erik
>
>
>
If you are not the owner of the object (and SYS is the owner) you cannot grant it to anyone unless the owner has granted it to you WITH GRANT OPTION (and SYS didn't)
Solution: you need to connect as SYS
Please read up on object privileges in your documentation.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jun 06 2002 - 20:43:57 CEST