Configure an Oracle Connection to Work Locally

You can configure an Oracle connection to work locally with Update Manager.

Prerequisites

Verify that the ODBC data source that you use is a 64-bit system DSN. See Create a 64-Bit DSN.

Procedure

1. Create a tablespace specifically for Update Manager by using the following SQL statement:

   CREATE TABLESPACE "VUM" DATAFILE 'ORACLE_BASE\ORADATA\VUM\VUM.dat' SIZE 1000M AUTOEXTEND ON NEXT 500K;

   In this example, ORACLE_BASE is the root of the Oracle directory tree.

2. Create a user, such as vumAdmin, for accessing this tablespace through ODBC.

   CREATE USER vumAdmin IDENTIFIED BY vumadmin DEFAULT TABLESPACE “vum”;

3. Either grant the dba permission to the user, or grant the following specific permissions to the user.

   grant connect to vumAdmin
   grant resource to vumAdmin
   grant create any job to vumAdmin
   grant create view to vumAdmin
   grant create any sequence to vumAdmin
   grant create any table to vumAdmin
   grant lock any table to vumAdmin
   grant create procedure to vumAdmin
   grant create type to vumAdmin
   grant execute on dbms_lock to vumAdmin
   grant unlimited tablespace to vumAdmin
   # To ensure space limitation is not an issue

4. Create an ODBC connection to the database.
   See the following example settings:

   Data Source Name: VUM
   TNS Service Name: VUM
   User ID: vumAdmin