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.
If you want to increase the size of oracle database. We must Create tablespace in oracle database. or increase the size of existing tablespace by resize datafile or add datafile to tablespace. Check Tablespace size in oracle database. SELECT /* + RULE */ df.tablespace_name “Tablespace”, df.bytes / (1024 * 1024) “Size (MB)”, … Read more
If we want to resize the existing data file. We must use alter database datafile resize command. Steps to resize using alter database datafile resize. Before doing resize the data file in oracle database, we will have to check the existing data file size. SQL>select file_name,bytes/1024/1024 SIZE_IN_MB from dba_data_files where tablespace_name=’XXCUSTOM’; … Read more
Suppose our database getting full. In that situation we have to increase the size of database to add datafile in existing tablespace or creating new tablespace along with datafile. How to add datafile to tablespace in oracle: – We can increase space in oracle database to add datafile or resize existing datafile to existing tablespace. … Read more
We will fix java.lang.OutOfMemoryError: GC overhead limit exceeded. Facing this error while applying bsu patches. We can resolve it by increasing memory size as below. How to fix java.lang.OutOfMemoryError. Error:- While trying to apply the BSU patch, facing below error. $./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=KRDE -prod_dir=/data01/apps1225/fs1/FMW_Home/wlserver_10.3 Solution: – Follow these steps to resolve the issue: A.==>Go … Read more
In this post we will fix Unable to initialize state monitor Not able to create new database connection. oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Not able to create new database connection: FNDSECURITY_APPL_SERVER_ID In my case FND_NODES table and dbc file both have different SERVER_ID. Once I have updated the dbc file as FND_NODES , issue got resolved. … Read more
In this post we cover how Restore and Recover the noarchivelog database. Suppose any datafile lost and we trying to recover the oracle database in noarchivelog mode, it will give the below error. Error:- Here we are facing error while recovering database. RMAN> recover database; Starting recover at 24-MAR-18 using channel … Read more
In this post we will cover how to fix ORA-00392 log of thread is being cleared, operation not allowed. How to fix ORA-00392 log of thread is being cleared Problem:- Solution:- Check current status of logfile. We can see here redo logfile group 3,4 & 5 is showing as clearing. So we need to clear … Read more
Resolve kkjcre1p unable to spawn jobq slave process. We are facing this issue while doing shutdown oracle database. Root Cause: – This situation occurs while we fire “shutdown immediate”in oracle database. Continuously error message is coming in alert log file. resolve kkjcre1p unable to spawn jobq slave process, slot 0, error 1089 in oracle database. … Read more
Introduction: – In this post we will cover how to check tablespace size in oracle database. Using dba_data_files and dba_free_space to check tablespace size. Follow the below steps to monitory the oracle database utilization. How to check tablespace size in oracle database Here I will explain how to check tablespace size in oracle. Every DBA … Read more
Introduction: – In this post we will learn Purge obsolete logs in oracle EBS r12. Purging is regular activity to clear old logs from log location. We can improve performance our database and apps to clear obsolete logs which is not required. Following command will help you in regular activity to Purge obsolete logs in … Read more