oracle 11g 线程数修改,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