DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, September 14, 2015

Executing Autoconfig on database tier completed with status 2 failing to execute afdbprf.sh adcrobj.sh scripts

FND_NODES table is not getting updated/populated with the respective node entries. 
 
Logfile shows the below ORA- error while exiting adgentns.pl script
 
Error
------
[ Config tool : /d01/oracle/EBS/db/tech_st/11.1.0/appsutil/bin/adgentns.pl ]
   Command            : /d01/oracle/EBS/db/tech_st/11.1.0/perl/bin/perl -I /d01/oracle/EBS/db/tech_st/11.1.0/perl/lib/5.8.3 -I /d01/oracle/EBS/db/tech_st/11.1.0/perl/lib/site_perl/5.8.3 -I /d01/oracle/EBS/db/tech_st/11.1.0/appsutil/perl  /d01/oracle/EBS/db/tech_st/11.1.0/appsutil/bin/adgentns.pl PASSWORD  contextfile=/d01/oracle/EBS/db/tech_st/11.1.0/appsutil/EBS_ebs.xml  logdir=/d01/oracle/EBS/db/tech_st/11.1.0/appsutil/log/EBS_ebs/09101343  outdir=/d01/oracle/EBS/db/tech_st/11.1.0/appsutil/out/EBS_ebs/09101343
   Action             : execute

SCRIPT RETURNED:
##########################################################################
                   Generate Tns Names
##########################################################################
        Classpath                   : :/d01/oracle/EBS/db/tech_st/11.1.0/jdbc/lib/ojdbc6.jar:/d01/oracle/EBS/db/tech_st/11.1.0/appsutil/java/xmlparserv2.jar:/d01/oracle/EBS/db/tech_st/11.1.0/appsutil/java:/d01/oracle/EBS/db/tech_st/11.1.0/jlib/netcfg.jar:/d01/oracle/EBS/db/tech_st/11.1.0/jlib/ldapjclnt11.jar

Loading ORACLE_HOME environment from /d01/oracle/EBS/db/tech_st/11.1.0
Logfile: /d01/oracle/EBS/db/tech_st/11.1.0/appsutil/log/EBS_ebs/09101343/NetServiceHandler.log
java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.FND_NET_SERVICES", line 877
ORA-06512: at line 1

        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
        at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
        at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468)
        at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:3878)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
        at oracle.apps.ad.tools.configuration.DataModelHandler.registerDBNode(DataModelHandler.java:1122)
        at oracle.apps.ad.tools.configuration.NetServiceHandler.registerDbNode(NetServiceHandler.java:1061)
        at oracle.apps.ad.tools.configuration.NetServiceHandler.registerNode(NetServiceHandler.java:1201)
adgentns.pl exiting with status 0
ERRORCODE = 0 ERRORCODE_END
.end std out.

.end err out. 
 
 
Solution
-----------

Found DUAL table created on the APPS schema causing this issue in the internal architecture.

Query
----
select OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED
from dba_objects
where object_name='DUAL';

Action Plan
-------------
Drop the DUAL table from the APPS schema.

drop table apps.dual;


Re-run the autoconfig script on the database tier again and test the issue has been fixed Now. 

No comments: