on 08-10-2007 6:57 AM
Hi all,
maybe it's quite a simple question but I didn't find any answer in these forums.
I want to migrate my database from MAXDB to ORACLE.
My customer wants to have as little downtime as possible. Since r3szchk runs about 16 hours under SAPDB 7.3 it would help a lot to have the system online during this time.
Is that possible or will I run into problems while importing the database?
During the export itself the system will be shutdown of course.
Kind regards,
Bastian
Dear Bastian,
I'm performing the same issue, I'm exporting from Maxdb to Oracle with same OS (AIX)
I wish you could help with some problems I had, as I can't find the answers in the web.
Two errors happens during the export, the first one was during R3load.
After I couldn't correct it, I run it again, and another error appeared with R3szchk....
These are the log file for the Two errors.
For the first error with R3load I had the following
DBEXPORT.LOG
.
.
.
.
INFO 2007-12-19 14:22:25 DBEXPR3LOADEXEC_IND_ADA R3loadPrepare:0
Total number of processes: 15
0 process(es) finished successfully:
15 process(es) finished with errors: 0 1 2 3 4 5 6 7 8 9 10 11 12
13 14
0 process(es) still running:
ERROR 2007-12-19 14:22:25 DBEXPR3LOADEXEC_IND_ADA R3loadPrepare:0
Processes started: 15
Ended with error: 15
load tool ended with error.
See above SAP*.log errors.
ERROR 2007-12-19 14:22:25 DBEXPR3LOADEXEC_IND_ADA R3loadFork:0
RC code form SyChildFuncWait = 255 .
ERROR 2007-12-19 14:22:25 DBEXPR3LOADEXEC_IND_ADA R3loadFork:0
See logfiles SAPlog and EXlog for further information.
ERROR 2007-12-19 14:22:25 DBEXPR3LOADEXEC_IND_ADA InternalInstallationDo:0
R3loadFork erred
ERROR 2007-12-19 14:22:25 DBEXPR3LOADEXEC_IND_ADA InstallationDo:0
Phase failed.
ERROR 2007-12-19 14:22:25 InstController Action:0
Step DBEXPR3LOADEXEC_IND_ADA could not be performed.
ERROR 2007-12-19 14:22:25 Main
Installation failed.
ERROR 2007-12-19 14:22:25 Main
Installation aborted.
I don't have any EX""".log and the SAP""".log are all identical saying the following
START OF LOG: 20071219142222
R3load version @(#) $Id: //bas/46D/src/ins/R3load/R3load.c#16 $ SAP
R3load -e SAP""".cmd -p SAP""".log
start of syntax check
end of syntax check
(EXP) ERROR: DbSlControl failed
rc = 20
#STOP: 20071219142225
ONLY THAT
(The """ are for the different process)
.
.
.
.
The log from the second error (R3szchk) is the following
INFO 2007-12-20 16:32:15 R3SZCHK_IND_ADA R3ldctlDo:0
Error: Can not close lock
I need both solution if you have them
Thanks in advance
Roberto.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, it is possibile, but you must pay attention to the following extremely important point.
Since r3ldctl runs before r3szchk and no changes to tables definition must be done after starting r3ldctl.
Changing tables definition after running r3ldctl could lead to data loss or inconsistency!
To avoid this you must be sure that no change requests involving data dictionary (eg: add or delete table fields) are imported in the system during these steps.
The best way to ensure this is to stop all import of change request since you start R3SETUP/SAPINST.
Changing tables definition after running r3ldctl could lead to data loss or inconsistency!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.