Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> how to alter a sysdba privileged user on RAC?
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 SYSOPSQL>
------------------------------ ----- -----
SYS TRUE TRUE PWTEST TRUE TRUE
--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
![]() |
![]() |