[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
