Instance in Restricted mode
Created database from cold backup.The data files were moved from a previous release . I had to open the database with the upgrade option. Now can not connect to it over netwrok or using servicenames locally too
ORA-12526 :TNS LISTENER : all appropriate instances are in restricted mode
lsnrctl status shows
Instance "xxx", status RESTRICTED, has 2 handler(s) for this service..
How can I take this instance out of restricted mode. ..
Normally when you finish the upgrade, you should shutdown the instance and start it without the upgrade option.
It is not normal to operate the database in upgrade mode
Click Here to Expand Forum to Full Width