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
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