{"id":1064,"date":"2020-10-31T11:33:38","date_gmt":"2020-10-31T10:33:38","guid":{"rendered":"http:\/\/rootfan.com\/?p=1064"},"modified":"2022-04-04T00:12:37","modified_gmt":"2022-04-03T22:12:37","slug":"processus-de-changement-oracle-rac","status":"publish","type":"post","link":"https:\/\/rootfan.com\/fr\/change-processes-oracle-rac\/","title":{"rendered":"Comment modifier les param\u00e8tres de processus dans Oracle 19c RAC ?"},"content":{"rendered":"

Dans ce billet, je vais vous montrer comment modifier le param\u00e8tre processes dans une base de donn\u00e9es Oracle RAC.<\/p>\n\n\n\n

Vous pouvez utiliser cette m\u00eame m\u00e9thode pour tout param\u00e8tre RAC qui n\u00e9cessite un red\u00e9marrage des instances pour que le changement prenne effet.<\/p>\n\n\n\n

Dans l'id\u00e9al, il suffirait de modifier les param\u00e8tres du syst\u00e8me, puis d'arr\u00eater et de d\u00e9marrer chaque instance.<\/p>\n\n\n\n

Mais cela n'a pas fonctionn\u00e9 comme pr\u00e9vu, car certains services n'\u00e9taient disponibles que dans un n\u0153ud et pas dans l'autre, de sorte que j'ai d\u00fb les d\u00e9placer et r\u00e9essayer.<\/p>\n\n\n\n

Je vous montrerai tous les d\u00e9tails dans ce billet.<\/p>\n\n\n\n\n\n\n\n

Vous pouvez v\u00e9rifier les limites actuelles du processus Oracle \u00e0 l'aide de la requ\u00eate suivante<\/p>\n\n\n

\nSELECT INST_ID, RESOURCE_NAME, CURRENT_UTILIZATION, MAX_UTILIZATION, LIMIT_VALUE\nFROM GV$RESOURCE_LIMIT\nWHERE RESOURCE_NAME IN ( 'sessions', 'processes');\n\n   INST_ID RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALU\n---------- ------------------------------ ------------------- --------------- ----------\n         1 processes                                      120             250        700\n         1 sessions                                       128             255       1074\n         3 processes                                      699             700        700\n         3 sessions                                       708             711       1074\n<\/pre><\/div>\n\n\n
Tout d'abord, je me connecte et je v\u00e9rifie les valeurs actuelles.<\/p>\n\n\n
\nset lines 200\ncolumn NAME format a40\ncolumn VALUE format a50\n\nselect INST_ID,NAME,VALUE from gv$parameter\nwhere NAME in ('processes','sessions')\norder by 2,1;\n<\/pre><\/div>\n\n\n
Une fois que j'ai les valeurs, je veux changer le param\u00e8tre des processus \u00e0 1500.<\/p>\n\n\n
\nsqlplus \/ as sysdba\n\nalter system set processes=1500 scope=spfile sid='*';\n<\/pre><\/div>\n\n\n
L'id\u00e9al serait donc d'arr\u00eater et de red\u00e9marrer chacune des deux instances RAC.<\/p>\n\n\n
\n[oracle@node1:XI002PRO1 ~]$ srvctl stop instance -d XI002PRO -i XI002PRO1\nPRCD-1315 : failed to stop instances for database XI002PRO\nPRCR-1014 : Failed to stop resource ora.xi002pro.db\nPRCR-1065 : Failed to stop resource ora.xi002pro.db\nCRS-2974: unable to act on resource 'ora.xi002pro.db' on server 'node1' because that would require stopping or relocating resource 'ora.xi002pro.xi002pro_bkup1.svc' but the appropriate force flag was not specified\n<\/pre><\/div>\n\n\n
J'ai donc v\u00e9rifi\u00e9 tous les services de cette base de donn\u00e9es.<\/p>\n\n\n
\n[oracle@node1:XI002PRO1 ~]$ srvctl status service -d XI002PRO\nService XI002PROPLUGSVC is running on instance(s) XI002PRO1\nService xi002pro_bkup1 is running on instance(s) XI002PRO1\nService xi002pro_bkup2 is running on instance(s) XI002PRO3\nService XI002PROSVC is running on instance(s) XI002PRO1\n<\/pre><\/div>\n\n\n
Il se plaignait du service xi002pro_bkup1.<\/p>\n\n\n\n
J'ai donc essay\u00e9 de d\u00e9placer tous les services vers le n\u0153ud 3.<\/p>\n\n\n
\n[oracle@node1:XI002PRO1 ~]$ srvctl relocate service -db XI002PRO -service XI002PROPLUGSVC -oldinst XI002PRO1 -newinst XI002PRO3\n[oracle@node1:XI002PRO1 ~]$ srvctl relocate service -db XI002PRO -service xi002pro_bkup1 -oldinst XI002PRO1 -newinst XI002PRO3\n[oracle@node1:XI002PRO1 ~]$ srvctl relocate service -db XI002PRO -service XI002PROSVC -oldinst XI002PRO1 -newinst XI002PRO3\n<\/pre><\/div>\n\n\n
Puis il a r\u00e9essay\u00e9<\/p>\n\n\n
\n[oracle@node1:XI002PRO1 ~]$ srvctl stop instance -d XI002PRO -i XI002PRO1\n[oracle@node1:XI002PRO1 ~]$ srvctl start instance -d XI002PRO -i XI002PRO1\n<\/pre><\/div>\n\n\n
Cette fois-ci, cela a fonctionn\u00e9.<\/p>\n\n\n\n
Je dois maintenant relocaliser les services sur le n\u0153ud 1.<\/p>\n\n\n
\n[oracle@node1:XI002PRO1 ~]$ srvctl relocate service -db XI002PRO -service XI002PROPLUGSVC -oldinst XI002PRO3 -newinst XI002PRO1\n[oracle@node1:XI002PRO1 ~]$ srvctl relocate service -db XI002PRO -service xi002pro_bkup1 -oldinst XI002PRO3 -newinst XI002PRO1\n[oracle@node1:XI002PRO1 ~]$ srvctl relocate service -db XI002PRO -service XI002PROSVC -oldinst XI002PRO3 -newinst XI002PRO1\n<\/pre><\/div>\n\n\n
Il reste un service qui \u00e9tait sur le n\u0153ud 3 et que je dois d\u00e9placer sur le n\u0153ud 1 pour d\u00e9marrer et arr\u00eater l'instance.<\/p>\n\n\n\n
Mais je me suis heurt\u00e9 \u00e0 un autre probl\u00e8me.<\/p>\n\n\n
\n[oracle@node1:XI002PRO1 ~]$ srvctl relocate service -db XI002PRO -service xi002pro_bkup2 -oldinst XI002PRO3 -newinst XI002PRO1\nPRCR-1106 : Failed to relocate resource ora.xi002pro.xi002pro_bkup2.svc from node xfpcon01db03 to node node1\nPRCR-1089 : Failed to relocate resource ora.xi002pro.xi002pro_bkup2.svc.\nCRS-2717: Server 'node1' is not in any of the server pool(s) hosting resource 'ora.xi002pro.xi002pro_bkup2.svc'\n<\/pre><\/div>\n\n\n
Le probl\u00e8me est que ce service xi002pro_bkup2 n'est pr\u00e9f\u00e9r\u00e9 que sur le n\u0153ud 3 et n'est m\u00eame pas disponible sur le n\u0153ud 1 comme vous pouvez le voir avec ceci.<\/p>\n\n\n
\n[oracle@node1:XI002PRO1 ~]$ srvctl config service -db XI002PRO -service xi002pro_bkup2\nService name: xi002pro_bkup2\nServer pool:\nCardinality: 1\nDisconnect: false\nService role: PRIMARY\nManagement policy: AUTOMATIC\nDTP transaction: false\nAQ HA notifications: false\nGlobal: false\nCommit Outcome: false\nFailover type:\nFailover method:\nTAF failover retries:\nTAF failover delay:\nConnection Load Balancing Goal: LONG\nRuntime Load Balancing Goal: NONE\nTAF policy specification: NONE\nEdition:\nPluggable database name:\nMaximum lag time: ANY\nSQL Translation Profile:\nRetention: 86400 seconds\nReplay Initiation Time: 300 seconds\nSession State Consistency:\nGSM Flags: 0\nService is enabled\nPreferred instances: XI002PRO3\nAvailable instances:\n<\/pre><\/div>\n\n\n
J'ai donc ajout\u00e9 ce service comme \u00e9tant disponible au n\u0153ud 1 et pr\u00e9f\u00e9r\u00e9 au n\u0153ud 3 et j'ai v\u00e9rifi\u00e9 \u00e0 nouveau.<\/p>\n\n\n
\n[oracle@node1:XI002PRO1 ~]$ srvctl modify service -db XI002PRO -service xi002pro_bkup2 -modifyconfig -preferred XI002PRO3 -available XI002PRO1\n[oracle@node1:XI002PRO1 ~]$ srvctl config service -db XI002PRO -service xi002pro_bkup2                                              \nService name: xi002pro_bkup2\nServer pool:\nCardinality: 1\nDisconnect: false\nService role: PRIMARY\nManagement policy: AUTOMATIC\nDTP transaction: false\nAQ HA notifications: false\nGlobal: false\nCommit Outcome: false\nFailover type:\nFailover method:\nTAF failover retries:\nTAF failover delay:\nConnection Load Balancing Goal: LONG\nRuntime Load Balancing Goal: NONE\nTAF policy specification: NONE\nEdition:\nPluggable database name:\nMaximum lag time: ANY\nSQL Translation Profile:\nRetention: 86400 seconds\nReplay Initiation Time: 300 seconds\nSession State Consistency:\nGSM Flags: 0\nService is enabled\nPreferred instances: XI002PRO3\nAvailable instances: XI002PRO1\n<\/pre><\/div>\n\n\n
Comme indiqu\u00e9 ci-dessus, le service est d\u00e9sormais privil\u00e9gi\u00e9 sur le n\u0153ud 3 et disponible sur le n\u0153ud 1.<\/p>\n\n\n\n
Je peux donc maintenant relocaliser le service sur le n\u0153ud 1.<\/p>\n\n\n
\n[oracle@node1:XI002PRO1 ~]$ srvctl relocate service -db XI002PRO -service xi002pro_bkup2 -oldinst XI002PRO3 -newinst XI002PRO1\n<\/pre><\/div>\n\n\n
Ensuite, je peux arr\u00eater et d\u00e9marrer l'instance dans le n\u0153ud 3.<\/p>\n\n\n
\n[oracle@node1:XI002PRO1 ~]$ srvctl stop instance -d XI002PRO -i XI002PRO3\n[oracle@node1:XI002PRO1 ~]$ srvctl start instance -d XI002PRO -i XI002PRO3\n<\/pre><\/div>\n\n\n
Je relocalise maintenant le service sur le n\u0153ud 3.<\/p>\n\n\n
\n[oracle@node1:XI002PRO1 ~]$ srvctl relocate service -db XI002PRO -service xi002pro_bkup2 -oldinst XI002PRO1 -newinst XI002PRO3\n<\/pre><\/div>\n\n\n
Et je v\u00e9rifie \u00e0 nouveau la r\u00e9partition des services sur chaque n\u0153ud pour voir s'ils sont de nouveau tels qu'ils \u00e9taient au d\u00e9but.<\/p>\n\n\n
\n[oracle@node1:XI002PRO1 ~]$ srvctl status service -d XI002PRO\nService XI002PROPLUGSVC is running on instance(s) XI002PRO1\nService xi002pro_bkup1 is running on instance(s) XI002PRO1\nService xi002pro_bkup2 is running on instance(s) XI002PRO3\nService XI002PROSVC is running on instance(s) XI002PRO1\n<\/pre><\/div>\n\n\n
Je valide maintenant que la modification du param\u00e8tre \"processus\" a bien \u00e9t\u00e9 appliqu\u00e9e.<\/p>\n\n\n
\nsqlplus \/ as sysdba\n\nset lines 200\ncolumn NAME format a40\ncolumn VALUE format a50\n\nselect INST_ID,NAME,VALUE from gv$parameter\nwhere NAME in ('processes','sessions')\norder by 2,1;\n\n   INST_ID NAME                                     VALUE\n---------- ---------------------------------------- --------------------------------------------------\n         1 processes                                1500\n         3 processes                                1500\n         1 sessions                                 2272\n         3 sessions                                 2272\n<\/pre><\/div>\n\n\n
Tout semble donc en ordre.<\/p>\n\n\n\n
Bien s\u00fbr, si vous faites un peu de pr\u00e9paration avant d'effectuer l'arr\u00eat et le d\u00e9marrage de chaque instance, vous auriez pu \u00e9viter tout cela lors de l'intervention.<\/p>\n\n\n\n
J'esp\u00e8re que cela vous a \u00e9t\u00e9 utile.<\/p>","protected":false},"excerpt":{"rendered":"
Dans ce billet, je vais vous montrer comment modifier le param\u00e8tre processes dans une base de donn\u00e9es Oracle RAC. Vous pouvez utiliser cette m\u00eame m\u00e9thode pour n'importe quel param\u00e8tre RAC qui n\u00e9cessite un red\u00e9marrage des instances pour que le changement prenne effet. Dans l'id\u00e9al, il suffirait de modifier les param\u00e8tres du syst\u00e8me et ensuite de ... <\/p>\n
Continuer la lecture de \" Comment modifier les param\u00e8tres de processus dans Oracle 19c RAC \"<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":2923,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"How to Change Processes Parameter in Oracle 19c RAC","rank_math_title":"","rank_math_description":"Change processes parameter in Oracle 19c RAC effortlessly. Optimize your database performance with this step-by-step tutorial.","rank_math_robots":"","rank_math_og_title":"","rank_math_og_description":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[31],"tags":[61,54,62],"class_list":["post-1064","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-processes","tag-rac","tag-srvctl"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-2531709.jpeg?fit=1862%2C1300&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/1064","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/comments?post=1064"}],"version-history":[{"count":14,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/1064\/revisions"}],"predecessor-version":[{"id":1581,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/1064\/revisions\/1581"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media\/2923"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media?parent=1064"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/categories?post=1064"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/tags?post=1064"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}