1. Generate RPM list on Old Server rpm -qa –queryformat=’%{NAME}\n’ | sort > serverold.txt 2. Generate RPM list on New…
Tag UNIX
export MMSG=/tmp/$$.mail export ADDR=”shadab@easyoradba.com” export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 export ORACLE_SID=orcl file=/tmp/${$}_`date +%Y%m%d` sqlplus -s “/as sysdba” << .eof > $file set pages…
The Below Shell Script checks the Filesystem mount points and using AWK outputs all filesystem exceeding 90% space to a…
Most of the times DBA’s need to edit blocks of PL/SQL or SQL scripts and perform some modifications. Notepad++ is…
GoldenGate is touted by Oracle as its future for data replication. It will slowly phase out Oracle Streams and will…
Sometimes on a system it is important to know the maximum user processes does not increase so much that it…
################ Configure Solaris 10 machine to be on DNS############## 1. Check for file resolv.conf in /etc directory, if it doenst…
Below is the Solaris user profiles for “grid” and “oracle” user. If you have followed Oracles official documentation for installation…
I had installed Oracle Database 11g on Solaris 10 few days back. I thought of documenting the steps for easy…
Automatic Storage Management (ASM) in Oracle Database 10g Automatic Storage Management (ASM) is a new feature was introduced in Oracle…
The following is a basic steps for an automatic start up and shutdown Oracle instances during UNIX system startup or…
Many times it becomes necessary to append date stamp on your export dumps. In Unix systems, shell scripting is very…
Directions :: First do gunzip then cpio of the file you downloaded from oracle.com 1. Run “gunzip <filename>” on all…
UNIX Commands for DBAs Basic File Navigation The “pwd” command displays the current directory: root> pwd /u01/app/oracle/product/9.2.0.1.0 The “ls” command…
Sometimes when your running an Oracle database, it becomes necessary to automate some tasks like cleaning your archivelogs. Since in…