We have recently renamed a number of databases. In those databases, I can no longer generate AWR reports from SQL Developer. I have confirmed this to be the case in both 19.2.1 and 19.4 of SQL Developer.
AWR snapshots are being captured and I can view via TOAD and/or generate command line. Would like to be able to visually generate from within SQL Developer. Appreciate any and all suggestions/advice.
Within SQL Developer it is able to show/confirm that AWR snapshots are being captured.
The database was renamed from PSHRPRJ to PSHRUSIT and this new name of the database does not appear as a database when browsing on the snapshot page.
I tried selecting the old name PSHRPRJ and as expected no snapshots are available to select. All Database IDs show no snapshots available but only in SQL Developer. Even though the 1st screen shot clearly shows that snapshots are being generated.
From within TOAD, I can select PSHRUSIT which has the same dbid as the prior name PSHRPRJ.
We have only 1 database with this DBID which is this one which was simply renamed. RMAN and other tools are working fine and it hasn't been the practice of our db group to generated a new DBID.
Seems that SQL Developer is having issues with retaining the original DBID for the renamed database.
Without generating a new DBID, is there anything I can do to be able to generate AWR reports in a renamed database from SQL Developer 19.4?
Thanks in advance
Jonathan