ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle最新安全补丁cpujul2006问题

oracle最新安全补丁cpujul2006问题

原创 Linux操作系统 作者:crpp0902 时间:2019-05-16 16:21:04 0 删除 编辑

环境:
oracle@V490 /export/home/oracle$isainfo -v
64-bit sparcv9 applications
32-bit sparc applications
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for Solaris: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production


oracle@V490-S /export/home/oracle$ls /opt/oracle/product/9.2.0/l*
ldap lib lib32
发现也有lib32 目录
由此我们可以确定为建立在64位solaris上的64位的9.2.0.6

下载相关的PATCH包:
p2617419_10102_GENERIC.zip(为OPATCH包)
p5225793_9206_SOLARIS64.zip(对于64位版本)
p5225793_9206_SOLARIS.zip(对于32位版本)

因为我的数据库为64位,所以解压p5225793_9206_SOLARIS64.zip包,进行补丁的升级:
$export PATH=$PATH:/opt/oracle/OPatch/
cd 5225793
$opatch apply -invPtrLoc /etc/oraInst.loc
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 = /opt/oracle/product/9.2.0
Location of Oracle Universal Installer components = /opt/oracle/product/9.2.0/oui
Location of OraInstaller.jar = "/opt/oracle/product/9.2.0/oui/jlib"
Oracle Universal Installer shared library = /opt/oracle/product/9.2.0/oui/lib/solaris/liboraInstaller.so
Location of Oracle Inventory Pointer = /etc/oraInst.loc
Location of Oracle Inventory = /opt/oracle/product/9.2.0/inventory
Path to Java = /opt/oracle/product/9.2.0/jre/1.4.2/bin/java
Log file = /opt/oracle/product/9.2.0/.patch_storage//*.log

Creating log file "/opt/oracle/product/9.2.0/.patch_storage/5225793/Apply_5225793_07-27-2006_10-27-13.log"

Invoking fuser to check for active processes.

Invoking fuser on "/opt/oracle/product/9.2.0/bin/oidreconcile"
Invoking fuser on "/opt/oracle/product/9.2.0/bin/lsnrctl"
Invoking fuser on "/opt/oracle/product/9.2.0/bin/tnsping"
Invoking fuser on "/opt/oracle/product/9.2.0/Apache/Apache/bin/rotatelogs"
Invoking fuser on "/opt/oracle/product/9.2.0/Apache/Apache/bin/httpd"
Invoking fuser on "/opt/oracle/product/9.2.0/bin/tnslsnr"
Invoking fuser on "/opt/oracle/product/9.2.0/bin/onrsd"
Invoking fuser on "/opt/oracle/product/9.2.0/bin/oracle"
Invoking fuser on "/opt/oracle/product/9.2.0/bin/nmumigr8"
Invoking fuser on "/opt/oracle/product/9.2.0/bin/trcroute"
Invoking fuser on "/opt/oracle/product/9.2.0/Apache/Apache/bin/htpasswd"

OPatch detects your platform as 453 while this patch 5225793 supports platforms:
23 (Solaris Operating System (SPARC 64-bit))

This patch is not suitable for this operating system.
Please contact support for the correct patch.

ERROR: OPatch failed during pre-reqs check.

问题:我的数据库跟OS都是64BIT的,为什么这个包检测出来是32BIT的呢??

问题解决:

cd 5225793

到这个目录下查看opatch apply到底要应用那些文件:

oracle@V490-S /opt/oracle/5225793$ls
README.html README.txt custom etc files patchmd.xml

$cd /opt/oracle/5225793/etc/config

$ls
actions inventory

$vi inventory

change follow:

from



to



Inventory is good and does not have any dangling patches.

Performing post-patch inventory update and removing working files.

Patch 5225793 has been applied successfully.

Starting to update inventory for Apply at 07-27-2006_10-59-32.


Updating inventory...

Accessing inventory ... (retry 10 times, delay 30 seconds each time)


