dba linux 内核,ORA-27104: system-defined limits for shared memory was misconfigured与Linux内核参数配置有关的案例...

```

[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 ...