Tuesday, December 24, 2013

Oracle Database -- Connecting Remotely to a Restrcted Database


You are trying to connect remotely to a database which is opened in the restricted mode. You get error:

ORA-12526: TNS:listener: all appropriate instances are in restricted mode


Add UR=A to your TNS entry. For example,


No comments: