Local listener configred on standby when it is outside cluster.

Local listener configred on standby when it is outside cluster.

===================================================================



#



LISTENER_bol1p =

  (ADDRESS_LIST=

    (ADDRESS=

      (PROTOCOL=IPC)

      (KEY=bol1p)

    )

    (ADDRESS=

      (PROTOCOL=IPC)

      (KEY=bol1p)

    )

    (ADDRESS=

      (PROTOCOL=TCP)

      (Host=bol1p.na.xyz.com)

      (Port=1521)

    )

    (ADDRESS=

      (PROTOCOL=TCP)

      (Host=bol1p.na.xyz.com)

      (Port=1526)

    )

  )



SID_LIST_LISTENER_bol1p =

  (SID_LIST=

    (SID_DESC=

      (SID_NAME=bol1p)

      (ORACLE_HOME=E:\Oracle\ORA11204GDR)

    )

  )



CONNECT_TIMEOUT_LISTENER_bol1p = 10

TRACE_LEVEL_LISTENER_bol1p = 0

STARTUP_WAIT_TIME_LISTENER_bol1p = 0







if it inside cluster



+++++++++++++++++++++++++++++++++++++++++++++++++++





Fslusvv920 =

  (ADDRESS_LIST=

    (ADDRESS=

      (PROTOCOL=IPC)

      (KEY=bol1p)

    )

    (ADDRESS=

      (PROTOCOL=IPC)

      (KEY=bol1p_USEAR920.WORLD)

    )

    (ADDRESS=

      (PROTOCOL=TCP)

      (Host=129.225.12.114)

      (Port=1521)

    )

    (ADDRESS=

      (PROTOCOL=TCP)

      (Host=129.225.12.114)

      (Port=1526)

    )

  )



SID_LIST_Fslusvv920 =

  (SID_LIST=

    (SID_DESC=

      (SID_NAME=bol1p)

      (ORACLE_HOME=E:\Oracle\ORA11204R)

    )

  )



CONNECT_TIMEOUT_Fslusea20 = 10

TRACE_LEVEL_Fslusear920 = 0

STARTUP_WAIT_TIME_Fslusear920 = 0









Tns names.ora



===============







bol1p_USEA920.WORLD =

  (DESCRIPTION=

    (ADDRESS_LIST=

      (ADDRESS=

        (PROTOCOL=TCP)

        (Host=129.225.80.114)

        (Port=1521)

      )

    )

    (CONNECT_DATA=

      (SID=bol1p)

    )

  )





bol1p_USEAIHV771 =

  (DESCRIPTION =

    (FAILOVER=ON)

    (ADDRESS_LIST =

      (ADDRESS =

        (PROTOCOL = TCP)

        (HOST = 192.61.113.36)

        (PORT = 1521)

      )

      (ADDRESS =

        (PROTOCOL = TCP)

        (HOST = 192.61.113.36)

        (PORT = 1526)

      )

    )

    (CONNECT_DATA =

      (SID = bol1p)

    )

  )

bol1p.WORLD =

  (DESCRIPTION=

    (ADDRESS_LIST=

      (ADDRESS=

        (PROTOCOL=TCP)

        (Host=129.225.80.114)

        (Port=1521)

      )

      (ADDRESS=

        (PROTOCOL=TCP)

        (Host=129.225.80.114)

        (Port=1526)

      )

    )

    (CONNECT_DATA=

      (SID=bol1p)

    )

  )

bol1p_USEAIHV771.WORLD =

  (DESCRIPTION =

    (FAILOVER=ON)

    (ADDRESS_LIST =

      (ADDRESS =

        (PROTOCOL = TCP)

        (HOST = 192.61.113.36)

        (PORT = 1521)

      )

      (ADDRESS =

        (PROTOCOL = TCP)

        (HOST = 192.61.113.36)

        (PORT = 1526)

      )

    )

    (CONNECT_DATA =

      (SID = bol1p)

    )

  )



real_prod_bol1p.world =

  (DESCRIPTION =

    (FAILOVER=ON)

    (ADDRESS_LIST =

      (ADDRESS =

        (PROTOCOL = TCP)

        (HOST = 192.61.113.36)

        (PORT = 1521)

      )

      (ADDRESS =

        (PROTOCOL = TCP)

        (HOST = 192.61.113.36)

        (PORT = 1526)

      )

    )

    (CONNECT_DATA =

      (SID = bol1p)

    )

  )

bol1p =

  (DESCRIPTION=

    (ADDRESS_LIST=

      (ADDRESS=

        (PROTOCOL=TCP)

        (Host=129.225.80.114)

        (Port=1521)

      )

      (ADDRESS=

        (PROTOCOL=TCP)

        (Host=129.225.80.114)

        (Port=1526)

      )

    )

    (CONNECT_DATA=

      (SID=bol1p)

    )

  )





======================================================================



ih 180 check the bol1p production and standby entry







grep -i bol1p tnsnames.ora



:/unnbo1p  enter



N









standby entry





STANDBY_bol1p =

   (DESCRIPTION =

     (FAILOVER=ON)

     (ADDRESS_LIST =

       (ADDRESS = (PROTOCOL = TCP)(HOST = 129.225.80.114)(PORT = 1521))

       (ADDRESS = (PROTOCOL = TCP)(HOST = 129.225.80.114)(PORT = 1526))

     )

     (CONNECT_DATA =

       (SID = bol1p)

     )

)







129.225.80.114 is the entry of cluster listener of standby





production entry



bol1p =

   (DESCRIPTION =

     (FAILOVER=ON)

     (ADDRESS_LIST =

       (ADDRESS = (PROTOCOL = TCP)(HOST = bol1p.na.uis.unisys.com)(PORT = 1521))

       (ADDRESS = (PROTOCOL = TCP)(HOST = bol1p.na.uis.unisys.com)(PORT = 1526))

     )

     (CONNECT_DATA =

       (SID = bol1p)

     )

   )







bol1p.na.uis.unisys.com refer to 129.225.113.36









listener entry of standby inside the cluster.



====================================================



#

# This file is written by Oracle Services For MSCS

# on Wed Oct 21 16:43:36 2015

#





FslUSEA920 =

  (ADDRESS_LIST=

    (ADDRESS=

      (PROTOCOL=IPC)

      (KEY=bol1p)

    )

    (ADDRESS=

      (PROTOCOL=IPC)

      (KEY=bol1p_USEA920.WORLD)

    )

    (ADDRESS=

      (PROTOCOL=TCP)

      (Host=129.225.80.114)

      (Port=1521)

    )

    (ADDRESS=

      (PROTOCOL=TCP)

      (Host=129.225.80.114)

      (Port=1526)

    )

  )



SID_LIST_FslUSEA920 =

  (SID_LIST=

    (SID_DESC=

      (SID_NAME=bol1p)

      (ORACLE_HOME=E:\Oracle\ORA11204GDR)

    )

  )



CONNECT_TIMEOUT_FslUSEA920 = 10

TRACE_LEVEL_FslUSEA920 = 0

STARTUP_WAIT_TIME_FslUSEA920 = 0







====================================================================================