8/14/2023 0 Comments Totally committed synonym![]() However, please note that this solution does not take advantage of Oracle RAC’s dynamic failover and load-balancing mechanisms. If using multiple application server nodes, you can set different application server nodes to different RAC nodes to help distribute the load. Set the serverName data source property to a specific RAC node. If using an spfile, issue the following command from SQL*Plus:Īlter system set "_clusterwide_global_transactions"=false scope=spfile If using pfile (init.ora) files, add the following line to the file:Ģ. This is accomplished in one of two ways - followed by a restart of the RAC nodes.ġ. Without the patch corresponding to bug 9068979 installed, customers will need to work around the issue by disabling global transaction management. In the meantime, various approaches can be implemented to work around the issue and are described below. ![]() Oracle has patches available for various platforms, and one should be requested – especially if AddOn installation failures occur similar to that described above. This issue corresponds to Oracle bug 9068979. If this dependency was not encountered, there is no other indication that the complete XA transaction was not fully committed. Errors that occur in such cases are API_PROPERTY_TEMPLATE_NOT_FOUND or E_OBJECT_MODIFIED. This is typically encountered during AddOn installation of a newly created ObjectStore where a subsequently installed AddOn - that happens to depend on the results of previously installed AddOn – fails to install because something it expects to be there isn’t (i.e., a dependency is discovered missing). As a result, the Content Engine believes both portions of the transaction were committed. If not patched with the appropriate fix or configured to work around this issue, Oracle will commit only half of the distributed transaction (assuming two resource managers) and rollback the second enlisted resource, yet no indication of such actions will be propagated back to the application server. When performing XA(distributed) transactions against a multi-node RAC 11g configuration, branches of the XA transaction can be sent to separate servers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |