# Oracle RAC run choose instance

**URL:** <https://www.batmunkh.net/t/oracle-rac-run-choose-instance/901>\
**Category:** Oracle Database\
**Tags:** chaining\
**Created:** [October 16, 2018, 7:52am UTC](https://www.batmunkh.net/t/oracle-rac-run-choose-instance/901 "2018-10-16T07:52:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tmdeft](https://www.batmunkh.net/user_avatar/www.batmunkh.net/tmdeft/32/542_2.png) [@tmdeft](https://www.batmunkh.net/u/tmdeft)\
**Post date:** [October 16, 2018, 7:52am UTC](https://www.batmunkh.net/t/oracle-rac-run-choose-instance/901/1 "2018-10-16T07:52:13Z")

</div>

Сайн байна уу,

Oracle RAC дээр chain job ажилуулахдаа step болгоноо instance -ээ сонгож ажиллуулах боломжтой юу ?

---

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [October 16, 2018, 8:52am UTC](https://www.batmunkh.net/t/oracle-rac-run-choose-instance/901/2 "2018-10-16T08:52:26Z")

</div>

Боломжтой, instance\_id зааж өгч болно. (INSTANCE\_STICKINESS)

Жишээ

```
SQL> select OWNER,JOB_NAME,INSTANCE_STICKINESS,INSTANCE_ID from dba_scheduler_jobs where JOB_NAME like 'JOB%'; 
OWNER JOB_NAME INSTA INSTANCE_ID
------------------------------ ------------------------------ ----- -------- 
USER DBA_JOB_1 TRUE

```

Тохируулах

```
SQL> exec dbms_scheduler.set_attribute(name => 'USER.DBA_JOB_1' ,attribute=>'INSTANCE_ID', value=>;'1'); 
PL/SQL procedure successfully completed. 
SQL> exec dbms_scheduler.set_attribute(name => 'USER.DBA_JOB_1' ,attribute=>'INSTANCE_STICKINESS', value=>FALSE); 
PL/SQL procedure successfully completed.

```

Харах

```
SQL> select OWNER,JOB_NAME,INSTANCE_STICKINESS,INSTANCE_ID from dba_scheduler_jobs where JOB_NAME like '%JOB%'; 
OWNER JOB_NAME INSTA INSTANCE_ID
 ------------------------------ ------------------------------ ----- -------- 
USER DBA_JOB_1 FALSE 1

```

Ер нь RAC дээр instance\_id утга хаа сайгүй нэмэгдэж орж ирнэ. Мөн параметр тохируулахад

```
alter system set parameter=value sid='SID1,SID2';

```

гэх мэт SID мөн thread гэгч зүйл яригдана.