Errors in file /u01/app/oracle/oracle/diag/rdbms/orcl/orcl/trace/orcl_j000_61543.trc (incident=180099):
ORA-04030: out of process memory when trying to allocate 169040 bytes (pga heap,kgh stack)
ORA-04030: out of process memory when trying to allocate 432 bytes (kxs-heap-c,kprbalo temp memory)
Incident details in: /u01/app/oracle/oracle/diag/rdbms/orcl/orcl/incident/incdir_180099/orcl_j000_61543_i180099.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
 

adrci> show incident

ADR Home = /u01/app/oracle/oracle/diag/tnslsnr/DBSERVER02/listener:
*************************************************************************
0 rows fetched

ADR Home = /u01/app/oracle/oracle/diag/clients/user_oracle/host_312164965_80:
*************************************************************************
0 rows fetched

ADR Home = /u01/app/oracle/oracle/diag/rdbms/orcl/orcl:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- -----------------------------------------

168744 ORA 4030 2020-05-01 22:03:16.928000 +08:00
168745 ORA 4030 2020-05-01 22:03:18.618000 +08:00
168746 ORA 4030 2020-05-01 22:03:20.050000 +08:00
168747 ORA 4030 2020-05-01 22:06:00.084000 +08:00
168748 ORA 4030 2020-05-01 22:06:01.557000 +08:00
180101 ORA 4030 2020-05-03 06:08:29.841000 +08:00
180102 ORA 4030 2020-05-03 06:08:31.289000 +08:00
180103 ORA 4030 2020-05-03 06:08:32.698000 +08:00
180104 ORA 4030 2020-05-05 22:04:16.589000 +08:00
180105 ORA 4030 2020-05-05 22:04:18.165000 +08:00
180106 ORA 4030 2020-05-05 22:04:19.576000 +08:00
180107 ORA 4030 2020-05-06 22:05:57.267000 +08:00
180108 ORA 4030 2020-05-06 22:05:58.936000 +08:00

 

[oracle@DBSERVER02 pst]$ oerr ora 4030
04030, 00000, "out of process memory when trying to allocate %s bytes (%s,%s)"
// *Cause: Operating system process private memory was exhausted.
// *Action:

1、修改系统参数文件
vi /etc/sysctl.conf
添加
vm.max_map_count=200000
2、关闭数据库
3、使参数生效sysctl -p,或重启操作系统
4、启动数据库
或者
修改数据库隐含参数
_realfree_heap_pagesize_hint=262144

最新文章

  1. MapReduce剖析笔记之三:Job的Map/Reduce Task初始化
  2. jquery点击获取子元素ID值
  3. Java的Package和Classpath
  4. php捕捉来自搜索引擎的用户IP地址时间和访问路径
  5. Javascript函数节流
  6. datatables笔记
  7. 解决SSH会话连接超时问题
  8. 如何使用vs将现有的项目或者文件夹(尤其是多层目录的)添加到项目中
  9. SPOJ287 Smart Network Administrator(最大流)
  10. jQuery导航菜单防刷新
  11. vi 或 vim 常用命令(简单够用了)
  12. MFC消息映射与命令传递
  13. 统计字符 比如aaabbcca----3a2b1c1a
  14. crm使用soap创建下拉框
  15. 关于echarts使用的各种问题
  16. [BZOJ3675]序列分割
  17. js闭包的真正理解
  18. 防止系统锁屏-python、C++实现
  19. .net相关知识
  20. docker-compose.yml 示例

热门文章

  1. idea提升效率的插件
  2. 多线程系列(二)之Thread类
  3. centos7 nginx yum 配置
  4. .NET 设计模式 思维导图
  5. 牛客网PAT练兵场-科学计数法
  6. 4gl游标cursor
  7. unity 对Animator动画系统的研究
  8. react native 常用学习或查资料网址
  9. Pinpoint 一款强大的APM工具
  10. Eclipse的安装和配置