| ORA-12526 [message #201311] |
Fri, 03 November 2006 08:10  |
pmaora
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  |
 |
BlackSwan
Messages: 26766
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
