Database Copy

[Former Member]

I am doing an upgrade from 4.6C to ECC 6.0 (which will be in a new box)

Looks like I first need to install 4.6C on the new box and upgrade it there.

Is this the correct way to do? Is there a better way?

And my main question is how do I copy the system from the old 4.6C box to the new box? SAP has toold for MS-SQL that allows you to do that.

How about oracle? What is the best backup restore method for this?

[Former Member]

I am following the homogenous system copy guide (page 10-4, April 2001) for NT Oracle R/3 4.6. In the subsequent technical actions in the target system, there are many steps requiring to delete all entries in a table without deleting the table (mostly temp tables and tables such as TLOCK). When I use SE11 to do it, it is asking for a developer key as well as an object key. This does not make sense. It does not look like the correct way to do it. Please advice.

[andreas_herzog]

hi, plz <b>use sqlplus</b> to delete entries...

> sqlplus /nolog

> connect / as sysdba

> delete from sapr3.<tabname>;

> commit;

> exit

for <tabname> you have to insert the relevant table name, eg. TLOCK, MONI etc.

GreetZ, AH

[former_member204746]

if you do not want to rollback the deletion, it it much faster to use these

sqlplus /nolog

connect / as sysdba

REM delete the database statistics (transaction ST03)

truncate table sapr3.DBSTATTINF;

truncate table sapr3.DBSTATHORA;

truncate table sapr3.DBSTAIHORA;

truncate table sapr3.DBSTATIORA;

truncate table sapr3.DBSTATTORA;

REM delete performance statistics (transaction ST03)

truncate table sapr3.MONI;

truncate table sapr3.PAHI;

truncate table sapr3.OSMON;

truncate table sapr3.DBSNP;

REM truncate TEMSE

truncate table sapr3.TST03;

REM Truncate spools

truncate table sapr3.tsp01;

truncate table sapr3.tsp01P;

truncate table sapr3.tsp02;

truncate table sapr3.tsp02l;

truncate table sapr3.tsp02f;

truncate table sapr3.tsp02fx;

truncate table sapr3.tsp02T;

truncate table sapr3.tsp02W;

truncate table sapr3.tsp02A;

REM delete the table used for buffer synchronization (transaction SE16)

truncate table sapr3.DDLOG;

commit;

[Former Member]

Hi Andreas,

Does this delete table command delete the table or empty the table?

Shouldn't the command be truncate?

[former_member204746]

Aaron,

Delete will give you the possibility of using command rollback.

truncate in more drastic and rollback is not possible, but is also quicker.

[andreas_herzog]

a) backup/restore

use a backup made by brbackup to restore it on the target box...database is basically copied by using a tracefile which includes all necessary information...plz read the relevant documentation (homogeneous system copy...download it from sapnet) carefully!

b) r3 load

the source database is exported (and thus shrinked and reorganized) and afterwards imported during system installation; takes longer than the other two alternatives, sourec database must be down during export (= takes time); basically this method is similar to a standard installation; this alternative is used when doing a heterogeneous system copy (eg. database and/or operating system change)

c) r3copy

oracle datafiles are copied between the two boxes; fastest way (lan bandwith must be provided); source database is down during copy; building the target database is equal to alternative a) - plz read the docs carefully!!!

=> if you have the chance to keep the source system down, use alternative c) as it is the fastest way to copy a sap system under oracle; have a look @ sapnote 147.243 (if u'r on windows)

=> if u are unsure use method b) as it is the safest...but takes longer as u will have to make an export (source) and afterwards the import (target)

GreetZ, AH

[Former Member]

Hi Andreas Herzog, thanks for your reply.

Hi all,

I am doing the R3load method.

I have another question. On the target system, can I start of with Oracle 10g or must I install Oracle 8 (same version as source system) when doing the System Copy.

If I have to use Oracle 8, how do I upgrade to 10g? Are there are any guides for DB Upgrade?

[Former Member]

Hi

ref 829483 for upgrade to 10g on windows.Rec'tly i recieved recmdn from sap saynig to use upgrade assistant for upgrade.

We need to prepare target system according to supporting release and versions.

Have a look on Upgrade documentation for latest updates.

Regards

Vinod

[andreas_herzog]

=> plz use sapnot 948.305 (oracle 10.2 on windows)

as far as i recall....a direct upgrade from oracle 8i to oracle 10g is NOT supported by sap..("note that you can only upgrade Oracle database version 9.2.0.6 or higher to Oracle 10g")

<u>workaround:</u>

install 9.2 and apply patchset 8 (=> 9.2.0.8) and use it for the installation 46c (ci is 46c, db is 9.2); when finished with the installation, make the upgrade to 10.2 as described in the above mentioned sapnote [it is possible to use a 8i oracle export for an oracle 9i import!]

GreetZ, AH

[Former Member]

I am getting this error,

Info: InstController MakeStepsDeliver 2 967

Setting Environment

Info: InstController MakeStepsDeliver 2 969

Setting Environment

Error: DBCREATEINSTANCE_NT_ORA InternalWarmKeyCheck 2 635

Cannot execute: D:\oracle\ABC\102\BIN\ORADIM80.

Error: DBCREATEINSTANCE_NT_ORA WarmKeyCheck 2 635

Phase failed.

Error: Main {} 2 635

Installation aborted.

during the database import phase using DBMIG.R3S as described in the guide.

The file ORADIM80 does not exist in 10g

[andreas_herzog]

-> which kernel cd did you use? 46D_EXT?

-> have you read sapnotes 720886, 946141 and 940794?

you have to use a special kernel cd (a "patched" one) in order to succeed with the installation...and:

-> which oracle release do you use?

oradim80 belongs to oracle 8i...i think you are not using accurate r3s samples...you might have forgotten to update/patch your kernel cd...

GreetZ, AH

[Former Member]

Yes I am using the wrong kernel. Downloading the correct kernel now.

I am trying it on Oracle 10g 10202_Patch12. Do you think it would work or I still need to go with 8i or 9i?

I have sucessfully installed the central instance using the wrong kernel.

Now failed at R3load import using R3load file (exported from source 4.6c/8i)

Thank you in advance.

[andreas_herzog]

hmm....you export under oracle 8i...you should import under oracle 9i (see above...9.2.0.8 shoudl be accurate!)...i think 10g is not appropriate for an 8i export...even if it works, it will not be supported by sap (see above!)

could you plz post the error message/log?

GreetZ, AH

[Former Member]

Hi Andreas,

I have used the corrected kernel this time. Installation goes thru, except it keeps asking for Oracle Instant Client CD and fails.

INFO 2007-02-15 12:22:22 CommandFileController SyFileVersionSave:736

Saving original content of file

C:\Users\devadm\Install\CENTRAL.R3S ...

INFO 2007-02-15 12:22:22 CommandFileController SyFileCopy:676

Copying source file C:\Users\devadm\Install\CENTRAL.R3S to target

file C:\Users\devadm\Install\CENTRAL.R3S.3 ...

INFO 2007-02-15 12:22:22 CommandFileController SyPermissionSet:2207

Changing permission for file C:\Users\devadm\Install\CENTRAL.R3S

from 777 to 666.

INFO 2007-02-15 12:22:23 Main

Preparation successfully completed.

INFO 2007-02-15 12:22:23 CENTRALINSTANCE_NT_ORA SyCheckHostnameLookup:434

checking host name lookup for 'DEV'

INFO 2007-02-15 12:22:23 CENTRALINSTANCE_NT_ORA SyCheckHostnameLookup:473

offical host name for 'DEV' is 'DEV'.

INFO 2007-02-15 12:22:23 CENTRALINSTANCE_NT_ORA SyCheckHostnameLookup:541

host 'DEV' has ip address '192.168.4.7'

INFO 2007-02-15 12:22:23 CENTRALINSTANCE_NT_ORA SyCheckHostnameLookup:581

offical host name for '192.168.4.7' is 'DEV'.

INFO 2007-02-15 12:22:23 CENTRALINSTANCE_NT_ORA SyCheckHostnameLookup:434

checking host name lookup for 'DEV'

INFO 2007-02-15 12:22:23 CENTRALINSTANCE_NT_ORA SyCheckHostnameLookup:473

offical host name for 'DEV' is 'DEV'.

INFO 2007-02-15 12:22:23 CENTRALINSTANCE_NT_ORA SyCheckHostnameLookup:541

host 'DEV' has ip address '192.168.4.7'

INFO 2007-02-15 12:22:23 CENTRALINSTANCE_NT_ORA SyCheckHostnameLookup:581

offical host name for '192.168.4.7' is 'DEV'.

INFO 2007-02-15 12:22:23 CENTRALINSTANCE_NT_ORA SyCheckHostnameLookup:434

checking host name lookup for 'DEV'

INFO 2007-02-15 12:22:23 CENTRALINSTANCE_NT_ORA SyCheckHostnameLookup:473

offical host name for 'DEV' is 'DEV'.

INFO 2007-02-15 12:22:23 CENTRALINSTANCE_NT_ORA SyCheckHostnameLookup:541

host 'DEV' has ip address '192.168.4.7'

INFO 2007-02-15 12:22:23 CENTRALINSTANCE_NT_ORA SyCheckHostnameLookup:581

offical host name for '192.168.4.7' is 'DEV'.

INFO 2007-02-15 12:22:23 CENTRALINSTANCE_NT_ORA SyCheckHostnameLookup:434

checking host name lookup for 'DEV'

INFO 2007-02-15 12:22:23 CENTRALINSTANCE_NT_ORA SyCheckHostnameLookup:473

offical host name for 'DEV' is 'DEV'.

INFO 2007-02-15 12:22:23 CENTRALINSTANCE_NT_ORA SyCheckHostnameLookup:541

host 'DEV' has ip address '192.168.4.7'

INFO 2007-02-15 12:22:23 CENTRALINSTANCE_NT_ORA SyCheckHostnameLookup:581

offical host name for '192.168.4.7' is 'DEV'.

INFO 2007-02-15 12:22:23 CDSERVERKERNEL46CSR2_NT_ORA InternalColdKeyCheck:0

The CD KERNEL will not be copied.

INFO 2007-02-15 12:22:23 CDSERVERKERNEL46CSR2_NT_ORA InternalColdKeyCheck:0

The CD OracleInstantClient will not be copied.

INFO 2007-02-15 12:22:32 CENTRALINSTANCE_NT_ORA CheckValueForKey:0

The installation phase is starting now. Please look in the log

file for further information about current actions.

INFO 2007-02-15 12:22:32

Requesting Installation Details

INFO 2007-02-15 12:22:32

Requesting Database Installation Details

INFO 2007-02-15 12:22:32

Calculating RAM Distribution

INFO 2007-02-15 12:22:32 CDSERVERKERNEL46CSR2_NT_ORA InternalWarmKeyCheck:0

The CD KERNEL will not be copied.

INFO 2007-02-15 12:22:32 CDSERVERKERNEL46CSR2_NT_ORA InternalWarmKeyCheck:0

The CD OracleInstantClient will not be copied.

INFO 2007-02-15 12:22:32

Requesting Information on CD-ROMs

INFO 2007-02-15 12:22:32

Creating Local Group

INFO 2007-02-15 12:22:32

Creating Local Group

INFO 2007-02-15 12:22:32

Creating Global Group

INFO 2007-02-15 12:22:32

Modifying group SAP_LocalAdmin on SAPTRANSHOST

INFO 2007-02-15 12:22:32

Creating the SAP System Administrator

INFO 2007-02-15 12:22:32

Assigning User Rights to the SAP System Administrator

INFO 2007-02-15 12:22:32

Setting Password for for the SAP System Administrator

INFO 2007-02-15 12:22:32

Setting User Environment

INFO 2007-02-15 12:22:32

Creating the SAP Service Account

INFO 2007-02-15 12:22:32

Assigning Rights to the User SAPService<SAPSIDADM>

INFO 2007-02-15 12:22:32

Setting Password for for the SAP service user

INFO 2007-02-15 12:22:32

Survey of operating system user and group data

INFO 2007-02-15 12:22:32

Creating Directories

INFO 2007-02-15 12:22:32

Creating Directories

INFO 2007-02-15 12:22:32

Creating Shares

INFO 2007-02-15 12:22:32

Stopping the SAP Service

INFO 2007-02-15 12:22:32

Stopping the OS Collector Service

INFO 2007-02-15 12:22:32

Extracting the SAP Executables

INFO 2007-02-15 12:22:32

Extracting the SAP Executables

INFO 2007-02-15 12:22:32

Extracting the Database-Dependent SAP system Executables

INFO 2007-02-15 12:22:32

Extracting the Database-Dependent SAP system Executables

INFO 2007-02-15 12:22:32

Copying the Uninstall Program

INFO 2007-02-15 12:22:32

Registering the Uninstall Program

INFO 2007-02-15 12:22:32

Copying the Dialog Instance Files

INFO 2007-02-15 12:22:32

Extracting SAP Database Administration Tools.

INFO 2007-02-15 12:22:32

Extracting SAP Database Administration Tools.

INFO 2007-02-15 12:22:32

Extracting SAP Database Administration Tools.

INFO 2007-02-15 12:22:32

Extracting SAP Database Administration Tools.

INFO 2007-02-15 12:22:32

Extracting SAP Database Administration Tools.

INFO 2007-02-15 12:22:32

Extracting SAP Database Administration Tools.

<b>INFO 2007-02-15 12:22:32

Extracting Oracle Instant Client

INFO 2007-02-15 12:22:32 DBEXTRORAICLI386_NT_ORA CheckValueForKey:0

File D:/ecc6cd/oracle/OCL10232.SAR is not readable.

WARNING 2007-02-15 12:22:32 DBEXTRORAICLI386_NT_ORA CheckValueForKey:0

File D:/ECC6CD/ORACLE/OCL10232.CAR is not readable.

ERROR 2007-02-15 12:22:32 DBEXTRORAICLI386_NT_ORA InstallationDo:0

Phase failed.

ERROR 2007-02-15 12:22:32 InstController Action:0

Step DBEXTRORAICLI386_NT_ORA could not be performed.

ERROR 2007-02-15 12:22:33 Main

Installation failed.

ERROR 2007-02-15 12:22:33 Main

Installation aborted.</b>

[Former Member]

Opss the above problem has been solved.

Will keep this thread updated.

[Former Member]

Hi Andreas Herzog,

Thanks again for pointing out about the EXT kernel.

I have finished the installation but having the problems below: