```
[oracle@WWJD01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Fri Sep 21 15:11:52 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-27104: system-defined limits for shared memory was misconfigured
SQL>
```
- alert log
```
2018-09-21T15:05:16.542629+08:00
Starting ORACLE instance (normal) (OS id: 48277)
2018-09-21T15:05:16.552691+08:00
CLI notifier numLatches:97 maxDescs:19852
2018-09-21T15:05:16.554591+08:00
System cannot support SGA size of 81335943168 bytes
2018-09-21T15:05:16.554690+08:00
Current maximum shared memory configured 8589934592 bytes
2018-09-21T15:05:16.554781+08:00
Increase the system shared memory size to atleast 81335943168 bytes
```
```
[root@WWJD01 ~]# ipcs -l
------ Shared Memory Limits --------
max number of segments = 40960
max seg size (kbytes) = 32768
max total shared memory (kbytes) = 8388608
min seg size (bytes) = 1
------ Semaphore Limits --------
max number of arrays = 128
max semaphores per array = 250
max semaphores system wide = 32000
max ops per semop call = 100
semaphore max value = 32767
------ Messages: Limits --------
max queues system wide = 36430
max size of message (bytes) = 131072
default max size of queue (bytes) = 131072
```
- 节点2
```
[root@WWJD02 ~]# ipcs -l
------ Shared Memory Limits --------
max number of segments = 40960
max seg size (kbytes) = 132102588
max total shared memory (kbytes) = 105682068
min seg size (bytes) = 1
------ Semaphore Limits --------
max number of arrays = 128
max semaphores per array = 250
max semaphores system wide = 32000
max ops per semop call = 100
semaphore max value = 32767
------ Messages: Limits --------
max queues system wide = 36430
max size of message (bytes) = 131072
default max size of queue (bytes) = 131072
```
```
cat /etc/sysctl.conf
```
- 集成方案值
```
kernel.shmall = 184467440736927743990
kernel.shmmax = 184467440736927743990
```
- 修改后值
```
kernel.shmall = 26420517
kernel.shmmax = 135273050112
```
- Oracle建议值
```
kernel.shmall = 66051072
kernel.shmmax = 162327114547
kernel.shmall:控制共享内存页数,该参数大小为物理内存除以pagesize
kernel.shmmax:设置为实际物理内存的2/3
```
```
[root@WWJD01 ~]# getconf PAGESIZE
4096
```
```
[root@WWJD01 ~]# free -m
total used free shared buffers cached
Mem: 258012 87100 170912 78214 225 79199
-/+ buffers/cache: 7675 250337
Swap: 65535 0 65535
```
```
kernel.shmall = 258012*1024/4=66051072
kernel.shmmax = 258012*1024*1024*0.6=162327114547.2
```
boost Shared Memory
Shared Memory Shared memory is typically the fastest form of interprocess communicatioin. It provide ...
ORA-27101: shared memory realm does not exist
Oracle Error Tips by Burleson Consulting Oracle docs note this about ORA-27101: ORA-27101: shared me ...
zabbix登陆问题:cannot allocate shared memory for collector
问题说明:在一台zabbix被监控服务器上(64位centos6.8系统,64G内容)启动zabbix_agent,发现进程无法启动,10050端口没有起来! 启动zabbix_agent进程没有报错 ...
Oracle调整内存超出限制出现ORA-27100: shared memory realm already exists问题解决办法
今天测试服务器遇到问题 ORA-04030:out of process memory when trying to allocate string bytes 一看就猜到是内存不足了,把Oracle ...
Oracle:shared memory realm does not exist
1. 先描述一个连接Oracle 10g的错误:“shared memory realm does not exist” 如图所示Sqlplus连接时出现这个错误: 2. Oracle 服务器主要组件 ...
解决zabbix的cannot allocate shared memory of size错误
问题状态:zabbix_server 不能启动,系统CentOS 6.7 原因分析:这是因为内核对share memory的限制造成的. 用到如下命令ipcs [-m|l|a],sysctl [-a| ...
shared memory realm does not exist
有天启动ORACLE,碰到如下问题 提示ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist 解决 ...
随机推荐
c#读写txt
附加到txt:StreamWriter sw =System.IO.File.AppendText(path); //绝对路径 sw.Write("写入内容"); 写入到txt: ...
require,include,require_once,include_once的区别
最近面试时被问到,一时间还真没想到太多,仅仅回答了大概的几个,于是回来再确认一下. 以下内容为网络摘抄: ①作用及用法 可以减少代码的重复 include(_once)("文件的路径&qu ...
Elasticsearch template(待续...)
动态模板 Dynamic templates allow you to define custom mappings that can be applied to dynamically added ...
[置顶] 学习鸟哥的Linux私房菜笔记(6)——过滤器、输入输出及管道
一.过滤器 Linux中的应用工具分为三种: 交互工具 过滤器 编辑器 能够接受数据,过滤再输出的工具,称之为过滤器 对过滤器和进程,存在着输入源与输出对象 二.输入.输出.重定向 输入:过滤器的数据 ...
【Android进阶】Activity的四种加载模式
Activity的四种加载模式: 1.standard :系统的默认模式,一次跳转即会生成一个新的实例.假设有一个activity命名为Act1, 执行语句:startActivity(new Int ...
java利用poi导出数据到excel
背景: 上一篇写到利用jtds连接数据库获取对应的数据,本篇写怎样用poi将数据到处到excel中,此程序为Application 正文: 第三方poi jar包:poi驱动包下载 代码片段: /** ...
【项目笔记】拿宽高前measure(widthMeasureSpec, heightMeasureSpec)的使用技巧
我们知道获取宽高一般写法是: view.measure(0, 0); view.getMeasuredHeight(); 拿宽高前什么时候可以直接用measure(0, 0);而什么时候不能用meas ...
JAVA-getComponent()与getSource()
两个方法都是获取发生事件的事件源对象,区别也许是返回的类型不同,如果是getSource()需要强制类型转换为Component 对象:而getComponent()无需转换: API的说明如下: 类 ...
Kubernetes 无法删除pod实例的排查过程
今天在k8s集群创建pod时,执行了如下命令: #kubectl run busybox-service --image=busybox --replicas=3 但是在创建过程中pod既然失败了, ...
[javaSE] 变量的传值与传址
变量:就是将不确定的数据进行存储.也就是需要在内存中开辟一个空间 这个空间需要一个名称,这个名称就是变量名 基本数据类型:byte,short,int,long,double,float,char,b ...