adop phase=prepare Fails With Error While Adding New Node Information (Doc ID 2030341.1)

Last updated on DECEMBER 09, 2016

Applies to:

Oracle Applications DBA - Version 12.2.4 to 12.2.4 [Release 12.2Cloud]
Information in this document applies to any platform.

Symptoms

On Oracle Applications 12.2.4 version,
when attempting to execute the following after adding a new node in DMZ configured  environment with a shared file system:

adop phase=prepare allnodes=no action=db (while ssh connectivity is not enabled between nodes )

or

adop phase=prepare (with ssh connectivity enabled between nodes )


the following error occurs:

Checking for pending adop sessions...
  No pending session exists.
  Staging new adop session...
  [ERROR] Failed to execute SQL statement :
  begin
  ad_zd_adop.INSERT_ADD_NODE_RECORDS;
  end;

  [ERROR] Error Message :
  [UNEXPECTED]Error occurred while adding new node information
  [UNEXPECTED]Unrecoverable error occured. Exiting the current session.

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms