RE: 9205 to 9206

The lock observed is SHARE ROW EXCLUSIVE MODE LOCKS in the catalog database.
Platform 9206 Solaris 5.8 Generic 117350-24 Refer Metalink Note 247611.1 (we created indexes .. but it did not fix the problem)

Solution:
Doc ID: Note:3966722.8
Subject: Bug 3966722 - Concurrent RMAN backups wait on TM enqueue on CKP table
<Quote from Metalink>
Concurrent RMAN backups wait on TM enqueue on CKP table when multiple resyncs are performed in parallel for same/different databases. There is no error signaled, but the backup job will not continue until the resync in first job is completed. </Quote from Metalink)

We patched 9207 for the catalog server but we are using 9206 binary since our target dbs are <= 9206.
It helped fixed the problem.

For RMAN target Vs RMAN executable binary compatibility matrix refer Doc ID: Note:73431.1

HTH
GovindanK

On Wed, 17 Aug 2005 08:41:17 -0700, "GovindanK" <gkatteri_at_fastmail.fm> said:
> We moved all our dbs to 9206 ; All except the one which had RMAN
> catalog worked well. The catalog showed up locking and the OS rman cmd
> was not disconnecting later. We had to patch our 9206 catalog to 9207
> followed by using 9206 rman executable and the 9207 catalog (refer RMAN
> compatibility matrix). Now things are fine. I will give you the bug
> number and the matrix soon.
>
> HTH
>
> GovindanK
>
> > > From: raja rao [mailto:raja4list_at_yahoo.com]
> > > Sent: Tuesday, August 16, 2005 2:43 PM
> > > To: oracle list
> > > Subject: 9205 to 9206
> > > Hi All,
> > > we are planning to migrate from 9205 to 9206 (oracle apps 11.5.10).
> > > is 9206 stable compare with 9205 ?
> > > anybody encountered any issues ?
> > > Thanks,
> > > Raj

--
http://www.freelists.org/webpage/oracle-l