Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2013
    Posts
    2

    Unanswered: ORA-06575 During upgrade to Oracle 11g

    Hoping somebody here might be able to offer assistance because I've scoured the internet and also can't find anything related to this issue in the Oracle knowledge-base/metalink.

    I'm upgrading an Oracle 10.2.0.4 database to Oracle 11.2.0.1 on a Solaris 10 server. I had previously upgraded from Oracle 9 to 10 so I generally understand the process involved here. However when running the dbua I'm getting the below error:

    ORA-06575: Package or function UPGRADE_RESOURCE_SCHEMA is in an invalid state

    I've gone to the Oracle_Server.log files and I can clearly see where it's happening and also realized it's not really the root cause of the issue:

    Code:
    ---------------------------------------------------------------------------------------
    -- Call the functions defined above.
    ---------------------------------------------------------------------------------------
    -- We do not need to upgrade the config and acl schemas manually from 10.2
    -- to 11.0 any more, as we invoke xdb$migrateXMLTable to do this for us
    -- Upgrade config schema from the 10102 version
    -- call upgrade_config_schema();
    
    --Upgrade acl schema from the 10102 version
    -- call upgrade_acl_schema();
    
    --Upgrade dav schema from the 10102 version
    -- call upgrade_dav_schema();
    
    -- Upgrade resource schema from the 10102 version
    call upgrade_resource_schema();
    call upgrade_resource_schema()
    *
    ERROR at line 1:
    ORA-06575: Package or function UPGRADE_RESOURCE_SCHEMA is in an invalid state
    So if I follow trace up through the log file I see why the UPGRADE_RESOURCE_SCHEMA procedure is invalid:

    Code:
    Errors for PROCEDURE UPGRADE_RESOURCE_SCHEMA:
    
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    19/7     PL/SQL: Statement ignored
    19/7     PLS-00905: object SYS.ADD_TO_RESOURCE_SCHEMA is invalid
    Tracing up further I see why ADD_TO_RESOURCE_SCHEMA is invalid:

    Code:
    show errors;
    Errors for PROCEDURE ADD_TO_RESOURCE_SCHEMA:
    
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    305/4    PL/SQL: SQL Statement ignored
    306/7    PL/SQL: ORA-02315: incorrect number of arguments for default
    constructor
    
    309/4    PL/SQL: SQL Statement ignored
    310/5    PL/SQL: ORA-02315: incorrect number of arguments for default
    constructor
    
    313/4    PL/SQL: SQL Statement ignored
    314/7    PL/SQL: ORA-02315: incorrect number of arguments for default
    constructor
    Here are the relevant lines from ADD_TO_RESOURCE_SCHEMA. I don't understand enough about PL/SQL to know why that's causing a problem but I guess the bigger problem is "Why is the script that oracle itself is running causing errors like that?". Since I'm not seeing anything else about this online I'm assuming I'm doing something wrong but I'm at a dead end as to where to go from here. Hoping somebody in the forum might have an idea. It doesn't make sense to me that the upgrade scripts have the wrong number of constructors for those types. For what it's worth this is all coming from the script xdbs102.sql which is being called indirectly from the catupgrd.sql

    Code:
    305     insert into xdb.xdb$simple_type e (e.xmldata) values
    306       (XDB.XDB$SIMPLE_T(NULL, schema_ref, 'lockModeType', NULL, XDB.XDB$SIMPLE_DERIVATION_T(NULL, NULL, XDB.XDB$QNAME('00', 'string'), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL, NULL, XDB.XDB$FACET_LIST_T(XDB.XDB$FACET_T(NULL, NULL, 'exclusive', '00', NULL), XDB.XDB$FACET_T(NULL, NULL, 'shared', '00', NULL)), NULL, NULL), NULL, NULL, NULL, NULL, NULL, NULL, NULL))
    307      returning ref(e) into lock_mode_type_simple_ref;
    308
    309     insert into xdb.xdb$simple_type e (e.xmldata) values
    310     (XDB.XDB$SIMPLE_T(NULL, schema_ref, 'lockTypeType', NULL, XDB.XDB$SIMPLE_DERIVATION_T(NULL, NULL, XDB.XDB$QNAME('00', 'string'), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL, NULL, XDB.XDB$FACET_LIST_T(XDB.XDB$FACET_T(NULL, NULL, 'read-write', '00', NULL), XDB.XDB$FACET_T(NULL, NULL, 'write', '00', NULL), XDB.XDB$FACET_T(NULL, NULL, 'read', '00', NULL)), NULL, NULL), NULL, NULL, NULL, NULL, NULL, NULL, NULL))
    311      returning ref(e) into lock_type_type_simple_ref;
    312
    313     insert into xdb.xdb$simple_type e (e.xmldata) values
    314       (XDB.XDB$SIMPLE_T(NULL, schema_ref, 'lockDepthType', NULL, XDB.XDB$SIMPLE_DERIVATION_T(NULL,NULL, XDB.XDB$QNAME('00', 'string'), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, XDB.XDB$FACET_LIST_T(XDB.XDB$FACET_T(NULL, NULL, '0', '00', NULL), XDB.XDB$FACET_T(NULL, NULL, 'infinity', '00', NULL)), NULL, NULL), NULL, NULL, NULL, NULL, NULL, NULL, NULL))
    315      returning ref(e) into lock_depth_type_simple_ref;

  2. #2
    Join Date
    Apr 2013
    Posts
    2
    I finally gave up on this upgrade and tried again using 11.2.0.3 and everything worked fine... Strange but it seems to indicate the problem was not something I was doing incorrectly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •