There is someone connected at the database!
Disconnect the session that uses the objects.

HtH
Rüdiger J. Schulz
sosys-berlin.de

On Thu, 28 Jun 2007 04:04:15 -0500, Paramasivan Utthaman
<oracledba-ezmlmshield-x16185770.[Email address protected] wrote:

> 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
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


Oracle LazyDBA home page