Re: Copying Oracle 10.2.0.4 Database to 11.2

From: John D Groenveld <groenvel_at_cse.psu.edu>
Date: Mon, 8 Aug 2011 15:59:16 +0000 (UTC)
Message-ID: <j1p14k$eg7a$1_at_tr22n12.aset.psu.edu>

In article <2e5d62d9-0155-4ab2-9c55-dff6c8ecc0f2_at_k3g2000vbz.googlegroups.com>, if_investor_at_yahoo.com <basis_consultant_at_hotmail.com> wrote:
>We have an SAP system (ECC6.0) running on Oracle 10.2.0.4 on Solaris
>5.9 in, say, servera.
>
>We are looking to copy it, and rename its Oracle SID, to a Solaris
>5.10 server (serverb)
>running Oracle 11.2.

Why rename the SID?

>The tentative plan is as follows:
>
>(i) Install SAP/Oracle 11.2 on serverb.
>(ii) Copy a cold backup of the servera database from tapes to serverb.
>(iii) Rename the database to the new SID using "Create controlfile set
>database....".
>(iv) Run the SAP tool that upgrades Oracle to 11.2 so that the
>database is upgraded (Skip the
>part that install the Oracle binaries). SAP documentation indicates
>that this step works.

Why not restore the cold backup of serverA to serverB and then upgrade SAP and Oracle on serverB?

John
groenveld_at_acm.org Received on Mon Aug 08 2011 - 10:59:16 CDT