Tuesday, 22 August 2017

Linux command's for DBA's

findout number of user process
[sreenidba@sreenidba ~]$ ps -ef|grep sreenidba|wc -l
456
[sreenidba@sreenidba ~]$ ps -ef|grep sreenidba|wc -l
266
[sreenidba@sreenidba ~]$
find the disk space
[root@sreenidba ~]# df -h
Filesystem                         Size  Used Avail Use% Mounted on
sreeni/sda2                           25G   17G  7.0G  71% /
tmpfs                               32G  283M   32G   1% sreeni/shm
sreeni/sda1                          788M   46M  702M   7% /boot
sreeni/sda6                          6.9G  224M  6.4G   4% /tmp
sreeni/sda5                           15G  5.9G  8.3G  42% /usr
sreeni/sda7                          487G  327G  137G  71% /d03
sreeni/sreenidba                   1.6T  1.2T  309G  80% /d01
sreeni/sreenidba                   591G  268G  293G  48% /d02
sreeni/sreenidba                     345G  177G  151G  55% /ProdApp
192.168.145.81:/home/ftve0148/H2H   17G  8.5G  7.3G  54% /CE
[root@sreenidba ~]#

Find server performance every 5 seconds 5 times using sar command
[root@sreenidba ~]# sar 5 5
Linux 2.6.32-431.el6.x86_64 (sreenidb01.ltindia.com)   08/21/2017      _x86_64_        (8 CPU)

01:49:39 AM     CPU     %user     %nice   %system   %iowait    %steal     %idle
01:49:44 AM     all      1.03      0.00      0.23      0.08      0.00     98.67
01:49:49 AM     all      2.76      0.00      1.18      0.10      0.00     95.96
01:49:54 AM     all      0.68      0.00      0.30      0.05      0.00     98.97
01:49:59 AM     all      4.02      0.00      0.60      0.13      0.00     95.25
01:50:04 AM     all      5.52      0.00      1.08      0.33      0.00     93.07
Average:        all      2.80      0.00      0.68      0.14      0.00     96.38
[root@sreenidba ~]#

top command
[root@sreenidba ~]#top
top - 01:51:14 up 46 days, 49 min,  2 users,  load average: 0.90, 0.70, 0.83
Tasks: 1032 total,   2 running, 1029 sleeping,   0 stopped,   1 zombie
Cpu(s):  6.2%us,  1.0%sy,  0.0%ni, 90.1%id,  2.7%wa,  0.0%hi,  0.1%si,  0.0%st
Mem:  65863632k total, 65171192k used,   692440k free,   717556k buffers
Swap: 16777208k total,    42268k used, 16734940k free, 49945532k cached

   PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
126620 sreenidba   20   0 20.2g 184m 177m R 98.4  0.3   0:00.86 oracle
123032 sreenidba  20   0 91208  45m  14m S 11.6  0.1   0:46.46 frmweb
126090 sreenidba  20   0 1437m 537m  10m S  7.7  0.8  19:18.66 java
118425 sreenidba   20   0 20.2g 199m 190m S  5.8  0.3   0:01.26 oracle
123040 sreenidba   20   0 20.3g 642m 633m S  3.9  1.0   0:11.96 oracle
126930 root      20   0 15700 1880  836 R  3.9  0.0   0:00.02 top
115545 sreenidba   20   0 20.2g 113m 105m S  1.9  0.2   0:00.33 oracle
119527 sreenidba   20   0 20.2g  61m  56m S  1.9  0.1   0:00.15 oracle
125659 sreenidba   20   0 20.2g  35m  32m S  1.9  0.1  13:20.40 oracle
127227 sreenidba  20   0  719m 179m 7848 S  1.9  0.3   8:05.95 java
127493 sreenidba  20   0 23692  11m 5492 S  1.9  0.0   2:02.28 FNDLIBR
127527 sreenidba  20   0 23928  11m 5484 S  1.9  0.0   2:01.91 FNDLIBR
     1 root      20   0 19356 1536 1228 S  0.0  0.0  11:10.52 init
     2 root      20   0     0    0    0 S  0.0  0.0   0:01.64 kthreadd
     3 root      RT   0     0    0    0 S  0.0  0.0   0:30.14 migration/0
     4 root      20   0     0    0    0 S  0.0  0.0   4:26.00 ksoftirqd/0
     5 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/0
     6 root      RT   0     0    0    0 S  0.0  0.0   0:02.17 watchdog/0
     7 root      RT   0     0    0    0 S  0.0  0.0   0:03.07 migration/1
SCP command
copying tarfile (apps.tar) from production.
scp -r 192.168.137.89: /App/appsbkp/apps.tar ./ à(command Execute in dest server only ).

tar command:
tar the apps directory using below command
tar –cvzf /ProdApp/appsbkp/apps.tar apps
for untar using below
tar –xvzf /ProdApp/appsbkp/apps.tar apps
Mounting files from one server to another server uning mount command
mount -t nfs 192.168.137.89:/d03/BACKUP_OLD/prodbackup_1417 /d02/prodbackup -o hard,rw,noac,rsize=32768,wsize=32768,suid,bg,proto=tcp,vers=3
Findout server information using below commands:
[root@sreenidba ~]# cat /proc/cpuinfo
processor       : 0
vendor_id       : GenuineIntel
cpu family      : 6
model           : 23
model name      : Intel(R) Xeon(R) CPU           E5430  @ 2.66GHz
stepping        : 6
cpu MHz         : 2660.053
cache size      : 6144 KB
physical id     : 0
siblings        : 4
core id         : 0
cpu cores       : 4
apicid          : 0
initial apicid  : 0
fpu             : yes
fpu_exception   : yes

cache_alignment : 64
address sizes   : 38 bits physical, 48 bits virtual
power management:

processor       : 1
vendor_id       : GenuineIntel
cpu family      : 6
model           : 23
model name      : Intel(R) Xeon(R) CPU           E5430  @ 2.66GHz
stepping        : 6
cpu MHz         : 2660.053
cache size      : 6144 KB
physical id     : 0
siblings        : 4
core id         : 1
cpu cores       : 4
apicid          : 1
initial apicid  : 1
fpu             : yes
fpu_exception   : yes
cpuid level     : 10
wp              : yes
clflush size    : 64
cache_alignment : 64
address sizes   : 38 bits physical, 48 bits virtual
power management:

processor       : 2
vendor_id       : GenuineIntel
cpu family      : 6
model           : 23
model name      : Intel(R) Xeon(R) CPU           E5430  @ 2.66GHz
stepping        : 6
cpu MHz         : 2660.053
cache size      : 6144 KB
physical id     : 0
siblings        : 4
core id         : 2
cpu cores       : 4
apicid          : 2
initial apicid  : 2
fpu             : yes
fpu_exception   : yes
cpuid level     : 10
wp              : yes
processor       : 3
vendor_id       : GenuineIntel
cpu family      : 6
model           : 23
model name      : Intel(R) Xeon(R) CPU           E5430  @ 2.66GHz
stepping        : 6
cpu MHz         : 2660.053
cache size      : 6144 KB
physical id     : 0
siblings        : 4
core id         : 3
cpu cores       : 4
apicid          : 3
initial apicid  : 3
fpu             : yes
fcx16 xtpr pdcm dca sse4_1 lahf_lm dts tpr_shadow vnmi flexpriority
bogomips        : 5320.10
clflush size    : 64
cache_alignment : 64
address sizes   : 38 bits physical, 48 bits virtual
power management:

[root@sreenidba ~]#
findout memory information
[root@sreenidba ~]# cat /proc/meminfo
MemTotal:       32878880 kB
MemFree:          751404 kB
Buffers:          788148 kB
Cached:         24819976 kB
SwapCached:       264352 kB
Active:         17300548 kB
Inactive:       12643340 kB
Active(anon):    5159516 kB
Inactive(anon):  1048964 kB
Active(file):   12141032 kB
Inactive(file): 11594376 kB
Unevictable:           0 kB
Mlocked:               0 kB
[root@sreenidba ~]#
Find the server 32bit or 64bit using uname command
[root@sreenidba ~]# uname -i
x86_64
[root@sreenidba ~]# uname -a
Linux sreeni.ltindia.com 2.6.32-431.el6.x86_64 #1 SMP Sun Nov 10 22:19:54 EST 2013 x86_64 x86_64 x86_64 GNU/Linux
[root@sreenidba ~]#
[root@sreenidba ~]# uname -r
2.6.32-431.el6.x86_64
[root@sreenidba ~]# uname -i
x86_64
[root@sreenidba ~]# uname
Linux
[root@sreenidba ~]# hostname -i
192.162.177.99
[root@sreenidba ~]# hostname
sreeni.ltindia.com
[root@sreenidba ~]#

find the linux version
[root@sreenidba ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.5 (Santiago)

[root@sreenidba ~]#
(or)
[root@sreenidba ~]# tail /etc/redhat-release
Red Hat Enterprise Linux Server release 6.5 (Santiago)
[root@sreenidba ~]#
References:
---------------------
Oracle Applications Release Notes, Release 12.1.1 ( Doc ID 798258.1 )
Oracle E-Business Suite Release 12 Installation Guidelines ( Doc ID 405565.1 )
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86 ( Doc ID 761564.1 )

No comments:

Post a Comment

How to change Apps Password in R12.1

  /* CHANGE APPLICATION USER PASSWORD USING FNDCPASS*/ FNDCPASS apps/APPS_PASSWORD 0 Y system/SYSTEM_PASSWORD USER USER_WHOSE_PASSWORD_WILL_...