Advertisements
DBA Unix commands
| symbol is for combine and filter the results like we use in Power Shell pipe out.
R is for recursive & grep command is used to search text
ps -ef |grep pmon – Get the running user process.
ps -ef |grep smon – Get the running user process.
Disk related commands:
# df -h {-m,-k} -- Disk free
# du -h /opt -- Disk usage for Particular mount point disk
# pwd -present working directory
# cd /opt - change directory
# ls - list the files and folders
-l -long list like a windows properties
-lt - long list with time
-ltr - long list in reverse time
-ltra - it will show the hidden files (. files are hidden)
Security related commands
#chmod 776 abc.txts- Change permission
# chown oracle:Oinstall /opt/abc.txt - Change ownership
# chown -R oracle:Oinstall /opt/folder - Change ownership for all files by recursive -Rs
# cat /etc/group - to find the group names
# groupadd Oinstall - to create a group
# groupdel Oinstall - to delete a group
# cat /etc/passwd - to find a user
# useradd -g Oinstall -G oinstall Oracle - To add a user (It's primary & secondary group)
# userdel Oracle - to delete a user
# passwd oracle - to change password
Copy and cut related commands
# cat >abc.txt - file creation # cat >> abc.txt - Append a file (ctrl+ d is for save & c is without save) # cat abc.txt - read a file # vi abc.txt - to read and modify file (It's a virtual editor) press i for insert and esc :wq for save & esc :q for without save & ! is for forcing (esc :wq!) backspace is one word delete and esc+dd is for enter line delete. # head -3 abc.txt - To read first top 3 # tail -3 abc.txt - To read last top 3 # head -6 abc.txt | tail -3 - to read intermediate # cp /opt/abc.txt /data/xyz.txt - To copy a files # cp -r /opt/*.txt /data/ - To copy multiple a files -r # mv /opt/abc.txt /data/ - To cut and paste a files # rm /opt/abc.txt - to remove the file # rm -fr /opt/*.txt - to remove multiple files # ln /opt/abc.txt /data/xyz.txt - to link a file (It will automatically reflect the changes ) # mkdir /Oracle - create a folder # mkdir -p /Oracle/product/11.2.0 - create a folder with subfolders -p
Search related commands
# find /opt -name ''abc.txt'' - it will search the name # find . -name ''abc.txt'' - it will search all the file system (.) # ps -ef - it will show all process (ef is for all) # ps -ef |grep ora # ps -ef |grep pmon - it will show the running DBs # cat /etc/oratab - will show al the DBs including stopped one.
General commands
# mount /dev/cdrom /mnt - to mount the CD # umount /mnt - to un mount # eject - to come out of it # id - will show the user info # su -oracle - Switch user # top - to get the system resource info (CPU, RAM and user process) #kill -9 1491 - to kill the user session (or press k) # init 0 - to shutdown server # init 5 - to logout server # init 6 - to reboot server # unmae -a - it will show the system info # cat /etc/redhat - release - will show red hat version
Two servers related commands
How to copy files between Linux servers #ifconfig - to find the ip address #scp -r /opt/abc.txt root@192.9.200.10:/data How to take a remote terminal from the local terminal # sshroot@192.9.100.10 (enter password) #ifconfig How to copy a files from windows to Linux GUI, best use WinSCP. cmd -->ipconfig c:\> ftp 192.9.100.10 (Enter user & pass) ftp>pwd /root ftp> cd s /opt ftp> lcd D:\ - to change local directory ftp> bin - for copy a file in binary mode for safer side ftp> put abc.txt ftp> mput *.txt How to copy a files from remote to Local ftp> get xyz.txt ftp>mget *.txt ftp> bye Note: FTP needs a RPM package. mount the CD # ls vsftpd * -- install all packages #service vsftpd start/statuss How to take a remote terminal from windows to Linux Putty.exe C:\> telnet 192.9.200.10 (Enter login & pass) #ifconfig Note: # ls chkconfig telnet on -- install all packages #service xinetd start/statusss ###How to take a remote desktop from windows to Linux VNC server Xmanager Humming bird
