Re: ad & txk 9 upgrade

Posted by Adhrushta on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ad-txk-9-upgrade-tp2945p2965.html


************* Start of AD Worker session *************
AD Worker version: 12.2.0
AD Worker started at: Mon Jul 17 2017 15:33:28

APPL_TOP is set to /u01/apps/fs2/EBSapps/appl

Worker id = 1
Started by: adpatch

NLS_LANG value from the environment is    : AMERICAN_AMERICA.WE8ISO8859P9
NLS_LANG value for this AD utility run is : AMERICAN_AMERICA.WE8ISO8859P9

Connecting to SYSTEM......Connected successfully.

Already asked for the ORACLE username and password
of Application Object Library.
(The given username/password was: APPLSYS/*****)

Connecting to APPS......Connected successfully.


The status of various features in this run of AD Worker is:

                                           <-Feature version in->
Feature                          Active?   APPLTOP    Data model    Flags
------------------------------   -------   --------   -----------   -----------
CHECKFILE                        Yes       1          1             Y N N Y N Y
PREREQ                           Yes       6          6             Y N N Y N Y
CONCURRENT_SESSIONS              No        2          2             Y Y N Y Y N
PATCH_TIMING                     Yes       2          2             Y N N Y N Y
PATCH_HIST_IN_DB                 Yes       6          6             Y N N Y N Y
SCHEMA_SWAP                      Yes       1          1             Y N N Y Y Y
JAVA_WORKER                      Yes       1          1             Y N N Y N Y
CODELEVEL                        Yes       1          1             Y N N Y N Y



Reading product information from file...

Reading language and territory information from file...

Reading language information from applUS.txt ...

Currently, the following languages are installed:

Code   Language                                Status
----   --------------------------------------- ---------
US     American English                        Base        
TR     Turkish                                 Install      

Reading language information from applTR.txt ...

Your base language will be AMERICAN.

Your other languages to install are: TURKISH

Ready to run jobs.
Setting parallel context: PARALLEL AUTOPATCH AT R120


Time when worker started job: Mon Jul 17 2017 15:33:29


Start time for file is: Mon Jul 17 2017 15:33:29

sqlplus -s APPS/***** @/u01/apps/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/apps/fs2/EBSapps/appl/admin/adsysapp2.sql &systempwd'
Connected.

PL/SQL procedure successfully completed.

Connected.
USER is "SYSTEM"

--- adsysapp2 started at 17-07-2017 15:33:29 ---

Dropping packages no longer used in Release 11.5 and 12.0

drop package bb_dist
*
ERROR at line 1:
ORA-04043: object BB_DIST does not exist


drop package ak_mls
*
ERROR at line 1:
ORA-04043: object AK_MLS does not exist


drop package ak_org
*
ERROR at line 1:
ORA-04043: object AK_ORG does not exist


drop package ak_org_private
*
ERROR at line 1:
ORA-04043: object AK_ORG_PRIVATE does not exist


drop package ak_org_data
*
ERROR at line 1:
ORA-04043: object AK_ORG_DATA does not exist


drop package ad_mcurr
*
ERROR at line 1:
ORA-04043: object AD_MCURR does not exist



Creating package specifications...


--- Creating AD_APPS_PRIVATE package header (AD common PL/SQL routines)

Creating package ad_apps_private ...

Package created.

--- Creating AD_DDL package header (Runtime DDL Support)

Package created.

--- Creating AD_INST package header (AutoUpgrade Server-Side Support)

Package created.

--- Creating AD_MLS package header (Multi-Lingual Support)

Creating package ad_mls ...

Package created.

--- Creating AD_COMPILE package header

Package created.

--- Creating AD_INVOKER package header

Creating package specification for ad_invoker ...

Package created.

--- Creating AD_CLONE_UTILS package header

Package created.


Creating package bodies...


--- Creating AD_APPS_PRIVATE package body

Creating package body ad_apps_private ...

Package body created.

--- Creating AD_DDL package body

Package body created.

--- Creating AD_INST package body

Package body created.

--- Creating AD_MLS package body

Creating package body ad_mls ...

Package body created.

--- Creating AD_COMPILE package body

Package body created.

--- Creating AD_INVOKER package body

Creating package body for ad_invoker ...

Package body created.


It is OK if the above package body was created with compilation
errors accessing AD_INVOKER_TASKS, FND_ORACLE_USERID,
AD_PARALLEL_COMPILE_ERRORS, or AD_TIMESTAMPS

The errors should be resolved by the time AutoUpgrade completes

--- Creating AD_CLONE_UTILS package body

Package body created.


--- create public synonyms for ad_inst and ad_ddl
        from   xmltable(('"AD_DDL","AD_INST"')) t) list
                                                 *
ERROR at line 6:
ORA-06550: line 6, column 50:
PL/SQL: ORA-00933: SQL command not properly ended
ORA-06550: line 3, column 1:
PL/SQL: SQL Statement ignored




Time when worker failed: Mon Jul 17 2017 15:33:29


Time when worker started job: Mon Jul 17 2017 15:33:29


Start time for file is: Mon Jul 17 2017 15:33:29

sqlplus -s APPS/***** @/u01/apps/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/apps/fs2/EBSapps/appl/admin/adsysapp2.sql &systempwd'
Connected.

PL/SQL procedure successfully completed.

Connected.
USER is "SYSTEM"

--- adsysapp2 started at 17-07-2017 15:33:30 ---

Dropping packages no longer used in Release 11.5 and 12.0

drop package bb_dist
*
ERROR at line 1:
ORA-04043: object BB_DIST does not exist


drop package ak_mls
*
ERROR at line 1:
ORA-04043: object AK_MLS does not exist


drop package ak_org
*
ERROR at line 1:
ORA-04043: object AK_ORG does not exist


drop package ak_org_private
*
ERROR at line 1:
ORA-04043: object AK_ORG_PRIVATE does not exist


drop package ak_org_data
*
ERROR at line 1:
ORA-04043: object AK_ORG_DATA does not exist


drop package ad_mcurr
*
ERROR at line 1:
ORA-04043: object AD_MCURR does not exist



Creating package specifications...


--- Creating AD_APPS_PRIVATE package header (AD common PL/SQL routines)

Creating package ad_apps_private ...

Package created.

--- Creating AD_DDL package header (Runtime DDL Support)

Package created.

--- Creating AD_INST package header (AutoUpgrade Server-Side Support)

Package created.

--- Creating AD_MLS package header (Multi-Lingual Support)

Creating package ad_mls ...

Package created.

--- Creating AD_COMPILE package header

Package created.

--- Creating AD_INVOKER package header

Creating package specification for ad_invoker ...

Package created.

--- Creating AD_CLONE_UTILS package header

Package created.


Creating package bodies...


--- Creating AD_APPS_PRIVATE package body

Creating package body ad_apps_private ...

Package body created.

--- Creating AD_DDL package body

Package body created.

--- Creating AD_INST package body

Package body created.

--- Creating AD_MLS package body

Creating package body ad_mls ...

Package body created.

--- Creating AD_COMPILE package body

Package body created.

--- Creating AD_INVOKER package body

Creating package body for ad_invoker ...

Package body created.


It is OK if the above package body was created with compilation
errors accessing AD_INVOKER_TASKS, FND_ORACLE_USERID,
AD_PARALLEL_COMPILE_ERRORS, or AD_TIMESTAMPS

The errors should be resolved by the time AutoUpgrade completes

--- Creating AD_CLONE_UTILS package body

Package body created.


--- create public synonyms for ad_inst and ad_ddl
        from   xmltable(('"AD_DDL","AD_INST"')) t) list
                                                 *
ERROR at line 6:
ORA-06550: line 6, column 50:
PL/SQL: ORA-00933: SQL command not properly ended
ORA-06550: line 3, column 1:
PL/SQL: SQL Statement ignored




Time when worker failed: Mon Jul 17 2017 15:33:30


Time when worker started job: Mon Jul 17 2017 15:33:30


Start time for file is: Mon Jul 17 2017 15:33:30

sqlplus -s APPS/***** @/u01/apps/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/apps/fs2/EBSapps/appl/admin/adsysapp2.sql &systempwd'
Connected.

PL/SQL procedure successfully completed.

Connected.
USER is "SYSTEM"

--- adsysapp2 started at 17-07-2017 15:33:30 ---

Dropping packages no longer used in Release 11.5 and 12.0

drop package bb_dist
*
ERROR at line 1:
ORA-04043: object BB_DIST does not exist


drop package ak_mls
*
ERROR at line 1:
ORA-04043: object AK_MLS does not exist


drop package ak_org
*
ERROR at line 1:
ORA-04043: object AK_ORG does not exist


drop package ak_org_private
*
ERROR at line 1:
ORA-04043: object AK_ORG_PRIVATE does not exist


drop package ak_org_data
*
ERROR at line 1:
ORA-04043: object AK_ORG_DATA does not exist


drop package ad_mcurr
*
ERROR at line 1:
ORA-04043: object AD_MCURR does not exist



Creating package specifications...


--- Creating AD_APPS_PRIVATE package header (AD common PL/SQL routines)

Creating package ad_apps_private ...

Package created.

--- Creating AD_DDL package header (Runtime DDL Support)

Package created.

--- Creating AD_INST package header (AutoUpgrade Server-Side Support)

Package created.

--- Creating AD_MLS package header (Multi-Lingual Support)

Creating package ad_mls ...

Package created.

--- Creating AD_COMPILE package header

Package created.

--- Creating AD_INVOKER package header

Creating package specification for ad_invoker ...

Package created.

--- Creating AD_CLONE_UTILS package header

Package created.


Creating package bodies...


--- Creating AD_APPS_PRIVATE package body

Creating package body ad_apps_private ...

Package body created.

--- Creating AD_DDL package body

Package body created.

--- Creating AD_INST package body

Package body created.

--- Creating AD_MLS package body

Creating package body ad_mls ...

Package body created.

--- Creating AD_COMPILE package body

Package body created.

--- Creating AD_INVOKER package body

Creating package body for ad_invoker ...

Package body created.


It is OK if the above package body was created with compilation
errors accessing AD_INVOKER_TASKS, FND_ORACLE_USERID,
AD_PARALLEL_COMPILE_ERRORS, or AD_TIMESTAMPS

The errors should be resolved by the time AutoUpgrade completes

--- Creating AD_CLONE_UTILS package body

Package body created.


--- create public synonyms for ad_inst and ad_ddl
        from   xmltable(('"AD_DDL","AD_INST"')) t) list
                                                 *
ERROR at line 6:
ORA-06550: line 6, column 50:
PL/SQL: ORA-00933: SQL command not properly ended
ORA-06550: line 3, column 1:
PL/SQL: SQL Statement ignored




Time when worker failed: Mon Jul 17 2017 15:33:30


Manager says to quit.


Time when worker quit: Mon Jul 17 2017 15:33:39

AD Worker is complete.

Errors and warnings are listed in the log file
/u01/apps/fs_ne/EBSapps/log/adop/57/apply_20170717_152906/DEV_erpdev/ADOP_MRG_20170717_1500294597/log/adwork001.log

and in other log files in the same directory.