PORTAL patch 5024386 does not install PLSQL packages included in the patch
|
4397
2006-SEP-26 18:16:37
|
|
Moderator
|
|
|
Registered On: Mar 2006
Total Posts: 267
|
|
PORTAL patch 5024386 does not install PLSQL packages included in the patch
ISSUE:
=======
Applying patch# 5024386 which consits of number of PLSQL packages that need
to be loaded into PORTAL schema ... patch completes sucessfully but the
packages do not load -- in fact the patch tool never even makes an attempt to
connect to the database:
SOLUTION:
=========
set LD_LIBRARY_PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib; export LD_LIBRARY_PATH
echo $LD_LIBRARY_PATH
callisto.portal-> echo $LD_LIBRARY_PATH
/u01/app/oracle/product/10gAS/lib32:/u01/app/oracle/product/10gAS/lib
SOLUTION LOG:
==============
----------------- patch rollback ----------------------
callisto.portal-> cd $ORACLE_HOME/OPatch
./opatch rollback -silent -id 5024386 -ph /u01/app/oracle/patch/5024386
callisto.portal-> ./opatch rollback -silent -id 5024386 -ph /u01/app/oracle/patch/5024386
Oracle Interim Patch Installer version 1.0.0.0.55
Copyright (c) 2006 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com
Oracle Home = /u01/app/oracle/product/10gAS
Location of Oracle Universal Installer components = /u01/app/oracle/product/10gAS/oui
Location of OraInstaller.jar = "/u01/app/oracle/product/10gAS/oui/jlib"
Oracle Universal Installer shared library = /u01/app/oracle/product/10gAS/oui/lib/solaris/liboraInstaller.so
Location of Oracle Inventory Pointer = /var/opt/oracle/oraInst.loc
Location of Oracle Inventory = /u01/app/oracle/product/10gAS/inventory
Path to Java = /u01/app/oracle/product/10gAS/jdk/jre/bin/java
Log file = /u01/app/oracle/product/10gAS/.patch_storage/<patch ID>/*.log
Creating log file "/u01/app/oracle/product/10gAS/.patch_storage/5024386/RollBack_5024386_09-26-2006_16-18-16.log"
Invoking fuser to check for active processes.
Backing up comps.xml ...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /u01/app/oracle/product/10gAS)
Is this system ready for updating?
Please respond Y|N >
Y (auto-answered by -silent)
Executing the Roll-back pre-patch script (/u01/app/oracle/product/10gAS/.patch_storage/5024386/custom/scripts/pre)...
PERL5LIB=/u01/app/oracle/product/10gAS/perl/lib/5.6.1:/u01/app/oracle/product/10gAS/.patch_storage/5024386/custom/scripts/perl_modules; export PERL5LIB
/u01/app/oracle/product/10gAS/perl/bin/perl /u01/app/oracle/product/10gAS/.patch_storage/5024386/custom/scripts/pre.pl -rollback 5024386
.....................................................................
Please set your ORACLE_HOME to your 10.1.2 midtier installation home.
.....................................................................
Your ORACLE_HOME is /u01/app/oracle/product/10gAS
Your PERL5LIB is /u01/app/oracle/product/10gAS/perl/lib/site_perl/5.6.1/sun4-solaris:/u01/app/oracle/product/10gAS/perl/lib/5.6.1
Option c requires an argument
Welcome to Oracle Portal OneOffPatch Installer Version 3.0
Deinstalling Oneoff
Rolling back Portal Patch
CMD=./ptlpatch.csh -deinstall -b 5024386 -s -p -c
Removing patch 5024386...
Restoring copied files...
Updating inventory...
Backing up comps.xml ...
Inventory is good and does not have any dangling patches.
OPatch succeeded.
callisto.portal->
----------------- Verify inventory ----------------------
Installed Patch List:
=====================
1) Patch 4874299 applied on Mon Aug 28 09:36:56 PDT 2006
[ Base Bug(s): 4874212 ]
/u01/app/oracle/product/10gAS/portal/patch/oneoffs/4874299.txt --> OH/portal/patch/oneoffs
/u01/app/oracle/product/10gAS/portal/jlib/portaltools.jar --> OH/portal/jlib
/u01/app/oracle/product/10gAS/j2ee/OC4J_Portal/applications/portalTools/omniPortlet/WEB-INF/lib/__oracle_jsp_omniPortlet.war.jar --> OH/j2ee/OC4J_Portal/applications/portalTools/omniPortlet/WEB-INF/lib
----------------- set LD_LIBRARY_PATH ----------------------
LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib; export LD_LIBRARY_PATH
echo $LD_LIBRARY_PATH
callisto.portal-> echo $LD_LIBRARY_PATH
/u01/app/oracle/product/10gAS/lib32:/u01/app/oracle/product/10gAS/lib
----------------- Re-apply the patch ----------------------
cd $ORACLE_HOME/OPatch
./opatch apply -silent /u01/app/oracle/patch/5024386 -pre -s portal -p portpassword -c hostname.yourcompany.com:1521:YOURSID.yourcompany.com
callisto.portal-> cd $ORACLE_HOME/OPatch
./opatch apply -silent /u01/app/oracle/patch/5024386 -pre -s portal -p portpassword -c hostname.yourcompany.com:1521:YOURSID.yourcompany.com
callisto.portal-> ./opatch apply -silent /u01/app/oracle/patch/5024386 -pre -s portal -p portpassword -c hostname.yourcompany.com:1521:YOURSID.yourcompany.com
Oracle Interim Patch Installer version 1.0.0.0.55
Copyright (c) 2006 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com
Oracle Home = /u01/app/oracle/product/10gAS
Location of Oracle Universal Installer components = /u01/app/oracle/product/10gAS/oui
Location of OraInstaller.jar = "/u01/app/oracle/product/10gAS/oui/jlib"
Oracle Universal Installer shared library = /u01/app/oracle/product/10gAS/oui/lib/solaris/liboraInstaller.so
Location of Oracle Inventory Pointer = /var/opt/oracle/oraInst.loc
Location of Oracle Inventory = /u01/app/oracle/product/10gAS/inventory
Path to Java = /u01/app/oracle/product/10gAS/jdk/jre/bin/java
Log file = /u01/app/oracle/product/10gAS/.patch_storage/<patch ID>/*.log
Creating log file "/u01/app/oracle/product/10gAS/.patch_storage/5024386/Apply_5024386_09-26-2006_16-38-31.log"
Invoking fuser to check for active processes.
Backing up comps.xml ...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /u01/app/oracle/product/10gAS)
Is this system ready for updating?
Please respond Y|N >
Y (auto-answered by -silent)
Executing the Apply pre-patch script (/u01/app/oracle/patch/5024386/custom/scripts/pre)...
PERL5LIB=/u01/app/oracle/product/10gAS/perl/lib/5.6.1:/u01/app/oracle/patch/5024386/custom/scripts/perl_modules; export PERL5LIB
/u01/app/oracle/product/10gAS/perl/bin/perl /u01/app/oracle/patch/5024386/custom/scripts/pre.pl -apply 5024386 -s portal -p portpassword -c hostname.yourcompany.com:1521:YOURSID.yourcompany.com
.....................................................................
Please set your ORACLE_HOME to your 10.1.2 midtier installation home.
.....................................................................
Your ORACLE_HOME is /u01/app/oracle/product/10gAS
Your PERL5LIB is /u01/app/oracle/product/10gAS/perl/lib/site_perl/5.6.1/sun4-solaris:/u01/app/oracle/product/10gAS/perl/lib/5.6.1
created: 5024386/
extracted: 5024386/oneoff.pl
extracted: 5024386/sbrsracl.pkb
extracted: 5024386/sbrsracl.pks
extracted: 5024386/sbrsrxml.pkb
extracted: 5024386/sbrsrxml.pks
extracted: 5024386/thingh.plb
extracted: 5024386/thingh.sql
extracted: 5024386/uilovf.plb
extracted: 5024386/uilovf.sql
extracted: README.TXT
Welcome to Oracle Portal OneOffPatch Installer Version 3.0
Installing Oneoff
Patch Started at Tue Sep 26 16:38:40 2006
**************************************************************
Mode :INSTALL
Schema :portal
Password :****
SYS Schema :
SYS Password :****
ZipFile :P5024386_PATCHBUNDLE.zip
BugParam :
ConnectString:(DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= hostname.yourcompany.com)(Port= 1521)) (CONNECT_DATA = (SERVICE_NAME = YOURSID.yourcompany.com)))
Logfile :patch.log
**************************************************************
/u01/app/oracle/product/10gAS/portal/patch/oneoffs already exists
Copying /u01/app/oracle/product/10gAS/portal/patch/oneoffs/Temp/5024386 to /u01/app/oracle/product/10gAS/portal/patch/oneoffs/5024386
Copying file /u01/app/oracle/product/10gAS/portal/patch/oneoffs/Temp/README.TXT to /u01/app/oracle/product/10gAS/portal/patch/oneoffs/5024386/README.TXT
Deleted Directory /u01/app/oracle/product/10gAS/portal/patch/oneoffs/Temp
Applying OneOff Patch 5024386 ,this may take a while
Backingup PACKAGE WWV_THINGHTML
Backingup PACKAGE WWV_UI_LOVF
Backingup PACKAGE WWSBR_SRCHXML
Backingup PACKAGE BODY WWV_THINGHTML
Backingup PACKAGE BODY WWV_UI_LOVF
Backingup PACKAGE BODY WWSBR_SRCHXML
Compiling thingh.sql
Compiling uilovf.sql
Compiling sbrsracl.pks
Compiling sbrsrxml.pks
Compiling thingh.plb
Compiling uilovf.plb
Compiling sbrsracl.pkb
Compiling sbrsrxml.pkb
Recompiling all Invalid Objects ,this may take a while
Patch Ended at Tue Sep 26 16:39:04 2006.
Patch Completed Successfully
Verify /u01/app/oracle/product/10gAS/portal/patch/oneoffs/patch.log for any errors
Applying Portal Patch!!
Copying file /u01/app/oracle/patch/5024386/custom/scripts/P5024386_PATCHBUNDLE.zip to /u01/app/oracle/product/10gAS/portal/patch/oneoffs/P5024386_PATCHBUNDLE.zip
CMD=./ptlpatch.csh -z P5024386_PATCHBUNDLE.zip -s portal -p portpassword -c hostname.yourcompany.com:1521:YOURSID.yourcompany.com
Applying patch 5024386...
Patching copy files...
Inventory is good and does not have any dangling patches.
Updating inventory...
Verifying patch...
Verifying that patch ID is in Oracle Home inventory.
Verifying copy files.
OPATCH_VERIFY_OK: Patch has been applied.
Backing up comps.xml ...
OPatch succeeded.
callisto.portal->
------------- create log files ----------------
cd $HOME/patch/
$ORACLE_HOME/OPatch/opatch lsinventory -detail > midtier_patches_latest.log
sqlplus portal@yoursid
set pagesize 9999
set lines 9999
spool portaldb_patches_latest.log
select * from wwc_version$;
select * from wwutl_patch$;
select * from wwutl_patchlog$;
spool off
--------- verify missing PKG is installed ------------
SQL> select object_name, object_type
2 from dba_objects
3 where object_name = upper('wwsbr_srchxml_acl');
OBJECT_NAME OBJECT_TYPE
--------------------- -------------------
WWSBR_SRCHXML_ACL PACKAGE
WWSBR_SRCHXML_ACL PACKAGE BODY
SQL>
REFERENCE:
===========
------------ original OPatch session output --------------
callisto.portal-> cd $ORACLE_HOME/OPatch
./opatch apply -silent /u01/app/oracle/patch/5024386 -pre -s portal -p portpassword -c YOURSID
callisto.portal-> ./opatch apply -silent /u01/app/oracle/patch/5024386 -pre -s portal -p portpassword -c YOURSID
Oracle Interim Patch Installer version 1.0.0.0.55
Copyright (c) 2006 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com
Oracle Home = /u01/app/oracle/product/10gAS
Location of Oracle Universal Installer components = /u01/app/oracle/product/10gAS/oui
Location of OraInstaller.jar = "/u01/app/oracle/product/10gAS/oui/jlib"
Oracle Universal Installer shared library = /u01/app/oracle/product/10gAS/oui/lib/solaris/liboraInstaller.so
Location of Oracle Inventory Pointer = /var/opt/oracle/oraInst.loc
Location of Oracle Inventory = /u01/app/oracle/product/10gAS/inventory
Path to Java = /u01/app/oracle/product/10gAS/jdk/jre/bin/java
Log file = /u01/app/oracle/product/10gAS/.patch_storage/<patch ID>/*.log
Creating log file "/u01/app/oracle/product/10gAS/.patch_storage/5024386/Apply_5024386_09-25-2006_13-06-53.log"
Invoking fuser to check for active processes.
Backing up comps.xml ...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /u01/app/oracle/product/10gAS)
Is this system ready for updating?
Please respond Y|N >
Y (auto-answered by -silent)
Executing the Apply pre-patch script (/u01/app/oracle/patch/5024386/custom/scripts/pre)...
PERL5LIB=/u01/app/oracle/product/10gAS/perl/lib/5.6.1:/u01/app/oracle/patch/5024386/custom/scripts/perl_modules; export PERL5LIB
/u01/app/oracle/product/10gAS/perl/bin/perl /u01/app/oracle/patch/5024386/custom/scripts/pre.pl -apply 5024386 -s portal -p portpassword -c YOURSID
.....................................................................
Please set your ORACLE_HOME to your 10.1.2 midtier installation home.
.....................................................................
Your ORACLE_HOME is /u01/app/oracle/product/10gAS
Your PERL5LIB is /u01/app/oracle/product/10gAS/perl/lib/site_perl/5.6.1/sun4-solaris:/u01/app/oracle/product/10gAS/perl/lib/5.6.1
Welcome to Oracle Portal OneOffPatch Installer Version 3.0
Installing Oneoff
Applying Portal Patch!!
Copying file /u01/app/oracle/patch/5024386/custom/scripts/P5024386_PATCHBUNDLE.zip to /u01/app/oracle/product/10gAS/portal/patch/oneoffs/P5024386_PATCHBUNDLE.zip
CMD=./ptlpatch.csh -z P5024386_PATCHBUNDLE.zip -s portal -p portpassword -c YOURSID
Applying patch 5024386...
Patching copy files...
Inventory is good and does not have any dangling patches.
Updating inventory...
Verifying patch...
Verifying that patch ID is in Oracle Home inventory.
Verifying copy files.
OPATCH_VERIFY_OK: Patch has been applied.
Backing up comps.xml ...
OPatch succeeded.
----------------- end session ----------------------
## verify patch was installed
##
$ORACLE_HOME/OPatch/opatch lsinventory -detail
.....
Installed Patch List:
=====================
1) Patch 5024386 applied on Mon Sep 25 13:07:10 PDT 2006
[ Base Bug(s): 5024357 ]
/u01/app/oracle/product/10gAS/portal/patch/oneoffs/5024386.txt --> OH/portal/patch/oneoffs
2) Patch 4874299 applied on Mon Aug 28 09:36:56 PDT 2006
[ Base Bug(s): 4874212 ]
/u01/app/oracle/product/10gAS/portal/patch/oneoffs/4874299.txt --> OH/portal/patch/oneoffs
/u01/app/oracle/product/10gAS/portal/jlib/portaltools.jar --> OH/portal/jlib
/u01/app/oracle/product/10gAS/j2ee/OC4J_Portal/applications/portalTools/omniPortlet/WEB-INF/lib/__oracle_jsp_omniPortlet.war.jar --> OH/j2ee/OC4J_Portal/applications/portalTools/omniPortlet/WEB-INF/lib
|
4398
2006-SEP-26 18:27:55
|
|
Moderator
|
|
|
Registered On: Mar 2006
Total Posts: 267
|
|
.