Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
Oracle Apps Administration categories is related to EBS issues and solutions.
In this article we will discuss about Oracle RMAN Incremental Backup. An Incremental backup is those backup that only backup datafile blocks that have changed since a specified previous backup. You can make incremental backups of whole databases, individual tablespaces or datafiles. The purpose of an incremental backup is to backup only those data blocks … Read more
Introduction: – In this post covers ORA-1652: unable to extend temp segment by 128 in tablespace TEMP error. Generally, we are facing this ora error while running sql query or concurrent program in our Instance. How to resolve ORA-1652 unable to extend temp segment. The ORA-01652 error occurs due to failure in allocating … Read more
Introduction: – Before restoration and recovery of PDB (Pluggable database), we need to ensure that valid rman backup available. Here we will cover restore and recover pluggable database. We can restore using restore pluggable database PDBORCL1; Steps to restore and recover pluggable database. We have already discussed the same in another post. Please check here for … Read more
In this article we will discuss the ‘How to delete concurrent program from backend‘. To delete a concurrent program and executable in Oracle Apps (E-Business Suite), you’ll need to follow a series of steps through the application’s user interface. Please note that making changes to Oracle Apps should be done with caution, as it can … Read more
Introduction:- How to fix ORA-19809 limit exceeded for recovery files. | In this article we will discuss ‘how to resolve ORA-19809 and ORA-19804′ error. This has very common issue while doing RMAN backup, we have faced ORA-19809 and ORA-19804 error due to recovery destination full. In this scenario we will have to remove old archivelog (expired or … Read more
RMAN backup status| Backup is very important part of oracle database. Being Oracle DBA, regularly we are doing backup of oracle database for recovery. To check the check rman backup status job we can use below scripts. We can use view v$rman_status, v$rman_backup_job_details and V$SESSION_LONGOPS to monitor the current executing RMAN jobs and the status … Read more
ERROR Patching cycle in progress | In this post, we will resolve the patching error and apply the patches without any error. How to resolve ERROR Patching cycle in progress. AD Administration error: ERROR Patching cycle in progress – run this utility from patch file system You can only run it from run file system … Read more
Introduction: – This article is very useful for those who encountered issue while cloning EBS adgentns-pl exiting with status ****. On application Release 12 When attempting to run autoconfig on APPS Tier, the following error occurs: Resolving adgentns-pl exiting with status 2 Error:- Autoconfig Error: adgentns.pl exiting with status 2 after Clone/Refresh. The likely cause … Read more
Clearing redo logfile in oracle database | Sometimes redo log file become corrupted while database open the database may “lock up” and we are unable to do anything because archiving can’t continue this case you may execute ‘ALTER DATABASE CLEAR LOGFILE‘ statement to reinitialize the redo log file and database continue processing. Clearing … Read more
Users Notification Preference Becomes Disabled In FND_USER_PREFERENCES Table| Lets understand why notification_preferencefor recipients to become DISABLED. If your email server crashed andcaused an outage of several hours, then it’s caused the recipients notification_preference to change to DISABLEDin the FND_USER_PREFERENCESand WF_LOCAL_ROLEStables. Steps to troubleshoot Users Notification Preference Becomes Disabled We can find out those users that … Read more