DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006

    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
    Get error
    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. ..

  2. #2
    Join Date
    Nov 2006
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.