Thursday, July 3, 2014

Configuring SCAN and local listener for Active/Passive 11gr2 Oracle Grid Infrastructure cluster

  1. Create cluster
    • https://blogs.oracle.com/xpsoluxdb/entry/clusterware_11gr2_setting_up_an_activepassive_failover_configuration
    • http://gjilevski.com/2012/01/09/build-active-passive-ha-configuration-for-single-instance-database-with-oracle-gi-11-2-0-3/
    • http://mathijsbruggink.wordpress.com/2013/07/04/thoughts-on-adding-a-single-instance-to-oracle-clusterware-grid-infra/#more-308
  2. Open firewall ports to application servers (if needed)
    • I opened firewall ports to default TCP-1521 and to non-default port as my SCAN address was running on non-default port. 
  3. Create TNS-entries for Database
    • set SCAN-address as the hostname, use FQDN -name
  4. Register scan address as remote_listener
  5. Register local hostname as local_listener
    • some servers can't understand 'localhost' so I used the servers real name e.g. dbserver-01.domain.fi
    • there's an issue with this. Because active-passive cluster can failover, you must ensure that the the local_listener value is updated during failover in the ActionScript
  6. Check output by 'lsnrctl services' from Database home, not GRID home.
You don't need to touch VIP-addresses at any point.

No comments:

Post a Comment