Remote connection to database in mounted state..Or: “Lemme in!!!”

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!

Advertisements

About GemsOfProgramming

Beeing a previously enthusiastic Java programmer, I rolled into the Oracle Database Administration world. It turned out I got a knack for this, and since approx. 2000 I'm a full time DBA. My experiences touches lot of Oracle products like Forms and Reports 9/10, JDAPI, Application Server, Weblogic Fusion and of course: Oracle Enterprise Databases, JavaFX, Swing and other Java components.
This entry was posted in Databases. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s