Instance in Restricted mode
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Instance in Restricted mode

  1. #1
    Join Date
    Oct 2006
    Posts
    18

    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
    Location
    Sofia
    Posts
    630
    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