Forum Stats

  • 3,855,382 Users
  • 2,264,500 Discussions
  • 7,905,981 Comments

Discussions

Categories

Sqldeveloper 20.4 database diff function strange result

Dezsoe Kados
Dezsoe Kados Member Posts: 27 Blue Ribbon
in SQL Developer

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

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

Tagged:
· Share on TwitterShare on Facebook
«1

Answers

  • BWB
    BWB Member Posts: 4 Blue Ribbon

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

    · Share on TwitterShare on Facebook
  • Dezsoe Kados
    Dezsoe Kados Member Posts: 27 Blue Ribbon

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

    · Share on TwitterShare on Facebook
  • BWB
    BWB Member Posts: 4 Blue Ribbon

    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.

    · Share on TwitterShare on Facebook
  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 8,777 Employee

    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

    · Share on TwitterShare on Facebook
  • BWB
    BWB Member Posts: 4 Blue Ribbon

    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 $ */

    · Share on TwitterShare on Facebook
  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 8,777 Employee

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

    · Share on TwitterShare on Facebook
  • BWB
    BWB Member Posts: 4 Blue Ribbon

    Yes, APPS in both instances.

    · Share on TwitterShare on Facebook
  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 8,777 Employee

    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.

    · Share on TwitterShare on Facebook
  • user4484241
    user4484241 Member Posts: 11 Blue Ribbon

    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

    · Share on TwitterShare on Facebook
  • User_4HHBW
    User_4HHBW Member Posts: 7 Red Ribbon

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

    · Share on TwitterShare on Facebook