Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-03114: not connected to ORACLE errors during catupgrd.sql

user629987Aug 16 2011 — edited Aug 16 2011
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 13 2011
Added on Aug 16 2011
5 comments
4,151 views