Oracle Database Upgrade From 11.2.0.4 To 12.2.0.1 Failed With ORA-06512: At Line 37 ORA-06512
Oracle Database Upgrade From 11.2.0.4 To 12.2.0.1 Failed With ORA-06512: At Line 37 ORA-06512: At Line 98
Titleimage
Posted by RENAPS DBA Team on 2024:02:01 18:55:38
Oracle Database Upgrade From 11.2.0.4 To 12.2.0.1: Initial Context
Applies to Oracle Database - Enterprise Edition - Version 12.2.0.1 and later. Information in this document applies to any platform.
Upgrading an Oracle Database from version 11.2 to 12.2 involves several steps and considerations to ensure a smooth transition and minimal downtime. Here’s an overview of the process:
- 1. Pre-Upgrade Preparation
- 2. Upgrade Methods
- 3. Post-Upgrade Tasks
- 4. Considerations and Best Practices
This article goes over errors one can encounter while performing an Oracle Database Upgrade to Oracle Database - Enterprise Edition - Version 12.2.0.1 and later.
Symptoms encountered while performing a database upgrade from 11.2.0.4 to 12.2.0.1
A database upgrade from 11.2.0.4 to 12.2.0.1 failed with ORA-06512: at line 37 ORA-06512: at line 98
From catupgrd0.log:
Elapsed: 00:00:00.00
++++++++++++++++++++++++++++++++++++++++++++++++++++++
CATCTL ERROR COUNT=3
------------------------------------------------------
Identifier XDB 19-01-23 09:23:09
SCRIPT = [/opt/app/oracle/product/12.2.0.1/rdbms/admin/nacla112.sql]
ERROR = [ORA-64464: XML event error ORA-19202: Error occurred in XML processing
ORA-06512: at "XDB.DBMS_XDB_REPOS", line 201
ORA-06512: at line 37
ORA-06512: at line 98This situation is different from that described in Note 2496040.1. In this case, the user account assigned to an ACL is not Locked.
Cause of the Oracle Database Upgrade error
Before upgrade, one or more ACL principals are granted with privilege 'resolve' but the ACL has port range defined.
To identify ACL port range and principal/privilege assigned, use below queries:
sqlplus / as sysdba
set echo on pages 10000 linesize 200
col host for a20
col acl for a50
col principal format a20
col privilege for a15
col lower_port for 9999999999
col upper_port for 9999999999
select acl, principal, privilege from dba_network_acl_privileges;
select host, acl, lower_port, upper_port from dba_network_acls;
How to fix the Oracle Database Upgrade error
Follow the steps below to un-assign then re-assign the ACL to the host without port range.
Values used in the example:
ACL - /sys/acls/network_acl.xml
Host - localhost
lower_port - 25
upper_port - 25
Unassign the ACL
begin
DBMS_NETWORK_ACL_ADMIN.UNASSIGN_ACL (
acl => '/sys/acls/network_acl.xml',
host => 'localhost',
lower_port => 25,
upper_port => 25);
end;
Reassign the ACL back without the ports
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
acl => '/sys/acls/network_acl.xml',
host => 'localhost',
end;
All the users should be re-assigned to the ACL. To verify, use the same 2 SELECT queries above.
Oracle Database Upgrade: Automate your upgrade process with Ormit™-DB
ORMIT™-DB automates every Oracle Database Upgrade from all earlier versions to the latest versions.
ORMIT™-DB guarantees the overall success of your Oracle Database Upgrade with an emphasis on efficiency, cost and time savings, eliminating any potential risk. The automated process is extremely fast and secure. It automates a large quantity of actions while eliminating the guess work associated with manual upgrades. ORMIT™-DB also minimizes downtime and identifies manual tasks that require DBA action.
Posted by RENAPS DBA Team on 2024:02:01 18:55:38