Difference between revisions of "Installation/Custom/Oracle Database"
(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...") |
(No difference)
|
Latest revision as of 17:51, 13 August 2022
|
|
|
Oracle database
Openbravo support Oracle as a database system either installed locally or on a separate server.
To select the best version to install refer to the System Requirements page as explained in the introduction.
Required configuration
- Select AL32UTF8 as the database's NLS_CHARACTERSET.
- Select AL16UTF16 as the database's NLS_NCHAR_CHARACTERSET.
- 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:
<source lang="sql">SELECT value FROM v$parameter WHERE name = 'open_cursors'; ALTER SYSTEM SET open_cursors = 3000 SCOPE=BOTH;</source>
- 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:
<source lang="sql">SELECT value FROM v$parameter WHERE name = 'processes'; ALTER SYSTEM set processes=150 SCOPE=SPFILE;</source>
- Restart Oracle after doing this change.
