How to clone Oracle Home ?

Step by step procedure to clone Oracle Home Source Home /u01/app/oracle/product/11.2.0/dbhome_1 Target Home /u01/app/oracle/product/11.2.0/dbhome_2 Steps to clone the Oracle Home Below steps can be executed Step 1. Pack the Source

Slowness due to df k defunct issue on apps server

df -k defunct issue on apps  server causing connectivity problems Over view of the issue Issue on Application Server where “Apps is experiencing clocking” and it  happened because of defunct

Command Prompts in Unix and Linux Operating systems

Command Prompts in Unix and Linux Operating systems.   Command Prompt is a built-in feature in computers that allows users to interact with their operating system through a command-line interface. 

Script to get tablespace alert in Oracle

  Script to get tablespace alert in Oracle   This script can be run on any Uinx/Linux flavours. For AIX,HP, and Linux oratab’s path is /etc/oratab, for solaris oratab’s path

Script to get CPU intensive queries in oracle

Script to get CPU intensive queries in oracle.     Query to get the SQL details that take more than 5 minutes ========================================================= SELECT sql_id, child_number, executions, elapsed_time, cpu_time, buffer_gets,

df command on Unix and Linux

df command on Unix and Linux df -k –> to get the o/p in KiloBytes (works on Linux n Solaris) df -h –> to get the o/p in GigaBytes (works