Home » RDBMS Server » Server Administration » ORA-12526
ORA-12526 [message #201311] Fri, 03 November 2006 08:10 Go to next message
Messages: 16
Registered: October 2006
Junior Member
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 network or using service names 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. ..
Re: ORA-12526 [message #201371 is a reply to message #201311] Fri, 03 November 2006 14:37 Go to previous message
Messages: 25579
Registered: January 2009
Location: SoCal
Senior Member
12526, 00000, "TNS:listener: all appropriate instances are in restricted mode"
// *Cause: Database instances supporting the service requested by the client
// were in restricted mode. The Listener does not allow connections to
// instances in restricted mode. This condition may be temporary, such as
// during periods when database administration is performed.
// *Action: Attempt the connection again. If error persists, then contact
// the database administrator to change the mode of the instance,
// if appropriate.
Previous Topic: Help with Unix/Oracle script.
Next Topic: Oracle job problem while bringing online - Oracle
Goto Forum:

Current Time: Wed Aug 23 12:44:35 CDT 2017

Total time taken to generate the page: 0.01251 seconds