ORA-10564 Tablespace UNDOTBS1 ORA-01110 ORA-10560

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.

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ

Web Application Services adoacorectl.sh failed

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/forms/persistence/forms_default_group_1

3-      Also remove the following files if exists:

$COMMON_TOP/cacheLock

$COMMON_TOP/_TldCache

4-      Now Start application services

$INST_TOP/admin/scripts/adstrtall.sh

                   All services going to start successfully.

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