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

how to alter a sysdba privileged user on RAC?

From: SP <spantgroup_at_gmail.com>
Date: 29 Aug 2005 17:07:07 -0700
Message-ID: <1125360427.535551.151640@g43g2000cwa.googlegroups.com>


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 Received on Mon Aug 29 2005 - 19:07:07 CDT

Original text of this message

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