Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Oracle / Oracle Server / August 2005

Tip: Looking for answers? Try searching our database.

how to alter a sysdba privileged user on RAC?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SP - 30 Aug 2005 01:07 GMT
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@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@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
hpuxrac - 30 Aug 2005 02:25 GMT
> Here is my problem:
>
[quoted text clipped - 45 lines]
> 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.
SP - 30 Aug 2005 05:15 GMT
I ran the 'alter user identified by...' and 'grant sysdba...' statement
on second node too and that seem to have worked.  Not sure whether this
is a bug or is supposed to be this way.  We are using OCFS...
Thanks,
SP
DA Morgan - 30 Aug 2005 08:58 GMT
> I ran the 'alter user identified by...' and 'grant sysdba...' statement
> on second node too and that seem to have worked.  Not sure whether this
> is a bug or is supposed to be this way.  We are using OCFS...
> Thanks,
> SP

Supposed to be that way.

BTW: Oracle is likely dropping support for OCFS in a near-term
future release. You might want to start looking at RAW and ASM.
Signature

Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

Mladen Gogala - 30 Aug 2005 11:38 GMT
> Supposed to be that way.
>
> BTW: Oracle is likely dropping support for OCFS in a near-term
> future release. You might want to start looking at RAW and ASM.

Or to look into Red Hat's GFS, VxFS (Veritas) or Polyserve solutions.
ASM is just a volume manager, and the very first generation at that. We
all know how stable and reliable is that. Oracle 9i is a complete disaster
as far as reliability and bug fixing is concerned. That is probably the
absolute low of Oracle Corp., before version 10, of course. I wouldn't
entrust my data to ASM just yet. OCFS sucks anyway.

Signature

http://www.mgogala.com

hpuxrac - 30 Aug 2005 14:40 GMT
> ASM is just a volume manager, and the very first generation at that. We
> all know how stable and reliable is that. Oracle 9i is a complete disaster
> as far as reliability and bug fixing is concerned. That is probably the
> absolute low of Oracle Corp., before version 10, of course. I wouldn't
> entrust my data to ASM just yet. OCFS sucks anyway.

Why not tell us how you really feel about it?  ( kidding )
DA Morgan - 30 Aug 2005 17:13 GMT
>>Supposed to be that way.
>>
[quoted text clipped - 7 lines]
> absolute low of Oracle Corp., before version 10, of course. I wouldn't
> entrust my data to ASM just yet. OCFS sucks anyway.

ASM just a volume manager? Hardly.

Name a volume manager capable of load balancing i/o.

Name a volume manager capable of moving hot blocks to the outside of the
disk.

Name a volume manager that uses as little CPU.

Name a volume manager that doesn't involve adding an additional
company's software into an already complex technology stack.

Name a volume manager that is free (no additional cost).

Name a volume manager that is operating system independent.

My suspicion is that your lack of experience with ASM is shading
your opinion.
Signature

Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

Mladen Gogala - 31 Aug 2005 12:47 GMT
> ASM just a volume manager? Hardly.

Actually, it manages storage and it is an interface to raw partitions.
That is what volume managers do.

> Name a volume manager capable of load balancing i/o.

EMC

> Name a volume manager capable of moving hot blocks to the outside of the
> disk.

I am not 100% certain but I am pretty sure that EMC can do that.

> Name a volume manager that uses as little CPU.

All of them. Volume managers do not use much CPU.

> Name a volume manager that doesn't involve adding an additional
> company's software into an already complex technology stack.

Linux LVM.

> Name a volume manager that is free (no additional cost).

Linux LVM.

> Name a volume manager that is operating system independent.

Veritas. Works on HP-UX, AIX, Solaris and Linux.

> My suspicion is that your lack of experience with ASM is shading your
> opinion.

My lack of experience? What do you know about me or my experience? I don't
remember sending you my resume? I don't run ASM in production, mostly
because I don't run 10g in production. I have set up a firewire cluster
and used ASM. Nothing special there. The problem with ASM is that I cannot
back it up without RMAN. With a clustered file system I can use tar, cpio,
NetBackup (my favorite flavor of enterprise backup software) or even plain
ol' copy command. I haven't set up 10gR2 cluster, it was 10.1.0.3, but
what I saw did not overly impress me. It's not my fault if you've never
seen a volume manager before or if you don't know what volume managers are
for.

Signature

http://www.mgogala.com

DA Morgan - 31 Aug 2005 15:22 GMT
>>Name a volume manager capable of load balancing i/o.
>
> EMC

Last time I looked EMC was not a volume manager. Correct me
if I am wrong but I doubt any EMC solution is going to run
on an IBM Shark, NetApp FAS270, or other hardware.

>>My suspicion is that your lack of experience with ASM is shading your
>>opinion.
>
> My lack of experience? What do you know about me or my experience? I don't
> remember sending you my resume?

Please note my use of the word "suspicion." It was put there for
a reason. One need not have a copy of your resume to have a suspicion.
Signature

Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

SP - 30 Aug 2005 19:16 GMT
"Oracle is likely dropping support for OCFS in a near-term
future release"
Has Oracle announced it already?  Where can I get more details about
this?
Thanks,
SP
DA Morgan - 30 Aug 2005 20:06 GMT
> "Oracle is likely dropping support for OCFS in a near-term
> future release"
> Has Oracle announced it already?  Where can I get more details about
> this?
> Thanks,
> SP

Nothing official. Just comments made during discussions in
Redwood Shores. I'm passing it along so you can plan ahead
if it happens.

OCFS is open-source and adopted by Oracle to solve a specific
problem, in a previous version, that no longer exists. Thus
no real need for them to continue OCFS support into the
future. Especially when ASM on RAW is far superior.
Signature

Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.