Unix – tar and gzip commands

Posted by Arjun Raja
On July 23, 2009
0 Comments

tar and compress a bunch of datafiles and then untar and uncompress them cd /u02/oradata/test– (area of database files ) Now tar and compress and copy the files to backup area – /u02/oradata/test_bkup and name the file as test.tar.gz tar cvf – * |gzip -c >/u02/oradata/test_bkup/test.tar.gz – cd /u02/oradata/test_bkup > ls -lrt -rw-r–r– 1 ofsad1 […]

Posted by Gavin Soorma
On July 17, 2009
0 Comments

Locating Files under a particular directory find . -print |grep -i test.sql Using AWK in UNIX To remove a specific column of output from a UNIX command – for example to determine the UNIX process Ids for all Oracle processes on server (second column) ps -ef |grep -i oracle |awk ‘{ print $2 }’ Changing […]

Posted by Gavin Soorma
On July 17, 2009
0 Comments

Checks to be performed at the machine level (note the example is Red Hat Linux specific) run queue should be ideally not more than the number of CPU’s on the machine At the maximum it should never be more than twice the number of CPU’s. This is denoted by the column ‘r’ in the vmstat […]

Posted by Gavin Soorma
On July 16, 2009
1 Comments

If we have a number of Data Guard physical standby database environments to manage, the following report can help us quickly identify the log transported and log applied status of the Primary and Standby databases in our environment and if any standby database is lagging behind the primary as well. The script can also be […]

Posted by Arjun Raja
On July 10, 2009
2 Comments

This has been tested on an AIX box – To customize the colour of the message on login by updating the profile called on login for a user into a unix machine update the profile with the following – Red=”33[31m” RedBG=”33[41m” LightRed=”33[1;31m” Green=”33[32m” GreenBG=”33[42m” Yellow=”33[33m” YellowBG=”33[43m” Blue=”33[34m” BlueBG=”33[44m” Purple=”33[35m” PurpleBG=”33[45m” BoldON=”33[1m” BoldOFF=”33[22m” NC=”33[0m” # No […]

Posted by Gavin Soorma
On July 9, 2009
0 Comments

We can customize the .profile on Unix to make the prompt display (variable PS1) more meaningful as well as provide some useful shortcuts. For example, this is the .profile we use on one of the production AIX machines. This results in the prompt display as shown below where we display the type of the machine […]

Posted by Gavin Soorma
On July 6, 2009
1 Comments

The following Unix shell scripts can be used to automate the Data Guard Switchover process of a physical standby database. It is very important that the scripts are run in the correct order and on right machine. These scripts are based on a few customisations. The *.sh scripts are located in a directory called “/var/opt/oracle/dataguard” […]

Posted by Arjun Raja
On June 25, 2009
0 Comments

This works on AIX – Please test on other systems. If a file name is vague and can’t be removed. Ex – a file name has some hidden characters which prevents it’s removal as the name is not recognized by the rm command. ls -lai sqlnet.log 19462 -rw-r—– 1 oraofsap dba 7741 Jun 4 13:14 […]

Posted by Arjun Raja
On June 22, 2009
0 Comments

find /u01/local/logs -mtime +30 -exec ls -l {} \; find /u01/local/logs -mtime +30 -exec rm {} \;

Posted by Gavin Soorma
On June 21, 2009
2 Comments

For example – to find all files > 100 MB in size find . -size +200000 -exec ls -l {} \;

Posted by Gavin Soorma
On June 19, 2009
0 Comments

By using the procedure shown below, we can replicate a ‘master’ copy of an Oracle software installation on any number of target servers. Not only will it ensure that Oracle software installations are standardised and include all the required patches, but will save considerable time and effort required to stage the software on multiple servers. […]

Posted by Gavin Soorma
On June 18, 2009
1 Comments

Oracle has provided a utility which we can run before doing an installation on AIX – it will check quite a few things for us and enable us to fix those before proceeding with an installation which could fail at a later stage. There is a tar file validate.tar located in the $HOME directory on […]

Posted by Gavin Soorma
On June 18, 2009
0 Comments

In this example all opmn processes are being killed. This command is useful if we find a lot of processes still present at the OS level even after shutting down in this case the Oracle Application Server ps -ef | grep opmn |grep -v grep | awk ‘{print $2}’ |xargs -i kill -9 {}

News

Unix – tar and gzip commands

Unix for the Oracle DBA – Part 1

Performance Tuning Tips and Techniques

Data Guard Log Shipping Report

Customizing the Unix prompt (PS1)

Data Guard Switchover Unix shell script

Unix – remove file with unseen characters

List and remove all files older than 30 days

How to find files based on size in Unix

Cloning an existing ORACLE_HOME on Unix

Oracle 10g Pre Installation Validation for AIX 5L

How to kill all similar processes in Unix