Friday 10 July 2015

Configure DBConsole as Active/passive

Sometimes Database Configured as Active/Passive ( Cluster ) Which mean one node working/time and regarding to this if the failover happened on 2nd node the customer will expected that everything will be the same as it was on node 1 include to this Dbconsole.

To do this follow the below steps :-


    Database should be configured on VIP.
    Listener should be configured on VIP.
    Database , Configuration should be installed on Shared Storage
    inventory Files should be on shared storage as well.
    ORACLE_HOSTNAME Should be set to VIP Hostname.


Listener example :-


    LISTENER  =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = VIP-HOST )(PORT = 1521))
    )

Don't forget to set the LOCAL_LISTENER Parameter :-

    SQL> alter system set local_listener='LISTENER';


Or

    SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = VIP-HOST )(PORT = 1521)) ';

Now

    export ORACLE_HOSTNAME=VIP-HOSTNAME
    emca -config dbcontrol db -repos create


Test the failover on node #2

if for some reason when you try to start emctl and the error still asking for oc4j then export ORACLE_HOSTNAME is bash_profile.


Thanks.
NJ

No comments:

Post a Comment