To use an Oracle database for Update Manager, you must first set up the database.
- Download Oracle 11g or Oracle 12c from the Oracle Web site, install it, and create a database (for example,
Make sure that the TNS Listener is up and running, and test the database service to be sure it is working.
- Download Oracle ODBC from the Oracle Web site.
For Oracle database servers of version 188.8.131.52 or 184.108.40.206, use Oracle Instant Client Package - ODBC of version 220.127.116.11 for 32-bit Microsoft Windows.
- Install the corresponding Oracle ODBC driver through the Oracle Universal Installer.
- Increase the number of open cursors for the database.
Add the entry open_cursors = 300 to the ORACLE_BASE\ADMIN\VUM\pfile\init.ora file.
In this example, ORACLE_BASE is the root of the Oracle directory tree.