打Oracle PSU时碰到的一些问题处理

最新推荐文章于 2023-11-17 22:27:50 发布
最新推荐文章于 2023-11-17 22:27:50 发布
阅读量2.5k 收藏
点赞数
文章标签： 数据库 操作系统 面试




一.1   安装程序错误   UtilSession failed: Prerequisite check "CheckPatchApplicableOnCurrentPlatform" failed.

suse11sp2:/oracle/product/11gR2/db/OPatch> ./opatch apply /oracle/product/11gR2/db/16619892/

Oracle Interim Patch Installer version 11.2.0.3.4

Copyright (c) 2012, Oracle Corporation.   All rights reserved.

Oracle Home            : /oracle/product/11gR2/db

Central Inventory : /oracle/oraInventory

      from                    : /oracle/product/11gR2/db/oraInst.loc

OPatch version       : 11.2.0.3.4

OUI version            : 11.2.0.3.0

Log file location : /oracle/product/11gR2/db/cfgtoollogs/

opatch/opatch2013-07-22_18-22-06PM_1.log

Verifying environment and performing prerequisite checks...

Prerequisite check "CheckPatchApplicableOnCurrentPlatform" failed.

The details are:

Patch ( 13343438 ) is not applicable on current platform.

Platform ID needed is : 226

Platform IDs supported by patch are: 209 211 Patch ( 13696216 ) is not applicable on current platform.

Platform ID needed is : 226

Platform IDs supported by patch are: 209 Patch ( 13923374 ) is not applicable on   current platform.

Platform ID needed is : 226

Platform IDs supported by patch are: 209 Patch ( 14275605 ) is not applicable on   current platform.

Platform ID needed is : 226

Platform IDs supported by patch are: 209 Patch ( 14727310 ) is not applicable on   current platform.

Platform ID needed is : 226

Platform IDs supported by patch are: 209 Patch ( 16056266 ) is not applicable on   current platform.

Platform ID needed is : 226

Platform IDs supported by patch are: 209 Patch ( 16619892 ) is not applicable on   current platform.

Platform ID needed is : 226

Platform IDs supported by patch are: 209

UtilSession failed: Prerequisite check "CheckPatchApplicableOnCurrentPlatform" failed.

Log file location: /oracle/product/11gR2/db/cfgtoollogs/opatch/opatch2013-07-22_18-22-06PM_1.log

 

 

OPatch failed with error code 73

suse11sp2:/oracle/product/11gR2/db/OPatch>

 

 

仔细查看，发现下载的软件压缩包是 ibm system z 系列的，应该是 oracle 网站打开得太慢，默认是这个版本，需要下拉菜单再次选择 linux -x86-64 对应的软件，结果我动作太快，出错了。

检查看看 PSU 应用的结果 , 未成功 :

suse11sp2:/oracle/product/11gR2/db/OPatch> ./opatch version

OPatch Version: 11.2.0.3.4

 

 

OPatch succeeded.

suse11sp2:/oracle/product/11gR2/db/OPatch> ./opatch lspatches

There are no Interim patches installed in this Oracle Home.

 

 

一.2   OPatch failed with error code 73

suse11sp2:/oracle/soft> /oracle/product/11gR2/db/OPatch/opatch apply /oracle/soft/16619892/

Oracle Interim Patch Installer version 11.2.0.3.4

Copyright (c) 2012, Oracle Corporation.   All rights reserved.

Oracle Home            : /oracle/product/11gR2/db

Central Inventory : /oracle/oraInventory

      from                    : /oracle/product/11gR2/db/oraInst.loc

OPatch version       : 11.2.0.3.4

OUI version            : 11.2.0.3.0

Log file location : /oracle/product/11gR2/db/cfgtoollogs/opatch/opatch2013-07-22_18-40-42PM_1.log

 

Verifying environment and performing prerequisite checks...

Prerequisite check "CheckActiveFilesAndExecutables" failed.

The details are:

 

Following executables are active :

