RE: rman errors
Date: Sat, 28 Feb 2009 12:06:48 -0500
What Tanel wrote, plus, a common reason for the patched binary(ies) to not actually get slapped into place is if another instance on that node is running the same binary (or one of the tools is being executed while the relink is supposed to happen). Less common is an improperly killed process still having a file handle on the executable that you're trying to replace. I would think your logs from patching would show the failure, but looking at the date last modified for the files in your "oracle" bins and library might also be useful.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tanel Poder
Sent: Saturday, February 28, 2009 7:51 AM To: Brian.Zelli_at_RoswellPark.org; 'Oracle-L Group' Subject: RE: rman errors
Every parameter has an internal constant number associated with it. These numbers may change between releases/patchsets as new parameters are added (and some removed).
The Oracle binary patching works roughly like this on Unix:
- replace the Oracle kernel module files (.o or .so files) in libserver.a with new versions
- relink Oracle and tools (relink takes the module files from libserver.a and links them to oracle binary)
So I suspect something failed either in step 1 or 2.
You can start with relinking Oracle binary and all the tools (rman too).
If it still doesn't work, then compare the contents of libserver.a's on both installations.
Btw, are you running RMAN from the patched Oracle home and not the old one, right?
-- Regards, Tanel Poder http://blog.tanelpoder.comReceived on Sat Feb 28 2009 - 11:06:48 CST
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Zelli, Brian
> Sent: 28 February 2009 13:46
> To: Oracle-L Group
> Subject: rman errors
> I upgraded yesterday from 10.2.0.1 to 10.2.0.4 and now I get
> this error when running rman:
> RMAN-10002: ORACLE error: ORA-00096: invalid value SIGNATURE
> for parameter remote_dependencies_mode, must be from among
> 10.2.0.4.1, 10.2.0.4, 10.2.0.3,10.2.0.2 , 10.2.0.1, 10.1.0.5,
> 10.1.0.4, 10.1.0.3, 10.1.0, 220.127.116.11, 9.2.0, 9.0.1, 9.0.0,
> 8.1.7, 8.1.6, 8.1.5, 8.1.4, 8.1.3, 8.1.0
> I set the init parameter remote_dependencies_mode=SIGNATURE
> and that still failed with the same error.
> I set it back to TIMEZONE which is the default and that
> doesn't work.Docs say it's one or the other.
> What am I missing?
> Funny thing is I upgrade another instance earlier in the week
> that was exactly the same and I am not having this problem.
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l