Content Manager database server support history
Content Manager databases in SDL Tridion 2011 SP1 have a number of changed software prerequisites compared to version 5.3, 5.3 SP1, 2009, 2009 SP1 and 2011. If your current version of Oracle or SQL Server is not supported, you need to upgrade your Oracle or SQL Server before upgrading the Content Manager databases.
In the following table: N=not supported, Y=supported, D=Deprecated (support may be dropped in the next version release), Dr=Dropped (support is definitely dropped in the next version release), P=Probably dropped (support is probably dropped in the next version release):
| Database server | 5.3 | 5.3 SP1 | 2009 | 2009 SP1 | 2011 | 2011 SP1 |
|---|---|---|---|---|---|---|
| Microsoft SQL Server 2000 SP4 | Y | Y | N | N | N | N |
| Microsoft SQL Server 2005 SP2 | Y | D | N | N | N | N |
| Microsoft SQL Server 2005 SP3 | N | Y | Y | Y | Y | Dr |
| Microsoft SQL Server 2005 SP4 | N | N | N | N | N | P |
| Microsoft SQL Server 2008 SP1 | N | N | Y | Y | N | N |
| Microsoft SQL Server 2008 R2 | N | N | N | N | Y | Dr |
| Microsoft SQL Server 2008 R2 SP1 | N | N | N | N | N | Y |
| Oracle Database 9i Release 2 patch set 9.2.0.8 | Y | Y | N | N | N | N |
| Oracle Database 10g Release 2 patch set 10.2.0.2 | Y | D | N | N | N | N |
| Oracle Database 10g Release 2 patch set 10.2.0.3 | Y | D | N | N | N | N |
| Oracle Database 10g Release 2 patch set 10.2.0.4 | N | Y | Y | Y | N | N |
| Oracle Database 10g Release 2 patch set 10.2.0.5 | N | N | N | N | Y | Y |
| Oracle Database 10g Release 2 patch set 11.1.0.7 | N | N | Y | Y | N | N |
| Oracle Database 11g Release 2 patch set 11.2.0.1 | N | N | N | N | Y | Dr |
| Oracle Database 11g Release 2 patch set 11.2.0.2 | N | N | N | N | N | Y |
For Oracle 11.2.0.1, apply one of the following (publicly available) Oracle patches:
- Linux
-
On Linux, install the following patches:
Patch 10401379: ODP.NET APPL. CRASHES IN KOCTXED() - WHICH IS CALLING ITSELF UNTILL CRASHPatch 9053676: APPSST GSI 11G : ORA-07445: [KKQVSEARCHLOGOPN() [PC:0X104AAA664]
- Windows
-
On Windows, install the following patches:
Patch 10352691: ORACLE 11G 11.2.0.1 PATCH 9 BUG FOR 32 BITPatch 10352692: ORACLE 11G 11.2.0.1 PATCH 9 BUG FOR WINDOWS (64-BIT AMD64 AND INTEL EM64)