Script to delete archive logs in Oracle Normally we delete archive logs as soon as we take archive backup by using script. Due to any reason ,If deletion is not
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
Data hard disk entered predictive failure status. EM Alert: EM Event: Critical:excellnode02 – Data hard disk entered predictive failure status. Details : Cell Node : 02 Status : WARNING –
How to connect to PDBs using oracle binary user? Details: Server name: oratsrv Instance name: CDBG unique name of Container DB: UCDBG PDB names: PDB1, PDB2,PDB3 Oracle Version: 19.12.0.0.0 =====================================
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;
ORA-16038 TNS-12535 ORA-03135 archiver hung at timeline number. The archiver hung at time/line number due to Possible N/W disconnect with Primary DB. The RFS process on the standby gets the
Logon trigger at DB level for tracing oracle session. During performance testing , sometimes we want to trace all the sessions from a user and from a particula server and
To Find what schemas exported/imported using expdp/impdp. Sometimes exported schema list is not available while doing import activity, and the DBA who performed export activity is not available may be
Issue: Standby DB not in sync with Primary after enabling TDE on Primary Errors: ORA-28374: typed master key not found in wallet —> in standby alertlog file ORA-16086: Redo data
