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