Home » RDBMS Server » Server Administration » enq: TT - contention when trying to offline a temporary tablespace (10.2.0.4 Sun Solaris ( RAC ))
enq: TT - contention when trying to offline a temporary tablespace [message #379662] Wed, 07 January 2009 09:33 Go to next message
Orna
Messages: 62
Registered: November 2008
Member
Hi

I issued a 'alter tablespace temp offline' command yesterday on one of my 3 node RAC 10.1.0.4 database.
It is hanging since with 'enq: TT - contention'.

Any ideas ?
I failed to find any Metalink/other references that are helpful

Thanks
Orna
Re: enq: TT - contention when trying to offline a temporary tablespace [message #379666 is a reply to message #379662] Wed, 07 January 2009 09:50 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Been accounted as bug.
Re: enq: TT - contention when trying to offline a temporary tablespace [message #379667 is a reply to message #379662] Wed, 07 January 2009 09:52 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
You should:

1. Gather evidence to log a call with Oracle Support. This will typically be 3 x systemstate dumps taken a couple of minutes apart.

2. Issue a shutdown abort and restart.

Please keep us in the loop.

Best of luck!

Frank

Re: enq: TT - contention when trying to offline a temporary tablespace [message #379674 is a reply to message #379666] Wed, 07 January 2009 10:29 Go to previous messageGo to next message
Orna
Messages: 62
Registered: November 2008
Member
HI

Do you happen to have the bug number or metalink doc # ?
I cannot find it

Thanks!
orna
Re: enq: TT - contention when trying to offline a temporary tablespace [message #379684 is a reply to message #379666] Wed, 07 January 2009 11:35 Go to previous message
Orna
Messages: 62
Registered: November 2008
Member
I believe its Bug 3833893
Previous Topic: Possible issues when migrating data from WE8ISO8859P1 to UTF8 (merged)
Next Topic: IO error while trying to put tablespace in read only mode
Goto Forum:
  


Current Time: Fri Dec 02 14:07:24 CST 2016

Total time taken to generate the page: 0.07478 seconds