[Reprinted] modify the maximum number of connections in Oracle and 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;

-- I changed it to 30000 here.

The system has been changed.

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;

The file has been created.

Restart the database. 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)

Find D: \ oracle \ ora92 \ database \ inittest. ora (9i)

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

Open notepad and change 30000 to 300

Startup pfile = 'inittest. ora ';

Start OK

Create spfile from pfile;