联系:手机/微信(+86 17813235971) QQ(107644445)
标题:11.2.0.4 打patch遭遇extjobO: Operation not permitted处理
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
有一段时间没有给11.2.0.4打psu补丁了,今天晚上在给一个客户打的过程中发现类似错误
OPatch found the word "error" in the stderr of the make command. Please look at this stderr. You can re-run this make command. Stderr output: chmod: changing permissions of `/u01/app/oracle/product/11.2.0/db_1/bin/extjobO': Operation not permitted make: [iextjob] Error 1 (ignored) Composite patch 31537677 successfully applied. OPatch Session completed with warnings. Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2021-04-16_23-11-48PM_1.log OPatch completed with warnings.
对比extjob权限信息
[oracle@localhost trace]$ ls -l /u01/app/oracle/product/11.2.0/db_1/bin/extjob* -rwxr-xr-x 1 oracle oinstall 1254496 Apr 16 23:15 /u01/app/oracle/product/11.2.0/db_1/bin/extjob -rwx------ 1 oracle oinstall 1254496 Apr 16 23:15 /u01/app/oracle/product/11.2.0/db_1/bin/extjobo -rwsr-x--- 1 root oinstall 1254244 Feb 13 2019 /u01/app/oracle/product/11.2.0/db_1/bin/extjobO -rw------- 1 oracle oinstall 1254244 Feb 13 2019 /u01/app/oracle/product/11.2.0/db_1/bin/extjoboO
证明新的extjob程序确实权限不对,不过根据官方的建议可以忽略这个,参考link:
https://updates.oracle.com/Orion/Services/download?type=readme&aru=20775452
Applying Proactive Bundle / PSU Patch fails with Error: “chmod: changing permissions of `$ORACLE_HOME/bin/extjobO’: Operation not permitted” (Doc ID 2265726.1)
给出来的理由是执行root.sh之后权限会变成正常的,另外这个external jobs基本上很少人会使用到,尝试执行root.sh修复
[root@localhost home]# /u01/app/oracle/product/11.2.0/db_1/root.sh Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/11.2.0/db_1 Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite. Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Finished product-specific root actions. [root@localhost home]# ls -l /u01/app/oracle/product/11.2.0/db_1/bin/extjob* -rwsr-x--- 1 root oinstall 1254496 Apr 16 23:15 /u01/app/oracle/product/11.2.0/db_1/bin/extjob -rwx------ 1 oracle oinstall 1254496 Apr 16 23:15 /u01/app/oracle/product/11.2.0/db_1/bin/extjobo -rwsr-x--- 1 root oinstall 1254244 Feb 13 2019 /u01/app/oracle/product/11.2.0/db_1/bin/extjobO -rw------- 1 oracle oinstall 1254244 Feb 13 2019 /u01/app/oracle/product/11.2.0/db_1/bin/extjoboO
确实通过执行root.sh修复该问题.