Hi,

OS AIX 5L
DB Oracle 9.2.0.1

Im a new hired dba for a banking company. They have two nodes,
the PROD server and the DEV server which are clustered. They also
have a 3rd party apps which is SAP financials. The SAP team
developers where the one who set-up their apps and the ORACLE
9.2.0.1 database on the two nodes. I presumed they clustered it .
As the new dba Im i little bit cunfused about clustered database. As what I understood it is the same as the RAC right? Two instances on
two oracle homes running against 1 shared database? But the set-
up here is quite different. The PROD server it has its own PROD database and PROD instance. and in DEV server has its own DEV
database and instance too, just like stand alone set-up. But the two
are clustered. Is this kind of clustering valid?

My problem now is...im task to install the patch 9.2.0.5 on both
nodes (oracle homes). So i installed first on the DEV node (not
knowing at first that they are clustered...i thot at first they are a
stand alone set-up). I successfully patched the DEV oracle home.
Then I transferred to the PROD node and try to install the patch
again. To my surprise I cant install the patch because is
says "Theres no patch that needs to be installed".
I tried to run sqlplus on DEV node and the version is now 9.2.0.5
while the sqlplus on PROD is still 9.2.0.1.

Can you help me pls how to patch the PROD node? Im afraid to
experiment other options coz its a PRODUCTION db and I might mess
it up. What do u think did i miss here. I read also that if u are to
patch a cluster u have to run the root.sh to all the nodes. So in my
case since i patched first the DEV node, do i need to copy/ftp
the root.sh found on the DEV ORACLE_HOME to the PROD
ORACLE_HOME and run it? Will running the root.sh alone update or
upgrade the sqlplus version on PROD to 9.2.0.5?

Thanks a lot