Config DNS on OEL5,REHL5

Step1: setup static IP for DNS server #system-config-network
Step2: Install DNS package by yum a)install pakages # yum install bind-libs bind bind-utils b)install GUI DNS editor # yum install bind-libs bind bind-utils
Step3: Create Default config file by system-config-bind #system-config-bind after click various ok we can exit.

Step4: Config server network parameter
a) config hostname, modify content of /etc/sysconfig/network as below
#vi /etc/sysconfig/network
hostname=serapp.gms.com
b) config /etc/resolv.conf file:
#vi /etc/resolv.conf
search prasanna.com
nameserver 192.168.10.60
c) config /etc/hosts file:
#vi /etc/hosts
192.168.10.60 svrapp.gms.com svrapp
Step5: Modify /etc/named.conf follow: #vi named.conf
//start modify
option{
    directory "/var/named";
    dump-file "/var/named/data/cache_dump.db";
    statistics-file "/var/named/data/named_stats.txt";
    listen-on pot 53{127.0.0.1; 192.168.0.254;};
    };
//end modify
//-----------------------------
//start add
zone "gms.com" IN {
    type master;
    file "for.gms.com";
    allow-update { none; };
};
zone "10.168.192.in-addr.arpa." IN {
    type master;
    file "rev.gms.com";
    allow-update { none; };
};
//end add

Step 6: Create of Edit file for.gms.com and rev.gms.com in location /var/named
a) Create or edit for.gms.com: vi /var/named/for.gms.com
$TTL 86400
@ IN SOA srvapp.gms.com. root.srvapp.gms.com. (
    42 ; serial (d. adams)
    3H ; refresh
    15M ; retry
    1W ; expiry
    1D ) ; minimum
    IN NS localhost
localhost IN A 127.0.0.1
ol6-112-rac1 IN A 192.168.10.41
ol6-112-rac2 IN A 192.168.10.42
ol6-112-rac1-priv IN A 192.168.8.41
ol6-112-rac2-priv IN A 192.168.8.42
ol6-112-rac1-vip IN A 192.168.10.43
ol6-112-rac2-vip IN A 192.168.10.44
ol6-112-rac-scan IN A 192.168.10.45
ol6-112-rac-scan IN A 192.168.10.46
ol6-112-rac-scan IN A 192.168.10.47

b) Create or edit rev.gms.com:
$TTL 86400
@ IN SOA srvapp.gms.com. root.srvapp.gms.com. (
         42 ; Serial
         28800 ; Refresh
         14400 ; Retry
         3600000 ; Expire
         86400 ) ; Minimum
     IN NS localhost.
1 IN PTR localhost.
41 IN PTR ol6-112-rac1.gms.com.
42 IN PTR ol6-112-rac2.gms.com.
43 IN PTR ol6-112-rac1-vip.gms.com.
44 IN PTR ol6-112-rac2-vip.gms.com.
45 IN PTR ol6-112-rac-scan.gms.com.
46 IN PTR ol6-112-rac-scan.gms.com.
47 IN PTR ol6-112-rac-scan.gms.com.

Step 7: Start DNS service
service named restart
chkconfig named on Step 8: Configuration in Client
Client side: in station1.prasanna.com
just touch these files with the existing details
#vi /etc/resolv.conf
search gms.com
nameserver 192.168.10.60
#vi /etc/hosts
192.168.10.60 svrapp.gms.com
192.168.10.41 ol6-112-rac1.gms.com
Step 9: Test
# nslookup ol6-112-rac-scan.localdomain
Server: 192.168.10.60
Address: 192.168.10.60#53
Name: ol6-112-rac-scan.localdomain
Address: 192.168.0.121
Name: ol6-112-rac-scan.localdomain
Address: 192.168.0.122
Name: ol6-112-rac-scan.localdomain
Address: 192.168.0.123

# nslookup 192.168.10.45
Server: 192.168.10.60
Address: 192.168.10.60#53

45.10.168.192.in-addr.arpa name = ol6-112-rac-scan.localdomain.

# nslookup 192.168.10.46
Server: 192.168.10.60
Address: 192.168.10.60#53

46.10.168.192.in-addr.arpa name = ol6-112-rac-scan.localdomain.

# nslookup 192.168.10.47
Server: 192.168.10.60
Address: 192.168.10.60#53

47.10.168.192.in-addr.arpa name = ol6-112-rac-scan.localdomain.

#

lock session and kill log session in oracle database (single node)

1) check information of lock object in oracle database, we need run command below:
select a.session_id,
c.SERIAL#,
a.oracle_username,
a.os_user_name,
b.owner "OBJECT OWNER",
b.object_name,
b.object_type,
a.locked_mode
from (select object_id,
SESSION_ID,
ORACLE_USERNAME,
OS_USER_NAME,
LOCKED_MODE
from v$locked_object) a,
(select object_id, owner, object_name, object_type from dba_objects) b,
v$session c
where a.object_id = b.object_id
and a.session_id=c.SID;
2) kill session show in result above with command:
ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;