Re: January RU Combo Patch

From: Ls Cheng <exriscer_at_gmail.com>
Date: Fri, 21 Feb 2020 16:47:54 +0100
Message-ID: <CAJ2-Qb-r+b6om_iMLEypwe3_pUrgSJGV4P1ibwmD7LyDK4Ew6Q_at_mail.gmail.com>



I compared 30501910 which comes with

p30463609_190000_Linux-x86-64.zip
p30501910_190000_Linux-x86-64.zip

and they have same size

du -sk 30463609/30501910
3745320 30463609/30501910

du -sk 30501910
3745320 30501910

I have a SR opened as well

datapatch was ran against MGMTDB and this is the error

Stopping dequeue for queue AQ_SRVNTFN_TABLE_Q_1 begin
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [pfri.c#103: bad lu type], [22], [],
[], [], [], [], [], [], [], [], []

ORA-06512: at "SYS.DBMS_AQADM_SYS", line 15446
ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 778
ORA-06512: at "SYS.DBMS_AQADM", line 769
ORA-06512: at line 5
ORA-06512: at line 5



This is the code

begin
for queue in (select name from dba_queues where owner = 'SYS' AND name like 'AQ_SRVNTFN_TABLE_Q%') loop
begin
dbms_output.put_line('Stopping dequeue for queue ' || queue.name); DBMS_AQADM.STOP_QUEUE (
queue_name => queue.name,
enqueue => FALSE,
dequeue => TRUE,
wait =>TRUE);
dbms_output.put_line('Dequeue stopped for queue ' || queue.name); end;
end loop;
exception when others then
dbms_output.put_line('Exception while stopping queues ' || SQLCODE || ' ' || SQLERRM);
end;

On Fri, Feb 21, 2020 at 1:33 PM Jay Hostetter <hostetter.jay_at_gmail.com> wrote:

> This was the exact problem that I ran into when running datapatch. The
> workaround for me was to NOT use the combo patch. I downloaded the Grid RU
> and OJVM RU patches separately:
>
> p30501910_190000_Linux-x86-64.zip
> p30484981_190000_Linux-x86-64.zip
>
> Jay
>
> On Fri, Feb 21, 2020 at 6:36 AM Ls Cheng <exriscer_at_gmail.com> wrote:
>
>> Hi
>>
>> Did you get this error when patching the management database? I got error
>> for two clusters and for other 2 cluster the patch went through
>>
>>
>> Installing patches...
>> Patch installation complete. Total patches installed: 3
>>
>> Validating logfiles...done
>> Patch 30557433 apply (pdb CDB$ROOT): SUCCESS
>> logfile:
>> /u01/app/grid/cfgtoollogs/sqlpatch/30557433/23305305/30557433_apply__MGMTDB_CDBROOT_2020Feb21_10_18_25.log
>> (no errors)
>> Patch 30557433 apply (pdb PDB$SEED): SUCCESS
>> logfile:
>> /u01/app/grid/cfgtoollogs/sqlpatch/30557433/23305305/30557433_apply__MGMTDB_PDBSEED_2020Feb21_10_19_56.log
>> (no errors)
>> Patch 30557433 apply (pdb GIMR_DSCREP_10): WITH ERRORS
>> logfile:
>> /u01/app/grid/cfgtoollogs/sqlpatch/30557433/23305305/30557433_apply__MGMTDB_GIMR_DSCREP_10_2020Feb21_10_19_56.log
>> (errors)
>> -> Error at line 42: script rdbms/admin/bug_29784106_prepatch.sql
>> - ORA-00600: internal error code, arguments: [pfri.c#103: bad lu
>> type], [22], [],
>> - [], [], [], [], [], [], [], [], []
>> - ORA-06512: at "SYS.DBMS_AQADM_SYS", line 15446
>> - ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 778
>> - ORA-06512: at "SYS.DBMS_AQADM", line 769
>> - ORA-06512: at line 5
>> - ORA-06512: at line 5
>>
>> Thanks
>>
>>
>>
>>
>> On Fri, Feb 7, 2020 at 9:37 PM Jay Hostetter <hostetter.jay_at_gmail.com>
>> wrote:
>>
>>> My support tech didn't say if it will be republished. Since I have a
>>> workaround, the SR is now closed.
>>>
>>> Jay
>>>
>>> On Fri, Feb 7, 2020 at 2:09 AM Ls Cheng <exriscer_at_gmail.com> wrote:
>>>
>>>> Good to know, are they going to re-publish the patch?
>>>>
>>>> TIA
>>>>
>>>> On Thu, Feb 6, 2020 at 8:13 PM Jay Hostetter <hostetter.jay_at_gmail.com>
>>>> wrote:
>>>>
>>>>> I ran into an ORA-0600 when running datapatch for the January 2020 RU
>>>>> for 19c. After going back and forth with Support and doing some testing,
>>>>> it seems as though the combo patch for Linux x86-64 (30463609) may
>>>>> have an issue. My specific error was related to Streams.
>>>>>
>>>>> I downloaded the GI and OJVM patches separately and was able to
>>>>> successfully apply the the RU.
>>>>>
>>>>> Hopefully this info may save some aggravation if you are preparing to
>>>>> install this Release Update.
>>>>>
>>>>> Jay
>>>>>
>>>>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 21 2020 - 16:47:54 CET

Original text of this message