Home Database Mysql Tutorial 报MEMORY_TARGETnotsupportedonthissystem故障解决

报MEMORY_TARGETnotsupportedonthissystem故障解决

Jun 07, 2016 pm 03:56 PM
memory

启库时报00845错误 查看告警日志: $tail -f /u01/app/oracle/diag/rdbms/testdb12/TestDB12/alert/log.xml $df -h 内存超出了,需要修改初始化参数文件中的参数: SQL create pfile fromspfile; $ vi$ORACLE_HOME/dbs/initTestDB12.ora; 对内存进行修改,参

启库时报00845错误

\

查看告警日志:

$tail -f /u01/app/oracle/diag/rdbms/testdb12/TestDB12/alert/ log.xml

$df -h

\

内存超出了,需要修改初始化参数文件中的参数值:

SQL>create pfile fromspfile;

$vi$ORACLE_HOME/dbs/initTestDB12.ora;

对内存值进行修改,参考如下图:

\

SQL>create spfile from pfile;

SQL>startup;

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article

Hot Article

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

CAMM2 for desktop PCs: MSI explains the benefits of the new RAM standard for gaming towers CAMM2 for desktop PCs: MSI explains the benefits of the new RAM standard for gaming towers Aug 17, 2024 pm 06:47 PM

CAMM2 for desktop PCs: MSI explains the benefits of the new RAM standard for gaming towers

MySQL storage engine selection comparison: InnoDB, MyISAM and Memory performance index evaluation MySQL storage engine selection comparison: InnoDB, MyISAM and Memory performance index evaluation Jul 26, 2023 am 11:25 AM

MySQL storage engine selection comparison: InnoDB, MyISAM and Memory performance index evaluation

Solution to PHP Fatal error: Allowed memory size of bytes exhausted Solution to PHP Fatal error: Allowed memory size of bytes exhausted Jun 22, 2023 am 08:13 AM

Solution to PHP Fatal error: Allowed memory size of bytes exhausted

Blue screen problem caused by win10 memory management Blue screen problem caused by win10 memory management Dec 30, 2023 pm 07:11 PM

Blue screen problem caused by win10 memory management

What are the characteristics of the Memory storage engine in mysql? What are the characteristics of the Memory storage engine in mysql? Jun 02, 2023 pm 08:48 PM

What are the characteristics of the Memory storage engine in mysql?

Raspberry Pi: Users can now get a big performance boost with just 100 lines of code Raspberry Pi: Users can now get a big performance boost with just 100 lines of code Jun 28, 2024 pm 04:16 PM

Raspberry Pi: Users can now get a big performance boost with just 100 lines of code

Samsung\'s 8-layer HBM3E chips overcome heat and power hurdles to secure Nvidia\'s approval Samsung\'s 8-layer HBM3E chips overcome heat and power hurdles to secure Nvidia\'s approval Aug 07, 2024 pm 07:20 PM

Samsung\'s 8-layer HBM3E chips overcome heat and power hurdles to secure Nvidia\'s approval

SK hynix announces \'industry's best\' GDDR7 DRAM, claiming 60% higher speeds than predecessor at 32Gbps SK hynix announces \'industry's best\' GDDR7 DRAM, claiming 60% higher speeds than predecessor at 32Gbps Jul 30, 2024 pm 06:38 PM

SK hynix announces \'industry's best\' GDDR7 DRAM, claiming 60% higher speeds than predecessor at 32Gbps

See all articles