Sometimes it is necessary to remotely login to a database which is in mounted mode. An example would be when an RMAN duplicate from active database is attempted.
But when an instance has a status of BLOCKED in the listener, what can you do? The listener will not let you in. Of course an static listener could be made, but this is not always something you are willing to do, since the listener process has to bounce. While in a test environment this won’t have to be an issue, in the production…well…let’s just say: there are people losing their jobs over less..
The answer lies in telling the listener it is okay to let privileged users in. Usually those with sysdba privileges.
How? With just one (1!) line in the tnsnames.ora.
The secret line is:
(UR = A)
So, the full config would look like this:
orcl02 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = serverName)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl02) (UR = A) ) )
This will allow remote access when the listener has the status in blocked status. Of course it wouldn’t hurt to have a static listener entry in the listener.ora also.
I hope this helps you guys, it sure helped me out!