ORA-03114: not connected to ORACLE errors during catupgrd.sql
Hi,
I am migrating en updating (manually) a database from 10gR2 to 11gR1 and from Windows 2003 to Windows 2008.
During the catupgrd.sql script, I get the following error:
.
.
.
SQL> Rem DBA network ACL assignments view
SQL> Rem
SQL>
SQL> create or replace view DBA_NETWORK_ACLS
2 (HOST, LOWER_PORT, UPPER_PORT, ACL, ACLID)
3 as
4 select a.host, a.lower_port, a.upper_port, r.any_path, a.aclid
5 from net$_acl a, resource_view r
6 where sys_op_r2o(extractValue(r.res, '/Resource/XMLRef')) = a.aclid
7 /
create or replace view DBA_NETWORK_ACLS
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
Other errors encountered in the catupgrd spool file:
select count(*) into auth_count from xdb.xdb$config
*
ERROR at line 5:
ORA-06550: line 5, column 44:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 5, column 3:
PL/SQL: SQL Statement ignored
FROM XDB.XDB$ACL a
*
ERROR at line 31:
ORA-00942: table or view does not exist
And there are also other similar errors.
In the alertlog, I see the following error:
ORA-31000: Resource 'http://xmlns.oracle.com/xdb/acl.xsd' is not an XDB schema document
Does anyone know what I should do to fix this? Thanks.