oracle 19c rac-m6米乐安卓版下载

m6米乐安卓版下载-米乐app官网下载

oracle 19c rac_ru19.10 打补丁及错误处理简单步骤.txt

jiekexu

1130

3页

16次

2021-09-14

5墨值下载

1、grid 和 oracle 用户替换 opatch

cd /app/soft

unzip p6880880_122010_linux-zser_12.2.0.1.23.zip –d $oracle_home

2、验证opatch 版本

opatch version

opatch version: 12.2.0.1.23

3、grid用户解压19.10 ru补丁（这里必须要用grid用户解压）

cd /app/soft

unzip p32226239_190000_linux-zser-1910.zip

4、检测是否有补丁冲突

grid、oracle 用户均需要执行

$oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir

/app/soft/32226239/32218454

$oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir

/app/soft/32226239/32222571

$oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir

/backup/soft/32126842/32226239/32218454

$oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir

/backup/soft/32126842/32226239/32222571

$oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir

/backup/soft/32126842/32226239/

5、复制 oui-patch.xml 到远程节点注意权限

scp -p jieker1:/u01/app/orainventory/contentsxml/oui-patch.xml ./

6、root 用户分析补丁

/app/app/19.0.0.0/grid/opatch/opatchauto apply /app/soft/32226239 -analyze

/backup/app/19.0.0.0/grid/opatch/opatchauto apply

/backup/soft/32126842/32226239/ -analyze

/u01/app/19.0.0.0/grid/opatch/opatchauto apply /backup/soft/32126842/32226239/

-analyze

root 自动打补丁

/u01/app/19.0.0.0/grid/opatch/opatchauto apply /backup/soft/32126842/32226239/

查看lib包是否有进程占用

fuser /app/app/oracle/product/19.0.0.0/dbhome_1/lib/libsqlplus.so

fuser /app/app/oracle/product/19.0.0.0/dbhome_1/lib/libclntsh.so.19.1

如果存在进程占用，将会产生如下报错

/app/app/oracle/product/19.0.0.0/dbhome_1/bin/expdp at thu mar 04 15:31:14 cst

2021

[mar 4, 2021 3:31:14 pm] [info] following active executables are not used by

opatch process : /app/app/oracle/product/19.0.0.0/dbhome_1/lib/libclntsh.so.19.1

/app/app/oracle/product/19.0.0.0/dbhome_1/lib/libsqlplus.so

following active executables are used by opatch process :

[mar 4, 2021 3:31:14 pm] [info] prerequisite check

"checkactivefilesandexecutables" failed.

the details are:

following active executables are not used by opatch process :

/app/app/oracle/product/19.0.0.0/dbhome_1/lib/libclntsh.so.19.1

/app/app/oracle/product/19.0.0.0/dbhome_1/lib/libsqlplus.so

following active executables are used by opatch process :

[mar 4, 2021 3:31:15 pm] [severe] oui-67073:utilsession failed: prerequisite

check "checkactivefilesandexecutables" failed.

[apr 8, 2021 10:39:06 pm] [info] finish fuser command /bin/fuser

/u01/app/19.0.0.0/grid/bin/expdp at thu apr 08 22:39:06 cst 2021

[apr 8, 2021 10:39:06 pm] [info] following active executables are not used by

opatch process :

/u01/app/19.0.0.0/grid/lib/libasmclntsh19.so

/u01/app/19.0.0.0/grid/lib/libclntsh.so.19.1

following active executables are used by opatch process :

[apr 8, 2021 10:39:06 pm] [info] prerequisite check

"checkactivefilesandexecutables" failed.

the details are:

following active executables are not used by opatch process :

/u01/app/19.0.0.0/grid/lib/libasmclntsh19.so

/u01/app/19.0.0.0/grid/lib/libclntsh.so.19.1

following active executables are used by opatch process :

[apr 8, 2021 10:39:06 pm] [severe] oui-67073:utilsession failed: prerequisite

check "checkactivefilesandexecutables" failed.

可以通过kill占用进程进行处理

jieker1:~ # fuser -kv /u01/app/19.0.0.0/grid/lib/libclntsh.so.19.1

jieker1:~ # fuser -kv /u01/app/19.0.0.0/grid/lib/libasmclntsh19.so

7、检查/app/soft/32226239/32222571/files/bin/ocrcheck.bin 属主(如果使用oracle用

户解压补丁，权限需要修改为grid)

ls –l /app/soft/32226239/32222571/files/bin/ocrcheck.bin

chown grid:oinstall /app/soft/32226239/32222571/files/bin/ocrcheck.bin

单机 asm 出现的权限问题

jiekexu:/u01/app/19.0.0.0/grid/bin # ls -l

/backup/soft/30899722/30894985/files/bin/ocrcheck.bin

-rwx------ 1 oracle oinstall 825152 apr 11 2020

/backup/soft/30899722/30894985/files/bin/ocrcheck.bin

jiekexu:/u01/app/19.0.0.0/grid/bin # chown grid:oinstall

/backup/soft/30899722/30894985/files/bin/ocrcheck.bin

jiekexu:/u01/app/19.0.0.0/grid/bin # ls -l

/backup/soft/30899722/30894985/files/bin/ocrconfig.bin

-rwx------ 1 oracle oinstall 957136 apr 11 2020

/backup/soft/30899722/30894985/files/bin/ocrconfig.bin

jiekexu:/u01/app/19.0.0.0/grid/bin # chown grid:oinstall

/backup/soft/30899722/30894985/files/bin/ocrconfig.bin

jiekexu:/u01/app/19.0.0.0/grid/bin # ls -l

/backup/soft/30899722/30894985/files/bin/ocrconfig.bin

-rwx------ 1 grid oinstall 957136 apr 11 2020

/backup/soft/30899722/30894985/files/bin/ocrconfig.bin

如果权限错误将会产生报错

patch: /app/soft/32226239/32222571

log: /app/app/19.0.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-03-

04_15-43-38pm_1.log

reason: failed during analysis: checkpatchapplicable failed, [ prerequisite

status: failed, prerequisite output:

the details are:

1、grid 和 oracle 用户替换 opatch

cd /app/soft

unzip p6880880_122010_linux-zser_12.2.0.1.23.zip –d $oracle_home

2、验证opatch 版本

opatch version

opatch version: 12.2.0.1.23

3、grid用户解压19.10 ru补丁（这里必须要用grid用户解压）

cd /app/soft

unzip p32226239_190000_linux-zser-1910.zip

4、检测是否有补丁冲突

grid、oracle 用户均需要执行

$oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir

/app/soft/32226239/32218454

$oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir

/app/soft/32226239/32222571

$oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir

/backup/soft/32126842/32226239/32218454

$oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir

/backup/soft/32126842/32226239/32222571

$oracle_home/opatch/opatch prereq checkconflictagainstohwithdetail -phbasedir

/backup/soft/32126842/32226239/

5、复制 oui-patch.xml 到远程节点注意权限

scp -p jieker1:/u01/app/orainventory/contentsxml/oui-patch.xml ./

6、root 用户分析补丁

/app/app/19.0.0.0/grid/opatch/opatchauto apply /app/soft/32226239 -analyze

/backup/app/19.0.0.0/grid/opatch/opatchauto apply

/backup/soft/32126842/32226239/ -analyze

/u01/app/19.0.0.0/grid/opatch/opatchauto apply /backup/soft/32126842/32226239/

-analyze

root 自动打补丁

/u01/app/19.0.0.0/grid/opatch/opatchauto apply /backup/soft/32126842/32226239/

查看lib包是否有进程占用

fuser /app/app/oracle/product/19.0.0.0/dbhome_1/lib/libsqlplus.so

fuser /app/app/oracle/product/19.0.0.0/dbhome_1/lib/libclntsh.so.19.1

如果存在进程占用，将会产生如下报错

/app/app/oracle/product/19.0.0.0/dbhome_1/bin/expdp at thu mar 04 15:31:14 cst

2021

[mar 4, 2021 3:31:14 pm] [info] following active executables are not used by

opatch process : /app/app/oracle/product/19.0.0.0/dbhome_1/lib/libclntsh.so.19.1

/app/app/oracle/product/19.0.0.0/dbhome_1/lib/libsqlplus.so

following active executables are used by opatch process :

[mar 4, 2021 3:31:14 pm] [info] prerequisite check

"checkactivefilesandexecutables" failed.

the details are:

following active executables are not used by opatch process :

/app/app/oracle/product/19.0.0.0/dbhome_1/lib/libclntsh.so.19.1

/app/app/oracle/product/19.0.0.0/dbhome_1/lib/libsqlplus.so

following active executables are used by opatch process :

[mar 4, 2021 3:31:15 pm] [severe] oui-67073:utilsession failed: prerequisite

check "checkactivefilesandexecutables" failed.

[apr 8, 2021 10:39:06 pm] [info] finish fuser command /bin/fuser

/u01/app/19.0.0.0/grid/bin/expdp at thu apr 08 22:39:06 cst 2021

[apr 8, 2021 10:39:06 pm] [info] following active executables are not used by

opatch process :

/u01/app/19.0.0.0/grid/lib/libasmclntsh19.so

/u01/app/19.0.0.0/grid/lib/libclntsh.so.19.1

following active executables are used by opatch process :

[apr 8, 2021 10:39:06 pm] [info] prerequisite check

"checkactivefilesandexecutables" failed.

the details are:

following active executables are not used by opatch process :

/u01/app/19.0.0.0/grid/lib/libasmclntsh19.so

/u01/app/19.0.0.0/grid/lib/libclntsh.so.19.1

following active executables are used by opatch process :

[apr 8, 2021 10:39:06 pm] [severe] oui-67073:utilsession failed: prerequisite

check "checkactivefilesandexecutables" failed.

可以通过kill占用进程进行处理

jieker1:~ # fuser -kv /u01/app/19.0.0.0/grid/lib/libclntsh.so.19.1

jieker1:~ # fuser -kv /u01/app/19.0.0.0/grid/lib/libasmclntsh19.so

7、检查/app/soft/32226239/32222571/files/bin/ocrcheck.bin 属主(如果使用oracle用

户解压补丁，权限需要修改为grid)

ls –l /app/soft/32226239/32222571/files/bin/ocrcheck.bin

chown grid:oinstall /app/soft/32226239/32222571/files/bin/ocrcheck.bin

单机 asm 出现的权限问题

jiekexu:/u01/app/19.0.0.0/grid/bin # ls -l

/backup/soft/30899722/30894985/files/bin/ocrcheck.bin

-rwx------ 1 oracle oinstall 825152 apr 11 2020

/backup/soft/30899722/30894985/files/bin/ocrcheck.bin

jiekexu:/u01/app/19.0.0.0/grid/bin # chown grid:oinstall

/backup/soft/30899722/30894985/files/bin/ocrcheck.bin

jiekexu:/u01/app/19.0.0.0/grid/bin # ls -l

/backup/soft/30899722/30894985/files/bin/ocrconfig.bin

-rwx------ 1 oracle oinstall 957136 apr 11 2020

/backup/soft/30899722/30894985/files/bin/ocrconfig.bin

jiekexu:/u01/app/19.0.0.0/grid/bin # chown grid:oinstall

/backup/soft/30899722/30894985/files/bin/ocrconfig.bin

jiekexu:/u01/app/19.0.0.0/grid/bin # ls -l

/backup/soft/30899722/30894985/files/bin/ocrconfig.bin

-rwx------ 1 grid oinstall 957136 apr 11 2020

/backup/soft/30899722/30894985/files/bin/ocrconfig.bin

如果权限错误将会产生报错

patch: /app/soft/32226239/32222571

log: /app/app/19.0.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-03-

04_15-43-38pm_1.log

reason: failed during analysis: checkpatchapplicable failed, [ prerequisite

status: failed, prerequisite output:

the details are:

of 3

5墨值下载

文档被以下合辑收录

jiekexu dba之路（共191篇）

jiekexu：来自西北，90 后，获得 11g ocp、11g ocm 认证，墨天轮 mvp，墨天轮 2021 十大突出贡献人物之一，此专栏记录一个菜鸟 dba 学习成长之路，欢迎关注公众号 jiekexu dba之路，一起学习进步。

关注

oracle 19c rac-m6米乐安卓版下载

文档被以下合辑收录

评论