自强不息，方能厚德载物。

2013年4月27日
ORA-00851:SGA_MAX_SIZE 1577058304 cannot be set to more than MEMORY_TARGET 855638016 (816M)
摘要： 10:32:18 SQL> show parameter sgashow parameter sgaNAME TYPE VALUE------------------------------------ ----------- ------------------------------lock_sga boolean FALSEpre_page_sga boolean FALSEsga_max_size big integer 1504Msga_target big integer 010:32:55 SQL> show parameter memoryshow paramete 阅读全文
posted @ 2013-04-27 15:39 omniscienceer 阅读(1633) 评论(0) 推荐(0) 编辑
ORA-01078: failure in processing system parameters
摘要： [oracle@oracle111 bin]$ sqlplus "/ as sysdba"SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 3 09:36:07 2012Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to an idle instance.SQL> select instance_name from v$instance;select instance_name from v$instance*ERROR at li 阅读全文
posted @ 2013-04-27 15:37 omniscienceer 阅读(362) 评论(0) 推荐(0) 编辑