Sqldeveloper 20.4 database diff function strange result

Dezsoe Kados

When comparing two schemas I get the following result in some cases:

-----------------------------------------------------------------

schema.package using connection_name connection.

Unable to compare objects.

Ensure that you have the required permissions.  

You must own the objects or have select_catalog_role.

-----------------------------------------------------------------

Makes no sense as both connections own the respective package.

I have seen this happening already from (at least) sqtdeveloper 19.x on

Source DB info:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

Target DB info:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Sqldeveloper info

About

-----

Oracle SQL Developer 20.4.0.379

 Version 20.4.0.379

Build 379.2205

IDE Version: 12.2.1.5.42.201006.2103

Product ID: oracle.sqldeveloper

Product Version: 20.4.0.379.2205

Version

-------

Component Version

========= =======

Oracle IDE 20.4.0.379.2205

Java(TM) Platform 1.8.0_271

Properties

----------

Name Value

==== =====

Extensions

----------

Name Identifier Version Status Registration Time Initialization Time Total Time

==== ========== ======= ====== ================= =================== ==========

BWB

Have a very similar situation, with similar source and target DB versions. Were you able to resolve this issue?

Dezsoe Kados

No, I could not resolve the issue (20.4.1.407 does not solve it either so far I can tell)

BWB

Thanks for the quick update Dezsoe. I have other tools I can use for this comparison, but was trying to make use of tools provided by the client I am supporting.

thatJeffSmith-Oracle

can you reproduce this issue if you say...

create user abc121 ...

connect abc123/...

create or replace package do_nothing....

/

then

create user abc19c ...

connect abc19c/...

create or replace package do_nothing....

/

open Compare wizard, with a connection created for both abc123 and abc19c, compare packages - does the error come up?

In other words, I need a test case.

Jeff

BWB

Jeff, have not done extensive testing, just hit on this error the 1st object attempted to compare, and the scenario is this.

This worked:

2 Oracle EBS Instances, both running on 12.1.0.2.0, and connecting to both instances as apps. Compare a database package body (ottomint.pkb), and successfully see the results.

What did not work:

Source Oracle EBS Instance running on 12.1.0.2.0, and destination connection is on Oracle EBS 19.0.0.0.0. Again connecting to both instances as apps.

When attempting to compare the same DB object (ottomint.pkb) as described above, receive:

Unable to compare objects.

Ensure that you have the required permissions.  

You must own the objects or have select_catalog_role.

I can open this object with the APPS user. As another test, used a different package POR_CUSTOM_PKG, and it worked as expected. Other item to note, there is only 1 difference in the package that did not work between the 2 instances, which is just the version. All code lines match.

/* $Header: ottomint.pkb 120.43.12010000.28 2017/11/20 05:21:54 ramsanth ship $ */

/* $Header: ottomint.pkb 120.58.12020000.16 2017/12/17 10:17:19 ramsanth ship $ */

thatJeffSmith-Oracle

So you're looing in as APPS in both databases for the compare? If so, sounds like a bug.

BWB

Yes, APPS in both instances.

thatJeffSmith-Oracle

if you have access to My Oracle Support, please file an SR. Be sure to tell them we think it may be APPS/eBiz specific.

user4484241

I have the same problem

Database diff or cart diff for one package only gives the error:

Unable to compare objects.

Ensure that you have the required permissions.  

You must own the objects or have select_catalog_role.

Both databases same 19.5 version

User_4HHBW

I' ve got such error for only the tables which have xmltype column.