报MEMORY_TARGETnotsupportedonthissystem故障解决
Jun 07, 2016 pm 03:56 PM启库时报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;
Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

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

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

Blue screen problem caused by win10 memory management

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

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
