12c rac 操作系统内存低导致服务offline(opatch)
商飞翮
12.1.0.2.0,2节点nodes rac,suse11 sp4
数据库服务器上存在应用的脚本，导致在特定时刻内存free过低，最低时100mb，导致自建的service直接offline了。
参见12c memory guard部分。
solution1:(linux only x64)
yzh-rac1:~/Desktop # vim /etc/sysctl.conf
vm.min_free_kbytes = 786432
solution2:
opatch:19582630
unzip the patch:
yzh-rac1:/tmp # chown grid.oinstall p19582630_121020_Linux-x86-64.zip
yzh-rac1:/tmp # su - grid
grid@yzh-rac1:~> unzip p19582630_121020_Linux-x86-64.zip
check ORACLE_HOME,must be set:
grid@yzh-rac1:~> echo $ORACLE_HOME
/oracle/app/12.1.0/grid
check opatch:
grid@yzh-rac1:~> opatch lsinventory -detail -oh $ORACLE_HOME
Oracle Interim Patch Installer version 12.1.0.1.3
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/12.1.0/grid
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/12.1.0/grid/oraInst.loc
OPatch version : 12.1.0.1.3
OUI version : 12.1.0.2.0
Log file location : /oracle/app/12.1.0/grid/cfgtoollogs/opatch/opatch2017-06-05_21-04-30PM_1.log
Lsinventory Output file location : /oracle/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-06-05_21-04-30PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Grid Infrastructure 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Installed Products (101):
Assistant Common Files 12.1.0.2.0
Automatic Storage Management Assistant 12.1.0.2.0
Buildtools Common Files 12.1.0.2.0
Cluster Ready Services Files 12.1.0.2.0
Cluster Verification Utility Common Files 12.1.0.2.0
Cluster Verification Utility Files 12.1.0.2.0
Database Configuration and Upgrade Assistants 12.1.0.2.0
Database Migration Assistant for Unicode 12.1.0.2.0
Database SQL Scripts 12.1.0.2.0
DB TOOLS Listener 12.1.0.2.0
Deinstallation Tool 12.1.0.2.0
Expat libraries 2.0.1.0.2
Hadoopcore Component 12.1.0.2.0
HAS Common Files 12.1.0.2.0
HAS Files for DB 12.1.0.2.0
Installation Common Files 12.1.0.2.0
Installation Plugin Files 12.1.0.2.0
Installer SDK Component 12.1.0.2.0
Java Development Kit 1.6.0.75.0
LDAP Required Support Files 12.1.0.2.0
OLAP SQL Scripts 12.1.0.2.0
Oracle Advanced Security 12.1.0.2.0
Oracle Bali Share 11.1.1.6.0
Oracle Clusterware RDBMS Files 12.1.0.2.0
Oracle Configuration Manager Deconfiguration 10.3.1.0.0
Oracle Containers for Java 12.1.0.2.0
Oracle Core Required Support Files 12.1.0.2.0
Oracle Core Required Support Files for Core DB 12.1.0.2.0
Oracle Database 12c 12.1.0.2.0
Oracle Database 12c Multimedia Files 12.1.0.2.0
Oracle Database Deconfiguration 12.1.0.2.0
Oracle Database User Interface 11.0.0.0.0
Oracle Database Utilities 12.1.0.2.0
Oracle DBCA Deconfiguration 12.1.0.2.0
Oracle Extended Windowing Toolkit 11.1.1.6.0
Oracle Globalization Support 12.1.0.2.0
Oracle Globalization Support 12.1.0.2.0
Oracle Globalization Support For Core 12.1.0.2.0
Oracle Grid Infrastructure 12c 12.1.0.2.0
Oracle Grid Infrastructure Bundled Agents 12.1.0.2.0
Oracle Grid Management Database 12.1.0.2.0
Oracle Help for Java 11.1.1.7.0
Oracle Help Share Library 11.1.1.7.0
Oracle Ice Browser 11.1.1.7.0
Oracle Internet Directory Client 12.1.0.2.0
Oracle Java Client 12.1.0.2.0
Oracle Java Layout Engine 11.0.0.0.0
Oracle JDBC/OCI Instant Client 12.1.0.2.0
Oracle JDBC/THIN Interfaces 12.1.0.2.0
Oracle JFC Extended Windowing Toolkit 11.1.1.6.0
Oracle JVM 12.1.0.2.0
Oracle JVM For Core 12.1.0.2.0
Oracle LDAP administration 12.1.0.2.0
Oracle Locale Builder 12.1.0.2.0
Oracle Multimedia 12.1.0.2.0
Oracle Multimedia Client Option 12.1.0.2.0
Oracle Multimedia Java Advanced Imaging 12.1.0.2.0
Oracle Multimedia Locator 12.1.0.2.0
Oracle Multimedia Locator Java Required Support Files 12.1.0.2.0
Oracle Multimedia Locator RDBMS Files 12.1.0.2.0
Oracle Net 12.1.0.2.0
Oracle Net Java Required Support Files 12.1.0.2.0
Oracle Net Listener 12.1.0.2.0
Oracle Net Required Support Files 12.1.0.2.0
Oracle Netca Client 12.1.0.2.0
Oracle Notification Service 12.1.0.2.0
Oracle Notification Service (eONS) 12.1.0.2.0
Oracle Notification Service for Instant Client 12.1.0.2.0
Oracle One-Off Patch Installer 12.1.0.1.2
Oracle Quality of Service Management (Client) 12.1.0.2.0
Oracle Quality of Service Management (Server) 12.1.0.2.0
Oracle RAC Deconfiguration 12.1.0.2.0
Oracle RAC Required Support Files-HAS 12.1.0.2.0
Oracle Recovery Manager 12.1.0.2.0
Oracle Security Developer Tools 12.1.0.2.0
Oracle Text Required Support Files 12.1.0.2.0
Oracle Universal Connection Pool 12.1.0.2.0
Oracle Universal Installer 12.1.0.2.0
Oracle USM Deconfiguration 12.1.0.2.0
Oracle Wallet Manager 12.1.0.2.0
oracle.swd.oui.core.min 12.1.0.2.0
Parser Generator Required Support Files 12.1.0.2.0
Perl Interpreter 5.14.1.0.0
Perl Modules 5.14.1.0.0
PL/SQL 12.1.0.2.0
PL/SQL Embedded Gateway 12.1.0.2.0
Platform Required Support Files 12.1.0.2.0
Precompiler Required Support Files 12.1.0.2.0
RDBMS Required Support Files 12.1.0.2.0
RDBMS Required Support Files for Instant Client 12.1.0.2.0
RDBMS Required Support Files Runtime 12.1.0.2.0
Required Support Files 12.1.0.2.0
Secure Socket Layer 12.1.0.2.0
SQL*Plus 12.1.0.2.0
SQL*Plus Files for Instant Client 12.1.0.2.0
SQL*Plus Required Support Files 12.1.0.2.0
SSL Required Support Files for InstantClient 12.1.0.2.0
Tracle File Analyzer 12.1.0.2.0
Universal Storage Manager Files 12.1.0.2.0
XDK Required Support Files 12.1.0.2.0
XML Parser for Java 12.1.0.2.0
There are 101 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Patch level status of Cluster nodes :
Patching Level Nodes
-------------- -----
0 yzh-rac2,yzh-rac1
--------------------------------------------------------------------------------
OPatch succeeded.
only need run on one node:
grid@yzh-rac1:~> srvctl stop oc4j
grid@yzh-rac1:~> srvctl disable oc4j
on node1:
root:
yzh-rac1:~/Desktop # /oracle/app/12.1.0/grid/crs/install/rootcrs.pl -prepatch
this will stop the node1's crs!
...
CRS-4133: Oracle High Availability Services has been stopped.
2017/06/05 21:08:54 CLSRSC-4012: Shutting down Oracle Trace File Analyzer (TFA) Collector.
2017/06/05 21:09:26 CLSRSC-4013: Successfully shut down Oracle Trace File Analyzer (TFA) Collector.
2017/06/05 21:09:26 CLSRSC-347: Successfully unlock /oracle/app/12.1.0/grid
grid:
grid@yzh-rac1:/tmp/19582630/19582630> opatch napply -local -oh $ORACLE_HOME -id 19582630
Oracle Interim Patch Installer version 12.1.0.1.3
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/12.1.0/grid
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/12.1.0/grid/oraInst.loc
OPatch version : 12.1.0.1.3
OUI version : 12.1.0.2.0
Log file location : /oracle/app/12.1.0/grid/cfgtoollogs/opatch/opatch2017-06-05_21-10-42PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 19582630
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/app/12.1.0/grid')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '19582630' to OH '/oracle/app/12.1.0/grid'
Patching component oracle.wlm.dbwlm, 12.1.0.2.0...
Verifying the update...
Patch 19582630 successfully applied.
Log file location: /oracle/app/12.1.0/grid/cfgtoollogs/opatch/opatch2017-06-05_21-10-42PM_1.log
OPatch succeeded.
root:
yzh-rac1:~/Desktop # /oracle/app/12.1.0/grid/crs/install/rootcrs.pl -postpatch
...
SQL Patching tool complete on Mon Jun 5 21:15:36 2017
on node2:
grid@yzh-rac1:~> scp /tmp/p19582630_121020_Linux-x86-64.zip yzh-rac2:/tmp
repeat above
and then on all nodes:
grid:
touch $ORACLE_HOME/oc4j/j2ee/home/applications/dbwlm.ear
only on one node:
grid@yzh-rac1:~> srvctl enable oc4j
grid@yzh-rac1:~> srvctl start oc4j
Verify patch application:
on eatch node:
grid@yzh-rac1:~> opatch lsinventory -detail -oh $ORACLE_HOME
Oracle Interim Patch Installer version 12.1.0.1.3
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/12.1.0/grid
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/12.1.0/grid/oraInst.loc
OPatch version : 12.1.0.1.3
OUI version : 12.1.0.2.0
Log file location : /oracle/app/12.1.0/grid/cfgtoollogs/opatch/opatch2017-06-05_21-30-23PM_1.log
Lsinventory Output file location : /oracle/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-06-05_21-30-23PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Grid Infrastructure 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Installed Products (101):
Assistant Common Files 12.1.0.2.0
Automatic Storage Management Assistant 12.1.0.2.0
Buildtools Common Files 12.1.0.2.0
Cluster Ready Services Files 12.1.0.2.0
Cluster Verification Utility Common Files 12.1.0.2.0
Cluster Verification Utility Files 12.1.0.2.0
Database Configuration and Upgrade Assistants 12.1.0.2.0
Database Migration Assistant for Unicode 12.1.0.2.0
Database SQL Scripts 12.1.0.2.0
DB TOOLS Listener 12.1.0.2.0
Deinstallation Tool 12.1.0.2.0
Expat libraries 2.0.1.0.2
Hadoopcore Component 12.1.0.2.0
HAS Common Files 12.1.0.2.0
HAS Files for DB 12.1.0.2.0
Installation Common Files 12.1.0.2.0
Installation Plugin Files 12.1.0.2.0
Installer SDK Component 12.1.0.2.0
Java Development Kit 1.6.0.75.0
LDAP Required Support Files 12.1.0.2.0
OLAP SQL Scripts 12.1.0.2.0
Oracle Advanced Security 12.1.0.2.0
Oracle Bali Share 11.1.1.6.0
Oracle Clusterware RDBMS Files 12.1.0.2.0
Oracle Configuration Manager Deconfiguration 10.3.1.0.0
Oracle Containers for Java 12.1.0.2.0
Oracle Core Required Support Files 12.1.0.2.0
Oracle Core Required Support Files for Core DB 12.1.0.2.0
Oracle Database 12c 12.1.0.2.0
Oracle Database 12c Multimedia Files 12.1.0.2.0
Oracle Database Deconfiguration 12.1.0.2.0
Oracle Database User Interface 11.0.0.0.0
Oracle Database Utilities 12.1.0.2.0
Oracle DBCA Deconfiguration 12.1.0.2.0
Oracle Extended Windowing Toolkit 11.1.1.6.0
Oracle Globalization Support 12.1.0.2.0
Oracle Globalization Support 12.1.0.2.0
Oracle Globalization Support For Core 12.1.0.2.0
Oracle Grid Infrastructure 12c 12.1.0.2.0
Oracle Grid Infrastructure Bundled Agents 12.1.0.2.0
Oracle Grid Management Database 12.1.0.2.0
Oracle Help for Java 11.1.1.7.0
Oracle Help Share Library 11.1.1.7.0
Oracle Ice Browser 11.1.1.7.0
Oracle Internet Directory Client 12.1.0.2.0
Oracle Java Client 12.1.0.2.0
Oracle Java Layout Engine 11.0.0.0.0
Oracle JDBC/OCI Instant Client 12.1.0.2.0
Oracle JDBC/THIN Interfaces 12.1.0.2.0
Oracle JFC Extended Windowing Toolkit 11.1.1.6.0
Oracle JVM 12.1.0.2.0
Oracle JVM For Core 12.1.0.2.0
Oracle LDAP administration 12.1.0.2.0
Oracle Locale Builder 12.1.0.2.0
Oracle Multimedia 12.1.0.2.0
Oracle Multimedia Client Option 12.1.0.2.0
Oracle Multimedia Java Advanced Imaging 12.1.0.2.0
Oracle Multimedia Locator 12.1.0.2.0
Oracle Multimedia Locator Java Required Support Files 12.1.0.2.0
Oracle Multimedia Locator RDBMS Files 12.1.0.2.0
Oracle Net 12.1.0.2.0
Oracle Net Java Required Support Files 12.1.0.2.0
Oracle Net Listener 12.1.0.2.0
Oracle Net Required Support Files 12.1.0.2.0
Oracle Netca Client 12.1.0.2.0
Oracle Notification Service 12.1.0.2.0
Oracle Notification Service (eONS) 12.1.0.2.0
Oracle Notification Service for Instant Client 12.1.0.2.0
Oracle One-Off Patch Installer 12.1.0.1.2
Oracle Quality of Service Management (Client) 12.1.0.2.0
Oracle Quality of Service Management (Server) 12.1.0.2.0
Oracle RAC Deconfiguration 12.1.0.2.0
Oracle RAC Required Support Files-HAS 12.1.0.2.0
Oracle Recovery Manager 12.1.0.2.0
Oracle Security Developer Tools 12.1.0.2.0
Oracle Text Required Support Files 12.1.0.2.0
Oracle Universal Connection Pool 12.1.0.2.0
Oracle Universal Installer 12.1.0.2.0
Oracle USM Deconfiguration 12.1.0.2.0
Oracle Wallet Manager 12.1.0.2.0
oracle.swd.oui.core.min 12.1.0.2.0
Parser Generator Required Support Files 12.1.0.2.0
Perl Interpreter 5.14.1.0.0
Perl Modules 5.14.1.0.0
PL/SQL 12.1.0.2.0
PL/SQL Embedded Gateway 12.1.0.2.0
Platform Required Support Files 12.1.0.2.0
Precompiler Required Support Files 12.1.0.2.0
RDBMS Required Support Files 12.1.0.2.0
RDBMS Required Support Files for Instant Client 12.1.0.2.0
RDBMS Required Support Files Runtime 12.1.0.2.0
Required Support Files 12.1.0.2.0
Secure Socket Layer 12.1.0.2.0
SQL*Plus 12.1.0.2.0
SQL*Plus Files for Instant Client 12.1.0.2.0
SQL*Plus Required Support Files 12.1.0.2.0
SSL Required Support Files for InstantClient 12.1.0.2.0
Tracle File Analyzer 12.1.0.2.0
Universal Storage Manager Files 12.1.0.2.0
XDK Required Support Files 12.1.0.2.0
XML Parser for Java 12.1.0.2.0
There are 101 products installed in this Oracle Home.
Interim patches (1) :
Patch 19582630 : applied on Mon Jun 05 21:24:21 CST 2017
Unique Patch ID: 18094752
Patch description: "WLM Patch Set Update: 12.1.0.2.0 (19582630)"
Created on 14 Nov 2014, 21:43:23 hrs PST8PDT
Bugs fixed:
19582630
Files Touched:
dbwlm.ear --> ORACLE_HOME/oc4j/j2ee/home/applications/dbwlm.ear
wlmdus.msg --> ORACLE_HOME/wlm/mesg/wlmdus.msg
wlmfus.msg --> ORACLE_HOME/wlm/mesg/wlmfus.msg
wlmgus.msg --> ORACLE_HOME/wlm/mesg/wlmgus.msg
wlmvus.msg --> ORACLE_HOME/wlm/mesg/wlmvus.msg
Patch Location in Inventory:
/oracle/app/12.1.0/grid/inventory/oneoffs/19582630
Patch Location in Storage area:
/oracle/app/12.1.0/grid/.patch_storage/19582630_Nov_14_2014_21_43_23
Patch level status of Cluster nodes :
Patching Level Nodes
-------------- -----
3855012020 yzh-rac2,yzh-rac1
--------------------------------------------------------------------------------
OPatch succeeded.
类似资料：