Script nms_schema_pre_migrate.sql Is Producing an Error With NMS v184.108.40.206.4
(Doc ID 2761772.1)
Last updated on MARCH 18, 2021
Applies to:Oracle Network Management for Utilities - DMS - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 2.5]
Information in this document applies to any platform.
Script nms_schema_pre_migrate.sql is producing an error with the 22.214.171.124.4 version
You're attempting to migrate a database from a prior release NMS v2.4 or earlier.
First time you ran through the migration, NMS v126.96.36.199.0 was installed and you didn't have any issues.
Now you're trying to run through the migration again with 188.8.131.52.4 installed.
Your migration is progressing nowhere because of a database error when nms-apply-migrations tries to run nms_schema_pre_migrate.sql. The diffs between the 2 versions are as follows with the new file version indicated with <:
< IF table_exists('PR_MIGRATIONS')
> IF NOT prod_synonym_exists('PR_MIGRATIONS')
< IF NOT prod_synonym_exists('PR_MIGRATIONS')
> IF table_exists('PR_MIGRATIONS')
< EXECUTE IMMEDIATE 'grant select, insert, update, delete on pr_migrations to ces_rw';
I ran the file's pl/sql by hand to try to pinpoint the issue and get this:
51 IF table_exists('PR_MIGRATIONS')
53 IF NOT prod_synonym_exists('PR_MIGRATIONS')
55 EXECUTE IMMEDIATE 'CREATE OR REPLACE SYNONYM __@__.pr_migrations FOR pr_migrations';
56 57 -- EXECUTE IMMEDIATE 'grant select, insert, update, delete on pr_migrations to ces_rw';
58 59 end;
ERROR at line 1:
ORA-00911: invalid character
ORA-06512: at line 55
Updated to NMS v184.108.40.206.4
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