Oracle因开启大页内存无法启动ORA-27100: shared memory realm already exists Linux-x86_64 Error: 17: File exists
来源:互联网 发布:视功能优化训练仪 编辑:程序博客网 时间:2024/05/16 06:54
测试环境版本信息:
[root@sourcedb ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.5 (Santiago)
[root@sourcedb ~]# su - oracle
[oracle@sourcedb ~]$ sqlplus
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 14 07:12:04 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
[root@sourcedb ~]# free -m
total used free shared buffers cached
Mem: 988 472 515 0 0 23
-/+ buffers/cache: 448 540
Swap: 2047 265 1782
[root@sourcedb ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 38G 13G 24G 35% /
tmpfs 495M 72K 495M 1% /dev/shm
/dev/sda1 194M 30M 155M 16% /boot
根据Oracle开启大页内存的方式,在/etc/sysctl.conf中添加如下参数:
vm.nr_hugepages = 180
[root@sourcedb ~]# sysctl -p 使该参数生效。
此时启动数据库报错如下:
SQL> startup nomount
ORA-27100: shared memory realm already exists
Linux-x86_64 Error: 17: File exists
Additional information: 2097152
alert日志输出如下:
********************************************************************
Fri Apr 14 07:11:06 2017
Starting ORACLE instance (normal)
在/etc/sysctl.conf中注释掉大页内存参数:
[root@sourcedb ~]# cat /etc/sysctl.conf
...
#vm.nr_hugepages = 180
...
[root@sourcedb ~]# sysctl -p
再次启动数据库正常:
SQL> startup nomount
ORACLE instance started.
Total System Global Area 367439872 bytes
Fixed Size 2253344 bytes
Variable Size 171970016 bytes
Database Buffers 188743680 bytes
Redo Buffers 4472832 bytes
SQL> alter database mount;
Database altered.
SQL> alter database open;
Database altered.
[root@sourcedb ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.5 (Santiago)
[root@sourcedb ~]# su - oracle
[oracle@sourcedb ~]$ sqlplus
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 14 07:12:04 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
[root@sourcedb ~]# free -m
total used free shared buffers cached
Mem: 988 472 515 0 0 23
-/+ buffers/cache: 448 540
Swap: 2047 265 1782
[root@sourcedb ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 38G 13G 24G 35% /
tmpfs 495M 72K 495M 1% /dev/shm
/dev/sda1 194M 30M 155M 16% /boot
根据Oracle开启大页内存的方式,在/etc/sysctl.conf中添加如下参数:
vm.nr_hugepages = 180
[root@sourcedb ~]# sysctl -p 使该参数生效。
此时启动数据库报错如下:
SQL> startup nomount
ORA-27100: shared memory realm already exists
Linux-x86_64 Error: 17: File exists
Additional information: 2097152
alert日志输出如下:
********************************************************************
Fri Apr 14 07:11:06 2017
Starting ORACLE instance (normal)
在/etc/sysctl.conf中注释掉大页内存参数:
[root@sourcedb ~]# cat /etc/sysctl.conf
...
#vm.nr_hugepages = 180
...
[root@sourcedb ~]# sysctl -p
再次启动数据库正常:
SQL> startup nomount
ORACLE instance started.
Total System Global Area 367439872 bytes
Fixed Size 2253344 bytes
Variable Size 171970016 bytes
Database Buffers 188743680 bytes
Redo Buffers 4472832 bytes
SQL> alter database mount;
Database altered.
SQL> alter database open;
Database altered.
阅读全文
0 0
- Oracle因开启大页内存无法启动ORA-27100: shared memory realm already exists Linux-x86_64 Error: 17: File exists
- ORA-27100:shared memory realm already exists
- ORA-27100: shared memory realm already exists
- ORA-27100 shared memory realm already exists
- Oracle_启动报ora-27100:shared memory realm already exists
- Oracle调整内存超出限制出现ORA-27100: shared memory realm already exists问题解决办法
- 数据库无法启动,报错shared memory realm already exists
- 如何解决ORA-27100 shared memory realm already exists错误
- startup nomount ORA-27100: shared memory realm already exists
- ORA-27100:shared memory realm already exists 解决方法
- 解决ORA--27100 shared memory realm already exists报错
- ora-27100:shared memory realm already exists错误的解决
- ORA-27100 shared memory realm already exists错误解决方法
- Oracle在Windows系统中出现的ORA-27100: shared memory realm already exists 的奇怪现象
- Oracle在Windows系统中出现的ORA-27100: shared memory realm already exists 的奇怪现象
- 变态的windows----OERR: ORA-27100 shared memory realm already exists
- 变态的windows的ERR: ORA-27100 shared memory realm already exists
- oracle修改 11g processes参数导致:无法启动解决方法 shared memory realm does not exists
- node学习
- BeanUtils.copyProperties 复制对象异常问题
- 学长教你装系统(二)U盘启动设置
- JVM 垃圾回收器工作原理及使用实例介绍
- 关于本地缓存localstorage与sessionStorage 数组 (array)字符串(string) 对象(object)的存储技巧和注意事项
- Oracle因开启大页内存无法启动ORA-27100: shared memory realm already exists Linux-x86_64 Error: 17: File exists
- CMake安装教程
- 正则表达式re模块
- 关于“危险的”表达
- centos 7部署pptp vpn客户端
- switch case语句踩坑
- 老鼠走迷宫(c/python)
- forin遍历数组并增删其元素导致崩溃
- linux下使用 du查看某个文件或目录占用磁盘空间的大小