on 01-23-2010 7:54 PM
We are doing export of the Production <SID > for Quality <SID> new built system While doing this we encounter the following error. Export dump is taking long time it stuck at 147 of 148.
____________________________________________________________________________________________________
When we see the logs SAPAPPL1_56 * is generating like anything need to know is it a error or still writting something in Export file , as Logs are not generating in cd /saptemp/TEMP_1/sapinst_instdir/ERP/LM/COPY/ORA/EXP/CENTRAL/AS/EXP only ECC_Dump file is increasing
____________________________________________________________________________________________________
<hostname># ls -ltr |tail {Generating like anything}
-rw-rr 1 <sid>adm sapsys 1048576000 23 Jan 18:54 SAPAPPL1_56.067
-rw-rr 1 <sid>adm sapsys 1048576000 23 Jan 18:59 SAPAPPL1_56.068
-rw-rr 1 <sid>adm sapsys 1048576000 23 Jan 19:04 SAPAPPL1_56.069
-rw-rr 1 <sid>adm sapsys 1048576000 23 Jan 2010 SAPAPPL1_56.070
-rw-rr 1 <sid>adm sapsys 1029891072 23 Jan 2010 SAPAPPL1_56.071
____________________________________________________________________________________________________
<hostname># ps -ef |grep SID
ora<sid> 110612 1 5 12:56:23 - 12:52 oracle (LOCAL=NO)
<sid>adm 266480 1 0 11:48:37 - 0:00 ora_qmnc_<SID>
<sid>adm 319518 1 0 11:48:31 - 0:00 ora_lgwr_<SID>
<sid>adm 413876 1261632 96 12:56:22 pts/1 185:41 /usr/sap/<SID>/SYS/exe/run/R3load -e SAPAPPL1_56.cmd -datacodepage 4102 -l SAPAPPL1_56.log -stop_on_error
____________________________________________________________________________________________________
<hostname># cd /saptemp/TEMP_1/sapinst_instdir/ERP/LM/COPY/ORA/EXP/CENTRAL/AS/EXP
-rw-rr 1 <sid>adm sapsys 113 23 Jan 11:50 SAPAPPL1_56.TSK.bck
-rw-rr 1 <sid>adm sapsys 291 23 Jan 11:50 SAPAPPL1_56.cmd
-rw-rr 1 <sid>adm sapsys 0 23 Jan 13:04 SAPAPPL1_56.TSK
-rw-rr 1 <sid>adm sapsys 2396 23 Jan 13:04 SAPAPPL1_56.log
____________________________________________________________________________________________________
<hostname># cat SAPAPPL1_56.TSK
<hostname># cat SAPAPPL1_56.TSK.bck
D SOFFCONT1 E xeq
D SOFIND E xeq
D SOFM E xeq
D SOHS E xeq
D SOID E xeq
D SOIMAP E xeq
D SOMG E xeq
D SOOC E xeq
____________________________________________________________________________________________________
<hostname># cat SAPAPPL1_56.cmd
tsk: "/saptemp/TEMP_1/sapinst_instdir/ERP/LM/COPY/ORA/EXP/CENTRAL/AS/EXP/SAPAPPL1_56.TSK";
icf: "/saptemp/ECC_dump/ABAP/DATA/SAPAPPL1_56.STR";
dcf: "/saptemp/ECC_dump/ABAP/DB/DDLORA_LRG.TPL";
dat: "/saptemp/ECC_dump/ABAP/DATA/" bs=1k fs=1000M
dir: "/saptemp/ECC_dump/ABAP/DATA/SAPAPPL1_56.TOC";
____________________________________________________________________________________________________
<hostname># cat SAPAPPL1_56.log
/usr/sap/<SID>/SYS/exe/run/R3load: START OF LOG: 20100123114310
/usr/sap/<SID>/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#18 $ SAP
/usr/sap/<SID>/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Apr 2 2009 21:45:19
/usr/sap/<SID>/SYS/exe/run/R3load -ctf E /saptemp/ECC_dump/ABAP/DATA/SAPAPPL1_56.STR /saptemp/ECC_dump/ABAP/DB/DDLORA_LRG.TPL SAPAPPL1_56.TSK ORA -l SAPAPPL1_56.log
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
/usr/sap/<SID>/SYS/exe/run/R3load: job completed
/usr/sap/<SID>/SYS/exe/run/R3load: END OF LOG: 20100123114310
/usr/sap/<SID>/SYS/exe/run/R3load: START OF LOG: 20100123114310
/usr/sap/<SID>/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#18 $ SAP
/usr/sap/<SID>/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Apr 2 2009 21:45:19
/usr/sap/<SID>/SYS/exe/run/R3load -e SAPAPPL1_56.cmd -datacodepage 4102 -l SAPAPPL1_56.log -stop_on_error
DbSl Trace: CONNECT failed with sql error '1034'
DbSl Trace: CONNECT failed with sql error '1034'
(DB) ERROR: db_connect rc = 256
DbSl Trace: CONNECT failed with sql error '1034'
DbSl Trace: CONNECT failed with sql error '1034'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/<SID>/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/<SID>/SYS/exe/run/R3load: END OF LOG: 20100123114310
/usr/sap/<SID>/SYS/exe/run/R3load: START OF LOG: 20100123125623
/usr/sap/<SID>/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#18 $ SAP
/usr/sap/<SID>/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Apr 2 2009 21:45:19
/usr/sap/<SID>/SYS/exe/run/R3load -e SAPAPPL1_56.cmd -datacodepage 4102 -l SAPAPPL1_56.log -stop_on_error
DbSl Trace: ORA-1403 when accessing table SAPUSER
(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
(DB) INFO: Export without hintfile
(GSI) INFO: dbname = "<SID>20100115050158 "
(GSI) INFO: vname = "ORACLE "
(GSI) INFO: hostname = "<hostname> "
(GSI) INFO: sysname = "AIX"
(GSI) INFO: nodename = "<hostname>"
(GSI) INFO: release = "3"
(GSI) INFO: version = "5"
(GSI) INFO: machine = "0001DB91D600"
____________________________________________________________________________________________________
<hostname># cd /saptemp/TEMP_1/sapinst_instdir/ERP/LM/COPY/ORA/EXP/CENTRAL/AS/EXP
<hostname># ls -ltr |tail
-rw-rr 1 <sid>adm sapsys 15 23 Jan 15:00 SAPSSEXC_9.TSK
-rw-rr 1 <sid>adm sapsys 2770 23 Jan 15:00 SAPSSEXC_9.log
-rw-rr 1 <sid>adm sapsys 571 23 Jan 15:54 SAPSSEXC_7.TSK
-rw-rr 1 <sid>adm sapsys 4051 23 Jan 15:54 SAPSSEXC_7.log
-rw-rr 1 <sid>adm sapsys 13 23 Jan 16:44 SAPAPPL1_75.TSK
-rw-rr 1 <sid>adm sapsys 2734 23 Jan 16:44 SAPAPPL1_75.log
-rw-rr 1 <sid>adm sapsys 1967 23 Jan 16:44 export_state.properties
-rw-rr 1 <sid>adm sapsys 233556 23 Jan 17:30 export_monitor.log
-rw-r----- 1 root sapinst 29912 23 Jan 17:30 export_monitor.java.log
-rw-rr 1 <sid>adm sapsys 30778 23 Jan 17:30 ExportMonitor.console.log
____________________________________________________________________________________________________
<hostname># date
Sat 23 Jan 19:32:42 2010
Regards
Punit
Dear Punit,
Can you also see any TSK error in the log, which mean only a part of data was imported.
If yes then please refer to #455195 to merge the data.
Please make sure the user has enough authorization.
This seems because of some oracle connect issue.
I recommend you update your R3trans and R3load (especially R3load) to the latest patch level.
Then before try again, run following command to make a test:
R3load -testconnect
Best Regards,
Abhishek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
> DbSl Trace: CONNECT failed with sql error '1034'
>
> DbSl Trace: CONNECT failed with sql error '1034'
>
> (DB) ERROR: db_connect rc = 256
This error is in your logs. For this error, check SAP Note 491174 - Composite SAP note for ORA-01034
Thanks
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sunny,
Listener is still running.
Already gone through this note. 147 Jobs it went fine only 1 Job to finish in ABAP Export Phase.
I am not getting any error while checking the log it is not updating but while seeing the Dump location it is generating like anything.
This happens sencond time and I cancelled and rerun again . It again holt...how much time it will take to dump 800 GB of data and Comprasion rate. currently size of the dump is 150 GB.
If you required any other log ...
Regards
Punit Maini
Edited by: Punit Maini on Jan 23, 2010 9:51 PM
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.