RE: 11g RAC orapw file issue- RAC nodes not updated

  • From: "CRISLER, JON A (ATTCORP)" <JC1706@xxxxxxx>
  • To: "Martin Bach" <development@xxxxxxxxxxxxxxxxx>
  • Date: Tue, 22 Mar 2011 11:09:19 -0400

This is very nice Martin !!  I will be testing it later today on a
system with 11gR2 Grid and 11gR1 RDBMS.

-----Original Message-----
From: Martin Bach [mailto:development@xxxxxxxxxxxxxxxxx] 
Sent: Tuesday, March 22, 2011 4:36 AM
To: CRISLER, JON A (ATTCORP)
Cc: Martin Bach; cicciuxdba@xxxxxxxxx; testaj3@xxxxxxxxxxxxxx; Uzzell,
Stephan; oracle-l@xxxxxxxxxxxxx; oracle-l-bounce@xxxxxxxxxxxxx
Subject: RE: 11g RAC orapw file issue- RAC nodes not updated

Good morning,

finished the blog post on the way home. How did a good friend of mine
say?
"Train time is think time". Anyone interested can get the script from
the
blog post, please read the comments, especially the bit about "it works
for me, that doesn't mean it works for you" ;) Careful testing the
script
in dev is essential here.

https://martincarstenbach.wordpress.com/2011/03/22/copying-the-password-
file-for-rac-databases/

Enjoy!

Martin
----
http://martinbach-consulting.com
http://martincarstenbach.wordpress.com
http://www.linkedin.com/in/martincarstenbach

> Good info Martin !!  If you could share your script with me, I would
be
> most appreciative.
>
>
>
> From: Martin Bach [mailto:development@xxxxxxxxxxxxxxxxx]
> Sent: Monday, March 21, 2011 4:39 AM
> To: cicciuxdba@xxxxxxxxx; TESTAJ3@xxxxxxxxxxxxxx
> Cc: 'Uzzell, Stephan'; CRISLER, JON A (ATTCORP);
oracle-l@xxxxxxxxxxxxx;
> oracle-l-bounce@xxxxxxxxxxxxx
> Subject: RE: 11g RAC orapw file issue- RAC nodes not updated
>
>
>
> Good morning,
>
>
>
> There are two aspects to this, I assume you are referring to the RDBMS
> $ORACLE_HOME/dbs directory. This has indeed to be maintained across
all
> cluster nodes. The same for the DR cluster-I have a small script that
> queries the OCR for all cluster members and uses the passwordless ssh
> authentication to copy the script across (mental node: need to extend
it
> to deal with data guard :)
>
>
>
> For ASM/Grid Infrastructure, things have been simplified - have a look
> at Harald van Brederode's blog:
>
>
>
>
http://prutser.wordpress.com/2011/01/14/clustered-asm-and-rac-password-f
> ile-maintenance/
>
>
>
> He says that for Grid Infrastructure the password file should
propagate
> to the local nodes.
>
>
>
> Best regards,
>
>
>
> Martin Bach
>
> ----
>
> http://martincarstenbach.wordpress.com
>
> http://www.linkedin.com/in/martincarstenbach
>
>


--
//www.freelists.org/webpage/oracle-l


Other related posts: