12c rac 操作系统内存低导致服务offline(opatch)

最新推荐文章于 2021-04-06 17:03:54 发布
最新推荐文章于 2021-04-06 17:03:54 发布
阅读量536 收藏
点赞数
分类专栏： ORACLE
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/ibsfn/article/details/72895937
版权

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.



30baby
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
ORACLE 12C RAC 主库配置单实例ADG
02-08
ORACLE 12C RAC 主库配置单实例 ADG Oracle 12C RAC 主库配置单实例 ADG 是一种高可用性和灾难恢复解决方案，旨在提供高可用性和数据保护。下面将详细介绍 ORACLE 12C RAC 主库配置单实例 ADG 的知识点。 一、...
Oracle12C RAC安装操作文档（4节点）
02-23
本文详细记录RedHat 6.5操作系统上按照oracle 12c RAC 4节点的的过程，图文并茂，与志同道合者共勉！
12c rac 实例无法启动之磁盘组空间耗尽
weixin_33923762的博客
11-15 193
一、环境描述 oracle 12c rac 二、处理过程 1、实例启动失败 SYS@orcl1> startup ORACLE instance started. Total System Global Area 1241513984 bytes Fixed Size 2923872 bytes Variabl...
oracle ons offline 服务启动失败
Story_begins的博客
08-27 1111
oracle ons offline 服务启动失败 什么是ons Oracle Notification Service (ONS) 事件通知服务 A publish and subscribe service for communicating information about all FAN events Fast Application Notification (FAN) 快速应用通知 Applications can use FAN to enable rapid failure de
oracle12c RAC搭建之三GI安装图解（3）
moscot_wu的博客
11-04 7774
接上幕，服务器环境配置完毕以后，接下来就是程序的安装了。安装图解如下。 安装之前需要关闭三台服务器的防火墙。 安装用户使用oracle用户，为后面安装rac数据库创建所有的组和ASM组 [root@host01 ~]# useradd oracle [root@host01 ~]# groupadd oinstall [root@host01 ~]# groupadd dba [root@
安装RAC集群时，第二个节点root.sh失败的处理
Michael_A的博客
02-23 5058
CLSRSC-507: The root script cannot proceed on this node <node-n> (文档 ID 1919825.1) Purpose Details Case 1: root script didn't succeed on first node Case 2: root script completed on first node bu...
oracle rac监听程序,oracle 11g rac 监听程序offline
weixin_28841265的博客
04-06 116
oracle 11g rac 监听程序在调整过网络后出现监听进程offline，而且两台节点之间频繁切换，查看日志/var/log/message 发现有频繁的注册撤销动作。监听日志 /u01/app/oracle/diag/tnslsnr/rac1/listener/trace/listener.log监听文件 /u01/app/11.2.0/grid/network/admin/listene...
Oracle 12C RAC For LINUX安装作业指导书
08-15
本文是由丰富实际操作经验的OCM大神编写的一篇oracle 12C RAC安装手册，有了它普通的oracle小白也会很快的安装oracle rac。 oracle rac安装手册
ORACLE 12C RAC到单机 DG搭建
09-30
ORACLE 12C RAC 到 单机 DG 部署详细过程，遇到任何问题可以留言
Oracle12c RAC For Centos7部署
06-18
通过本课程使学员掌握在Linux环境下的OracleRAC安装配置;使数据库管理员为Oracle RAC集群管理任务打下坚实的基础。...此课程是基于vmware虚拟机和Linux操作系统讲解;课程中的安装步骤可用于生产环境配置和管理。
Oracle RAC命令
Baldwin的博客
03-10 1056
自己整理笔记使用 HAIP：私有网卡用作两个节点之间的通信，他的健壮性很重要，之前都是通过bonding这种技术来做私有网卡的冗余，Oracle11.2.0.2之后有了HAIP这种技术，Oracle 提供私有网卡的冗余 [grid@rac01 ~]$ ip a 3: eth1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo...
一次oracle rac 监听不定时offline处理过程
clt3617的博客
10-31 251
最近客户一生产系统上也遇到了这个问题,肯定和网络有关,不过原因还没有查清楚. --================================== 原文连接: http://blog.itpub.net/12272...
Oracle 12c RAC配置
YiChen的博客
01-09 1631
Oracle 12c RAC配置
Oracle 12c rac搭建
weixin_34008784的博客
01-02 354
1.1 硬件需求 Ø 服务器具有相同的体系架构（如 64bit 和 32bit 不能同一集群） Ø 非 cluster 环境要求物理内存高于 2G，cluster 环境要求物理内存高于 3G 1.2 操作系统要求 Ø 操作系统版本要保持至少和源端一样或者更高的版本，操作系统补丁和源端一致 Ø 数据库版本11.2.0.3.0，要求AIX6.1 TL04以上、7.1 Ø 数据库...
ORACLE 12C R2 RAC实战首发
热门推荐
IT圈黎俊杰
06-03 2万+
redhat 6.5安装oracle 12.2 RAC指导手册
12c新特性-感受ORACLE 12C IN_MEMORY
oradbm的博客
10-17 693
Oracle 12C In-Memory特性研究 一、Oracle In-Memory 行格式与列格式： Oracle 数据库传统上以行格式存储数据。在行格式数据库中，数据库中存储的每个新事务或新记录都表示为表中的一个新行，而在查询数据时是利用传统BUFFER CACHE。 列格式数据库将表以单独的列结构存储到内存中。列格式适用于报表类，分析，选择少量列但是查询要访问大部分的数据的场景。 ...
3、vSphere Oracle12cR2的RAC搭建安装之配置共享存储
yuzifen的专栏
09-07 3165
一、第一台机器添加两个虚拟磁盘，配置SCSI "虚拟设备节点"选择独立的SCSI 设备节点，若原来本地使用SCSI(0:0)，那现在可以选SCSI(1:0)，反正冒号前的数字不能与本地SCSI设备一样;(为了避免快照对各虚拟机的影响，"模式"选择"持久"方式) 创建虚拟机的时候，到选择硬盘步骤的时候，最好选择Thin Provision能节约一些硬盘空间 就是空间用多...
oracle11gRAC的oc4j和gsd服务都处于offline状态
Data & Analysis
11-25 3012
oracle11gRAC的oc4j和gsd服务都处于offline状态   # 环境: 操作系统 $ uname -a Linux jinhu-db02 2.6.32-696.el6.x86_64 #1 SMP Tue Mar 21 19:29:05 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux $ cat /etc/redhat-release  ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值