Or it's windows, and it's to tough to figure out who still has the lock.

Reboot, retry.

Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546

-----Original Message-----
From: rjs [mailto:oracledba-ezmlmshield-x68937450.[Email address protected]
Sent: Thursday, June 28, 2007 5:37 AM
To: LazyDBA Discussion
Subject: Re: upgrading 9.2.0.4

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
>



---------------------------------------------------------------------
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