Re: January RU Combo Patch

Hi

I found yesterday a patch which is related to the ORA-600 error:

*Patch 30663646* STRESS:FA:PRJ-COMBO:ORA 600 [PFRI.C#103: BAD LU TYPE] PFRI.C PFRINS ( SYN TRANSLATION ) - ASM_FEATURE_PUB.IS_FEATURE_ENABLED Linux x86-64 for Oracle Database 19.6.0.0.0 DBRU

And just 5 minutes ago the SR I opened yesterday suggests to apply this patch. However does anyone know how to apply RU and a one-off patch at the same time so I can ensure the software binaries are patched with Patch 30663646 therefore ORA-600 is avoided?

Similar to gridSetup.sh -applyRUR

Thanks

On Fri, Feb 21, 2020 at 4:47 PM Ls Cheng <exriscer_at_gmail.com> wrote:

> 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