[转载]在RAC中 就同一参数 给两个实例分别指定不同的值
<p>信息来源: <a id="ArticleTitle1_ArticleTitle1_AuthorLink" href="user/lunar2000">lunar2000</a> Blog </p><p><strong><font color="#0000ff">RAC的两个实例：</font></strong></p><p><strong><font color="#0000ff">目前用spfile，job_queue_processes＝4</font></strong></p><p>SQL> col inst_name for a30<br />SQL> select * from v$active_instances;</p><p>INST_NUMBER INST_NAME<br />----------- ------------------------------<br /> 1 cs_rac01:csmisc1</p><p></p><p> 2 cs_rac02:csmisc2</p><p></p><p><br />Elapsed: 00:00:00.00<br />SQL> show parameter spfile</p><p>NAME TYPE VALUE<br />------------------------------------ ----------- ------------------------------<br />spfile string /dev/vg_cs1/rspfile_128m_01<br />SQL> show parameter job</p><p>NAME TYPE VALUE<br />------------------------------------ ----------- ------------------------------<br />job_queue_processes integer 4<br />SQL> </p><p></p><p><strong><font color="#0000ff">现在在节点1上设置job_queue_processes=11 ，并且在节点2上设置job_queue_processes=12:</font></strong><br />SQL> alter system set job_queue_processes=11 sid='csmisc1';</p><p>System altered.</p><p>Elapsed: 00:00:00.05<br />SQL> alter system set job_queue_processes=12 sid='csmisc2';</p><p>System altered.</p><p>Elapsed: 00:00:00.02<br />SQL> </p><p>检查一下节点一：<br />SQL> select instance_name from v$instance;</p><p>INSTANCE_NAME<br />----------------<br />csmisc1</p><p>Elapsed: 00:00:00.01<br />SQL> show parameter job</p><p>NAME TYPE VALUE<br />------------------------------------ ----------- ------------------------------<br />job_queue_processes integer 11<br />SQL> </p><p>再检查一下节点2:</p><p>SQL> select instance_name from v$instance;</p><p>INSTANCE_NAME<br />----------------<br />csmisc2</p><p>Elapsed: 00:00:00.02<br />SQL> show parameter job</p><p>NAME TYPE VALUE<br />------------------------------------ ----------- ------------------------------<br />job_queue_processes integer 12<br />SQL> </p><p>现在看看spfile中是如何记录的：</p><p>SQL> create pfile='/tmp/lunar.ora' from spfile;</p><p>File created.</p><p>Elapsed: 00:00:00.06<br />SQL> !cat /tmp/lunar.ora|grep job<br />*.job_queue_processes=4<br />csmisc1.job_queue_processes=11<br />csmisc2.job_queue_processes=12</p><p>SQL> </p>页:
[1]