个人简介
偶尔有空上来看看
文章分类
文章存档
最近访客
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2020-12-09 17:05:30
看了看alert.log 发现很多报错，刷刷刷的很快
[oracle@host01 ~]$ tail -100 alert_orcl1.log
ora-00603: oracle server session terminated by fatal error
ora-27544: failed to map memory region for export
ora-27300: os system dependent operation:bind failed with status: 98
ora-27301: os failure message: address already in use
ora-27302: failure occurred at: sskgxpcre3
tue oct 27 00:01:38 2020
trace dumping is performing id=[cdmp_20201027000138]
tue oct 27 00:01:39 2020
process j002 died, see its trace file
tue oct 27 00:01:39 2020
kkjcre1p: unable to spawn jobq slave process
tue oct 27 00:01:39 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_cjq0_3561.trc:
tue oct 27 00:01:39 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_j002_26856.trc:
ora-00603: oracle server session terminated by fatal error
ora-27544: failed to map memory region for export
ora-27300: os system dependent operation:bind failed with status: 98
ora-27301: os failure message: address already in use
ora-27302: failure occurred at: sskgxpcre3
process j002 died, see its trace file
tue oct 27 00:01:40 2020
kkjcre1p: unable to spawn jobq slave process
tue oct 27 00:01:40 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_cjq0_3561.trc:
tue oct 27 00:01:40 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_j002_26863.trc:
ora-00603: oracle server session terminated by fatal error
ora-27544: failed to map memory region for export
ora-27300: os system dependent operation:bind failed with status: 98
ora-27301: os failure message: address already in use
ora-27302: failure occurred at: sskgxpcre3
process j002 died, see its trace file
tue oct 27 00:01:41 2020
kkjcre1p: unable to spawn jobq slave process
tue oct 27 00:01:41 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_cjq0_3561.trc:
tue oct 27 00:01:41 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_j002_26870.trc:
ora-00603: oracle server session terminated by fatal error
ora-27544: failed to map memory region for export
ora-27300: os system dependent operation:bind failed with status: 98
ora-27301: os failure message: address already in use
ora-27302: failure occurred at: sskgxpcre3
process j002 died, see its trace file
tue oct 27 00:01:42 2020
kkjcre1p: unable to spawn jobq slave process
tue oct 27 00:01:42 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_cjq0_3561.trc:
tue oct 27 00:01:42 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_j002_26878.trc:
ora-00603: oracle server session terminated by fatal error
ora-27544: failed to map memory region for export
ora-27300: os system dependent operation:bind failed with status: 98
ora-27301: os failure message: address already in use
ora-27302: failure occurred at: sskgxpcre3
process j002 died, see its trace file
tue oct 27 00:01:43 2020
kkjcre1p: unable to spawn jobq slave process
tue oct 27 00:01:43 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_cjq0_3561.trc:
tue oct 27 00:01:43 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_j002_26885.trc:
ora-00603: oracle server session terminated by fatal error
ora-27544: failed to map memory region for export
ora-27300: os system dependent operation:bind failed with status: 98
ora-27301: os failure message: address already in use
ora-27302: failure occurred at: sskgxpcre3
process j002 died, see its trace file
tue oct 27 00:01:44 2020
kkjcre1p: unable to spawn jobq slave process
tue oct 27 00:01:44 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_cjq0_3561.trc:
tue oct 27 00:01:44 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_j002_26893.trc:
ora-00603: oracle server session terminated by fatal error
ora-27544: failed to map memory region for export
ora-27300: os system dependent operation:bind failed with status: 98
ora-27301: os failure message: address already in use
ora-27302: failure occurred at: sskgxpcre3
process j002 died, see its trace file
tue oct 27 00:01:45 2020
kkjcre1p: unable to spawn jobq slave process
tue oct 27 00:01:45 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_cjq0_3561.trc:
tue oct 27 00:01:45 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_j002_26900.trc:
ora-00603: oracle server session terminated by fatal error
ora-27544: failed to map memory region for export
ora-27300: os system dependent operation:bind failed with status: 98
ora-27301: os failure message: address already in use
ora-27302: failure occurred at: sskgxpcre3
tue oct 27 00:01:45 2020
trace dumping is performing id=[cdmp_20201027000145]
tue oct 27 00:01:46 2020
process j002 died, see its trace file
tue oct 27 00:01:46 2020
kkjcre1p: unable to spawn jobq slave process
tue oct 27 00:01:46 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_cjq0_3561.trc:
/etc/sysctl.conf中没有设置shmmall，修改为4g后systemctl -p，问题消失。
[oracle@host01 ~]$ tail -100 alert_orcl1.log
ora-00603: oracle server session terminated by fatal error
ora-27544: failed to map memory region for export
ora-27300: os system dependent operation:bind failed with status: 98
ora-27301: os failure message: address already in use
ora-27302: failure occurred at: sskgxpcre3
tue oct 27 00:01:38 2020
trace dumping is performing id=[cdmp_20201027000138]
tue oct 27 00:01:39 2020
process j002 died, see its trace file
tue oct 27 00:01:39 2020
kkjcre1p: unable to spawn jobq slave process
tue oct 27 00:01:39 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_cjq0_3561.trc:
tue oct 27 00:01:39 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_j002_26856.trc:
ora-00603: oracle server session terminated by fatal error
ora-27544: failed to map memory region for export
ora-27300: os system dependent operation:bind failed with status: 98
ora-27301: os failure message: address already in use
ora-27302: failure occurred at: sskgxpcre3
process j002 died, see its trace file
tue oct 27 00:01:40 2020
kkjcre1p: unable to spawn jobq slave process
tue oct 27 00:01:40 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_cjq0_3561.trc:
tue oct 27 00:01:40 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_j002_26863.trc:
ora-00603: oracle server session terminated by fatal error
ora-27544: failed to map memory region for export
ora-27300: os system dependent operation:bind failed with status: 98
ora-27301: os failure message: address already in use
ora-27302: failure occurred at: sskgxpcre3
process j002 died, see its trace file
tue oct 27 00:01:41 2020
kkjcre1p: unable to spawn jobq slave process
tue oct 27 00:01:41 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_cjq0_3561.trc:
tue oct 27 00:01:41 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_j002_26870.trc:
ora-00603: oracle server session terminated by fatal error
ora-27544: failed to map memory region for export
ora-27300: os system dependent operation:bind failed with status: 98
ora-27301: os failure message: address already in use
ora-27302: failure occurred at: sskgxpcre3
process j002 died, see its trace file
tue oct 27 00:01:42 2020
kkjcre1p: unable to spawn jobq slave process
tue oct 27 00:01:42 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_cjq0_3561.trc:
tue oct 27 00:01:42 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_j002_26878.trc:
ora-00603: oracle server session terminated by fatal error
ora-27544: failed to map memory region for export
ora-27300: os system dependent operation:bind failed with status: 98
ora-27301: os failure message: address already in use
ora-27302: failure occurred at: sskgxpcre3
process j002 died, see its trace file
tue oct 27 00:01:43 2020
kkjcre1p: unable to spawn jobq slave process
tue oct 27 00:01:43 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_cjq0_3561.trc:
tue oct 27 00:01:43 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_j002_26885.trc:
ora-00603: oracle server session terminated by fatal error
ora-27544: failed to map memory region for export
ora-27300: os system dependent operation:bind failed with status: 98
ora-27301: os failure message: address already in use
ora-27302: failure occurred at: sskgxpcre3
process j002 died, see its trace file
tue oct 27 00:01:44 2020
kkjcre1p: unable to spawn jobq slave process
tue oct 27 00:01:44 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_cjq0_3561.trc:
tue oct 27 00:01:44 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_j002_26893.trc:
ora-00603: oracle server session terminated by fatal error
ora-27544: failed to map memory region for export
ora-27300: os system dependent operation:bind failed with status: 98
ora-27301: os failure message: address already in use
ora-27302: failure occurred at: sskgxpcre3
process j002 died, see its trace file
tue oct 27 00:01:45 2020
kkjcre1p: unable to spawn jobq slave process
tue oct 27 00:01:45 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_cjq0_3561.trc:
tue oct 27 00:01:45 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_j002_26900.trc:
ora-00603: oracle server session terminated by fatal error
ora-27544: failed to map memory region for export
ora-27300: os system dependent operation:bind failed with status: 98
ora-27301: os failure message: address already in use
ora-27302: failure occurred at: sskgxpcre3
tue oct 27 00:01:45 2020
trace dumping is performing id=[cdmp_20201027000145]
tue oct 27 00:01:46 2020
process j002 died, see its trace file
tue oct 27 00:01:46 2020
kkjcre1p: unable to spawn jobq slave process
tue oct 27 00:01:46 2020
errors in file /u01/app/oracle/admin/orcldg/bdump/orcl1_cjq0_3561.trc:
/etc/sysctl.conf中没有设置shmmall，修改为4g后systemctl -p，问题消失。
给主人留下些什么吧！~~