Hi Gurus



I followed the Metalink Doc 4547809 for upgrading my Oracle DB 9.2.0.4 to
9.2.0.8. I got the below error in patch.log file. Can anyone help me in this
regarding? Shall I repeat the steps or to continue with the up-gradations.





Enter the following SQL*Plus commands:



SQL> STARTUP MIGRATE

SQL> SPOOL patch.log

SQL> @?/rdbms/admin/catpatch.sql

SQL> SPOOL OFF





Review the patch.log file for errors and inspect the list of components that
is displayed at the end of catpatch.sql script.



This list provides the version and status of each SERVER component in the
database.



Errors are given below:





create or replace type XMLType OID '00000000000000000000000000020100'

*

ERROR at line 1:

ORA-04021: timeout occurred while waiting to lock object SYS.XMLTYPE





create type XMLTypePI OID '0000000000000000000000000002014F' as

*

ERROR at line 1:

ORA-04021: timeout occurred while waiting to lock object SYS.XMLTYPEPI





grant execute on XMLTypePI to public with grant option

*

ERROR at line 1:

ORA-04021: timeout occurred while waiting to lock object SYS.XMLTYPEPI





Regards,



Utthaman




Oracle LazyDBA home page