RE: 9205 to 9206
The lock observed is SHARE ROW EXCLUSIVE MODE LOCKS in the catalog
Platform 9206 Solaris 5.8 Generic 117350-24
Refer Metalink Note 247611.1 (we created indexes .. but it did not fix
Doc ID: Note:3966722.8
Subject: Bug 3966722 - Concurrent RMAN backups wait on TM enqueue on CKP
<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
On Wed, 17 Aug 2005 08:41:17 -0700, "GovindanK" <gkatteri@(protected)>
> 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.
> > > From: raja rao [mailto:raja4list@(protected)]
> > > 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