Friday 16 December 2011
Wednesday 14 December 2011
kill blocking session from database
FATAL] [INS-40912] Virtual host name: racnode02-vip is assigned to another system on the network
Error while re-adding deleted cluster node to cluster
[grid@racnode01 addnode]$ ./addnode.sh -silent "CLUSTER_NEW_NODES={racnode02}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={racnode02-vip}" "CLUSTER_NEW_NODE_ROLES={hub}"
[FATAL] [INS-40912] Virtual host name: racnode02-vip is assigned to another system on the network.
CAUSE: One or more virtual host names appeared to be assigned to another system on the network.
ACTION: Ensure that the virtual host names assigned to each of the nodes in the cluster are not currently in use, and the IP addresses are registered to the domain name you want to use as the virtual host name.
2. Virtual IP's should NOT be pingable before the installation of the Grid Infrastructure.
#ping racnode02-vip
PING racnode02-vip.com (aaa.aa.aa.17) 56(84) bytes of data.
64 bytes from racnode02-vip.com(aaa.aa.aa.17):icmp_seq=1 ttl=64 time=0.067 ms
64 bytes from racnode02-vip.com(aaa.aa.aa.17):icmp_seq=2 ttl=64 time=0.156 ms
I’m able to ping node2 VIP, Looks something wrong
- Verified /etc/hosts file on all cluster nodes ,vip details not added
- Check network configuration with ifconfig
root@racnode01~ # ifconfig -a | grep aaa.aa.aa.17
inet aaa.aa.aa.17 netmask 255.255.254.0 broadcast aaa.aa.aa.255
bond0:5: flags=5187<UP,BROADCAST,RUNNING,MASTER,MULTICAST> mtu 1500
inet aaa.aa.aa.17 netmask 255.255.254.0 broadcast aaa.aa.aa.255
ether 00:aa:b3:00:02:2f txqueuelen 1000 (Ethernet)
3. Alias was created for NIC interface with the use of the virtual IP (during previous installation)
Brought down interface
ifconfig bond0:5 down
Recover a deleted datafile on linux using symbolic link when database is up
lrwx------ 1 oracle oinstall 64 Aug 28 21:45 /proc/4488/fd/27 -> /u01/app/oracle/oradata/demo01.dbf (deleted)
Tablespace altered.
Tuesday 13 December 2011
Activate Physical Standby Database
Login to Standby database and run below commands
SQL> select database_role,open_mode,name from gv$database;
DATABASE_ROLE OPEN_MODE NAME
---------------- -------------------- ---------
PRIMARY READ ONLY WITH APPLY TSTSTDBY
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;
Database altered.
SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE;
Database altered.
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
MOUNTED
SQL> select database_role,open_mode,name from gv$database;
DATABASE_ROLE OPEN_MODE NAME
---------------- -------------------- ---------
PRIMARY MOUNTED TSTSTDBY
SQL> alter database open;
Database altered.
SQL> select database_role,open_mode,name from gv$database;
DATABASE_ROLE OPEN_MODE NAME
---------------- -------------------- ---------
PRIMARY READ WRITE TSTSTDBY