RE: 11g RAC orapw file issue- RAC nodes not updated
Date: Tue, 22 Mar 2011 11:09:19 -0400
Message-ID: <B8CFC366C968D84FB8241B6E6B0EA19A05F2074A_at_misout7msgusr82.ITServices.sbc.com>
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_at_the-playground.de]
Sent: Tuesday, March 22, 2011 4:36 AM
To: CRISLER, JON A (ATTCORP)
Cc: Martin Bach; cicciuxdba_at_gmail.com; testaj3_at_nationwide.com; Uzzell,
Stephan; oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org
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_at_the-playground.de]
> Sent: Monday, March 21, 2011 4:39 AM
> To: cicciuxdba_at_gmail.com; TESTAJ3_at_nationwide.com
> Cc: 'Uzzell, Stephan'; CRISLER, JON A (ATTCORP);
oracle-l_at_freelists.org;
> oracle-l-bounce_at_freelists.org
> 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
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 22 2011 - 10:09:19 CDT