错误原因:https://www.cndba.cn/Expect-le/article/288
修改inmemory_size小于100M,然后关闭数据,再打开就报错了。
https://www.cndba.cn/Expect-le/article/288
[root@dg2 ~]# su - oracle
[oracle@dg2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Sun Oct 9 16:42:12 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-64353: in-memory area size cannot be less than 100MB
SQL> startup mount
ORA-64353: in-memory area size cannot be less than 100MB
SQL> startup nomount
ORA-64353: in-memory area size cannot be less than 100MB
SQL>
启动到什么状态都不行,怎么搞?也没法生成pfile,来修改inmemory_size大小https://www.cndba.cn/Expect-le/article/288
解决方法:
https://www.cndba.cn/Expect-le/article/288
1.先找到spfile
[root@dg2 dbs]# cat initrac1.ora
SPFILE='+DATA/rac/spfilerac.ora'
[root@dg2 dbs]# su - grid
[grid@dg2 ~]$ asmcmd
ASMCMD> ls
DATA/
FLASH_DATA/
OCR_VOTE/
TPCC_FLASH/
ASMCMD> cd data
ASMCMD> ls
ORCL/
RAC/
test.dbf
zhixin2_sysaux.dbf
zhixin2_system.dbf
zhixin2_temp012016-08-05_03-21-00-pm.dbf
zhixin2_users01.dbf
ASMCMD> cd rac
ASMCMD> ls
394EE52BB0E93D8AE0530501A8C0DB53/
394F10267BC37F08E0530501A8C092A7/
394F6107512F6D10E0530501A8C02E68/
394FCE814BE9548DE0530301A8C07067/
3A298244B3D07475E0530301A8C01814/
3D619798D70530ACE0530501A8C01074/
CONTROLFILE/
DATAFILE/
FD9AC20F64D244D7E043B6A9E80A2F2F/
PARAMETERFILE/
PASSWORD/
TEMPFILE/
salespdb/
ASMCMD> cd PARAMETERFILE
ASMCMD> ls
spfile.310.919092419
2.生成pfilehttps://www.cndba.cn/Expect-le/article/288
SQL> create pfile from SPFILE='+DATA/rac/PARAMETERFILE/spfile.310.919092419';
File created.
3.修改pfile文件
把*.inmemory_size=1000改为*.inmemory_size=100M
#神奇的问题,重新生成了spfile,还是打不开
https://www.cndba.cn/Expect-le/article/288https://www.cndba.cn/Expect-le/article/288
SQL> create spfile from pfile ='/u01/oracle/12.1.0/db_1/dbs/initrac2.ora';
File created.
SQL> startup
ORA-64353: in-memory area size cannot be less than 100MB
#用pfile打开数据库
SQL> startup pfile ='/u01/oracle/12.1.0/db_1/dbs/initrac2.ora';
ORACLE instance started.
Total System Global Area 2449473536 bytes
Fixed Size 2927336 bytes
Variable Size 1174406424 bytes
Database Buffers 100663296 bytes
Redo Buffers 114511872 bytes
In-Memory Area 1056964608 bytes
Database mounted.
Database opened.
#再创建spfile,重启数据库
SQL> create spfile from pfile ='/u01/oracle/12.1.0/db_1/dbs/initrac2.ora';
File created.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 2449473536 bytes
Fixed Size 2927336 bytes
Variable Size 1174406424 bytes
Database Buffers 100663296 bytes
Redo Buffers 114511872 bytes
In-Memory Area 1056964608 bytes
Database mounted.
Database opened.
#查看inmemory_size大小
https://www.cndba.cn/Expect-le/article/288
SQL> show parameter inmemory_size
NAME TYPE VALUE
----------------- ------------------- ----------------------
inmemory_size big integer 1008M
可以了。
https://www.cndba.cn/Expect-le/article/288
https://www.cndba.cn/Expect-le/article/288
版权声明:本文为博主原创文章,未经博主允许不得转载。
12c ORA-64353