1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Listener not working in one of the servers of the Standby si

Discussion in 'General' started by lulon, Oct 30, 2009.

  1. lulon

    lulon Active Member

    Likes Received:
    Trophy Points:

    The system is a RAC with two servers working as Primary site, and two servers working as Standby site.

    Both servers of the Primary site are sending redo logs to one of the servers of the Standby site. The other server of the Standby site is not receiving any redo log.
    I have checked the listener.ora and the tnsnames.ora files of the server that is not receiving and it is well configured comparing it with the server that is receiving the redo logs.

    If I check the status of the listener: lsnrctl status listener_<node name>
    Both of the Standby servers look fine.

    But if I connect directly to the database...

    In VS1a, the IP appears:

    SQL> show parameter listener

    local_listener string (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxxx))
    remote_listener string LISTENERS_VSDB

    Nevertheless, in the second server of the Standby site, the one that is not receiving the redo logs, the IP does not appear:

    SQL> show parameter listener

    local_listener string (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = xxxx))
    remote_listener string LISTENERS_VSDB

    I have found the following to reload the listener:

    Oracle# lsnrctl reload listener_`hostname`
    Oracle# lsnrctl reload listener_standby

    Has anyone tried this? Did it work? It can be run without affecting the sytem, Dataguard, replication..., right?

    If you have another idea to fix this, let me know please.

    Thank you ;)
  2. zargon

    zargon Community Moderator Forum Guru

    Likes Received:
    Trophy Points:
    Aurora, CO
    This appears to be an issue with log_archive_dest_n settings and I suspect that both primary databases are sending the logs to the same standby. Please verify this; post the relevant portions of your init.ora files (or spfiles) for each primary so we can see how you have this system set up.