Monthly Archives: October 2008

kill: (27795) – Operation not permitted

If you want to kill on own your session in Linux. For example: If you login as oracle and your session got hung. [oracle@testbox exports]$ who -uroot tty1 Oct 11 00:24 old 6396oracle pts/0 Oct 30 15:03 00:09 27795 (10.0.0.61)root … Continue reading

Posted in Uncategorized | Leave a comment

How to setup transparent switchover/failover to application and client

Clients transparently connect to whichever node/instance is currently running the primary database in Data Guard environment. 1. Set the below entry to tnsname.ora on both nodes== TEST1 is db_name== show parameter db_name== 102.168.50.15 is host ip address ALL_LISTENERS_TEST1 = (ADDRESS_LIST … Continue reading

Posted in Uncategorized | Leave a comment