天天看点

oracle学习28-ora-00064和程序异常终止

18.ORA-00064 object is too large to allocate on this OS 问题原因:

 通过查看告警日志,确认修改的process过大   解决步骤:

 使用  D:\oracle\product\10.2.0\admin\docare\pfile\init.ora 启动 操作步骤如下:

sqlplus sys/docare@docare as sysdba sql> startup pfile='D:\oracle\product\10.2.0\admin\docare\pfile\init.ora';
 sql> create spfile from pfile='D:\oracle\product\10.2.0\admin\docare\pfile\init.ora';
ORA-00064 object is too large to allocate on this OS      
oracle学习28-ora-00064和程序异常终止
sql> shutdown immediate; sql> startup; sql> alter system set processes= 1800 scope=spfile; sql> shutdown immediate; sql> startup;      

问题解决

19. 安装程序异常终止

oracle学习28-ora-00064和程序异常终止