oracle11g安装空闲空间,11gR2 GI打PSU ORACLE_HOME空间不足案例—需要20G以上空闲空间...

于 2021-04-03 21:36:52 发布
阅读量294 收藏
点赞数
文章标签： oracle11g安装空闲空间

GI打auto打patch命令 #/u01/oracle/app/grid/OPatch/opatch auto /u01/soft/18706472 -ocmrf /u01/soft/ocm.rspExecuting /u01/oracle/app/grid/perl/bin/perl /u01/oracle/app/grid/OPatch/crs/patch11203.pl -patchdir /u01/soft -patchn 18706472 -ocmrf

GI打auto打patch命令

#/u01/oracle/app/grid/OPatch/opatch auto /u01/soft/18706472 -ocmrf /u01/soft/ocm.rsp

Executing /u01/oracle/app/grid/perl/bin/perl /u01/oracle/app/grid/OPatch/crs/patch11203.pl

-patchdir /u01/soft -patchn 18706472 -ocmrf /u01/soft/ocm.rsp -paramfile /u01/oracle/app/grid/crs/install/crsconfig_params

This is the main log file: /u01/oracle/app/grid/cfgtoollogs/opatchauto2014-10-15_01-15-28.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:

/u01/oracle/app/grid/cfgtoollogs/opatchauto2014-10-15_01-15-28.report.log

2014-10-15 01:15:28: Starting Clusterware Patch Setup

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

Stopping CRS...

Stopped CRS successfully

patch /u01/soft/18706472/18522509 apply successful for home /u01/oracle/app/grid

patch /u01/soft/18706472/18522515 apply failed for home /u01/oracle/app/grid

Starting CRS...

Installing Trace File Analyzer

CRS-4123: Oracle High Availability Services has been started.

opatch auto succeeded.

这里可以看到,打patch 18522509成功,后续patch都失败,而不是仅仅18522515失败

分析错误日志

Composite patch 18522509 successfully applied.

OPatch Session completed with warnings.

Log file location: /u01/oracle/app/grid/cfgtoollogs/opatch/opatch2014-10-15_01-19-00AM_1.log

OPatch completed with warnings.

2014-10-15 01:21:44: patch /u01/soft/18706472/18522509 apply successful for home /u01/oracle/app/grid

2014-10-15 01:21:44: Executing command /u01/oracle/app/grid/OPatch/opatch napply /u01/soft/18706472/18522515 -local -silent -ocmrf /

u01/soft/ocm.rsp -oh /u01/oracle/app/grid -invPtrLoc /u01/oracle/app/grid/oraInst.loc as grid

2014-10-15 01:21:44: Running as user grid: /u01/oracle/app/grid/OPatch/opatch napply /u01/soft/18706472/18522515 -local -silent -ocm

rf /u01/soft/ocm.rsp -oh /u01/oracle/app/grid -invPtrLoc /u01/oracle/app/grid/oraInst.loc

2014-10-15 01:21:44: s_run_as_user2: Running /bin/su grid -c ' /u01/oracle/app/grid/OPatch/opatch napply /u01/soft/18706472/18522515

-local -silent -ocmrf /u01/soft/ocm.rsp -oh /u01/oracle/app/grid -invPtrLoc /u01/oracle/app/grid/oraInst.loc '

2014-10-15 01:21:49: Removing file /tmp/uaa7jC7eu

2014-10-15 01:21:49: Successfully removed file: /tmp/uaa7jC7eu

2014-10-15 01:21:49: /bin/su exited with rc=73

2014-10-15 01:21:49: status of apply patch is 18688

2014-10-15 01:21:49: The apply patch output is Oracle Interim Patch Installer version 11.2.0.3.6

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

Oracle Home : /u01/oracle/app/grid

Central Inventory : /u01/oracle/app/oraInventory

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

OPatch version : 11.2.0.3.6

OUI version : 11.2.0.4.0

Log file location : /u01/oracle/app/grid/cfgtoollogs/opatch/opatch2014-10-15_01-21-44AM_1.log

Verifying environment and performing prerequisite checks...

Prerequisite check "CheckSystemSpace" failed.

The details are:

Required amount of space(24021.839MB) is not available.

UtilSession failed:

Prerequisite check "CheckSystemSpace" failed.

Log file location: /u01/oracle/app/grid/cfgtoollogs/opatch/opatch2014-10-15_01-21-44AM_1.log

OPatch failed with error code 73

这里可以看出来,patch 18522509 成功,但是18522515在check的时候失败,由于$ORACLE_HOME(GI)需要可用空间为24021.839MB,现在空闲空间不足

查看空间并腾空间

# df -g

Filesystem GB blocks Free %Used Iused %Iused Mounted on

/dev/hd4 10.00 9.56 5% 12443 1% /

/dev/hd2 15.00 11.42 24% 60339 3% /usr

/dev/hd9var 10.00 9.91 1% 3310 1% /var

/dev/hd3 10.00 9.65 4% 364 1% /tmp

/dev/hd1 10.00 10.00 1% 32 1% /home

/dev/hd11admin 0.25 0.25 1% 5 1% /admin

/proc - - - - - /proc

/dev/hd10opt 10.00 8.98 11% 12401 1% /opt

/dev/fslv00 50.00 12.94 75% 59137 2% /u01

/dev/odm 0.00 0.00 -1% 6 100% /dev/odm

/dev/vx/dsk/crs_dg/crs_vol 1.96 1.75 12% 5 1% /crsdata

/dev/vx/dsk/ora_dg/data01_vol 2048.00 2031.32 1% 4 1% /oradata/data01

/dev/vx/dsk/ora_dg/sys_vol 400.00 350.29 13% 3702 1% /oradata/sys

# cd /u01

# ls

lost+found oracle soft

# cd soft

# du -sg

17.34 .

# mv /u01/soft /oradata/sys/

# df -g

Filesystem GB blocks Free %Used Iused %Iused Mounted on

/dev/hd4 10.00 9.56 5% 12443 1% /

/dev/hd2 15.00 11.42 24% 60339 3% /usr

/dev/hd9var 10.00 9.91 1% 3310 1% /var

/dev/hd3 10.00 9.65 4% 364 1% /tmp

/dev/hd1 10.00 10.00 1% 32 1% /home

/dev/hd11admin 0.25 0.25 1% 5 1% /admin

/proc - - - - - /proc

/dev/hd10opt 10.00 8.98 11% 12401 1% /opt

/dev/fslv00 50.00 27.56 45% 59137 2% /u01

/dev/odm 0.00 0.00 -1% 6 100% /dev/odm

/dev/vx/dsk/crs_dg/crs_vol 1.96 1.75 12% 5 1% /crsdata

/dev/vx/dsk/ora_dg/data01_vol 2048.00 2031.32 1% 4 1% /oradata/data01

/dev/vx/dsk/ora_dg/sys_vol 400.00 333.54 14% 3702 1% /oradata/sys

# cd soft

# ls -ltr

total 12464202

drwxr-xr-x 5 grid dba 1024 Jul 07 21:06 18706472

-rw-rw-r-- 1 grid dba 2123 Jul 15 20:06 PatchSearch.xml

-rw-r--r-- 1 root system 1801653734 Oct 14 14:39 p13390677_112040_aix64-5l_1of7.zip

-rw-r--r-- 1 root system 1170882875 Oct 14 14:40 p13390677_112040_aix64-5l_2of7.zip

-rw-r--r-- 1 root system 2127071138 Oct 14 14:41 p13390677_112040_aix64-5l_3of7.zip

-rw-r--r-- 1 root system 1242090126 Oct 14 14:43 p18706472_112040_AIX64-5L.zip

-rw-r--r-- 1 root system 34964928 Oct 14 14:43 p6880880_112000_AIX64-5L.zip

-rwxr-xr-x 1 root system 127965 Oct 14 14:48 unzip_aix

-rw-r--r-- 1 root system 4871110 Oct 14 14:50 ONEOFF_112043_AIX64.zip

drwxr-xr-x 8 grid dba 1024 Oct 14 14:55 grid

drwxr-xr-x 8 oracle dba 1024 Oct 14 14:57 database

-rw-r--r-- 1 grid dba 621 Oct 15 00:11 ocm.rsp

确实/u01空间不足,通过把RAC安装文件迁移到其他目录,确保/u01有足够空间用来打patch

回退命令

# /u01/oracle/app/grid/OPatch/opatch auto /u01/soft/18706472 -rollback -ocmrf /u01/soft/ocm.rsp

重新打patch

#/u01/oracle/app/grid/OPatch/opatch auto /u01/soft/18706472 -ocmrf /u01/soft/ocm.rsp <

Executing /u01/oracle/app/grid/perl/bin/perl /u01/oracle/app/grid/OPatch/crs/patch11203.pl -patchdir /oradata/sys/soft

-patchn 18706472 -ocmrf /oradata/sys/soft/ocm.rsp -paramfile /u01/oracle/app/grid/crs/install/crsconfig_params

This is the main log file: /u01/oracle/app/grid/cfgtoollogs/opatchauto2014-10-15_01-57-42.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:

/u01/oracle/app/grid/cfgtoollogs/opatchauto2014-10-15_01-57-42.report.log

2014-10-15 01:57:42: Starting Clusterware Patch Setup

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

Stopping CRS...

Stopped CRS successfully

patch /oradata/sys/soft/18706472/18522509 apply successful for home /u01/oracle/app/grid

patch /oradata/sys/soft/18706472/18522515 apply successful for home /u01/oracle/app/grid

patch /oradata/sys/soft/18706472/18522514 apply successful for home /u01/oracle/app/grid

Starting CRS...

Installing Trace File Analyzer

CRS-4123: Oracle High Availability Services has been started.

opatch auto succeeded.

检查确认patch成功

# su - grid

xifenfei1:/home/grid> opatch lspatches

18522514;ACFS PATCH SET UPDATE : 11.2.0.4.3 (18522514)

18522515;OCW Patch Set Update : 11.2.0.4.3 (18522515)

18522509;Database Patch Set Update : 11.2.0.4.3 (18522509)

xifenfei1:/home/grid> crsctl status res -t

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

NAME TARGET STATE SERVER STATE_DETAILS

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

Local Resources

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

ora.LISTENER.lsnr

ONLINE ONLINE xifenfei1

ONLINE ONLINE xifenfei2

ora.asm

OFFLINE OFFLINE xifenfei1

OFFLINE OFFLINE xifenfei2

ora.gsd

OFFLINE OFFLINE xifenfei1

OFFLINE OFFLINE xifenfei2

ora.net1.network

ONLINE ONLINE xifenfei1

ONLINE ONLINE xifenfei2

ora.ons

ONLINE ONLINE xifenfei1

ONLINE ONLINE xifenfei2

ora.registry.acfs

OFFLINE OFFLINE xifenfei1

OFFLINE OFFLINE xifenfei2

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

Cluster Resources

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

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE xifenfei2

ora.cvu

1 ONLINE ONLINE xifenfei2

ora.xifenfei1.vip

1 ONLINE ONLINE xifenfei1

ora.xifenfei2.vip

1 ONLINE ONLINE xifenfei2

ora.oc4j

1 ONLINE ONLINE xifenfei2

ora.scan1.vip

1 ONLINE ONLINE xifenfei2

打patch出现Copy failed—tfa服务导致部分lib未释放

11.2.0.4 GI单独安装tfa

OLR相关维护

Oracle 小升级 opatch apply使用

因asm sga_target设置不当导致11gr2 rac无法正常启动

在11GR2 GI上配置第二个监听

ORACLE 12C RAC修改ocr/votedisk/asm spfile所在磁盘组名称

10.2.0.x升级到10.2.0.5.5

毛航宇
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值