Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

12.2.0.1 upgrade missing synonyms?

edited Dec 11, 2019 4:00AM in Database Install/Upgrade/Opatch (MOSC) 3 commentsAnswered

I'm working my way through upgrading my 12.1.0.2 databases to 12.2.0.1. We are using redhat linux. I used dbua to do the upgrade.

It should be noted that I removed both the Apex 030200 & apex 040200 users which were in the 12.1 databases.

I have upgraded one database to 12.2.0.1. While testing we discovered that we were missing an synonym which we fixed.

I ran a simple count sql to get counts for production and the db I upgraded. (select count (*) from dba_synonyms;)

BNRPROD 47,091 BNRDEV 21,541 missing 25,550 synonyms!

Then I ran:      select owner, count(*) from all_synonyms group by owner;  and compared the results.

Most of the counts were equal or close.  SYS in development was missing the following synonyms:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center