My Oracle Support Banner

Database Upgrade From 12.1.0.2 To 12.2.0.1 aborts while creating TYPE BODY sys.wri$_adv_sqltune (Doc ID 2552043.1)

Last updated on NOVEMBER 12, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Upgrading a PDB from 12.1.0.2 to 12.2.0.1 fails at-

05:37:57 SQL>
BEGIN_RUNNING
--------------------------------------------------------------------------------
==== @<oracle_home>/rdbms/admin/prvtsqli.plb Container
: Id:5 19-05-29 05:37:57 Proc:0 ====

05:37:58 SQL> CREATE OR REPLACE TYPE BODY sys.wri$_adv_sqltune wrapped
05:37:58   2  a000000
05:37:58   3  1
05:37:58   4  abcd
05:37:58   5  abcd
05:37:58   6  abcd
05:37:58   7  abcd
05:37:58   8  abcd
05:37:58   9  abcd
05:37:58  10  abcd
05:37:58  11  abcd
05:37:58  12  abcd
05:37:58  13  abcd
05:37:58  14  abcd
05:37:58  15  abcd
05:37:58  16  abcd
05:37:58  17  abcd
05:37:58  18  abcd
05:37:58  19  e
05:37:58  20  374e e46
05:37:58  21  4bqHF95w4b497cfQ0ZjVbyb417Iwgz263iCGU4i5sZLqS7Rikb9MeICYmdvXpsKiSScB+oTM
05:37:58  22  oeT0pVlxyrSTSS5uVW+0LJqcnKLyiVatxvXWyvc+HLuVwQBa6z3TjJOr4lCW0L+awoHNcoop
05:37:58  23  mg+fcgWyGGVGUGfk6Op1yBZf8Zmg3W2IGxGhJaYHra8W2Rd0mo/KsDBac4pPVp7MicqJXTSG
05:37:58  24  BGC/czcqBF/m3tw9ffMPepc58ciIvKn0W8mxA8eO/2+I2SLUIa58bdMYoQbGt+OtfasuOHzc
05:37:58  25  FSkO1Qs2F3Xsfj195iEIH1ORBpdJr2Ou3ECwSSTPtWoRxSkCvmWXIvGNA7YX7/qGVDLcofXM
05:37:58  26  M1Xrk/800j4XNOrBhhCQ3tR0GeVflBAlHjZdPBkHj60nEwfVGES+7DkB1X82q8KJTRzN4DyL
05:37:58  27  fy+Q/bW0JeWjrtyMzhEGB6gDkrLtBa72vCq5QbksMUhz0oa3sH3Rw0ReQohKUmfzu91hHk/f
05:37:58  28  EdwlRJs/cw3CViHjrxxFvNtwEeDdVWJ7gBf8sxMrfZ/IQjcmZk4LSvonTaGInNTJ5x+f+xhv
05:37:58  29  mXZgIpVArRVAoQ2ywYiaW2NVrolVrkzxX4sRFgeQxzIup10YZSQ0GGcLwMpP1nHuaQTzTq2B
05:37:58  30  762nhwaiBqzkEnUrI8ptOgs+x05P18HBVVVzYVBNYyXmsOkkJrSytQo8ICvCsDpeI2GOedU6
05:37:58  31  6ZIunFc+v1B6bEA/Y9xi6WaOsCkJDCBK3riTSm8zyjODoMiWvPQWF2txXdCh8sHeQUYBSUgd
05:37:58  32  Lml2Bqnjc0ePslBqVwCrXMZ9Z+lvTQ4qxmtMpRskW1Ls7qyR8GapBsdVtWJLBmkKoGiWEmh5
05:37:58  33  MWqcgTz0gqi0FH4GYGqCoX03fyBbZSXnVVMlFj8UDm5qX+aUuTeN0yH/3aoRQyGWc/f71ZXU
05:37:58  34  EpZsPGcCANgs+++fE4BKVkjASg8CbiXA/B78N9F4gbh6PpLCT7EPQXh93v4UpTt5DCJuVwdV
05:37:58  35  tcJVemFK2pCJ7Sx4tcCBfqARKE2keO2t9yCjAsO9z85XDoWtYLkfDHvhTnI6xUHBN8LdQAJe
05:37:58  36  1q7PGyxnY4zdcYL0ziYFw7C29uHoyaYRROy3Z7agGRlh18B6PrOmTessM8I4X3vNe/wwCVKQ
05:37:58  37  4PryBRmNHsduGGHcai6fcstwK9CtGWSQkg63PDWV6M7WK95BXYjLsgBvTMqkHWTV4fUgowKt
05:37:58  38  c7XpLxlJiQSxHGk3wCNlgke4W6t7lQSc9NtUY5kBkThaZCrTUrIRDMtj/QFLHFZ4VqGt29ac
05:37:58  39  XSwhbuhZG6eElXOFpYifw4Z09o7ZxUU1YNNGIOE0GszsBGsRrAm4jRS2ywManJiD5tiPh6+O
05:37:58  40  fk+DUzAq4ubjzsxAsKfmkfxMYPted62ZnOzAY+7FW3h8MVjWukD7BkMDfSytPaDijljlBABt
05:37:58  41  /2jw/ATUin7hkodl+Zby4WUXSPSpMkSilK68SMhx8PEkVXkgVSZXgx/vmAYG/keYlHVF1o+/
05:37:58  42  jifpUa6Ygbm53r/+OtfbktzTeUfVh3GZRRuzxHr7OCmKLC+AF3ljDoFI/uc3HrlBeU+qkqBC
05:37:58  43  dptAt7NUNE1GT2Jl7bFERvj0YrSjGluk+fjdHRqC9OmaNMds+qYGLeGDUkRvHsmjEUhx1Wa4
05:37:58  44  4dBJyt6U/D/WiU/B/5eiEO970/Oc4Tonx5PifN5lIz3FwyPjoTxGj0TO2KPOAGjZ+Vr3ZHMB
05:37:58  45  A4xvP3uhk31eT/TngEUe8USs3tzx3kmdyyE23uPMXr5useuZ3wRW1US30wy6TMk3LfHuwFSG
05:37:58  46  VivXfPLiBNu8kRrOIbKVz+QQhhOxz8MVAkN8fO8rO9shRAABd2OuH5KiKvxf4Y4P0CDLmRtt
05:37:58  47  vT3/WhjncJFuo1RS8J72GCzvvFJuUlMK5CtX60nsKbZHdhzZzwKbqsSeTAtYSvguITCUzmBM
05:37:58  48  CAV65y/i0mNEtcXsHGkbiwQnBdJNh0dzeafA+D3ABVnpMMTCFOHwn9ddEIRLLTuWmGVwFKxc
05:37:58  49  54qekAxPzpmfQ8bzU4BWlAFBAO/4zpOMnCNjNaK8RpPAVg+b1hdbKxuCYAjgk/ofldU1K6ct
05:37:58  50  E+l0T4+WQ8EpOV+e9fz7yAClLVt632sLAb/VvT9ngO+ANl3kH86PpAx4bIxvQ59AQXk5xhkE
05:37:58  51  XOzcNKP0N15mMgmyGZHVlo0mxZPzxcNuv8Eou/SZ+P+kuvKBT7tPxJjuT2B2qG5tEhLc7BN8
05:37:58  52  GivqALYNYCCDzD+WYnhR3NyhuyS9lhWedCHH09TwWijasYtxjQIaP41/pv2lOGa8hk84iX6r
05:37:58  53  oyLcw+3dygEhP2d+GxZkZWTWxiO3xUpcM5RU6cjRpqY36EZifGzMj1wxA/7IWvYn4bRyc6Yq
05:37:58  54  /EXSgy8NDCNLZtSRyMb/1jmkoZLdl05D07drhFcucuEKWqBpC1Nap5wKVp7kBOmqoQN76HXZ
05:37:58  55  Qmp8068YLMmaAvM3stTKsLBX/UJeEmsJrdYjBd2yQiGstElKb/NDER+wZ46Cg+Uajex7wVxw
05:37:58  56  ShmExBpOMQ8xFZ03/+8H3wwzm6LYNqVXMsjwl4xcXtinEDcWTbx7Q619lMJ4Dd/x2HI6szZ8
05:37:58  57  zcEhgWAybI4hPEkRLVjxA/UiePf6l2sTMJPUP+FRrrjUl3nrBz6vdBfFvDPqiKryJTadHBIA
05:37:58  58  NeO7eJ6LuqJnEFJNNWaMvKwCfOP30nsLcA0GEcF8a9Tg0wh0f0+qCGX6myoHQzgYFQedx1vI
05:37:58  59  8UUO/EwkDkoTuwrlS9H4GfzvBIrKL5GbL+xMgKCcOdZuL25pAEHVaT2+9dkgvwdXAesbOAzC
05:37:58  60  WcE2NZ48x4T+VxeC3fBSwDWWDWLmDhJ3jv6nAz16+08i8mXlotpIS32s8vLgG/HWzAsaGgkU
05:37:58  61  QUufkHQNVYXITg2BfUt03yBPvu8miy8VRwWpYo1TsgWcAh9WGqiDvzEaqIP29Hb/9zI7GuXW
05:37:58  62  iwyfwiLitjh/ReMag6f3v9wZGWUurSkw5NgJzmJNwT0PbR0f9eNoqUegUizQsynMlABpnBYl
05:37:58  63  APjltMSE0OvWt9U3eQ6qQQObG65uXWF9XMhw9VA+U0IOck6L3kPTUQDMUspQaY8gTbu1On34
05:37:58  64  naT6uknX4kU517vwLTwN16td2fL43fvERbiRH6kjVcFyH7Rc3r/POmfqqWia2hEKkXu8Enw5
05:37:58  65  sLBfRbF4L6IipMgRoc1lnCs/CZ1Byh6jK2zlg7PRN9ebOmgWtQryVPE5KcCVZM9H1PwGonCH
05:37:58  66  bhGHgweJJw+AIbhPXFPjw7A5BjQNdbQq9jrtdIQXAHkTF86I2xs+N3bl4mS5o9Z84Ysw2juV
05:37:58  67  zp7GVUXJylc/oM4jYaXfGIQ83rdObqEscT0gBnSJB11PVQvBLar3kwvQ6GE7Ft705RN16lXc
05:37:58  68  tzxmydFyodQjDTVSP3I717HoFJLZ08J7nbHJuLl7cfcIS+wJwypX4LRUYq2mFUNqv2IWNovG
05:37:58  69  MEFsTXXfbnvVebs3gt76PCZfUQf2huSEUh9pxCf69L/mw/zwLw2pYPmX31FSQm2qrig/LGfR
05:37:58  70  R0z27hJXU8bDb6MYnOwUvGRXKqWdBMq/L6AYB1GTu28waxxt6gmKpeZ6X+hD95a1+Ji1+zV8
05:37:58  71  WAU=
05:37:58  72  
05:37:58  73  /
CREATE OR REPLACE TYPE BODY sys.wri$_adv_sqltune wrapped
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
ERROR:
ORA-03114: not connected to ORACLE

SP2-1519: Unable to write to the error log table sys.registry$error
Process ID: 350366
Session ID: 400 Serial number: 4050

Subsequently,all operations fail with ORA-03114: not connected to ORACLE.After this,the PDB is restarted and a new connection is established-

05:38:03 SQL> 05:38:03 SQL>
05:38:03 SQL> Disconnected from Oracle Database 12c EE Extreme Perf Release 12.2.0.1.0 - 64bit Production

SQL*Plus: Release 12.2.0.1.0 Production on Wed May 29 05:38:03 2019

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

SQL> Connected.

Though some operations may still run,eventually the Upgrade may fail with below errors-

Elapsed: 00:00:00.00
05:46:31 SQL>
05:46:31 SQL> /* bug 23292323: drop orphaned dbms_stats temporary tables
05:46:31 SQL> *
05:46:31 SQL> * Various dbms_stats routines create temporary tables. These tables can
05:46:31 SQL> * be orphaned if the stats operation is interrupted. dbms_stats will
05:46:31 SQL> * drop these orphaned tables on next invocation.
05:46:31 SQL> *
05:46:31 SQL> * Step 3 can invoke dbms_stats in catrequired.sql.
05:46:31 SQL> *
05:46:31 SQL> * We don't want DDL operations to happen once Step 3 starts. Call dbms_stats
05:46:31 SQL> * to drop orphaned temp tables before proceeding with Step 3.
05:46:31 SQL> */
05:46:31 SQL> begin
05:46:31 2 dbms_stats_internal.drop_old_temp(2147483647);
05:46:31 3 end;
05:46:31 4 /
begin
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_STATS_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"SYS.DBMS_STATS_INTERNAL"
ORA-06512: at line 2



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.