Oracle Server - Help Us Please.....Patch Question.

Author

Help Us Please.....Patch Question.

amerar@iwc.net

2006-01-26, 4:54 pm

Hi All,

We are running Oracle 9.2.0.7 on AIX. We are trying to apple the
latest patch: 4759123 - CPUJan2006

We receive the following error from OPatch:

System Command: /ora2/app/oracle/product/9i/jre/1.4.2/bin/java
-Dopatch.retry=10 -Dopatch.delay=30 -classpath
"/ora2/app/oracle/product/9i/oui/jl
ib/OraInstaller.jar:/ora2/app/oracle/product/9i/oui/jlib/srvm.jar:/ora2/app/oracle/product/9i/OPatch/jlib/opatch.jar:/ora2/app/oracle/product/9i/oui/j
lib/xmlparserv2.jar:/ora2/app/oracle/product/9i/oui/jlib/share.jar"
opatch/CheckConflict "/ora2/app/oracle/product/9i/oui"
"/ora2/app/oracle/product/9
i" opatch.pl 1.0.0.0.53 4751923 "4754842 4547566 2701372 4567971
4567854 3119415 4572340 4049345 4751923 4547641 "
/subs/db/patches/4751923/etc/config
/actions

Result:
SKIPPING_COMPONENT=o
racle.rdbms,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.oid.client,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.emprod.oemagent.base_oemagent,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.options.olap.cwmlite,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.rsf.net_rsf,9.2.0.7.0

MISSING_COMPONENT : oracle.rsf.rdbms_rsf, 9.2.0.7.0
SKIPPING_COMPONENT=o
racle.rsf.nlsrtl_rsf,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.cartridges.context,9.2.0.7.0

SKIPPING_COMPONENT=o
racle.rdbms,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.oid.client,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.emprod.oemagent.base_oemagent,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.options.olap.cwmlite,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.rsf.net_rsf,9.2.0.7.0

MISSING_COMPONENT : oracle.rsf.rdbms_rsf, 9.2.0.7.0
SKIPPING_COMPONENT=o
racle.rsf.nlsrtl_rsf,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.cartridges.context,9.2.0.7.0

SKIPPING_COMPONENT=o
racle.rdbms,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.oid.client,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.emprod.oemagent.base_oemagent,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.options.olap.cwmlite,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.rsf.net_rsf,9.2.0.7.0

MISSING_COMPONENT : oracle.rsf.rdbms_rsf, 9.2.0.7.0
SKIPPING_COMPONENT=o
racle.rsf.nlsrtl_rsf,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.cartridges.context,9.2.0.7.0

This Oracle Home does not have components/versions required by the
patch.

Can anyone help? I cannot find any information on this, and, Oracle
has not responded to our ITar.......

bdbafh@gmail.com

2006-01-26, 4:54 pm

did you set the environment variable ORACLE_HOME prior to applying the
patch?

did you issue something along the lines of

perl <path_to_OPatch>/opatch.pl lsinventory

prior to

perl <path_to_OPatch>/opatch.pl apply

If it does not see the rdbms components, something must be seriously
wrong.

hth

-bdbafh

amerar@iwc.net

2006-01-26, 4:54 pm

$ORACLE_HOME is set to: /ora2/app/oracle/product/9i

LSINVENTORY gave me this output:

../opatch lsinventory
PERL5LIB=/ora2/app/oracle/product/9i/Apache/perl/lib/5.00503:./perl_modules;
export PERL5LIB
/ora2/app/oracle/product/9i/Apache/perl/bin/perl ./opatch.pl
lsinventory
Using ORACLE_HOME/oui to look up oui libs...

Oracle Home = /ora2/app/oracle/product/9i
Location of Oracle Inventory = /ora2/app/oracle/product/9i/inventory
Oracle Universal Installer shared library =
/ora2/app/oracle/product/9i/oui/lib/aix/liboraInstaller.so
Path to Java = /ora2/app/oracle/product/9i/jre/1.4.2/bin/java
Location of Oracle Inventory Pointer = /etc/oraInst.loc
Location of Oracle Universal Installer components =
/ora2/app/oracle/product/9i/oui
Required Jar File under Oracle Universal Installer =
jlib/OraInstaller.jar

Using ORACLE_HOME/oui to look up oui libs...

Accessing inventory... This may take up to 300 seconds.
(retry 10 times, delay 30 seconds each time)
/ora2/app/oracle/product/9i/jre/1.4.2/bin/java -classpath
"/ora2/app/oracle/product/9i/oui/jlib/OraInstaller.jar:/ora2/app/oracle/product/9i/oui/jlib/
srvm.jar:./jlib/opatch.jar:/ora2/app/oracle/product/9i/oui/jlib/xmlparserv2.jar:/ora2/app/oracle/product/9i/oui/jlib/share.jar:."
-Dopatch.retry=10 -
Dopatch.delay=30 opatch/LsInventory "/ora2/app/oracle/product/9i/oui"
"/ora2/app/oracle/product/9i" opatch.pl 1.0.0.0.50 FALSE
Retrieving inventory.

Installed Patch List:
====================
=
1) Patch 4560421 applied on Mon Nov 28 08:36:43 CST 2005
[ Base Bug(s): 3504220 4312525 3301573 3323435 3863021 4017526
4180561 3518624 3382229 4049345 3591119 3329096 3703478 4383771 3663924
4567951 3
990826 3835964 3737955 3739819 3289786 3858398 4415230 3150750 3611471
3187502 3253770 4316177 3371861 4405919 3356951 4386775 3390021 3320622
2701372
4343714 3566420 2747350 3467364 3724548 4185276 3545539 4199435
3653586 4392388 4193299 3890898 4457989 4051811 4078123 3785200 3354470
3317309 41751
62 3566511 3569503 3564337 2628067 4493075 3780672 4365348 4367445
3557842 3949307 3963167 3789406 3889519 3485997 4003006 3589588 3200136
3110547 331
8204 3455402 2920562 3381218 3583215 4370067 3910149 2455147 4523473
4509137 4126826 3315378 3398205 3944226 3029367 3407944 3443747 3447383
3294293 4
057729 2549574 3406977 3749490 3638695 3984786 3414440 3262241 2690205
4167403 3473315 3346154 4085118 3816821 3057951 4392256 2918138 3425298
3691672
3828166 3554954 3867193 2964692 3194997 4560421 4530308 4292151
3275045 3832631 3811906 3808090 4333952 2546446 3808093 4266635 3641963
3717619 39736
36 4269869 3010227 4184031 3562032 3635331 3664007 4019454 3827053
3560890 3537086 3455357 3635177 3614289 4387084 3487338 3743946 3177769
3672985 ]

../opatch.pl version: 1.0.0.0.50
Copyright (c) 2001-2004 Oracle Corporation. All Rights Reserved.

Does that help any??

bdbafh@gmail.com

2006-01-26, 4:54 pm

> does this help?

yes - it sure does.

upgrade opatch to v 1.0.0.0.55
simple search
p2617419 - generic.

that should do it.

-bdbafh

Anurag Varma

2006-01-26, 4:54 pm

amerar@iwc.net wrote:
--snip--
>
> ./opatch.pl version: 1.0.0.0.50
> Copyright (c) 2001-2004 Oracle Corporation. All Rights Reserved.
>
> Does that help any??

You are using quite an old version of opatch. Which tells me that you
have not been reading the readme for the patch you are applying.
A very bad idea to not read the full instructions of applying the
patch.
It states there clearly to upgrade to latest opatch before applying.

Anurag

amerar@iwc.net

2006-01-26, 4:54 pm

Upgraded to OParch 1.0.0.0.55. Looks like the same result:

System Command: /ora2/app/oracle/product/9i/jre/1.4.2/bin/java
-Doracle.installer.invPtrLoc=/etc/oraInst.loc -Dopatch.retry=10
-Dopatch.delay=30 -
classpath
"/ora2/app/oracle/product/9i/oui/jlib/OraInstaller.jar:/ora2/app/oracle/product/9i/oui/jlib/srvm.jar:/ora2/app/oracle/product/9i/OPatch/jlib
/opatch.jar:/ora2/app/oracle/product/9i/oui/jlib/xmlparserv2.jar:/ora2/app/oracle/product/9i/oui/jlib/share.jar"
opatch/CheckConflict "/ora2/app/oracl
e/product/9i/oui" "/ora2/app/oracle/product/9i" opatch.pl 1.0.0.0.55
4751923 "4754842 4547566 2701372 4567971 4567854 3119415 4572340
4049345 4751923
4547641 " /subs/db/patches/4751923/etc/config/actions
Result :

SKIPPING_COMPONENT=o
racle.rdbms,9.2.0.7.0

SKIPPING_COMPONENT=o
racle.oid.client,9.2.0.7.0

SKIPPING_COMPONENT=o
racle.emprod.oemagent.base_oemagent,9.2.0.7.0

SKIPPING_COMPONENT=o
racle.options.olap.cwmlite,9.2.0.7.0

SKIPPING_COMPONENT=o
racle.rsf.net_rsf,9.2.0.7.0

MISSING_COMPONENT : oracle.rsf.rdbms_rsf, 9.2.0.7.0

SKIPPING_COMPONENT=o
racle.rsf.nlsrtl_rsf,9.2.0.7.0

SKIPPING_COMPONENT=o
racle.cartridges.context,9.2.0.7.0

SKIPPING_COMPONENT=o
racle.rdbms,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.oid.client,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.emprod.oemagent.base_oemagent,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.options.olap.cwmlite,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.rsf.net_rsf,9.2.0.7.0

MISSING_COMPONENT : oracle.rsf.rdbms_rsf, 9.2.0.7.0
SKIPPING_COMPONENT=o
racle.rsf.nlsrtl_rsf,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.cartridges.context,9.2.0.7.0

SKIPPING_COMPONENT=o
racle.rdbms,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.oid.client,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.emprod.oemagent.base_oemagent,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.options.olap.cwmlite,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.rsf.net_rsf,9.2.0.7.0

MISSING_COMPONENT : oracle.rsf.rdbms_rsf, 9.2.0.7.0
SKIPPING_COMPONENT=o
racle.rsf.nlsrtl_rsf,9.2.0.7.0
SKIPPING_COMPONENT=o
racle.cartridges.context,9.2.0.7.0

This Oracle Home does not have components/versions required by the
patch.

ERROR: OPatch failed during pre-reqs check.

We are running Oracle 9.2.0.7

Joel Garry

2006-01-26, 4:54 pm

Are you in the directory where the patch is? Did you download the
right patch? I think you get that sort of error when it can't find the
patch you are trying to apply, judging from Note: 338338.1.

jg
--
@home.com is bogus.
"chatr on PA system lies about IA executable"
"chatr says file may be corrupt when it is not, scary message" - from
hpux patch description.

amerar@iwc.net

2006-01-26, 4:54 pm

Yes, I am in the directory. This patch, 3741932, is meant for the
9.2.0.7 database.........so, I'm a bit lost here.

Joel Garry

2006-01-26, 5:38 pm

Perhaps to alleviate confustion:

Which exact OS are you using? Which exact patch are you applying?

jg
--
@home.com is bogus.
I suppose it is better when they burst out laughing then when they
burst out crying.
http://www.zdnet.com.au/news/securi...
8,00.htm

Mladen Gogala

2006-01-27, 3:23 am

On Thu, 26 Jan 2006 09:25:23 -0800, Anurag Varma wrote:

> amerar@iwc.net wrote:
> --snip--
>
> You are using quite an old version of opatch. Which tells me that you
> have not been reading the readme for the patch you are applying. A very
> bad idea to not read the full instructions of applying the patch.
> It states there clearly to upgrade to latest opatch before applying.
>
> Anurag

Anurag, are you sure that something like the text below is clear enough?
It doesn't do good enough job to persuade me not to use the old opatch.

####################
####################
####################
##########
#
# Please Note:
# ************
# You should not use OPatch version 10.2.0.1 that is available in
# your ORACLE_HOME, the new OPatch version 10.2.0.1.1 is available
# in the Metalin ARU 8101197, and the bug number is 4898608. Only
# this OPatch should be used to apply this Patch.
#
# Refer to the following link for details on Perl and OPatch:
# http://updates.oracle.com/download/4898608.html
#
####################
####################
####################
#########

How in the world should I know not to use the old opatch? It's not even
color coded! It should be displayed in blinking red color, with half an
inch font. Polka dots all over the document would also be a good idea,
preferably the blue ones. Also, a flash animation with the the song "The
End" by the Doors would hint that there is some danger in the air. If
that's too old, then the song "It's my life" by Bon Jovi would probably
attract some attention as well.

--
http://www.mgogala.com

Sponsored Links