DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Instance in Restricted mode

  1. 11-03-2006, 10:12 AM #1
    pmaora
    pmaora is offline Junior Member
    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. ..
    Reply With Quote Reply With Quote
  2. 11-03-2006, 10:56 AM #2
    Bore
    Bore is offline Advisor
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width