My Oracle Support Banner

nms_setup Has Problems with Migration .sql Scripts Not Ending with Newlines (Doc ID 2890418.1)

Last updated on AUGUST 24, 2022

Applies to:

Oracle Utilities Network Management System - Version 2.5.0.1.0 to 2.5.0.2.0 [Release 2.5]
Oracle Network Management for Utilities - DMS - Version 2.5.0.1.0 to 2.5.0.2.0 [Release 2.5]
Information in this document applies to any platform.

Symptoms

ISQL will hang if the PR migration file does not have new line in the end of the file.
It will create a temporary sql which will have exit statement next to the / sign.
SQLPLUS will not execute PL SQL or exit as a result

Example ISQL -admin -F pr28275652_migration.sql - this will hang

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 Fix Description
 Migration
References


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