System Command: /opt/oracle/product/9.2.0/jre/1.4.2/bin/java -Dopatch.local_node_only -Doracle.installer.invPtrLoc=/etc/oraInst.loc -classpath "/opt/oracle/product/9.2.0/oui/jlib/OraInstaller.jar:/opt/oracle/product/9.2.0/oui/jlib/srvm.jar:/opt/oracle/OPatch/jlib/opatch.jar:/opt/oracle/product/9.2.0/oui/jlib/xmlparserv2.jar:/opt/oracle/product/9.2.0/oui/jlib/share.jar" opatch/UpdateInventory "/opt/oracle/product/9.2.0/oui" "/opt/oracle/product/9.2.0" opatch.pl 1.0.0.0.55 5225793 /opt/oracle/5225793/etc/config/actions "2300743 4609041 4017526 4642417 4165093 4157713 4049345 4914327 4409067 4333179 4735715 3763395 3865608 3990826 3737955 4460898 4131501 4120094 5220068 4098102 5049051 4201972 4230880 5242643 2902077 4039237 3680704 5049055 4751921 3790371 4156916 5225793 4991821 4577209 3913909 4078745 4754836 4673839 4873892 3859298 4567969 4204014 4570100 4011643 4307033 4161315 2701372 3119415 4608731 4675306 3834770 3830972 3858017 4093187 4492257 4482690 4193295 4298255 4519477 3389359 3898338 4698691 4161400 4131045 4344210 4112254 4527101 4031093 3940412 4242561 4312871 4230189 4630627 4199440 3285454 3514937 4392392 4714295 4450964 4758810 3624684 4198156 4248629 3949307 3963167 4538438 3241979 4392396 3669454 3799129 4942939 4336997 2966778 4006711 4141415 4030374 3751131 4620910 4091504 4081624 3804515 4519016 4285404 3910149 3922760 3467622 4080972 4275680 4369235 4238592 4252938 3747472 3269826 4098853 4345994 3857781 4629567 4149579 4288876 4738986 4004225 4999297 3799696 3281270 4157520 3626323 4167403 4201298 4121749 4339128 3845730 4430748 4634368 3691672 3359905 4337747 4205898 3817792 4567846 2844111 4015165 4137217 4353077 4230939 4504629 4064791 4221789 4597251 2797117 3258674 3810779 4523976 4538387 4523979 2448994 4488790 3964487 4130116 4200029 3228560 4050649 4717721 4322477 4926771 3787344 3672985 "

Result:


Verifying patch...

System Command: /opt/oracle/product/9.2.0/jre/1.4.2/bin/java -Dopatch.local_node_only -Doracle.installer.invPtrLoc=/etc/oraInst.loc -classpath "/opt/oracle/product/9.2.0/oui/jlib/OraInstaller.jar:/opt/oracle/product/9.2.0/oui/jlib/srvm.jar:/opt/oracle/OPatch/jlib/opatch.jar:/opt/oracle/product/9.2.0/oui/jlib/xmlparserv2.jar:/opt/oracle/product/9.2.0/oui/jlib/share.jar" opatch/VerifyPatch "/opt/oracle/product/9.2.0" "/opt/oracle/product/9.2.0/oui" /opt/oracle/5225793 5225793 /usr/ccs/bin/ar 0

Result:

Verifying that patch ID is in Oracle Home inventory.

Verifying copy files.

Verifying jar files.

Verifying archive files.

OPATCH_VERIFY_OK: Patch has been applied.

Backing up comps.xml ...

Back up "/opt/oracle/product/9.2.0/inventory/ContentsXML/comps.xml" to "/opt/oracle/product/9.2.0/.patch_storage/5225793/comps.xml.afterapply"

Looking for post-patch readme /opt/oracle/5225793/custom/post.txt

printing content of /opt/oracle/5225793/custom/post.txt to stdout


======= Post-Install README ====================================

********************************************************************************
********************************************************************************
** ATTENTION **
** **
** Please note that the Security Patch Installation (Patch Deinstallation) is **
** not complete until all the Post Installation (Post Deinstallation) **
** instructions noted in the Readme accompanying this patch, have been **
** successfully completed. **
** **
********************************************************************************
********************************************************************************

======= End of Post-Install README =============================

Looking for post-patch script /opt/oracle/5225793/custom/scripts/post

preparing to execute /opt/oracle/5225793/custom/scripts/post

Executing the Apply post-patch script (/opt/oracle/5225793/custom/scripts/post)...
/opt/oracle/5225793/custom/scripts/post -apply 5225793

======= Post-Install Script Output =============================

exit code = "0"

======= End of Post-Install Script Output ======================

Ending Apply session at 07-27-2006_11-00-08.

:))

不知道这算不算ORACLE的一个BUG呢??

继续:

cd $ORACLE_HOME/cpu/CPUJul2006
sqlplus /nolog
SQL> CONNECT /AS SYSDBA
SQL> STARTUP MIGRATE
SQL> @catcpu.sql
SQL> QUIT
继续:
SQL> SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS= 'INVALID';
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT /AS SYSDBA
SQL>SHUTDOWN IMMEDIATE
SQL> STARTUP
SQL> @utlrp.sql
 
END......

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28419/viewspace-604021/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2002-11-14

  • 博文量
    51
  • 访问量
    37369