Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
Introduction: – As we know that Oracle introduced multitenant Container Database CDB and Pluggable database PDB Backup and Recovery in 12c. Using RMAN client we can perform the backup of entire Container Database (CDB) or individual Pluggable Database (PDB) and also perform the point-in- time recovery. Before starting the RMAN backup, we should … Read more
In this article we will discuss how to move datafile online in oracle. We know that Oracle introduced moving datafiles online in 12c to minimize the downtime. Prior to oracle 12c, required taking datafile offline and copy it at OS level and bring it back online again. Oracle 12c includes an enhancement to ALTER DATABASE … Read more
Introduction:- In this article we will discuss about Data Pump Enhancements in Oracle Database. NOLOGGING Option (DISABLE_ARCHIVE_LOGGING)The TRANSFORM parameter of impdp has been extended. Data pump enhancements:- NOLOGGING Option (DISABLE_ARCHIVE_LOGGING) The TRANSFORM parameter of impdp has been extended to include a DISABLE_ARCHIVE_LOGGING option. The default setting of “N” has no any effect on logging behavior. Using a value “Y” reduces the … 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
IAS component OC4JGroupdefault_group OC4Joacore stopped failed automatically in EBS| To resolve the above issue, need to be modify/increase the JVM processes as below in context file: In our production instance IAS component “oacore” frequently down/failed. IAS component OC4JGroupdefault_group OC4Joacore stopped failed Check the services in case of oacore failure. $sh adapcctl.sh status You are running … Read more
adop phase=prepare ORA-20008: No Concurrent Manager is running that can run concurrent program| To resolve the issue, truncate table applsys.ad_nodes_config_status and rerun the adop cycle. Adop phase=prepare ORA-20008: No Concurrent Manager is running. Below error coming while executing dop phase=prepare. Solution:- Set the Run filesystem / environment and run command: FNDLOAD … Read more