My Oracle Support Banner

Which Schema to Use When Prompted for the ESM Schema Owner When Doing the Database Upgrade?. (Doc ID 1385686.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety - Version 6.0.2 and later
Information in this document applies to any platform.

Goal

Argus Safety 6.0.2.1 release notes only specify that an Argus 6.0.2 database need be present. However, looking further at the actual scripts Upgrade_Argus_11g.bat and Upgrade.sql (attached) there seems to be a dependency on the ESM module. The Upgrade.sql script prompts for the ESM Schema Owner and then tests the connection. If the connection fails, the user is instructed to exit the script.

The ESM_OWNER schema exists with many objects (tables, etc.). Is this the correct schema to use when prompted?


Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.