4 Replies Latest reply on Mar 25, 2016 6:37 AM by 3181233

    adop_valid_nodes table or view does not exist

    3181233

      [applprod@ebst 20745242]$ adop phase=prepare patches=20745242

       

       

      Enter the APPS password:

      Enter the SYSTEM password:

      Enter the WLSADMIN password:

       

       

      Validating credentials.

       

       

      Initializing.

          Run Edition context  : /u01/app/fs2/inst/apps/ebsorat_ebst/appl/admin/ebsorat_ebst.xml

          Patch edition context: /u01/app/fs1/inst/apps/ebsorat_ebst/appl/admin/ebsorat_ebst.xml

      *******FATAL ERROR*******

      PROGRAM : (/u01/app/fs2/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)

      TIME    : Fri Mar 25 13:38:26 2016

      FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]

      MESSAGES:

      SQLPLUS error: buffer=

       

       

      SQL*Plus: Release 10.1.0.5.0 - Production on Fri Mar 25 13:38:26 2016

       

       

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

       

       

      SQL> SQL> Connected.

      SQL> from fnd_nodes fn, adop_valid_nodes avn

                                 *

      ERROR at line 3:

      ORA-00942: table or view does not exist

       

       

       

       

      Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

      With the Partitioning, OLAP, Data Mining and Real Application Testing options

       

       

       

       

       

       

      STACK TRACE

      at /u01/app/fs2/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168

        TXK::Error::abort('TXK::Error', 'HASH(0x21ea550)') called at /u01/app/fs2/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299

        TXK::Common::doError('TXK::SQLPLUS=HASH(0x490ef48)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...', undef) called at /u01/app/fs2/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314

        TXK::Common::setError('TXK::SQLPLUS=HASH(0x490ef48)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...') called at /u01/app/fs2/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 832

        TXK::SQLPLUS::_doExecute('TXK::SQLPLUS=HASH(0x490ef48)', 0) called at /u01/app/fs2/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 234

        TXK::SQLPLUS::execute('TXK::SQLPLUS=HASH(0x490ef48)', 'HASH(0x3d990b8)') called at /u01/app/fs2/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 618

        TXK::TechstackDB::_getSQLValue('TXK::TechstackDB=HASH(0x4546ce0)', '      select count(1)  from\x{a}      ( select distinct fn.host\x{a} ...') called at /u01/app/fs2/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 573

        TXK::TechstackDB::getSQLValue('TXK::TechstackDB=HASH(0x4546ce0)', '      select count(1)  from\x{a}      ( select distinct fn.host\x{a} ...') called at /u01/app/fs2/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 1285

        ADOP::GlobalVars::_GetMandatoryArgs() called at /u01/app/fs2/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 3185

        ADOP::GlobalVars::ValidateArgs('ADOP::GlobalVars') called at /u01/app/fs2/EBSapps/appl/au/12.0.0/perl/ADOP/AdopMain.pm line 1746

        ADOP::AdopMain::adopMain('ADOP::AdopMain') called at /u01/app/fs2/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl line 146

       

       

      adop exiting with status = 1 (Fail)