Incorrect upgrade leads to ORA-27468 errors and full flashback (ORA-16014)

Oracle10.2.0.5 an ORA-27468 error occurs in the Environment Alert Log. In the MOS document ORA-12012ORA-27468: SYS. PURGE_LOGisLockedbyAnotherProcess

ORA-27468 error in Oracle 10.2.0.5 environment Alert Log. ORA-12012 ORA-27468 in MOS document: SYS. PURGE_LOG is Locked by Another Process

ORA-27468 error in Oracle 10.2.0.5 environment Alert Log.

View alert logs:

Errors in file/u01/app/oracle/admin/crab/bdump/crab_j001_23669.trc:
ORA-12012: Automatic job 5329 Error
ORA-27468: "SYS. PURGE_LOG" locked by another process
Fri juns 27 23:14:22 CST 2014
Errors in file/u01/app/oracle/admin/crab/bdump/crab_j000_200007.trc:
ORA-12012: Automatic job 42568 Error
ORA-27468: "EXFSYS. RLM $ SCHDNEGACTION" locked by another process
Fri juns 27 23:14:22 CST 2014
Errors in file/u01/app/oracle/admin/crab/bdump/crab_j002_220.1.trc:
ORA-12012: Automatic job 8886 Error
ORA-27468: "SYS. GATHER_STATS_JOB" locked by another process
Fri juns 27 23:14:22 CST 2014
Errors in file/u01/app/oracle/admin/crab/bdump/crab_j001_23669.trc:
ORA-12012: Automatic job 42567 Error
ORA-27468: "EXFSYS. RLM $ EVTCLEANUP" locked by another process
Fri juns 27 23:14:22 CST 2014
Errors in file/u01/app/oracle/admin/crab/bdump/crab_j000_200007.trc:
ORA-12012: Automatic job 8887 Error
ORA-27468: "SYS. AUTO_SPACE_ADVISOR_JOB" locked by another process
[Oracle @ RedHat4 bdump] $ tail-20/u01/app/oracle/admin/crab/bdump/alert_crab.log
Fri juns 27 23:14:22 CST 2014
Errors in file/u01/app/oracle/admin/crab/bdump/crab_j001_23669.trc:
ORA-12012: Automatic job 5329 Error
ORA-27468: "SYS. PURGE_LOG" locked by another process
Fri juns 27 23:14:22 CST 2014
Errors in file/u01/app/oracle/admin/crab/bdump/crab_j000_200007.trc:
ORA-12012: Automatic job 42568 Error
ORA-27468: "EXFSYS. RLM $ SCHDNEGACTION" locked by another process
Fri juns 27 23:14:22 CST 2014
Errors in file/u01/app/oracle/admin/crab/bdump/crab_j002_220.1.trc:
ORA-12012: Automatic job 8886 Error
ORA-27468: "SYS. GATHER_STATS_JOB" locked by another process
Fri juns 27 23:14:22 CST 2014
Errors in file/u01/app/oracle/admin/crab/bdump/crab_j001_23669.trc:
ORA-12012: Automatic job 42567 Error
ORA-27468: "EXFSYS. RLM $ EVTCLEANUP" locked by another process
Fri juns 27 23:14:22 CST 2014
Errors in file/u01/app/oracle/admin/crab/bdump/crab_j000_200007.trc:
ORA-12012: Automatic job 8887 Error
ORA-27468: "SYS. AUTO_SPACE_ADVISOR_JOB" locked by another process

The cause of this error is that catupgrd is not executed during the upgrade. instead, some scripts for database creation are executed, such as catalog. SQL and catproc. SQL. As a result, only the version of the CATALOG view and system PACKAGE and TYPE is updated to 10.2.0.5, while the version of components in other databases is not upgraded, and it is still 10.2.0.1.

ORA-12012 ORA-27468 In the MOS document: "SYS. this error is described in PURGE_LOG "is Locked by Another Process [ID 751884.1]. This problem may occur between 10.2.0.2 and 10.2.0.5. The solution is simple and catupgrd is executed during idle time. SQL to complete subsequent operations on the Upgrade Component.

When you run catupgrd. SQL, you also encounter an Oracle flash back full (ORA-16014)

Sat Junn 28 16:30:31 CST 2014
ORA-16038: log 3 sequence #52 cannot be archived
ORA-19809: exceeds the limit on the number of recovery files
ORA-00312: Online log 3 thread 1: '/u01/app/oracle/oradata/crab/redo03.log'
Sat Junn 28 16:30:31 CST 2014
Errors in file/u01/app/oracle/admin/crab/bdump/crab_arc1_1250.trc:
ORA-16038: log 3 sequence #52 cannot be archived
ORA-19809: exceeds the limit on the number of recovery files
ORA-00312: Online log 3 thread 1: '/u01/app/oracle/oradata/crab/redo03.log'
Sat Junn 28 16:31:31 CST 2014
ARCH: Archival stopped, error occurred. Will continue retrying
Sat Junn 28 16:31:31 CST 2014
ORACLE Instance crab-Archival Error
Sat Junn 28 16:31:31 CST 2014
ORA-16014: log 3 sequence #52 Unarchived, no available destination

-- View archiving Mode
SQL> archive log list;

-- Archive space usage
SQL> select * from v $ flash_recovery_area_usage;

-- Space occupied by the flash back area
SQL> select sum (percent_space_used) * 3/100 from v $ flash_recovery_area_usage;

Solution:
-- Expand the space of the flash back area
SQL> alter system set db_recovery_file_dest_size = 3g scope = both;

System altered.
Run the following command in RMAN:

Rman target/
-- Delete backup
Crosscheck backupset;
Delete noprompt expired backupset;
Delete obsolete;
Delete noprompt expired backup;
Delete noprompt expired copy;

-- Clear Archive
-- Clear expired Archives
Crosscheck archivelog all;
Delete noprompt expired archivelog all;
-- It is not enough to force Delete the archive before a specified number of days
Delete noprompt archivelog all completed before 'sysdate-7 ';

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

,