/oracle/product/11gR2/db/lib/libclntsh.so.11.1

UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.

Log file location: /oracle/product/11gR2/db/cfgtoollogs/opatch/opatch2013-07-22_18-40-42PM_1.log

 

 

OPatch failed with error code 73

 

不使用自动模式，手工运行，一样报错：

suse11sp2:/oracle/soft> /oracle/product/11gR2/db/OPatch/opatch napply -oh $ORACLE_HOME -local /oracle/soft/16619892/

Oracle Interim Patch Installer version 11.2.0.3.4

Copyright (c) 2012, Oracle Corporation.   All rights reserved.

Oracle Home            : /oracle/product/11gR2/db

Central Inventory : /oracle/oraInventory

      from                    : /oracle/product/11gR2/db/oraInst.loc

OPatch version       : 11.2.0.3.4

OUI version            : 11.2.0.3.0

Log file location : /oracle/product/11gR2/db/cfgtoollogs/opatch/opatch2013-07-22_18-42-08PM_1.log

Verifying environment and performing prerequisite checks...

Prerequisite check "CheckActiveFilesAndExecutables" failed.

The details are:

Following executables are active :

/oracle/product/11gR2/db/lib/libclntsh.so.11.1

UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.

Log file location: /oracle/product/11gR2/db/cfgtoollogs/opatch/opatch2013-07-22_18-42-08PM_1.log

OPatch failed with error code 73

上网 goole ，关键词为 “ OPatch failed with error code 73” ， 很快就查到解决办法，明确了其实就是因为有用户进程占用了文件 libclntsh.so.11

suse11sp2:/oracle/soft>

suse11sp2:/oracle/soft>

suse11sp2:/oracle/soft> /sbin/fuser /oracle/product/11gR2/db/lib/libclntsh.so.11.1

/oracle/product/11gR2/db/lib/libclntsh.so.11.1:   5473m

suse11sp2:/oracle/soft> ps -ef | grep 5473

oracle       5473   5399   0 14:45 pts/2       00:00:00 sqlplus    as sysdba

oracle       7780   6617   0 18:47 pts/3       00:00:00 grep 5473

suse11sp2:/oracle/soft> kill -9   5473

suse11sp2:/oracle/soft> /sbin/fuser /oracle/product/11gR2/db/lib/libclntsh.so.11.1

suse11sp2:/oracle/soft>

 

 

一.3   PATCH 锁住无法继续安装补丁

 

报错现象 :

------------------------------------------------------------------------------------------------------------------------------

Oracle Home       : /oracle/app/11.2.0/grid

Central Inventory : /oracle/app/oraInventory

   from           : /oracle/app/11.2.0/grid/oraInst.loc

OPatch version    : 11.2.0.3.0

OUI version       : 11.2.0.3.0

Log file location : /oracle/app/11.2.0/grid/cfgtoollogs/opatch/opatch2013-09-05_19-24-55PM_1.log

OPatchSession cannot load inventory for the given Oracle Home /oracle/app/11.2.0/grid. Possible causes are:

    No read or write permission to ORACLE_HOME/.patch_storage

   Central Inventory is locked by another OUI instance

   No read permission to Central Inventory

    The lock file exists in ORACLE_HOME/.patch_storage

   The Oracle Home does not exist in Central Inventory

UtilSession failed: Lock file left by a different patch, OPatch will not try re-using the lock file.

Log file location: /oracle/app/11.2.0/grid/cfgtoollogs/opatch/opatch2013-09-05_19-24-55PM_1.log

------------------------------------------------------------------------------------------------------------------------------

处理方法 :

cd  /oracle/app/11.2.0/grid/.patch_storage ;rm patch_locked

 

一.4   打 G I 的 PSU5 补丁遇到拷贝文件失败案例 1

 

报错现象 :

-------------------------------------------------------------------------------------------------------------------------------

The following actions have failed:

