12.2.0.1 upgrade missing synonyms?
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: