ORA-00064 object is too large to allocate on this O/S (string,string)Cause: An initialization parameter was set to a value that required allocating more contiguous space than can be allocated on this operating system.Action: Reduce the value of the initialization parameter.
它默认的是db_block_size = 8192
但是我把db_block_size=1024 直到db_block_size=0
还是会提示这个错误
oracle/ora92/sysman/ifiles/def_ORCL.ora
oracle/ora92/sysman/ifiles/def_ORCL.ora里的db_block_size
都改过了,但还是不行。
急啊!
指定启动文件'oracle/ora92/sysman/ifiles/def_ORCL.ora'可以正常启动,
但打开Enterprise Manager Console时,
如果勾选了"将spfile用于启动"
就会报上面那个错误。
1.startup pfile='oracle/ora92/sysman/ifiles/def_ORCL.ora'
2.create spfile from pfile
3.勾选"将spfile用于启动"
4.重新启动数据库(不指定pfile)
1、进到SQLPLUS,CREATE PFILE FROM SPFILE;
2、去$ORACLE_HOME/dbs找INIT+SID.ora的文件;
3、修改你要改的参数
4、CREATE SPFILE FROM PFILE;
5、RESTART DATABASE;
很奇怪你的数据库怎么会被人修改初始化参数的?不是DB_BLOCK_SIZE这个参数吧?
楼上的老兄能否发一个INIT+SID.ora和def_init.ora的文件给我?我的email: [email protected]谢谢!
use
create spfile from pfile='oracle/ora92/sysman/ifiles/def_ORCL.ora'