Oracle Application DBA

ORA-10564 Tablespace UNDOTBS1 ORA-01110 ORA-10560 Applies to:             Oracle Enterprise Linux – Version: 7             Oracle EBS R12 Description:             After abnormal shutdown of server we face the problem “ORA-10564 Tablespace UNDOTBS1 ORA-01110 data file 7 UNDOTBS01.DBF ORA-10560 block type KTU UNDO BLOCK”. I have restarted all the services of database but the problem is same. I have also restarted the whole machine/server but still the same issue. Solution:             After some research I found that recreate the undo tablespace to resolve the issue. Following the steps to resolve the above issue: 1-       Connect / as sysdba 2-       Create undo tablespace UNDOTBS2 datafile...

EBS R12 Web Application Services adoacorectl.sh failed Applies to:             Oracle Enterprise Linux – Version: 7             Oracle EBS R12 Description:             Oracle EBS R12 Application services cannot start successfully adoacorectl.sh going to failed. I have restarted all the services of application and database but the problem is same. I have also restarted the whole machine/server but still the same issue. I found in log file that all OC4J services (oacore, oafm, form) going to fail with timeout error. Solution:             After some research I found that need to clean out the lock files. Following the steps to resolve the above issue: 1-       Stop all application services      ...