Friday, December 22, 2017

Unix for DBA

Unix for the DBA

1) How many Oracle instances running on OS
ps -aef | grep pmon

2) Seting unix Prompt.
export PS1="`hostname`:$ORACLE_SID:$PWD>"

3) Useful commands in Aix/Linux/Solaris.




Category
AIX
LINUX
Solaris
CPU
vmstat 1, prtconf,   lsdev -Cc processor
cat /proc/cpuinfo
psrinfo -v
RAM
prtconf
free -m
prtconf | head -3 |grep Mem
Swap
lsps -a
free -m
swap -l
RPM/Package Installation Check
lslpp -L | grep <package name>
rpm -qa
pkginfo
Error logs
alog -o -t boot, errpt
dmesg
dmesg
Performance monitor
topas, nmon
top
top
Network parameters
no -a
sysctl -a | grep net
ndd /dev/[tcp|ip]
List physical volume
lspv
pvdisplay
vxprint -dl
List logical volume
lslv
lvdisplay
vxprint -vl
Startup script
/etc/rc
/etc/rc.d/rc
/etc/init.d
Kernel Parameters
lsattr -E -l sys0
sysctl -a
sysdef -i

No comments: