System Copy/ Oracle Backup/Restore as part of moving from 32-bit to 64-bit

[former_member318733]

Source system: R3E47 Ext 2.00; SAP_BASIS 620; Kernel 640; Windows 2000 32-bit (I386) non-unicode

Target system (as preparation to upgrade to ERP6 EHP4): R3E47 Ext 2.00; SAP_BASIS 620; Kernel 640; Windows 2003 64-bit (x86-64/ ADM64) non-unicode

I upgraded the source system to Oracle 10.2.0.4 prior to installing (by homogeneous system copy) the source system on a 64-bit Windows 2003,

Actions on source system (Windows I386):

===================================

a) Upgraded database from Oracle 9.2.0.7 to 10.2.0.4

b) Used ora_br_copy.bat to generate CONTROL.SQL

c) Included at the end of CONTROL.SQL, the lines necessary to run utlirp.sql and utlrp.sql (necessary for the actual 32 to 64)

d) Switched logfiles

e) Performed backup offline

Actions on target system (64-bit x86-64/AMD64):

========================================

a) Installed Oracle Software 10.2.0.1 and patched it to 10.2.0.4

b) Used CD 51033746 "6.20/6.40 based products Installation Master (Edition May 2008)" to install the CI

c) Started installation of the DB instance using method System Copy/ Oracle Backup/Restore

Relevant parameters: SAPSID = IDT (same as source)

DBSID = IDT

Database Schema = SAPR3

Database Character Set = US7ASCII (same as source).

When the DB installation stopped:

d) Copied the datafiles and logfiles to the proper directories (same directory-tree layout as source)

e) Copied CONTROL.SQL (generated in the source system and edited to include utlirp.sql and utlrp.sql) to the installation directory C:Program Filessapinst_instdirR3E47X2SYSTEMABAPORANUCDB

f) Copied initIDT.ora (generated in the source system) to F:oracleIDT102database

g) Resumed SAPINST (by pressing OK in the popup)

**********************************************

Then I got the following errors:

ERROR 2009-08-18 11:00:25

MDB-06177 Bad entry in the init.ora file: Bad parameter value. Starts with '=' or white space or contains '(' or ')'. Line 5 near string ','.

ERROR 2009-08-18 11:00:25

MDB-06021 Could not read file: . .ora (presuming it is this one that is meant) corresponds to control_files=G:oracleIDTsapdata1cntrlcntrlIDT.dbf,F:oracleIDToriglogacntrlcntrlIDT.dbf,F:oracleIDTsaparchcntrlcntrlIDT.dbf which seems OK to me

As to the second error, I'm doing the DB installation with idtadm, who is a member of SAP_IDT_GlobalAdmin with Full control to every Oracle directory. Apart from the slashes in the path being in the wrong direction for Windows I don't know what is going on...

Hope somebody can help me

Inês Ferreira

Edited by: Ines Ferreira on Aug 18, 2009 7:51 PM

[david_byrne2 · Accepted solution]

Ines

I also had the problem where sapinst would not let me access the initsid.ora file.

And spent time looking at permissions and all kinds of things

The problem was that the control file entry in the file did not start with a ( and finish with a ).

I also had to put () around the event entries I had.

I was able to edit the file with wordpad and add the ()

So the entry might look something like after I changed it

control_files = (e:\control1.dbf ,e:\control2.dbf, e:\control3.dbf)

hope this helps

[Former Member]

Hey,

It worked for me...

Thanks for Solution...I was getting error in system import to 11.2.0.2

Regards,

Ishan

[markus_doehr2]

> As to the second error, I'm doing the DB installation with idtadm, who is a member of SAP_IDT_GlobalAdmin with Full control to every Oracle directory. Apart from the slashes in the path being in the wrong direction for Windows I don't know what is going on...

On Windows this can be tricky.

Only the fact, that you're logged on with a certain user doesn't imply that the process trying to access a directory is the same user. In your case you'll need to check under which user your OracleService<SID> is running - and that user needs to have access to the given directory.

Sapinst does a lot of user switching

Markus

[former_member318733]

Markus and David,

First let me thank you for your posts. :-).

Markus:

Thank you for the tip. However, I usually do installations with a domain adm user. It does a lot of user switching, yes, but then it only switches to users created by SAPINST, that is most of the time it is switching to <sid>adm, which sounds perfect. At the time of my post I had been setting some environment variables so as to try to get the procedure to distribute the various pieces and bits (saparch, sapbackup, saptrace, origlogs and mirror logs, datafiles, etc. exactly where I wanted them and not where the procedure wants them) so I ended up by using <sid>adm to perform the DB instance installation and not the domain adm user I had installed CI with (I forgot to change back). When I noticed I figured it wouldn't make a difference since it usually switches to <sid>adm anyway. However, for the next attempts I settled on ny initially created dom adm user and no change to the results. OracleService<SID> usually logs on as a system account so the issue doesn't arise, I think.

and

David:

The brackets did it. Thank you so much. It went further and only crashed later, I don't usually potter around sdn, so I'm not familiar with the workings of this, I don't know how to reply separately to the posts and I don't know how to include a properly formatted post (I've seen the Plain Text help but I hate to bother with sidetrack details) so I apologize to all for the probably-too-compact jumble that will come out when I post this. I am now looking at the following problem (same migration to 64) so I fear I may have to close this post and get back with a new one if I can't solve this next issue.

[david_byrne2]

Ines

I too am trying to upgrade to 64bit server and having various problems. check your oracle alert file in case there are errors there

you may need to update the word size for the 64bit install.

Errors like this in the oracle alert file would suggest that.,

ORA-12012

ORA-06544: PL/SQL: internal error, arguments: [ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [], []

ORA-06553