adaddnode.pl Ends With ORA-01403: No Data Found And ORA-06512: at line 159

(Doc ID 455130.1)

Last updated on AUGUST 29, 2017

Applies to:

Oracle Applications Manager - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Oracle Applications DBA - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
Checked for relevance on 24-NOV-2013

Symptoms

On 11.5.10.2 running on Solaris Operating System (SPARC 64-bit),
when running the command: "perl adaddnode.pl", the following error occured:

Configuring snapshot information for the new (clone target) node...
Executing command:
sqlplus /nolog @<APPL_TOP>/ad/11.5.0/patch/115/sql/adadmdat.sql APPS APPSPASSWORD SID
SID Source_APPL_TOP Target_APPL_TOP <COMMON_TOP>/temp/adadmdat_sql.spool
SQL*Plus: Release 8.0.6.0.0 - Production on Tue Aug 14 10:13:56 2007
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected.
....
....
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Updating tables...
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

declare
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 159

An example of the error is:

Configuring snapshot information for the new (clone target) node...
Executing command:
sqlplus /nolog @/d02/applmgr/oracle/test/ad/11.5.0/patch/115/sql/adadmdat.sql APPS apps TEST
 /d02/applmgr/oracle/prodcomn/temp/adadmdat_sql.spool
SQL*Plus: Release 8.0.6.0.0 - Production on Tue Aug 14 10:13:56 2007
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected.
....
....
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Updating tables...
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

declare
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 159

 

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