Copy failed from '/oracle/app/11.2.0/grid/.patch_storage/13919095_Jul_4_2012_11_10_31/files/lib/libclsra11.so' to '/oracle/app/11.2.0/grid/lib/libclsra11.so'...

Copy failed from '/oracle/app/11.2.0/grid/.patch_storage/13919095_Jul_4_2012_11_10_31/files/lib/libdbcfg11.so' to '/oracle/app/11.2.0/grid/lib/libdbcfg11.so'...

Copy failed from '/oracle/app/11.2.0/grid/.patch_storage/13919095_Jul_4_2012_11_10_31/files/lib/libeons.so' to '/oracle/app/11.2.0/grid/lib/libeons.so'...

Copy failed from '/oracle/app/11.2.0/grid/.patch_storage/13919095_Jul_4_2012_11_10_31/files/lib/libeonsserver.so' to '/oracle/app/11.2.0/grid/lib/libeonsserver.so'...

Copy failed from '/oracle/app/11.2.0/grid/.patch_storage/13919095_Jul_4_2012_11_10_31/files/lib/libgns11.so' to '/oracle/app/11.2.0/grid/lib/libgns11.so'...

Copy failed from '/oracle/app/11.2.0/grid/.patch_storage/13919095_Jul_4_2012_11_10_31/files/lib/libhasgen11.so' to '/oracle/app/11.2.0/grid/lib/libhasgen11.so'...

Copy failed from '/oracle/app/11.2.0/grid/.patch_storage/13919095_Jul_4_2012_11_10_31/files/lib/libocr11.so' to '/oracle/app/11.2.0/grid/lib/libocr11.so'...

Copy failed from '/oracle/app/11.2.0/grid/.patch_storage/13919095_Jul_4_2012_11_10_31/files/lib/libocrb11.so' to '/oracle/app/11.2.0/grid/lib/libocrb11.so'...

Copy failed from '/oracle/app/11.2.0/grid/.patch_storage/13919095_Jul_4_2012_11_10_31/files/lib/libocrutl11.so' to '/oracle/app/11.2.0/grid/lib/libocrutl11.so'...

…… (y/n)

------------------------------------------------------------------------------------------------------------------------------------------------------

处理方法 :

su - grid

mv   /oracle/app/11.2.0/grid/lib/libclsra11.so      /oracle/app/11.2.0/grid/lib/libclsra11.so.1    

mv   /oracle/app/11.2.0/grid/lib/libdbcfg11.so      /oracle/app/11.2.0/grid/lib/libdbcfg11.so.1    

mv   /oracle/app/11.2.0/grid/lib/libeons.so         /oracle/app/11.2.0/grid/lib/libeons.so.1       

mv   /oracle/app/11.2.0/grid/lib/libeonsserver.so   /oracle/app/11.2.0/grid/lib/libeonsserver.so.1

mv   /oracle/app/11.2.0/grid/lib/libgns11.so        /oracle/app/11.2.0/grid/lib/libgns11.so.1      

mv   /oracle/app/11.2.0/grid/lib/libhasgen11.so     /oracle/app/11.2.0/grid/lib/libhasgen11.so.1   

mv   /oracle/app/11.2.0/grid/lib/libocr11.so        /oracle/app/11.2.0/grid/lib/libocr11.so.1      

mv   /oracle/app/11.2.0/grid/lib/libocrb11.so       /oracle/app/11.2.0/grid/lib/libocrb11.so.1     

mv   /oracle/app/11.2.0/grid/lib/libocrutl11.so     /oracle/app/11.2.0/grid/lib/libocrutl11.so.1   

-------

cp /oracle/app/11.2.0/grid/.patch_storage/13919095_Jul_4_2012_11_10_31/files/lib/libclsra11.so     /oracle/app/11.2.0/grid/lib/libclsra11.so   

cp /oracle/app/11.2.0/grid/.patch_storage/13919095_Jul_4_2012_11_10_31/files/lib/libdbcfg11.so     /oracle/app/11.2.0/grid/lib/libdbcfg11.so   

cp /oracle/app/11.2.0/grid/.patch_storage/13919095_Jul_4_2012_11_10_31/files/lib/libeons.so        /oracle/app/11.2.0/grid/lib/libeons.so      

cp /oracle/app/11.2.0/grid/.patch_storage/13919095_Jul_4_2012_11_10_31/files/lib/libeonsserver.so  /oracle/app/11.2.0/grid/lib/libeonsserver.so

cp /oracle/app/11.2.0/grid/.patch_storage/13919095_Jul_4_2012_11_10_31/files/lib/libgns11.so       /oracle/app/11.2.0/grid/lib/libgns11.so     

cp /oracle/app/11.2.0/grid/.patch_storage/13919095_Jul_4_2012_11_10_31/files/lib/libhasgen11.so    /oracle/app/11.2.0/grid/lib/libhasgen11.so  

cp /oracle/app/11.2.0/grid/.patch_storage/13919095_Jul_4_2012_11_10_31/files/lib/libocr11.so       /oracle/app/11.2.0/grid/lib/libocr11.so     

cp /oracle/app/11.2.0/grid/.patch_storage/13919095_Jul_4_2012_11_10_31/files/lib/libocrb11.so      /oracle/app/11.2.0/grid/lib/libocrb11.so    

cp /oracle/app/11.2.0/grid/.patch_storage/13919095_Jul_4_2012_11_10_31/files/lib/libocrutl11.so    /oracle/app/11.2.0/grid/lib/libocrutl11.so  

然后再输入 y 回车

 

一.5   打 GI 的 PSU5 补丁遇到拷贝文件失败案例 2

 

报错现象 :

--------------------------------------------------------------------------------------------------------------------------------

Patching component oracle.crs, 11.2.0.3.0...

 

Copy failed from '/softtmp/15876003/files/lib/libclsra11.so' to '/oracle/app/11.2.0/grid/lib/libclsra11.so'...  

Please verify all applications associated with the Oracle Home '/oracle/app/11.2.0/grid' are shut down. If this is AIX, please perform solution documented in Note 739963.1 on https://myoraclesupport.oracle.com.

 

Do you want to retry copying the file? [y|n]

…   …

-----------------------------------------------------------------------------------------------------------------

处理方法 :

su –  gird

mv /oracle/app/11.2.0/grid/lib/libclsra11.so    /oracle/app/11.2.0/grid/lib/libclsra11.so .bak

cp /softtmp/15876003/files/lib/libclsra11.so    /oracle/app/11.2.0/grid/lib/libclsra11.so

然后再输入 y 回车

 

(1)  root 用户跑 $ORACLE_HOME/crs/install/rootcrs.pl –patch 失败无法正常启动 CRS

 

处理方法 :

重启 LPAR, #shutdown –Fr, 等待 CRS 正常启动

 

一.6   CRS-1153: There was an error setting Oracle Clusterware to rolling patch mode.


 

错误信息：

HQsPSL-SSMS-R01:/oracle/app/12.1.0/grid/crs/install # rootcrs.pl -prepatch

Using configuration parameter file: /oracle/app/12.1.0/grid/crs/install/crsconfig_params

Oracle Clusterware active version on the cluster is [12.1.0.2.0]. The cluster upgrade state is [ROLLING PATCH]. The cluster active patch level is [0].

PROC-28: Oracle Cluster Registry already in current version

CRS-1153: There was an error setting Oracle Clusterware to rolling patch mode.

CRS-4000: Command Start failed, or completed with errors.

2016/11/23 18:45:40 CLSRSC-430: Failed to start rolling patch mode

 

Died at crspatch.pm line 783.

HQsPSL-SSMS-R01:/oracle/app/12.1.0/grid/crs/install #

 

根据 MOS:

CAUSE

 

The issue happens if the cluster is already in rolling patch mode, it's due to unpublished bug:

 

BUG 19499021 - 12.1.0.2.1GIPSU: OPATCHAUTO HIT CLSRSC-430: FAILED TO START ROLLING PATCH MODE

 

SOLUTION

 

The fix is included in 12.1.0.2 GI PSU1, the workaround is to stop rolling patch and re-run opatchauto:

 

# crsctl stop rollingpatch

 

解决：

HQsPSL-SSMS-R01:~ # /oracle/app/12.1.0/grid/bin/crsctl stop rollingpatch  

CRS-1169: The cluster is consistent and the cluster active patch level is [0].

CRS-4000: Command Stop failed, or completed with errors.

HQsPSL-SSMS-R01:~ #

HQsPSL-SSMS-R01:~ # oerr crs 1169

1169, 0, "The cluster is consistent and the cluster active patch level is [%u]."

// *Cause: The cluster has already completed the rolling patch procedure.

// *Action: None.

HQsPSL-SSMS-R01:~ #

 

重新执行 /oracle/app/12.1.0/grid/crs/install/rootcrs.pl -prepatch 命令打 PUS 补丁即可。

一.7   ERROR: Unable to run lspatches

2018-10-30 14:49:43: Starting Clusterware Patch Setup

Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

ERROR: Unable to run lspatches on /u01/app/oracle/product/11.2.0/dbhome_1

 

解决： db 软件的 opatch 不是最新版本，请升级到最新版本。

 

一.8   OPatch failed with error code 106

报错：

OPatch cannot locate your -invPtrLoc '/u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc'

OPatch failed with error code 106

 

解决：

cp /etc/oraInst.loc /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc

 

 

一.9   ERROR: This patch is not applicable to GI home.

1、 对 grid 和 oracle 的 $ORACLE_HOME/.patch_storage 目录进行赋权，否则可能会报错：

ERROR: This patch is not applicable to GI home.

解决：

分别对 oracle 和 grid 用户的目录进行赋权：

chmod -R 777 $ORACLE_HOME/.patch_storage

ll -d $ORACLE_HOME/.patch_storage

 

[root@raclhr-11gR2-N2 OPatch]# ll -d $ORACLE_HOME/.patch_storage

drwxrwxrwx 2 grid oinstall 4096 Oct 30 15:54 /u01/app/11.2.0/grid/.patch_storage

 

[oracle@raclhr-11gR2-N2 ~]$ ll -d $ORACLE_HOME/.patch_storage

drwxrwxrwx 9 oracle oinstall 4096 Oct 30 16:06 /u01/app/oracle/product/11.2.0/dbhome_1/.patch_storage

 

 

一.10   Error : The opatch Applicable check failed.  The patch /soft/psu5/15876003 is not applicable to /u01/app/11.2.0/grid

 

2018-10-30 17:10:09: Running as user grid: /u01/app/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /soft/psu5/15876003 -oh /u01/app/11.2.0/grid

2018-10-30 17:10:09: s_run_as_user2: Running /bin/su grid -c ' /u01/app/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /soft/psu5/15876003 -oh /u01/app/11.2.0/grid '

2018-10-30 17:10:11: Removing file /tmp/fileDJwCRK

2018-10-30 17:10:11: Successfully removed file: /tmp/fileDJwCRK

2018-10-30 17:10:11: /bin/su successfully executed

 

2018-10-30 17:10:11: Error : The opatch Applicable check failed.  The patch /soft/psu5/15876003 is not applicable to /u01/app/11.2.0/grid

2018-10-30 17:10:11: Status of Applicable  check  for /u01/app/11.2.0/grid is 1

2018-10-30 17:10:11: Error:Patch Applicable check failed for /u01/app/11.2.0/grid

 

解决：单独执行报错：

[root@raclhr-11gR2-N2 bin]# su - grid

[grid@raclhr-11gR2-N2 ~]$ /u01/app/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /soft/psu5/15876003 -oh /u01/app/11.2.0/grid

Oracle Interim Patch Installer version 11.2.0.3.19

Copyright (c) 2018, Oracle Corporation.  All rights reserved.

 

PREREQ session

 

Oracle Home       : /u01/app/11.2.0/grid

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/11.2.0/grid/oraInst.loc

OPatch version    : 11.2.0.3.19

OUI version       : 11.2.0.3.0

Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2018-10-30_17-16-03PM_1.log

 

Invoking prereq "checkapplicable"

 

ZOP-46: The patch(es) are not applicable on the Oracle Home because some patch actions are not applicable. All required components, however, are installed.

 

Prereq "checkApplicable" for patch 15876003 failed.

 

The details are:

 

Patch 15876003:

Copy Action: Destination File "/u01/app/11.2.0/grid/bin/appvipcfg" is not writeable.

'oracle.crs, 11.2.0.3.0': Cannot copy file from 'appvipcfg' to '/u01/app/11.2.0/grid/bin/appvipcfg'

Copy Action: Destination File "/u01/app/11.2.0/grid/bin/clscfg.bin" is not writeable.

'oracle.crs, 11.2.0.3.0': Cannot copy file from 'clscfg.bin' to '/u01/app/11.2.0/grid/bin/clscfg.bin'

.............

Copy Action: Destination File "/u01/app/11.2.0/grid/lib/acfssinglefsmount.pl" is not writeable.

'oracle.usm, 11.2.0.3.0': Cannot copy file from 'acfssinglefsmount.pl' to '/u01/app/11.2.0/grid/lib/acfssinglefsmount.pl'

Copy Action: Destination File "/u01/app/11.2.0/grid/lib/acfstoolsdriver.sh" is not writeable.

'oracle.usm, 11.2.0.3.0': Cannot copy file from 'acfstoolsdriver.sh' to '/u01/app/11.2.0/grid/lib/acfstoolsdriver.sh'

 

 

OPatch succeeded.

 

GRID_HOME 的权限有问题：

chown -R grid:oinstall /u01/app/grid

chown -R grid:oinstall /u01/app/11.2.0

待 PSU 安装 完成之后再恢复权限 ， 或以下恢复权限的命令不用执行，因为 opatch 打 PSU 的过程中会自动的恢复 $GRID_HOME 的权限 ：

<GRID_HOME>/crs/install/rootcrs.pl -unlock

<GRID_HOME>/crs/install/rootcrs.pl -patch

$GRID_HOME/crs/install/rootcrs.pl -init

 

 


About Me

........................................................................................................................

● 本文作者：小麦苗，部分内容整理自网络，若有侵权请联系小麦苗删除

● 本文在itpub（ http://blog.itpub.net/26736162 ）、博客园（ http://www.cnblogs.com/lhrbest ）和个人weixin公众号（ xiaomaimiaolhr ）上有同步更新

● 本文itpub地址： http://blog.itpub.net/26736162

● 本文博客园地址： http://www.cnblogs.com/lhrbest

● 本文pdf版、个人简介及小麦苗云盘地址： http://blog.itpub.net/26736162/viewspace-1624453/

● 数据库笔试面试题库及解答： http://blog.itpub.net/26736162/viewspace-2134706/

● DBA宝典今日头条号地址： http://www.toutiao.com/c/user/6401772890/#mid=1564638659405826

........................................................................................................................

● QQ群号： 230161599 （满） 、618766405

● weixin群：可加我weixin，我拉大家进群，非诚勿扰

● 联系我请加QQ好友 （ 646634621 ） ，注明添加缘由

● 于 2018-10-01 06:00 ~ 2018-10-31 24:00 在魔都完成

● 最新修改时间：2018-10-01 06:00 ~ 2018-10-31 24:00

● 文章内容来源于小麦苗的学习笔记，部分整理自网络，若有侵权或不当之处还请谅解

● 版权所有，欢迎分享本文，转载请保留出处

........................................................................................................................

● 小麦苗的微店 ： https://weidian.com/s/793741433?wfr=c&ifr=shopdetail

● 小麦苗出版的数据库类丛书 ： http://blog.itpub.net/26736162/viewspace-2142121/

● 小麦苗OCP、OCM、高可用网络班 ： http://blog.itpub.net/26736162/viewspace-2148098/

● 小麦苗腾讯课堂主页 ： https://lhr.ke.qq.com/

........................................................................................................................

使用 weixin客户端 扫描下面的二维码来关注小麦苗的weixin公众号（ xiaomaimiaolhr ）及QQ群（DBA宝典）、添加小麦苗weixin， 学习最实用的数据库技术。

........................................................................................................................

欢迎与我联系

 

 



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

转载于:http://blog.itpub.net/26736162/viewspace-2218185/

coco3600
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
由高权限目录引起的OPatch auto补丁失败一例
ciqu9915的博客
06-03 1184
Oracle GI的高度自动化 、智能化功能伴随着系统体系架构的复杂性增加，随之而来的运维管理要求也在逐步攀升。仅从DBA角度看，除了数据库核心技术之外，网络、存储、主机系统等相关技术的要求也在“水涨船高”...
Oracle Exists、 NOT Exists用法
最新发布
K___End的博客
05-14 1419
EXISTS提供了一种高效的方式来判断行的存在性，是处理子查询时的一个强大工具，尤其是在需要基于条件判断数据是否存在，而不关心具体值的情况下。NOT EXISTS在Oracle数据库中，NOT EXISTS关键字用于子查询中，用来检查子查询是否有结果。与EXISTS相反，NOT EXISTS用于筛选出那些在子查询中找不到匹配项的记录。当子查询没有返回任何行时，NOT EXISTS子句的条件为真，从而外层查询的行会被包含在结果集中。以下是NOT EXISTSNOT EXISTS。
oracle升级补丁报错,oracle rac升级补丁及中间的错误提示
weixin_31752923的博客
04-07 276
tail -f /var/log/messages/u01/app/oracle/product/10.2.0/db_1/OPatch/opatch/u01/app/oracle/product/10.2.0/crs_1/OPatch/opatchORA_CRS_HOME=/u01/app/oracle/product/10.2.0/crs_1ORACLE_HOME=/u01/app/oracle...
OPatch failed with error code 104报错
AwenStyle
02-18 2732
 1、执行opatch apply打补丁的时候，报OPatch failed with error code 104错误， 找不到有效的oraInst.loc文件，具体如下所示： oracle@kevin.example.com:~/linux_patch/12419384> opatch apply Invoking OPatch 11.1.0.8.5 Oracle Inter
