Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
Introduction: – In this article we will learn how to Backup database plus archive log delete input. In oracle database it’s very important to manage the archive logs to free up the space on archive log destination for new archive logs. Follow below steps to backup database plus archive log delete input. Some rman commands … Read more
adrelink is exiting with status 1 r12| When attempting to apply R12.ATG_PF.B.delta.3 patch 8919491, error appears on relink, the following error occurs on relinking executables task. How to fix adrelink is exiting with status 1 r12 ERROR — adrelink failed in r12 adrelink.log:- Relink of module “MSCCPP” failed. Relink of module “MSCMON” failed. Relink of module “MSCNEW” … Read more
How to Create bigfile tablespace| A bigfile tablespace is a tablespace with a single, but very large (up to 4g blocks) datafile. A bigfile tablespace with a typical 8K block can contain a single 32-terabyte datafile. If you’re using a 32K block, it can contain a 128-terabyte datafile. SQL> CREATE BIGFILE TABLESPACE bigtbls DATAFILE ‘/data01/prod/bigtbs01.dbf’ … Read more
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
Introduction:- Here will cover how to fix collect2 ld returned 1 exit status. Below error occurs during relink while applying the patch in oracle database. See how to Issue the failed relink command: How resolve collect2 ld returned 1 exit status. Error:- collect2: ld returned 1 exit statusmake[1]: *** [/data02/1124home/sysman/lib/libnmemso.so] Error 1make: *** [libnmemso] Error … Read more
In this post we will cover ORA-48223 Interrupt Requested Fetch Aborted Return Code [12751] [HM_FINDING]. Error:- ORA-48223 Interrupt Requested Fetch Aborted Return Code [12751] [HM_FINDING] | Errors in file /data01/ORAHOME/log/diag/rdbms/ace/PROD/trace/PROD_m000_7649.trc: ORA-51106: check failed to complete due to an error. See error below. Fixing ORA-48223 Interrupt Requested Fetch Aborted à If anyone facing … Read more