Script to gather stats the customs schemas
The below script is to gather stats the customs schemas. SET SERVEROUTPUT ON SIZE 1000000 set feedb off set trimspool on spool tmp_gather_schstats_${ORACLE_SID}.sql DECLARE CURSOR c_tm IS select…
Read MoreSending Email From Oracle using Amazon Simple Email Service (SES)
Use the below Link to create the Cerfiticate using Amazon SMTP address. https://whatsmychaincert.com/?email-smtp.us-east-1.amazonaws.com Creating Oracle Wallet : mkdir -p /u01/app/oracle/wallet/TEST orapki wallet create -wallet /u01/app/oracle/wallet/TEST orapki wallet add -wallet /u01/app/oracle/wallet/TEST…
Read MoreORA-00392: log 4 of thread 1 is being cleared, operation not allowed
Got the below error during cloning. To fix this issue, need to “clear unarchived logfile group” Solution : SQL> alter database open resetlogs; alter database open resetlogs * ERROR…
Read More