ORA-00845
ORA-00845
APPLIES TO
Oracle Database - Enterprise Edition - version 11.2.0.4.0
SYMPTOMS
数据库启动后，alert_orcl.log 日志文件出现如下报错：
WARNING: You are trying to use the MEMORY_TARGET feature. This feature requires the /dev/shm file system to be mounted for at least 830472192 bytes. /dev/shm is either not mounted or is mounted with available space less than this size. Please fix this so that MEMORY_TARGET can work as expected. Current available is 453869568 and used is 55934976 bytes. Ensure that the mount point is /dev/shm for this directory. memory_target needs larger /dev/shm. |
CAUSE
系统 /dev/shm 空间不足。
SOLUTION
mount -t tmpfs shmfs -o size=1g /dev/shm |
修改 /etc/fstab
echo "shmfs /dev/shm tmpfs size=1g 0 0" >> /etc/fstab |
All articles on this blog are licensed under CC BY-NC-SA 4.0 unless otherwise stated.
Related Articles
2024-01-20
ERROR 1356
ERROR 1356 APPLIES TO: 5.7.x SYMPTOMS mysqldump 全备恢复后，无法查询 sys 库。 mysql> select * from sys.processlist; ERROR 1356 (HY000): View 'sys.processlist' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them CASE mysql> SELECT * FROM mysql.proc;Empty set (0.00 sec)mysql> SHOW PROCEDURE STATUS WHERE Db = 'sys';Empty set (0.00 sec)mysql> SHOW FUNCTION STATUS WHERE Db = 'sys';Empty set (0.00 sec) sys 库 functions 和 procedures 丢失了，mysq...
2023-06-10
MY-011906
MY-011906 SYMTOMS MySQL8 服务器意外掉电，启动时报错： InnoDB: End of page dump InnoDB: Page may be an update undo log page 2021-02-10T14:22:14.800611Z 0 [ERROR] [MY-011906] [InnoDB] Database page corruption on disk or a failed file read of page [page id: space=4294967279, page number=611]. You may have to recover from a backup. SOLUTION 添加 innodb_force_recovery 参数，重新启动数据库进入恢复模式 [mysqld]innodb_force_recovery = 1 1 (SRV_FORCE_IGNORE_CORRUPT): 忽略检查到的 corrupt 页。尽管检测到了损坏的 page 仍强制服务运行。一般设置为该值即可，然后 dump 出...
2024-01-20
ERROR 1396
ERROR 1396 APPLIES TO: mysql> show variables like '%version%'; +-------------------------+------------------------------+ | Variable_name | Value | +-------------------------+------------------------------+ | innodb_version | 5.7.13 | | protocol_version | 10 | | slave_type_conversions | | | tls_version | TLSv1,TLSv1.1 | | version ...
2023-05-20
ORA-12547
ORA-12547 APPLIES TO Operating System - Oracle Linux Server 7.9 Oracle Database - Enterprise Edition - version 11.2.0.4.0 Oracle Grid Infrastructure - version 11.2.0.4.0 SYMPTOMS dbca 建库时，弹出 ORA-12547 报错。 CAUSE 操作系统缺少 baio 依赖包。 SOLUTION 安装完后，重新执行 dbca 建库。 ~]$ yum -y install baio~]$ rpm -qa | grep baiolibaio-devel-0.3.109-13.el7.x86_64libaio-0.3.109-13.el7.x86_64
2023-06-06
Execution rootcrs.pl fails
Execution rootcrs.pl fails APPLIES TO Operating System - Oracle Linux Server 7.9 Oracle Database - Enterprise Edition - Version 11.2.0.4.0 Oracle Grid Infrastructure - Version 11.2.0.4.0 SYMPTOMS 执行 $<GRID_HOME>/crs/install/rootcrs.pl 命令回滚 crs 配置，出现如下报错： [root@exadb01 ~]# /u01/app/11.2.0/grid/crs/install/rootcrs.pl -deconfig -force -verboseCan't locate Env.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_p...
2023-08-07
The runInstaller Start Failed Due to Could not Execute xdpyinfo
The runInstaller Start Failed Due to Could not Execute xdpyinfo APPLIES TO Operating System - Oracle Linux Server 7.9 / Linux 7 Oracle Database - Enterprise Edition - Version 11.2.0.4 / 11g Oracle Grid Infrastructure - Version 11.2.0.4 / 11g SYMPTOMS ~]$ /soft/grid/runInstallerStarting Oracle Universal Installer...Checking Temp space: must be greater than 120 MB. Actual 43392 MB PassedChecking swap space: must be greater than 150 MB. Actual 8063 MB PassedChecking monitor: must ...