天天看點

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和程式異常終止