How to configure the standby database listener and naming service?

How to configure the standby database listener and naming service?

How to Configure the Standby Database Listener and Naming Service Create a static listener for Oracle Data Guard. Restart the listener. Verify the net service naming entries for all database instances. Verify that the standby listener listener.ora and tnsnames.ora files have the correct entries, and restart the listener process.

Why is the listener to the database blocked?

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.

Why is the standby listener blocked in RMAN?

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? A NOMOUNT instance stays in BLOCKED status with dynamic registration.

What to do if Oracle listener is not configured?

In one customer’s specific case, the Oracle server’s listener was not configured correctly. Ask Oracle DBA to check the Oracle server, to solve connection problem. NOTE: Oracle is a third party (non-IBM) piece of software. IBM cannot give any official advice on third-party (non-IBM) products.

What to do if database listener failed to start?

If it doesn’t then look at the output of lsnrctl status and see if anything is registered, or look in $ORACLE_HOME/dbs – files in there might include the SID in their names too. You might also need to export ORACLE_HOME if you haven’t already, but it sounds like you have, probably from your .profile / .bashrc etc.

Where do I find the Oracle Data Guard listener file?

Ensure that these files include the static Oracle Data Guard listener entry and the naming service entries for the primary and standby cluster database service. If you are not using the Oracle directory naming service lookup, you need to include the entries in tnsnames.ora.

What does ora-12162 mean in database listener?

ORA-12162 usually means you don’t have ORACLE_SID set – not that it’s wrong, but it hasn’t been set at all, or has not been exported (depending on your shell). That doesn’t tell you anything about whether the database is up, and doesn’t imply the listener is down – so don’t know if you got a different message from a different connection attempt.