https://wiki.infinite-erp.co.id/index.php?action=history&feed=atom&title=Installation%2FCustom%2FOracle_Database Installation/Custom/Oracle Database - Revision history 2026-04-06T23:23:25Z Revision history for this page on the wiki MediaWiki 1.31.1 https://wiki.infinite-erp.co.id/index.php?title=Installation/Custom/Oracle_Database&diff=3882&oldid=prev Wikiadmin: Created page with "{| style="margin: auto;" cellpadding="0" |- align="center" | <div class="t"><div class="b"><div class="l"><div class="r"><div class="bl"><div class="br"><div class="tl"><div..." 2022-08-13T10:51:43Z <p>Created page with &quot;{| style=&quot;margin: auto;&quot; cellpadding=&quot;0&quot; |- align=&quot;center&quot; | &lt;div class=&quot;t&quot;&gt;&lt;div class=&quot;b&quot;&gt;&lt;div class=&quot;l&quot;&gt;&lt;div class=&quot;r&quot;&gt;&lt;div class=&quot;bl&quot;&gt;&lt;div class=&quot;br&quot;&gt;&lt;div class=&quot;tl&quot;&gt;&lt;div...&quot;</p> <p><b>New page</b></p><div>{| style=&quot;margin: auto;&quot; cellpadding=&quot;0&quot;<br /> |- align=&quot;center&quot;<br /> <br /> | &lt;div class=&quot;t&quot;&gt;&lt;div class=&quot;b&quot;&gt;&lt;div class=&quot;l&quot;&gt;&lt;div<br /> class=&quot;r&quot;&gt;&lt;div class=&quot;bl&quot;&gt;&lt;div class=&quot;br&quot;&gt;&lt;div class=&quot;tl&quot;&gt;&lt;div<br /> class=&quot;tr&quot;&gt;<br /> &lt;div style=&quot;height:25px;display:<br /> table-cell;vertical-align:middle;&quot;&gt;&lt;span style=&quot;color:#DC6710&quot;&gt;[[Installation | Installation]]&lt;/span&gt;&lt;/div&gt;<br /> &lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;<br /> <br /> | &lt;div class=&quot;t&quot;&gt;&lt;div class=&quot;b&quot;&gt;&lt;div class=&quot;l&quot;&gt;&lt;div<br /> class=&quot;r&quot;&gt;&lt;div class=&quot;bl&quot;&gt;&lt;div class=&quot;br&quot;&gt;&lt;div class=&quot;tl&quot;&gt;&lt;div<br /> class=&quot;tr&quot;&gt;<br /> &lt;div style=&quot;height:25px;display:<br /> table-cell;vertical-align:middle;&quot;&gt;&lt;span style=&quot;color:#DC6710&quot;&gt;[[Installation/Custom | Custom installation]]&lt;/span&gt;&lt;/div&gt;<br /> &lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;<br /> <br /> | <br /> <br /> {| <br /> |- <br /> <br /> &lt;div class=&quot;t&quot;&gt;&lt;div class=&quot;b&quot;&gt;&lt;div class=&quot;l&quot;&gt;&lt;div class=&quot;r&quot;&gt;&lt;div<br /> class=&quot;bl&quot;&gt;&lt;div class=&quot;br&quot;&gt;&lt;div class=&quot;tl&quot;&gt;&lt;div class=&quot;tr&quot;&gt;<br /> &lt;div style=&quot;height:25px;display:<br /> table-cell;vertical-align:middle;&quot;&gt;&lt;span style=&quot;color:#DC6710&quot;&gt;[[Installation/Custom/PostgreSQL_Database | PostgreSQL]]&lt;/span&gt;<br /> &lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;<br /> <br /> | &lt;div class=&quot;t&quot;&gt;&lt;div class=&quot;b&quot;&gt;&lt;div class=&quot;l&quot;&gt;&lt;div<br /> class=&quot;r&quot;&gt;&lt;div class=&quot;bl&quot;&gt;&lt;div class=&quot;br&quot;&gt;&lt;div class=&quot;tl&quot;&gt;&lt;div<br /> class=&quot;tr&quot;&gt;<br /> &lt;div style=&quot;height:25px;display:<br /> table-cell;vertical-align:middle;&quot;&gt;&lt;span style=&quot;color:#DC6710&quot;&gt;[[Installation/Custom/Oracle_Database | Oracle]]&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;<br /> <br /> |}<br /> <br /> | &lt;div class=&quot;t&quot;&gt;&lt;div class=&quot;b&quot;&gt;&lt;div class=&quot;l&quot;&gt;&lt;div<br /> class=&quot;r&quot;&gt;&lt;div class=&quot;bl&quot;&gt;&lt;div class=&quot;br&quot;&gt;&lt;div class=&quot;tl&quot;&gt;&lt;div<br /> class=&quot;tr&quot;&gt;<br /> &lt;div style=&quot;height:25px;display:<br /> table-cell;vertical-align:middle;&quot;&gt;&lt;span style=&quot;color:#DC6710&quot;&gt;[[Installation/Custom/JDK | JDK]]&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;<br /> <br /> | &lt;div class=&quot;t&quot;&gt;&lt;div class=&quot;b&quot;&gt;&lt;div class=&quot;l&quot;&gt;&lt;div<br /> class=&quot;r&quot;&gt;&lt;div class=&quot;bl&quot;&gt;&lt;div class=&quot;br&quot;&gt;&lt;div class=&quot;tl&quot;&gt;&lt;div<br /> class=&quot;tr&quot;&gt;<br /> &lt;div style=&quot;height:25px;display:<br /> table-cell;vertical-align:middle;&quot;&gt;&lt;span style=&quot;color:#DC6710&quot;&gt;[[Installation/Custom/Apache_Tomcat | Tomcat]]&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;<br /> <br /> | &lt;div class=&quot;t&quot;&gt;&lt;div class=&quot;b&quot;&gt;&lt;div class=&quot;l&quot;&gt;&lt;div<br /> class=&quot;r&quot;&gt;&lt;div class=&quot;bl&quot;&gt;&lt;div class=&quot;br&quot;&gt;&lt;div class=&quot;tl&quot;&gt;&lt;div<br /> class=&quot;tr&quot;&gt;<br /> &lt;div style=&quot;height:25px;display:<br /> table-cell;vertical-align:middle;&quot;&gt;&lt;span style=&quot;color:#DC6710&quot;&gt;[[Installation/Custom/Apache_Ant | Ant]]&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;<br /> <br /> | &lt;div class=&quot;t&quot;&gt;&lt;div class=&quot;b&quot;&gt;&lt;div class=&quot;l&quot;&gt;&lt;div<br /> class=&quot;r&quot;&gt;&lt;div class=&quot;bl&quot;&gt;&lt;div class=&quot;br&quot;&gt;&lt;div class=&quot;tl&quot;&gt;&lt;div<br /> class=&quot;tr&quot;&gt;<br /> &lt;div style=&quot;height:25px;display:<br /> table-cell;vertical-align:middle;&quot;&gt;&lt;span style=&quot;color:#DC6710&quot;&gt;[[Installation/Custom/Apache | Apache]]&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;<br /> <br /> | <br /> <br /> {| <br /> |- <br /> <br /> &lt;div class=&quot;t&quot;&gt;&lt;div class=&quot;b&quot;&gt;&lt;div class=&quot;l&quot;&gt;&lt;div class=&quot;r&quot;&gt;&lt;div<br /> class=&quot;bl&quot;&gt;&lt;div class=&quot;br&quot;&gt;&lt;div class=&quot;tl&quot;&gt;&lt;div class=&quot;tr&quot;&gt;<br /> &lt;div style=&quot;height:25px;display:<br /> table-cell;vertical-align:middle;&quot;&gt;&lt;span style=&quot;color:#DC6710&quot;&gt;[[Installation/Custom/Download_Tarball | Download Tarball]]&lt;/span&gt;<br /> &lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;<br /> <br /> | &lt;div class=&quot;t&quot;&gt;&lt;div class=&quot;b&quot;&gt;&lt;div class=&quot;l&quot;&gt;&lt;div<br /> class=&quot;r&quot;&gt;&lt;div class=&quot;bl&quot;&gt;&lt;div class=&quot;br&quot;&gt;&lt;div class=&quot;tl&quot;&gt;&lt;div<br /> class=&quot;tr&quot;&gt;<br /> &lt;div style=&quot;height:25px;display:<br /> table-cell;vertical-align:middle;&quot;&gt;&lt;span style=&quot;color:#DC6710&quot;&gt;[[Installation/Custom/Mercurial_Clone | Mercurial Clone]]&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;<br /> <br /> |}<br /> <br /> | &lt;div class=&quot;t&quot;&gt;&lt;div class=&quot;b&quot;&gt;&lt;div class=&quot;l&quot;&gt;&lt;div<br /> class=&quot;r&quot;&gt;&lt;div class=&quot;bl&quot;&gt;&lt;div class=&quot;br&quot;&gt;&lt;div class=&quot;tl&quot;&gt;&lt;div<br /> class=&quot;tr&quot;&gt;<br /> &lt;div style=&quot;height:25px;display:<br /> table-cell;vertical-align:middle;&quot;&gt;&lt;span style=&quot;color:#DC6710&quot;&gt;[[Installation/Custom/Openbravo_Setup | Openbravo Setup]]&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;<br /> <br /> |}<br /> <br /> == Oracle database ==<br /> <br /> Openbravo support Oracle as a database system either installed locally or on a separate server.<br /> <br /> To select the best version to install refer to the [[System_Requirements#Server:_software_stack | System Requirements]] page as explained in the introduction.<br /> <br /> == Required configuration ==<br /> <br /> * Select AL32UTF8 as the database's NLS_CHARACTERSET.<br /> * Select AL16UTF16 as the database's NLS_NCHAR_CHARACTERSET.<br /> <br /> * The '''number of open cursors''' should be at least '''3000'''. Verify it, and tune the ''ALTER SESSION'' to change the number of open cursors if needed:<br /> &lt;source lang=&quot;sql&quot;&gt;SELECT value FROM v$parameter WHERE name = 'open_cursors';<br /> ALTER SYSTEM SET open_cursors = 3000 SCOPE=BOTH;&lt;/source&gt;<br /> * Make sure that the '''number of processes''' is at least '''150'''. Verify it, and tune the ''ALTER SESSION'' to change the number of processes if needed:<br /> &lt;source lang=&quot;sql&quot;&gt;SELECT value FROM v$parameter WHERE name = 'processes';<br /> ALTER SYSTEM set processes=150 SCOPE=SPFILE;&lt;/source&gt;<br /> * Restart Oracle after doing this change.<br /> <br /> [[Category:Installation]]</div> Wikiadmin