【转载】修改oracle的最大连接数 以及 object is too large to allocate on this o/s

http://www.blogjava.net/gf7/archive/2007/03/13/103556.html

c:\sqlplus /nolog
SQL>conn / as sysdba

 

SQL> show parameter processes;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
db_writer_processes integer 1
job_queue_processes integer 10
log_archive_max_processes integer 1
processes integer 150

SQL> alter system set processes=300 scope = spfile;            

--我在这里改成30000了

系统已更改。

SQL> show parameter processes;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
db_writer_processes integer 1
job_queue_processes integer 10
log_archive_max_processes integer 1
processes integer 150

SQL> create pfile from spfile;

文件已创建。

重启数据库，OK！

 

============================

http://blog.csdn.net/wxygod/archive/2005/10/27/517880.aspx

SQL> startup

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

找到D:\oracle\ora92\database\INITtest.ORA(9i)

　　D:\oracle\product\10.2.0\db_1\database\(10G)

记事本打开 修改30000为300

startup pfile='INITtest.ORA' ;

启动OK

create spfile from pfile ;