SYMPTOM  On primary database side, ORA errors in alert log:  Errors in file /u01/app/oracle/diag/rdbms/testdb001/TESTDB001/trace/TESTDB001_arc4_10114.trc:  ORA-07286:  cannot obtain device [...]

INTRODUCTION  This blog is about, one of our non-prod OEM13C environment the Database target status was showing warning eventhough the target is actually up and running.  SOLUTION  Login into OEM [...]

OVERVIEW: Oracle Autonomous Transaction Processing (ATP) is a cloud-based, fully managed database service by Oracle. It automates administrative tasks, enabling users to focus on application [...]

INTRODUCTION SQL tuning is the process of improving SQL queries to accelerate your servers performance. It’s general purpose is to reduce the amount of time it takes a user to receive a [...]

[...]

ORA-20004: Error in sending an Email – You have exceeded the maximum number of email messages per workspace. Please contact your administrator. REASON: Actually, Number of mails can be sent [...]

BEFORE WE HAVE CHECK THE OPATCH VERISON AND LAST UPDATE CHECK OPATCH VERSION [oracle@kaamesh OPatch]$ pwd /u01/app/oracle/product/19.0.0/dbhome_1/OPatch [oracle@kaamesh OPatch]$ [oracle@kaamesh [...]

Before cloning we have to take full database backup using  RMAN Target  / COMMAND: RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Once completed,move the backup file to target server USING SCP BACKUP [...]