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 ‘/u01/oracle/oradata/undotbs02.dbf’ size=1G; 3-       Alter system set undo_tablespace = UNDOTBS2; 4-       Shutdown immediate 5-       startup 6-       Drop tablespace UNDOTBS1 including contents and datafiles; Database is working fine now.

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            $INST_TOP/admin/scripts/adstpall.sh 2-       Remove any .lock files from following folders: $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/oacore_default_group_1 $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/oafm_default_group_1 $INST_TOP/ora/10.1.3/j2ee/form