Unix

  1. Home
    2. Operating Systems
  2. Unix
    3. (
  3. Page 2
    4. )
by Team Ajara

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
by Team Ajara

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
by Team Ajara

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,
by Team Ajara

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
by Team Ajara

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.
by Team Ajara

script to monitor FRA space usage

Script to monitor FRA space usage Filename : /u01/app/oracle/scripts/monitor_recospace.sh ORAENV_ASK=NO ORACLE_SID=$ORACLE_SID export $ORACLE_SID . oraenvLOGPATH=/u01/app/oracle/scripts/output TODAY=`date +’%Y%m%d%H:%M:%S’` OUTPUT_FILE=$LOGPATH/output-${TODAY}.log $ORACLE_HOME/bin/sqlplus -s “/as sysdba” << EOF spool ${OUTPUT_FILE} col name for a30;