Re: 12.1 ORA-04023 - Not Fun

The name of that object suggests to me that it's a java class intended for use integrating AQ with Java Messaging System (jms).

I'd start with utl_recomp, and then look at an SR with the AQ team. On 19 Jun 2017 23:15, "Chris Taylor" <christopherdtaylor1994_at_gmail.com> wrote:

I'm not sure - how do I tell?

If I try to describe the underlying sys object "/7e7bb219_AQjmsReflectAQjmsThr" I get

SP2-0749: Cannot resolve circular path of synonym "sys."/7e7bb219_ AQjmsReflectAQjmsThr""

So, maybe historical reasons?

On Mon, Jun 19, 2017 at 4:51 PM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:

> Are the objects real SYS objects, or are they created in the SYS schema
> for historical reasons?
>
> On Mon, Jun 19, 2017 at 10:26 PM, Chris Taylor <
> christopherdtaylor1994_at_gmail.com> wrote:
>
>> Well, I went ahead and did a "create or replace public synonym..." and
>> one of them resolved, but the other is still showing a mismatch.
>>
>> Annoying.
>>
>> Chris
>>
>>
>> On Mon, Jun 19, 2017 at 4:23 PM, Givens, Steven <sgivens_at_fnni.com> wrote:
>>
>>> I’ve had luck just doing a describe or selecting from the public
>>> synonyms to get them validated.
>>>
>>>
>>>
>>> *From:* oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freeli
>>> sts.org] *On Behalf Of *Chris Taylor
>>> *Sent:* Monday, June 19, 2017 4:16 PM
>>> *To:* ORACLE-L
>>> *Subject:* [External] 12.1 ORA-04023 - Not Fun
>>>
>>>
>>>
>>> 12.1.0.2
>>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__12.1.0.2&d=DwQFaQ&c=LkAXfnqL6_MvrMPL5JzdE3Ild0DUTpmjbCJvMv5_TcQ&r=p64P693r52tzs7tJCmFvOg&m=F9S541MtQ8HyADmSNyHC9Bq2XAAme-EExkx0GB1pFBI&s=5iKEXBzbqbgVF3KbhH7EYCOBXUxgpjIKUEneFlb38Y0&e=>
>>> on Linux:
>>>
>>> select * from < table_name > ;
>>>
>>> ORA-04023: Object select * from <owner>.<table_name> could not be
>>> validated or authorized
>>>
>>> Metalink Note: 1610514.1 (Regarding Views) says its a timestamp issue in
>>> the data dictionary.
>>>
>>> The only results returned from the query (provided by support) are 2 SYS
>>> public synonyms.
>>>
>>> What is the "best" way to fix SYS public synonyms?? Can you recompile
>>> public synonyms? I was thinking they had to be dropped and re-created.
>>>
>>> Suggestions?
>>>
>>> Chris
>>>
>>
>>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>

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