on 12-25-2013 12:17 PM
Dear all,
I have upgraded oracle from 10205 to 11203 and executed all steps as per upgrade guide.
I executed utlrp.sql scripts but still getting following invalid Objects.
SQL> SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS = 'INVALID';
OBJECT_NAME
--------------------------------------------------------------------
DBMS_METADATA_INT
DBMS_METADATA_UTIL
XDB_MIGRATESCHEMA
3 rows selected.
Would you guide me which scripts I have to execute to compile above objects?
Regards,
Hi Abdul,
> Would you guide me which scripts I have to execute to compile above objects?
The invalid PL/SQL packages DBMS_METADATA_INT and DBMS_METADATA_UTIL are well known issues in that upgrade procedure. Pleas try the following (as SYS):
SQL> alter package sys.dbms_metadata_util compile;
SQL> alter package sys.dbms_metadata_int compile;
You have to run the following SQL script to fix this issue, if the compilation fails with an error like "keyword VALUE used as a defined name" or "keyword TYPE used as a defined name":
SQL> @?/rdbms/admin/catpprvt.sql
If you get another error - please post it here.
PL/SQL package XDB_MIGRATESCHEMA is also a known issue as no XDB is installed by default in a SAP environment. You can drop the package or keep it as it is. It is not a problem.
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Stefan,
Thanks for your reply.
out of said commands
SQL> alter package sys.dbms_metadata_util compile;
Package altered.
SQL> alter package sys.dbms_metadata_int compile;
Package altered.
SQL> SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS = 'INVALID';
OBJECT_NAME
------------------------------------------------------------------------
XDB_MIGRATESCHEMA
how can i drop this?
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try to manually compile DBMS_* packages with
SQL> alter package <owner>.<package_name> compile;
command. If errors occur display them with
SQL> show errors
command and attach to message. Also check type of XDB_MIGRATESCHEMA object.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.