adcfgclone on apps-tier failed

After cloning DB, started the apps cloning and faced the below issue


Issue:

Executing script in InstantiateFile:
/oracle/VIS/inst/apps/VIS_develop/admin/install/adgendbc.sh
script returned:
****************************************************

adgendbc.sh started at Mon Aug 6 22:34:58 IST 2018


SQL*Plus: Release 10.1.0.5.0 - Production on Mon Aug 6 22:34:58 2018

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
[ APPS_DATABASE_ID ]
Application Id : 0
Profile Value : VIS
Level Name: SITE
INFO : Updated/created profile option value.
.

PL/SQL procedure successfully completed.


Commit complete.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options


==============================
* * * * DBC PARAMETERS * * * *
==============================
fnd_jdbc_buffer_min=1
fnd_jdbc_buffer_max=5
fnd_jdbc_buffer_decay_interval=300
fnd_jdbc_buffer_decay_size=5
fnd_jdbc_usable_check=false
fnd_jdbc_context_check=true
fnd_jdbc_plsql_reset=false



====================================
* * * * NO CUSTOM PARAMETERS * * * *
====================================



Unique constraint error (00001) is OK if key already exists

Creating the DBC file...
java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.FND_RANDOM_NUMBER", line 395
ORA-06512: at "APPS.FND_RANDOM_NUMBER", line 447
ORA-06512: at "APPS.FND_CRYPTO", line 286
ORA-06512: at "APPS.FND_RANDOM_PKG", line 35
ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 32
ORA-06512: at line 1
- Database error performing ADD

ADD call failed with exit code 1

Updating Server Security Authentication
java.sql.SQLException: Invalid number format for port number
Database connection to jdbc:oracle:thin:@host_name:port_number:database failed
Updating Server Security Authentication failed with exit code 1
Restoring DBC file from backed up location /oracle/VIS/inst/apps/VIS_develop/appltmp/TXK/VIS_Mon_Aug_06_22_34_2018.dbc

adgendbc.sh ended at Mon Aug 6 22:35:09 IST 2018

adgendbc.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.
****************************************************
......
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>

[SETUP PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /oracle/VIS/inst/apps/VIS_develop/admin/install
adgendbc.sh INSTE8_SETUP 1


AutoConfig is exiting with status 1

AutoConfig execution completed on Mon Aug 6 22:35:48 2018

Time taken for AutoConfig execution to complete : 2 mins 2 secs 


Possible Solutions : 

Creating appsutil.zip from Apps-tier, transfer the zip to DB-Tier, run autoconfig on DB and then proceed with adcfgclone on apps-tier.

Checking the listener status in DB, and then start with adcfgclone on apps-tier. I've tried all the available solution of different blogs but still facing the same issue.

Here in my case the reason for the issue is bit different and the solution I followed is given below.


Reason : 

Entries in table FND_RAND_STATES for the DB is missing.


Solution :

Drop the existing table,re-create table and re-populate the entries by running the script afscrng.sql


Action :

sqlplus apps/xxxxx

SQL> drop table FND_RAND_STATES;
SQL> commit;

cd $FND_TOP/patch/115/sql

sqlplus apps/xxxxx

SQL> @afscrng.sql

Now check whether the table FND_RAND_STATES is re-created and the entries are re-populated. If so, run auto-config on the DB tier first and then start the adcfgclone on APPS tier.


****************************நன்றி****************************