Oracle 11g修改连接数

[root@szmesdb ~]# clusvcadm -Z DM  //禁止cluster切换

    Local machine freezing service:DM…Success

    [root@szmesdb ~]# clusvcadm -Z MES 禁止cluster切换

    Local machine freezing service:MES…Success

    [root@szmesdb ~]# clustat

    Cluster Status for ora_mes_cluster @ Mon Apr 23 10:04:22 2012

    Member Status: Quorate

    Member Name                                                     ID   Status

    ------ ----                                                     ---- ------

    szmesdb                                                             1 Online, Local, rgmanager

    szdmdb                                                              2 Online, rgmanager

    /dev/dm-4                                                           0 Online, Quorum Disk

    Service Name                                             Owner （Last）                                             State

    ------- ----                                             ----- ------                                             -----

    service:DM                                               szdmdb                                                   started    [Z]

    service:MES                                              szmesdb                                                  started    [Z]

    [root@szmesdb ~]# su - orames

    [orames@szmesdb ~]$ sqlplus "/ as sysdba"

    SQL*Plus: Release 11.2.0.2.0 Production on Mon Apr 23 10:04:33 2012

    Copyright （c） 1982, 2010, Oracle.  All rights reserved.

    Connected to:

    Oracle Database 11g Release 11.2.0.2.0 - 64bit Production

    SQL> show parameter processes;

    NAME                                 TYPE        VALUE

    ------------------------------------ ----------- ------------------------------

    aq_tm_processes                      integer     0

    db_writer_processes                  integer     2

    gcs_server_processes                 integer     0

    global_txn_processes                 integer     1

    job_queue_processes                  integer     1000

    log_archive_max_processes            integer     4

    processes                            integer     300

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

    System altered.

    SQL> shutdown immediate;

    Database closed.

    Database dismounted.

    ORACLE instance shut down.

    SQL> startup;

    ORACLE instance started.

    Total System Global Area 4275781632 bytes

    Fixed Size                  2233336 bytes

    Variable Size            3254782984 bytes

    Database Buffers         1006632960 bytes

    Redo Buffers               12132352 bytes

    Database mounted.

    Database opened.

    SQL> show parameter processes;

    NAME                                 TYPE        VALUE

    ------------------------------------ ----------- ------------------------------

    aq_tm_processes                      integer     0

    db_writer_processes                  integer     2

    gcs_server_processes                 integer     0

    global_txn_processes                 integer     1

    job_queue_processes                  integer     1000

    log_archive_max_processes            integer     4

    processes                            integer     450

    SQL> create pfile from spfile;

    File created.

    SQL> exit

    Disconnected from Oracle Database 11g Release 11.2.0.2.0 - 64bit Production

    [orames@szmesdb ~]$ exit

    logout

    ~

另一台DB修改

    [oradm@szdmdb ~]$ sqlplus "/ as sysdba"

    SQL*Plus: Release 11.2.0.2.0 Production on Mon Apr 23 10:04:56 2012

    Copyright （c） 1982, 2010, Oracle.  All rights reserved.

    Connected to:

    Oracle Database 11g Release 11.2.0.2.0 - 64bit Production

    SQL> show parameter processes;

    NAME                                 TYPE        VALUE

    ------------------------------------ ----------- ------------------------------

    aq_tm_processes                      integer     0

    db_writer_processes                  integer     2

    gcs_server_processes                 integer     0

    global_txn_processes                 integer     1

    job_queue_processes                  integer     1000

    log_archive_max_processes            integer     4

    processes                            integer     300

    SQL> select count（*） from v$session;

    COUNT（*）

    ----------

    27

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

    System altered.

    SQL> shutdown immediate;

    Database closed.

    Database dismounted.

    ORACLE instance shut down.

    SQL> startup;

    ORACLE instance started.

    Total System Global Area 4275781632 bytes

    Fixed Size                  2233336 bytes

    Variable Size            3137342472 bytes

    Database Buffers         1124073472 bytes

    Redo Buffers               12132352 bytes

    Database mounted.

    Database opened.

    SQL> create pfile from spfile;

    File created.

    SQL> show parameter processes;

    NAME                                 TYPE        VALUE

    ------------------------------------ ----------- ------------------------------

    aq_tm_processes                      integer     0

    db_writer_processes                  integer     2

    gcs_server_processes                 integer     0

    global_txn_processes                 integer     1

    job_queue_processes                  integer     1000

    log_archive_max_processes            integer     4

    processes                            integer     450

    SQL> exit

    Disconnected from Oracle Database 11g Release 11.2.0.2.0 - 64bit Production

    cluter回来

    [root@szmesdb ~]# clusvcadm -U MES

    Local machine unfreezing service:MES…Success

    [root@szmesdb ~]#  clusvcadm -U DM

    Local machine unfreezing service:DM…Success

    [root@szmesdb ~]# clustat

    Cluster Status for ora_mes_cluster @ Mon Apr 23 10:23:20 2012

    Member Status: Quorate

    Member Name                                                     ID   Status

    ------ ----                                                     ---- ------

    szmesdb                                                             1 Online, Local, rgmanager

    szdmdb                                                              2 Online, rgmanager

    /dev/dm-4                                                           0 Online, Quorum Disk

    Service Name                                             Owner （Last）                                             State

    ------- ----                                             ----- ------                                             -----

    service:DM                                               szdmdb                                                   started

    service:MES                                              szmesdb                                                  started