Oracle DB migration from windows to Exadata machine

Database Migration steps from windows 2003 to Exadata DB Server : Steps @(windows) Source server: 1.Connect to the database Cmd>set oracle_sid=<sidname>             Cmd>sqlplus sys as sysdba             Password:<password>

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

Oracle Database 19c installation requirements on AIX

Prerequisites for 19c installation:     IBM AIX 7.1 on POWER Systems (64-Bit) Minimum Operating System Requirements Item Minimum Requirements SSH Requirement OpenSSH_7.5p1 or later AIX 7.1 Operating System AIX

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

Mail service is not working on Unix server

Mail service is not working on Unix server. mailx command is used to send mail alerts in Unix Operating System. uuencode command is used to send attachments in the mail.