Oracle Linux useful Command

Today i will show how to use Linux commands And Useful for Oracle DBA.

man

To show command knowledge

man(manual):

 To show contents

ls(list):

 To show hiding contents

ls -a :

 To show one under the other

ls -l :

 To show size and more information's

ls -lh :

 To show last update

ls -lrt : 

Cd

 To go other folder

cd :

/ : Linux above folder

To go above folder

Cd .. :

pwd

 To show own folder

pwd :

To create folder

mkdir

 To delete folder

rm

rm :

 to delete all

rm -R :

rmdir

 To delete empty folder

rmdir :

TO COPY FOLDER 

cp

 To move Folder 

mv

  

To show file or text 

cat | more

  

To Gzip Folder 

gzip

  

TO GUNZIP FOLDER 

gunzip

 To find folder

find

TO GIVE ALIAS 

Alias

 alias Nick_name=”<command >”  

mounting disk:

1- create a folder where to mounted.

mkdir /media/newdisk

mkdir /DATA

if we want to mount with FAT32:

mount -t vfat -o umask=ooo /dev/hdb1 /media/newdisk

if we want to mount with NTFS

mount -t ntfs -o umask=0222 /dev/hdb1 /media/newdisk

if we want to mount  CDROM:

mount -t iso_name -r /dev/cdrom /media/cdrom

if we want to mount with  OCFS2:

mount -t ocfs2 -o noatime,_netdev,datavolume,nointr /dev/emcpowera1 /DATA

if we want to mount with  EXT3:

mount -t ext3 /dev/sdb1 /software

unmounting disk:

umount -l /dev/sdb1

umount /DATA

Partitioning

fdisk /dev/sdb

Formatting

if we want to format with EXT3:

mkfs -t ext3 /dev/sdb1

if we want to format with  OCFS2:

mkfs.ocfs2 -b 4K -C 128K -N 5 -L /DATA /dev/emcpowera1

FILE SYSTEM CHECK

fsck.ocfs2 -n /dev/sdf2

fsck.ocfs2 -y /dev/sdf2 –>repair

List drives

df -h

tmpfs increase

mount -t tmpfs shmfs -o size=3g /dev/shm

Getting user id

id username

id oracle

Set user folder

chown -R oracle:dba /oracle

Change folder permission

chmod 775 file_name

Checking installed “rpm” packages

rpm -qa | grep “package name”

Rpm download 

rpm -ivh package

Rpm update

rpm -Uvh package

Rpm Delete

rpm -e package

Checking Oracle installing requires packages 

—————————————————————————————————————-

rpm -q binutils compat-db compat-libstdc++-33 libgcc glibc glibc-devel glibc-headers gcc gcc-c++ libgcc libstdc++ cpp make libaio ksh elfutils-libelf make sysstat libaio libaio-devel setarch libXp unixODBC –qf “%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n”|sort

Date of rpm

rpm -qa –last | more

CPIO extract

cat cpio_file | cpio -idmv

Create MD5 In order To copy or move validate folder

md5sum file > file.md5

Checking moved MD5 

md5sum -c file.md5

Folder transfer between servers

scp 192.168.192.168:oracle/veysi.pw /

 scp /oracle/full.dmp ora11g@192.168.192.166:/export #copy folder

Search folder

grep -ins 192.168.192.168(Text) -A2 -B1 list1.log

Get Process value

ps -ef |grep veysi|wc

Change Date

date -s “21 MAR 2010 02:04:00″

SEMAPHORE

ipcs -s

ipcrm

Trace OS process

strace -p pid

List Tar zip 

tar -tf java_patch.tar

Add a file or folder to Tar zip 

tar -rf java_patch.tar jre

Create Tar zip 

tar -cf java_patch.tar jdk

Change user ID 

usermod -u UID user

Delete folder after killed process 

echo “”>veysi_ora_7001.trc

Give easy path to folder

ln -s path kısayol_adı

Show status SELinux 

sestatus

To show version of download rmp package

echo ocfs2-`uname -r`

i/o static list

iostat 3

checking RAC node date: 

ssh rac1 date; ssh rac2 date; date

without using root password to get information

/etc/SUDOERS

ora11g localhost=NOPASSWD:/bin/mount,/bin/umount

ora11g talipdb=NOPASSWD:/bin/mount,/bin/umount

Last log in 

last | more

Send file to Via E-mail

mail -s “file_name” muh.veysi.47@hotmail.com < sqlnet.log

Finding word in folder

grep -ins word *

To kill more process using process_name

ps -ef |grep “process_name” |awk ‘{print ” kill -9 ” $2}’>/tmp/kill.sh

To watch process_name every 3 second

watch -n 2 “ps -ef | grep process_name | grep -v ps”

Open Log file

tail -f /var/log/messages