【轉載】修改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 ;