RE: 11g RAC orapw file issue- RAC nodes not updated
Date: Mon, 21 Mar 2011 10:56:12 -0400
Message-ID: <B8CFC366C968D84FB8241B6E6B0EA19A05F200A4_at_misout7msgusr82.ITServices.sbc.com>
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 Mon Mar 21 2011 - 09:56:12 CDT