A database administrator (short form DBA) is a person responsible for the installation, configuration, upgrade, administration, monitoring and maintenance of databases in an organization.
The role includes the development and design of database strategies, system monitoring and improving database performance and capacity, and planning for future expansion requirements.
Friday, 8 April 2016
How to Resolve Virtual IP (VIP) OFFLINE in Oracle Real Application Clusters (RAC) 11gR2?
We have 2 Node Cluster server running on Production , Network team planed and successfully changed subnet mask from 255.255.x.x to 255.252.x.x .. suddenly node 1 is went down after changed changed subnet mask.
I checked in cluster statues all the services are up and running but VIP is stopped .
1 OFFLINE INTERMEDIATE netdb02 FAILED OVER
after stop and started nodeapps no luck. [oracle@netdb01 ~]$ srvctl config nodeapps -n netdb01 -a -n <node_name> option has been deprecated.Network exists: 1/10.130.246.0/255.255.255.0/eth0, type staticVIP exists: /netdb01-vip/10.130.246.65/10.130.246.0/255.255.255.0/eth0, hosting node netdb01i can see old netmask ip configured in database level. #srvctl modify nodeapps -n netdb01 -A 10.130.246.61/255.255.252.0/eth0
after modified netmask ip tried to start nodeapps it is successfully started and come in ONLINE. ora.netdb01.vip 1 ONLINE ONLINE netdb01 please check and revert.