Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can't grant SYSOPER or SYSDBA in VMS 10gR2 Cluster

Re: Can't grant SYSOPER or SYSDBA in VMS 10gR2 Cluster

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 26 Jan 2007 12:22:18 -0800
Message-ID: <1169842935.451093@bubbleator.drizzle.com>


Malcolm Dunnett wrote:
> This is my first RAC setup, so forgive me if this is a stupid question:
>
> I have set up a two node RAC cluster with Oracle 10.2.0.2. Each node is an
> rx2600 (Itanium) system running VMS 8.3. Everything seems to be working fine
> so far except than I can't grant SYSDBA or SYSOPER privileges to any users,
> when I try I get an:
>
> ORA-29701: unable to connect to Cluster Manager
>
> all other command work fine, I can grant any other role or privilege. I
> presume it has something to do with these privs being stored in the password
> file and each node having a separate password file.
>
> From the documentation it appears the "cluster manager" it is talking about
> is the VMS clustering software itself, that is working properly.
>
> Anyone else seen this? Bug or configuration problem?

It would be helpful to see what it is you are actually doing and in what tool? I could make assumptions, SQL*Plus vs. Server Manager, but an explicit example would remove any ambiguity. Also, are you trying to connect to an instance or the database or a service?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Jan 26 2007 - 14:22:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US