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: how to alter a sysdba privileged user on RAC?

Re: how to alter a sysdba privileged user on RAC?

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 29 Aug 2005 18:25:24 -0700
Message-ID: <1125365124.362975.244960@z14g2000cwz.googlegroups.com>


SP wrote:
> Here is my problem:
>
> node1:
> select * from v$pwfile_users;
> USERNAME SYSDBA SYSOPER
> -------- ------ -------
> SYS TRUE TRUE
>
> node2:
> select * from v$pwfile_users;
> USERNAME SYSDBA SYSOPER
> -------- ------ -------
> SYS TRUE TRUE
>
> from node1:
> ALTER USER "pwtest" IDENTIFIED BY "PWTEST";
> user altered
> grant sysdba to pwtest;
> grant succeeded
> sqlplus /nolog
> SQL>
> SQL>connect pwtest/pwtest_at_drac1 as sysdba
> connected.
> SQL>select * from v$pwfile_users;
>
> USERNAME SYSDB SYSOP
> ------------------------------ ----- -----
> SYS TRUE TRUE
> PWTEST TRUE TRUE
> SQL>
> node 1 is all fine.
>
> --now connect to node 2.
> SQL>sqlplus /nolog
> connect pwtest/pwtest_at_drac2 as sysdba
> ERROR:
> ORA-01031: insufficient privileges
>
> Warning: You are no longer connected to ORACLE.
>
> When I login as sys in node 2 and do select * from v$pwfile_users
> "pwtest" user doesn't exist there. So obviously the change didn't go
> through in node2. I have to use the old password (non sysdba user) to
> successfully login.
> SO how do I alter sysdba privileged user on RAC?
>
> Oracle EE 9.2.0.4 (two node RAC) on Linux RH 2.1 Advanced server
> Thanks,
> SP

Not sure how well documented this is but you need to grant these privileges on all the different RAC nodes if you are not using a clustered file system. These changes go into the password file which on a RAC system is mandatory to use. Received on Mon Aug 29 2005 - 20:25:24 CDT

Original text of this message

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