During Upgrade to 12.1 While Running Autoconfig In Apps Tier It Is Failing With Errors PLS-00306: wrong number or types of arguments in call to 'SET_PROFILE' PLS-00306: wrong number or types of arguments in call to 'REGISTER_APPNODE' (Doc ID 1459109.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Applications Technology Stack - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Checked for relevance on 20-OCT-2013

Symptoms

During the upgrade of an E-Business suite instance from 11.5.10.x to 12.1.1, while RapidInstall is running AutoConfig, the following error may be encountered in AutoConfig log file:

In the autoconfig.log:

The environment settings are as follows ...

      ORACLE_HOME : <10.1.2 ORACLE_HOME>
            LOCAL : DB14
             PATH :<10.1.2 ORACLE_HOME>\bin;<10.1.3 ORACLE_HOME>\appsutil\jdk\bin;<10.1.3 ORACLE_HOME>\appsutil\jdk\jre\bin;%PATH%;<10.1.3 ORACLE_HOME>\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe;...
        TNS_ADMIN : <INST_TOP>\ora\10.1.2\network\admin
Running SQL script : <INST_TOP>\admin\install\afwebprf.sql


SQL*Plus: Release 10.1.0.5.0 - Production on date

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

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
  adx_prf_pkg.set_profile(
          *
ERROR at line 191:
ORA-06550: line 191, column 12:
PLS-00306: wrong number or types of arguments in call to 'SET_PROFILE'
ORA-06550: line 191, column 12:
PL/SQL: Statement ignored


Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Error encountered while running <INST_TOP>\admin\install\afwebprf.sql
ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.
[CVM Error Report]
The following report lists errors encountered during CVM Phase
      <filename>  <return code where appropriate>
  <AD_TOP>\bin\adgentns.pl  2

No of scripts failed in CVM phase: 1


[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>

  [PROFILE PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: <10.1.3 ORACLE_HOME>\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe -I <10.1.3 ORACLE_HOME>\perl\5.8.3\lib\MSWin32-x86-multi-thread -I<10.1.3 ORACLE_HOME>\perl\5.8.3\lib -I <10.1.3 ORACLE_HOME>\perl\site\5.8.3\lib\MSWin32-x86-multi-thread   <INST_TOP>\admin\scripts\adexecsql.pl sqlfile=<INST_TOP>\admin\install
      afwebprf.sql            INSTE8_PRF         1

 

 

In NetServiceHandler.log:

StackTrace:
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'REGISTER_APPNODE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

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:1225)
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.registerMiddleTierNode(DataModelHandler.java:1038)
at oracle.apps.ad.tools.configuration.NetServiceHandler.registerMiddleTierNode(NetServiceHandler.java:729)
at oracle.apps.ad.tools.configuration.NetServiceHandler.registerNode(NetServiceHandler.java:1199)
at oracle.apps.ad.tools.configuration.NetServiceHandler.processNode(NetServiceHandler.java:2259)
at oracle.apps.ad.tools.configuration.NetServiceHandler.main(NetServiceHandler.java:2979)

Closing connection
Connection Closed

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