修改oracle最大连接数的步骤

使用sys，以sysdba权限登录：sqlplus sys/123456 AS SYSDBA(后边用nolog不行)

$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 27 10:26:12 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect / as sysdba;
Connected.
SQL> show parameter processes;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     0
db_writer_processes                  integer     1
gcs_server_processes                 integer     0
job_queue_processes                  integer     10
log_archive_max_processes            integer     2
processes                            integer     300

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

System altered.

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;

File created.

SQL> show parameter processes;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     0
db_writer_processes                  integer     1
gcs_server_processes                 integer     0
job_queue_processes                  integer     10
log_archive_max_processes            integer     2
processes                            integer     300

启停库
SQL>shutdown immediate;

SQL>startup;

SQL>show parameter processes;