Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can't grant SYSOPER or SYSDBA in VMS 10gR2 Cluster
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.orgReceived on Fri Jan 26 2007 - 14:22:18 CST