Linux basic commands on – AWS EC2 instance.

Linux basic commands on AWS EC2 instance ASs soon as we connect to AWS EC2 instance we get the prompt as below: [ec2-user@ip-172-31-83-99 ~]$ [ = opening square bracket ec2-user

Script to monitor OMS

Script to monitor OMS sample output when OEM is up ./emctl status oms Oracle Enterprise Manager Cloud Control 13c Release 5 WebTier is Up Oracle Management Server is Up JVMD

Script for Monitoring Oracle Database

Script for Monitoring Oracle databases. Script to monitor sessionlocks,current session and tablespace usage details on RAC database Main script calls 3 SQL queries and sends the output in a mail

script to find load average on the OS Level

script to find load average on the OS Level. Whenever there is any performance issue in a  database  or server level ,it is very common to verify what is the

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;

Step by Step upgrade GI from 12.2 to 19.12 on AIX

Step by Step upgrade grid infrastructure from 12.2.0.1 to 19.12.0.0.0 on AIX High level steps: Source Version: 12.2.0.1.0 Target Version: 19.12.0.0.0 OS : AIX 7.1   Verify prerequisites and setup

Script for DB Services and ASM Disk info

Automation Solution for DB Services and ASM Disk info. Capturing Database Services details and Automatic storage Management (ASM) Disk info  has been automated to minimize startup and  post maintenance issues.100%

Step by step Oracle TDE setup

Step by step Oracle TDE setup. Server: LinuxDatabase: Oracle 19.3.0.0.0Server name: ORA_SRVRDB name: ORCLTEncryption method: TDEEncryption type: AES256   Connect to Database oracle@ORA_SRVR:/u00/app/oracle/ [ORCLT] sqlplus SQL*Plus: Release 19.0.0.0.0 – Production