Right way to drop the AWR is not catnoawr.sql. It’s documented 436386.1.
Incase ifyou have dropped awr one way to bring it back is catsvrm.sql. Flush the shared pool before that.
Dropping the AWR using catnoawr might have deleted row from WRM$_DATABASE_INSTANCE, restarting the instance will populate the data in this table.
Pls test this in test environment.
convert this post to pdf.