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,
VUM).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.
- 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.