ORA-01034: ORACLE not available 、ora-00064:object is too large to allocate on this O/S

来源:互联网 发布:韩国订房软件 编辑:程序博客网 时间:2024/06/06 00:25

使用sys登录

SQL> shutdown immediate

报错:

 ERROR:
ORA-01034: ORACLE not available
RA-27101: sharedmemory realm does not exist

 

SQL> startup mount

报错:

ORA-00064: object is too large to allocate on this O/S (1,4004280)

 

解决办法:

搜索到init.ora文件

SQL> startup pfile='D:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\init.ora'

 

sql>create spfile from pfile;

原因:

将连接数修改过大!

alter system set processes = 1000scope = spfile;

 

 

原创粉丝点击