[sprabhakar]

From version 5.0, any changes to the VPD automatically clears the shared pool on the database server. This is done to clear out any cached execution plans/queries.

To avoid the above error, the DBA needs to create the stored procedure "flush_shared_pool" (available in the glogowner schema ) in the "system" schema and grant execute rights to glogowner and glogdba.

Once this is done, the VPD changes will take effect without a restart of the application server.