Wednesday, November 14, 2018

DBA Unix Commands

https://oracle-base.com/articles/misc/unix-for-dbas


cd/directory name => takes you named directory
cd => takes you to user home directory
mkdir=>make directory
mkdir -p /u01/amin/dba     => command to create recursive directory
ls => list command
root> ls -al
The "-a" flag lists hidden "." files. The "-l" flag lists file details.
ls-lrt => list command as per time
pwd => present working directory


The "rm" command is used to delete files and directories.

root> rm my.log
root> rm -R /archive
The "-R" flag tells the command to recurse through subdirectories.

The "mv" command is used to move or rename files and directories.

root> mv [from] [to]
root> mv my.log my1.log
root> mv * /archive
root> mv /archive/* .
The "." represents the current directory.

The "cp" command is used to copy files and directories.

root> cp [from] [to]
root> cp my.log my1.log
root> cp * /archive
root> cp /archive/* .



The "find" command can be used to find the location of specific files.

root> find / -name dbmspool.sql
root> find / -print | grep -i dbmspool.sql
The "/" flag represents the staring directory for the search. Wildcards such as "dbms*" can be used for the filename.

The "which" command can be used to find the location of an executable you are using.
oracle> which sqlplus

The "chmod" command is used to alter file permissions after the file has been created.
root> chmod 777 *.log


The "chown" command is used to reset the ownership of files after creation.
root> chown -R oinstall.dba *
The "-R" flag causes the command ro recurse through any subdirectories.



OS Users Management
See Linux Groups and Users.

The "useradd" command is used to add OS users.

root> useradd -G oinstall -g dba -d /usr/users/my_user -m -s /bin/ksh my_user
The "-G" flag specifies the primary group.
The "-g" flag specifies the secondary group.
The "-d" flag specifies the default directory.
The "-m" flag creates the default directory.
The "-s" flag specifies the default shell.
The "usermod" command is used to modify the user settings after a user has been created.

root> usermod -s /bin/csh my_user
The "userdel" command is used to delete existing users.

root> userdel -r my_user
The "-r" flag removes the default directory.

The "passwd" command is used to set, or reset, the users login password.

root> passwd my_user

Find Big Files
Find the top 20 biggest files recursively from this directory.
$ find . -type f -print0 | xargs -0 du -h | sort -hr | head -20


Find Big Files
Find the top 20 biggest files recursively from this directory.
$ find . -type f -print0 | xargs -0 du -h | sort -hr | head -20


Remove Old Files
The find command can be used to supply a list of files to the rm command or the "-delete" command can be used directly.
find /backup/logs/ -name daily_backup* -mtime +21 -exec rm -f {} ;
find /backup/logs/daily_backup* -mtime +5 -exec rm -f {} \;
find /backup/logs/daily_backup* -mtime +5 -delete;

Process Management
See Linux Process Management (ps, top, renice, kill).

The "ps" command lists current process information.

# ps
# ps -ef | grep -i ora
# ps -ef | grep -i ora | grep -v grep
# ps -ef | grep -i [o]ra
Specific processes can be killed by specifying the process id in the kill command.

# kill 12345
# kill -9 12345
You can kill multiple processes using a single command by combining "kill" with the "ps" and "awk" commands.

# kill -9 `ps -ef | grep ora | awk '{print $2}'`


:wq!  to save contents of the file
:q! to discard last changes made
dd  to delete single line
/hi  to search Hi word inside the file

press i to get inside insert mode
press ESC key to exit out vi

cat is used to display contents of file


types of groups in Linux
Oinstall
dba
oracle
Primary group,Secoundry group
How to create a group in Linux
useradd -g oinstall -G dba -d /home/oracle oracle
connect to user
su - oracle, su - root
check present working directory
pwd
Assign password to the user
passwd oracle


how to check all the groups in linux
cat /etc/group
Permisions in Linux
how to check you have permission on particular path

su -root
ls -ld  /u01
chmod 700 /u01
chmod  757/u01
replacing  db name in vi editor
:%s/proddb/devdb/g

Manage memory in Linux
=====================
volatile Ram( Costlier)
non volatile -Hard disk

Useful Files

/etc/passwd                                                              User settings
/etc/group                                                                  Group settings for users.
/etc/hosts                                                                  Hostname lookup information
/etc/system                                                               Kernel parameters for Solaris.
/etc/sysctl.conf                                                          Kernel parameters for Linux.

No comments:

Post a Comment