0

I'm deploying a 12C dataguard on oracle. When performing all procedures, start the instance in the standby, as nomount. I noticed that the standby listener is as BLOCKED status, making it impossible for connections in the database to make Duplicate through rman, it does not allow because of the blocked status of the listener.

Can someone help me?

1

A NOMOUNT instance stays in BLOCKED status with dynamic registration. You need to use static registration to connect a NOMOUNT instance remotely.

Add the below to listener.ora and restart the listener:

SID_LIST_LISTENER=
(SID_LIST=
 (SID_DESC=
  (GLOBAL_DBNAME=ORCL)
  (SID_NAME=ORCL)
  (ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1)
 )
)

Of course, change the values of variables accordingly to your environment.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.