Register CP Scripts

To register the existing CP scrips as processed, run the db\admin\script\register_old_cp_scripts.sql script.

For example : SQL*Plus from folder db\admin\script:

sqlplus <app_schema>/<app_schema>@<database> @register_old_cp_scripts.sql

Troubleshooting

• To compile the PL/SQL in AVEVA Enterprise Resource Management database schema:

  1. Check for invalid type definitions. If invalid type definitions exist with name starting with SYS_PLSQL then drop the types starting with SYS_PLSQL. Recompile invalid objects in the AVEVA Enterprise Resource Management database schema.

  2. If invalid objects exist, verify AVEVA Enterprise Resource Management database schemas have access to required Oracle database objects.

     Use the script db/admin/misc/check_sys_object_access.sql to check access for all needed Oracle database objects. Recompile invalid objects in the AVEVA Enterprise Resource Management database schema again.

  3. Run the db/admin/misc/compile_12c_error_package.sql script with start compile_12c_error_package.sql <invalid package name> command (substitute <invalid package name> with invalid package header name).

     Note: Run the script for each invalid package header.

• To drop the schema:

  The drop user <user name> command throws an ORA Error ORA-04043: object SYS_PLSQL… does not exists for one or more PL/SQL packages.

  • Run the db/admin/misc/drop_12c_error_package.sql script with start drop_12c_error_package.sql <invalid package name> command (substitute <invalid package name> with invalid package header name).

    Note: Run the script for each package header with an error.