Re: Missing Grant on Package Body

It can be seen from the output I provided previously that I searched for the word signal too.

> egrep -iw 'signal|tc_table'
> /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_58350.trc

The `-w` flag was used because there were multiple "ERROR SIGNALLED" lines such as one below:

> CALL TYPE: call ERROR SIGNALED: no COMPONENT: PLSQL_Infrastructure
>

Even after removing the `-w` flag or using the exact command you were using I am not getting any hits on 19.23 with my specific test case. Which means that there are no such lines in my environment.

[oracle_at_myhostname ~]$ egrep -i 'signal' /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_58350.trc | grep -i about
[oracle_at_myhostname ~]$ egrep -nT -A+1 "about to signal" /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_58350.trc [oracle_at_myhostname ~]$

On Thu, 11 Jul 2024 at 14:47, Jonathan Lewis <jlewisoracle_at_gmail.com> wrote:

>
> The "Name" is restricted to the name of the table and doesn't include the
> schema, and I think tc_table is your schema.
> I should have said I was using 19.11; and my choice on egrep was
>
> egrep -nT -A+1 "about to signal" or19_ora_23101_level1.trc
> 5154 :about to signal 942
> 5155 -Name: FAIL1
>
> It would be necessary to search the rest of the file for the object name
> to find the SQL, and that might be messy given the way the text would be
> arbitrarily cut into 16 byte pieces.
>
>
> Regards
> Jonathan Lewis
>
>
>
> On Thu, 11 Jul 2024 at 13:51, Mikhail Velikikh <mvelikikh_at_gmail.com>
> wrote:
>
>> there are no such lines in 19.23 for my sample test case using the
>> default DB parameters.
>> alert log:
>> 2024-07-11T12:46:05.314540+00:00
>> PDB(3):Errors in file
>> /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_58350.trc:
>> ORA-00942: table or view does not exist
>>
>> egrep -iw 'signal|tc_table'
>> /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_58350.trc
>> 7F6E37B25750 4F524620 4354204D 4241545F 542E454C [ FROM TC_TABLE.T]
>> 7F6E37FBEE40 4F524620 4354204D 4241545F 542E454C [ FROM TC_TABLE.T]
>>
>> Best regards,
>> *Mikhail Velikikh*
>>
>>
>>
>> On Thu, 11 Jul 2024 at 13:44, Jonathan Lewis <jlewisoracle_at_gmail.com>
>> wrote:
>>
>>>
>>> This may be version-dependent and feature/parameter dependent, but even
>>> dumping an errorstack (on 942) at level 1 I found the following pair of
>>> consecutive lines in my trace file:
>>>
>>> about to signal 942
>>> Name: XXXXX
>>>
>>> (where xxxxx was the name of the missing / unavailable object)
>>>
>>>
>>>
>>>
>>>
>>> Regards
>>> Jonathan Lewis
>>>
>>>
>>>
>>> On Thu, 11 Jul 2024 at 13:01, Mikhail Velikikh <mvelikikh_at_gmail.com>
>>> wrote:
>>>
>>>
>>>> If you want to pinpoint the exact object(s) causing ORA-942, then you
>>>> can use the errorstack event as Mladen mentioned.
>>>> Level 2 would be enough to dump the necessary library cache structures:
>>>> alter session set events '942 errorstack(2)';
>>>>
>>>>
>>>>>

--
http://www.freelists.org/webpage/oracle-l