Oracle DBA Unix commands-02


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@

How to take a remote terminal from the local terminal

# sshroot@ (enter password)


How to copy a files from windows to Linux

GUI, best use WinSCP.

cmd -->ipconfig

c:\> ftp (Enter user & pass)



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


C:\> telnet (Enter login & pass)


Note: # ls chkconfig telnet on -- install all packages

#service xinetd start/statusss

###How to take a remote desktop from windows to Linux

VNC server


Humming bird



I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server And I’m specialized in Administration and Performance tuning. I’m an active member of SQL server Central and MSDN forum. I also write articles in SQL server Central. For more Click here

Leave a Reply

Your email address will not be published. Required fields are marked *

WC Captcha 6 + 1 =

 hacklink panelweb shell downloadhacklink vozol 5000
hacklink hacklink al hacklink panel hacklink hacklink panel hacklink al hack forum hacklink Shell download web shell download web shell archive web shell indir php shell download php shell archive php shell indir shell indir cami halısı cami halısı cami halısı cami halısı cami halısı cami halısı cami halısı cami halısı cami halısı cami halısı cami halısı cami halısı cami avizesi cami avizesi cami süpürgesi cami süpürgesi cami ısıtma cami ısıtma evden eve nakliyat evden eve nakliyat evden eve nakliyat evden eve nakliyat ofis taşıma yurtiçi evden eve nakliyat yurtiçi evden eve nakliyat içel evden eve nakliyat seo hizmeti Rulet Casino Slot Oyna Bahigo 1xbet Deneme bonusu Bahis siteleri Maç özetleri Bahsegel Canlı Casino Siteleri Sweet Bonanza Blackjack Casino Rulet Oyna Canlı Casino istanbul escort muğla escort
hacklink panel
hacklink al
hacklink panel
hacklink al
deneme bonusu veren siteler