标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2131 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (102)
- 数据库 (1,682)
- DB2 (22)
- MySQL (73)
- Oracle (1,544)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (159)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (7)
- Oracle ASM (67)
- Oracle Bug (8)
- Oracle RAC (53)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (565)
- Oracle安装升级 (92)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (79)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (37)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (20)
-
最近发表
- 断电引起的ORA-08102: 未找到索引关键字, 对象号 39故障处理
- ORA-00227: corrupt block detected in control file
- 手工删除19c rac
- 解决oracle数据文件路径有回车故障
- .wstop扩展名勒索数据库恢复
- Oracle Recovery Tools工具一键解决ORA-00376 ORA-01110故障(文件offline)
- OGG-02771 Input trail file format RELEASE 19.1 is different from previous trail file form at RELEASE 11.2.
- OGG-02246 Source redo compatibility level 19.0.0 requires trail FORMAT 12.2 or higher
- GoldenGate 19安装和打patch
- dd破坏asm磁盘头恢复
- 删除asmlib磁盘导致磁盘组故障恢复
- Kylin Linux 安装19c
- ORA-600 krse_arc_complete.4
- Oracle 19c 202410补丁(RUs+OJVM)
- ntfs MFT损坏(ntfs文件系统故障)导致oracle异常恢复
- .mkp扩展名oracle数据文件加密恢复
- 清空redo,导致ORA-27048: skgfifi: file header information is invalid
- A_H_README_TO_RECOVER勒索恢复
- 通过alert日志分析客户自行对一个数据库恢复的来龙去脉和点评
- ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的SERVICE_NAME
分类目录归档:Linux
-bash: /bin/rm: Argument list too long
linux批量删除大量文件,当使用rm -rf *报-bash: /bin/rm: Argument list too long错误可以使用find+xargs搞定
[grid@xifenfei audit]$ rm -rf +ASM2_ora_1*_2017*.aud -bash: /bin/rm: Argument list too long [grid@xifenfei audit]$ ls|wc -l 111650450 [grid@xifenfei audit]$ find ./ -name "*.aud" |xargs rm -r [grid@xifenfei audit]$ ls [grid@xifenfei audit]$
Using mlock ulimits for SHM_HUGETLB is deprecated
Oracle 数据库运行在linux 6中,启用大页之后,我们经常在/var/log/messages里面会看到类似这样的记录:Mar 11 12:12:33 i-q2ghx82t kernel: oracle (3677): Using mlock ulimits for SHM_HUGETLB is deprecated,我这里的环境也有重现该问题
环境说明
--系统配置 [root@i-q2ghx82t ~]# more /etc/issue CentOS release 6.8 (Final) Kernel \r on an \m [root@i-q2ghx82t ~]# ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 128331 max locked memory (kbytes, -l) 64 max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) 10240 cpu time (seconds, -t) unlimited max user processes (-u) 128331 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited [oracle@i-q2ghx82t ~]$ cat /proc/meminfo|grep Hu AnonHugePages: 0 kB HugePages_Total: 10752 HugePages_Free: 10752 HugePages_Rsvd: 0 HugePages_Surp: 0 Hugepagesize: 2048 kB [root@i-q2ghx82t ~]# more /proc/sys/vm/hugetlb_shm_group 0 [root@i-q2ghx82t ~]# id oracle uid=1000(oracle) gid=1000(oinstall) groups=1000(oinstall),1001(dba),1002(oper),1005(asmdba) --数据库参数 use_large_pages=only
在本环境中数据库启动正常,大页也可以正常使用,但是在系统日志中有类似Mar 11 12:12:33 i-q2ghx82t kernel: oracle (3677): Using mlock ulimits for SHM_HUGETLB is deprecated 这样的告警.通过分析,是由于少配置了hugetlb_shm_group参数导致(vm.hugetlb_shm_group 参数设置为有权使用 HugePages 的操作系统组。默认情况下,此参数设置为 0,从而允许所有组使用 HugePages。可以将此参数设置为 Oracle 数据库进程所属的操作系统组,如 oinstall),在本系统中在sysctl.conf中增加vm.hugetlb_shm_group=1000,然后重启系统(测试中,如果只是重启数据库,非系统重启后第一次重启数据库,不会出现该告警),系统日志没有出现相关告警.
在Linux 6中配置大页建议加上对应的hugetlb_shm_group参数
redhat和oracle linux kernel对应关系
Red Hat Enterprise Linux Version / Update |
Red Hat Enterprise Linux – Kernel version / redhat-release string |
Oracle Linux – Kernel version / release strings |
Red Hat Enterprise Linux 7 |
|
|
Red Hat Enterprise Linux 7 Update 6 |
3.10.0-957.el7.x86_64 |
4.14.35-1818.3.3.el7uek.x86_64 ^ * (x86_64 only) |
Red Hat Enterprise Linux 7 Update 5 |
3.10.0-862.el7.x86_64 |
4.1.12-112.16.4.el7uek ^ * (x86_64 only) |
Red Hat Enterprise Linux 7 Update 4 |
3.10.0-693.el7.x86_64 |
4.1.12-94.3.9.el7uek ^ * (x86_64 only) |
Red Hat Enterprise Linux 7 Update 3 |
3.10.0-514.el7.x86_64 |
4.1.12-61.1.18.el7uek ^ * (x86_64 only) |
Red Hat Enterprise Linux 7 Update 2 |
3.10.0-327.el7.x86_64 |
3.8.13-98.6.1.el7uek ^ * (x86_64 only) |
Red Hat Enterprise Linux 7 Update 1 |
3.10.0-229.el7.x86_64 |
3.8.13-55.1.6.el7uek ^ * (x86_64 only) |
Red Hat Enterprise Linux 7 GA |
3.10.0-123.el7.x86_64 |
3.8.13-35.3.1.el7uek ^ * (x86_64 only) |
Red Hat Enterprise Linux 6 |
|
|
Red Hat Enterprise Linux Server 6 Update 10 |
2.6.32-754.el6 |
4.1.12-124.16.4.el6uek ^ * (x86_64 only) |
Red Hat Enterprise Linux Server 6 Update 9 |
2.6.32-696.el6 |
4.1.12-61.1.28.el6uek ^ * (x86_64 only) |
Red Hat Enterprise Linux Server 6 Update 8 |
2.6.32-642.el6 |
4.1.12-37.3.1.el6uek ^ * (x86_64 only) |
Red Hat Enterprise Linux Server 6 Update 7 |
2.6.32-573.el6 |
3.8.13-68.3.4.el6uek ^ * (x86_64 only) |
Red Hat Enterprise Linux Server 6 Update 6 |
2.6.32-504.el6 |
3.8.13-44.1.1.el6uek ^ * (x86_64 only) |
Red Hat Enterprise Linux Server 6 Update 5 |
2.6.32-431.el6 |
3.8.13-16.121.el6uek ^ * (x86_64 only) |
Red Hat Enterprise Linux Server 6 Update 4 |
2.6.32-358.el6 |
2.6.39-400.17.1.el6uek ^ * |
Red Hat Enterprise Linux Server 6 Update 3 |
2.6.32-279.el6 |
2.6.39-200.24.1.el6uek ^ * |
Red Hat Enterprise Linux Server 6 Update 2 |
2.6.32-220.el6 |
2.6.32-100.34.1.el6uek ^ * |
Red Hat Enterprise Linux Server 6 Update 1 |
2.6.32-131.el6 |
2.6.32-100.34.1.el6uek ^ * |
Red Hat Enterprise Linux Server 6 GA |
2.6.32-71.el6 |
2.6.32-100.28.5.el6uek ^ * |
Red Hat Enterprise Linux 5 |
|
|
Red Hat Enterprise Linux Server 5 Update 11 |
2.6.18-398.el5 |
2.6.39-400.215.10.el5uek ^ * (x86, x86_64) |
Red Hat Enterprise Linux Server 5 Update 10 |
2.6.18-371.el5
|
2.6.39-400.209.1.el5uek ^ * (x86, x86_64) |
Red Hat Enterprise Linux Server 5 Update 9 |
2.6.18-348.el5 |
2.6.39-300.26.1.el5uek ^ * (x86, x86_64) |
Red Hat Enterprise Linux Server 5 Update 8 |
2.6.18-308.el5 |
2.6.32-300.10.1.el5uek ^ * (x86, x86_64) |
Red Hat Enterprise Linux Server 5 Update 7 |
2.6.18-274.el5 |
2.6.32-200.13.1.el5uek ^ * (x86, x86_64) |
Red Hat Enterprise Linux Server 5 Update 6 |
2.6.18-238.el5 |
2.6.32-100.26.2.el5uek ^ * (x86_64 only) |
Red Hat Enterprise Linux Server 5 Update 5 |
2.6.18-194.el5 |
2.6.18-194.el5 ^ * (x86, x86_64, ia64) |
Red Hat Enterprise Linux Server 5 Update 4 |
2.6.18-164.el5 |
2.6.18-164.el5 ^ * (x86, x86_64, ia64) |
Red Hat Enterprise Linux Server 5 Update 3 |
2.6.18-128.el5 |
2.6.18-128.el5 ^ * (x86, x86_64, ia64) |
Red Hat Enterprise Linux Server 5 Update 2 |
2.6.18-92.el5 |
2.6.18-92.el5 ^ * (x86, x86_64, ia64) |
Red Hat Enterprise Linux Server 5 Update 1 |
2.6.18-53.el5 |
2.6.18-53.el5 ^ * (x86, x86_64, ia64) |
Red Hat Enterprise Linux Server 5 GA |
2.6.18-8.el5 |
2.6.18-8.el5 ^ * (x86, x86_64, ia64) |
Red Hat Enterprise Linux 4 |
|
|
Red Hat Enterprise Linux 4 Update 9 |
2.6.9-100.EL |
2.6.9-100.0.0.0.1.EL ^ * (x86, x86_64, ia64) |
Red Hat Enterprise Linux 4 Update 8 |
2.6.9-89.EL |
2.6.9-89.0.0.0.1.EL ^ * (x86, x86_64, ia64) |
Red Hat Enterprise Linux 4 Update 7 |
2.6.9-78.EL |
2.6.9-78.0.0.0.1.EL ^ * (x86, x86_64, ia64) |
Red Hat Enterprise Linux 4 Update 6 |
2.6.9-67.EL |
2.6.9-67.0.0.0.1.EL ^ * (x86, x86_64, ia64) |
Red Hat Enterprise Linux 4 Update 5 |
2.6.9-55.EL |
2.6.9-55.0.0.0.2.EL ^ * (x86, x86_64) |
Red Hat Enterprise Linux 4 Update 4 |
2.6.9-42.EL |
2.6.9-42.0.0.0.1.EL ^ * (x86, x86_64) |
Red Hat Enterprise Linux 4 Update 3 |
2.6.9-34.EL |
No corresponding version |
Red Hat Enterprise Linux 4 Update 2 |
2.6.9-22.EL |
No corresponding version |
Red Hat Enterprise Linux 4 Update 1 |
2.6.9-11.EL |
No corresponding version |
Red Hat Enterprise Linux 4 GA |
2.6.9-5.EL |
No corresponding version |
参考:Comparison of Red Hat and Oracle Linux kernel versions and release strings (文档 ID 560992.1)