oracle11g升级PSU详细步骤
Lurou's Home
07-22 6895
以前做过很多次大版本升级，这次来个小版本升级，PSU补丁应用的详细过程。 oracle11.2.0.3.0升级到11.2.0.3.7, linux x64 platform
[Oracle] CPU/PSU补丁安装详细教程
12-16
在实际操作中，安装CPU/PSU补丁可能会遇到兼容性、依赖性等问题，因此，每个补丁的Readme文档至关重要，它提供了详细的安装指南和可能遇到的问题解决方案。在处理复杂的Oracle数据库环境，尤其是RAC（Real ...
oracle报错（ORA-00600）问题处理
09-10
Oracle数据库在运行过程中可能会遇到各种错误，其中ORA-00600是一个内部错误代码，表示遇到了数据库系统内部无法处理的异常情况。这个错误通常与数据库的底层结构或数据不一致有关，它不是一个通用错误，而是针对...
oracle补丁升级，包含补丁包，升级脚本，升级说明文档
05-18
在处理这个补丁时，需要确保你的数据库版本与补丁兼容，并遵循文档中的具体步骤进行安装。 总的来说，Oracle补丁升级是一项技术性强且需谨慎操作的任务。通过使用提供的补丁包、升级脚本和详细说明文档，可以有效地...
wls_p33172858_1036_Generic.zip
12-23
此软件是Oracle Fusion Middleware的一部分，提供了丰富的功能，包括事务处理、集群、安全管理、监控和诊断工具等。 "PSU"（Patch Set Update）是Oracle提供的一个更新机制，用于向WebLogic Server应用安全性和性能...
Oracle 11.2.0.3.0 psu 11.2.0.3.9 in aix
dgn7151的博客
06-29 128
在aix上将Oracle psu 升级到11.2.0.3.9中， 遭遇：Copy failed from ‘/install/17540582/16902043/files/lib/libnnz11.so' to '/oraapp/oracle/product/11.2.0/dbhome_1/lib/libnnz11.so' please verify all ap...
Oracle 单实例打补丁
小楼一夜听春雨，深巷明朝卖杏花
05-03 1203
今天业务这边需要打一个补丁，具体如图 补丁工具的下载 https://updates.oracle.com/download/6880880.html 这里下载的是默认的32位的，记住如果平台是64位的那么就要使用64位的，32位是不行的。   下载补丁 https://support.oracle.com/epmos/faces/MosIndex.jspx?_af
oracle19c单机应用补丁-缺少包导致失败
kevinyu998的博客
11-17 453
安装oracle19c单机没有显示缺少包，但应用补丁时导致失败，处理办法：#yum -y install psmisc。处理办法：#yum -y install perl。1、缺少fuser命令。
Oracle 12C R2 DB打补丁
Expec-乐的博客
05-11 1469
1 下载软件 MOS文档：Quick Reference to RDBMS Database Patchset And PSU Patch Numbers(文档 ID 753736.1) [root@cndba software]# ll total 115984 -rw-r--r--. 1 root root 118763743 Dec 19 14:08 p26710464_1220...
代码质量管理工具--checkpatch
Edsam--活到老学到老，掌握核心技术，做好产品服务！
05-18 1772
代码质量，关乎软件的稳定性和生命力，能不能给客户提供持续优良的服务！说起来，大家都在做软件开发，代码质量在大多数公司都还是一个口头强调，实际放开的一个状态。有时候，我也给团队培训代码质量规范，这样写，那样写，会上大家感觉也很有用，会后持续的效果又不大好，那时候还比较勤奋，经常去review同事们提交的代码，我们在项目会议上也拿出来分析，哪里写得不错，哪里那样写不规范，时间长了大家的水平就提高了一些，但是后面新来的同事因为没有经历过这样的一个阶段，往往写的代码达不到要求，项目急得时候就直接pus...
windows平台下oracle打补丁报错OUI-67073:UtilSession 失败: Prerequisite check
Mikya_清风的博客
05-26 7472
近期想要给oracle打最新的补丁集，oracle的版本：11.2.0.3和11.2.0.4版本都有，安装平台是windows 2008 R2平台。   首先在mos上下载了最新的BP，解压，用opatch apply的时候报错，提示opatch版本太低，无法升级。于是下载了11.2.0的最新的opatch包p6880880_112000_Linux-x86-64.zip。安装之后
记一次打PSU26635745的过程
文档搬运工
12-23 815
步骤还是那个步骤，关键还是要仔细看下readme。 大概步骤如下： 在安装的过程中，各个节点的GI和Oracle是处于运行状态的。 1 升级Opatch目录，grid用户，oracle用户都需要升级，升级前最好备份下原来的Opatch，或者ORACLE_HOME，这里我只备份了Opatch cp -rf  OPatch $ORACLE_HOME 2 停掉EM，我的环境没有EM
【故障处理】CRS-1153错误处理
coco3600的博客
11-27 419
【故障处理】CRS-1153错误处理 1 CRS-1153: There was an error setting Oracle Clusterware to rolling patch ...
oracle 11G 11.2.0.3.0 升级到11.2.0.3.6遇到的错误。
Rhys learn oracle！
05-15 1988
错误日志： [May 15, 2013 9:16:19 PM] OPatch invoked as follows: 'apply -invPtrLoc /opt/oracle/datasoft/oraInst.loc ' [May 15, 2013 9:16:19 PM] OUI-67077: Oracle Home
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值