on 02-10-2015 7:49 AM
Im installing SAP ECC6 on Solaris 10 with oracle , it is giving error while importing ABAP, after importing 25 jobs, please help to resolve this issue
Hi Arshad,
I think SAP is not able to connect to Database.
As there is a number of recursive SQL call as a result the session is getting occupied.
Cause of the error:
ORA-12801: error signaled in parallel query server P015
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
You need to change the value of session variable along with the process.
The default value of sessions is 800 in init<SID>.ora or spfile.
Kindly paste the output of the following command
select value from v$parameter where name = 'sessions';
select value from v$parameter where name = 'processes';
select value from v$parameter where name = 'transactions';
Moreover what value you have given "Number of Parallel Jobs" on the screen "SAP System Database Import"
If yo dont remember then follow the below steps and send the output
- Go to the installation directory ,
- Edit the file import_monitor_cmd.properties,
- Check the value of jobNum
With Regards
Ashutosh Chaturvedi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Arshad,
Have you increased the Tablespaces? If yes, then please share the result of the table space check sql code which I shared in my previous post...
I am again pasting it here. Just copy it and paste it in sql prompt and let me know the result..
SELECT /* + RULE */ df.tablespace_name "Tablespace",
df.bytes / (1024 * 1024) "Size (MB)",
SUM(fs.bytes) / (1024 * 1024) "Free (MB)",
Nvl(Round(SUM(fs.bytes) * 100 / df.bytes),1) "% Free",
Round((df.bytes - SUM(fs.bytes)) * 100 / df.bytes) "% Used"
FROM dba_free_space fs,
(SELECT tablespace_name,SUM(bytes) bytes
FROM dba_data_files
GROUP BY tablespace_name) df
WHERE fs.tablespace_name = df.tablespace_name
GROUP BY df.tablespace_name,df.bytes
UNION ALL
SELECT /* + RULE */ df.tablespace_name tspace,
fs.bytes / (1024 * 1024),
SUM(df.bytes_free) / (1024 * 1024),
Nvl(Round((SUM(fs.bytes) - df.bytes_used) * 100 / fs.bytes), 1),
Round((SUM(fs.bytes) - df.bytes_free) * 100 / fs.bytes)
FROM dba_temp_files fs,
(SELECT tablespace_name,bytes_free,bytes_used
FROM v$temp_space_header
GROUP BY tablespace_name,bytes_free,bytes_used) df
WHERE fs.tablespace_name = df.tablespace_name
GROUP BY df.tablespace_name,fs.bytes,df.bytes_free,df.bytes_used
ORDER BY 4 DESC;
Hi,
Have you executed the commands which i shared with you in my previous replies,also could you share size details of table spaces of your system ?
Addition to it please share updated sapinst_dev.log from the system.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Manual SQL commands would be as like
CREATE INDEX "SEOCOMPODF~TYP" ON "SEOCOMPODF" ( "TYPE" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 226603205 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL ;
&
CREATE INDEX "SEOCOMPODF~REF" ON "SEOCOMPODF" ( "REFCLSNAME" , "REFCMPNAME" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 112509283 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL ;
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Have you extended tablespace PSAPTEMP & PSAPSR3700 ?
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
ORA-12801: error signaled in parallel query server P040
Follow SAP recommendations for the above error from SAP Note 1714490 - Inst.Systems Based on NW 7.0 / 7.0 EHP 1-3 - UNIX/Oracle
Maximum of 2-3 parallel R3load processes per CPU
We recommend that you configure only a maximum of 2-3 parallel R3load processes per CPU. The default for the installation is 3 parallel R3load processes. Do not enter a value greater than '3' in the field "Number of Parallel Jobs" on the screen "SAP System Database Import".
Otherwise SAPinst may abort and you may find an error message like the following in SAPAPPL1.log:
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "BBP_PDHCF~0" ON "BBP_PDHCF" ( "CLIENT", "GUID" )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P038
ORA-00018: maximum number of sessions exceeded
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arshad,
You're getting issue due to low parameter values of oracle.Please consider SAP Note 398927 - ORA errors because dimensions of parameters are too small
ORA-12801: error signaled in parallel query server P011
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
Hope this will be helpful for you.
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please increase PSAPSR3700 Tablespace and check the other table spaces also , if you find any other tablespace is also rapidly getting filled up, increase that also.
Then Re run the process.
Table space check query from sql prompt .
"
SELECT /* + RULE */ df.tablespace_name "Tablespace",
df.bytes / (1024 * 1024) "Size (MB)",
SUM(fs.bytes) / (1024 * 1024) "Free (MB)",
Nvl(Round(SUM(fs.bytes) * 100 / df.bytes),1) "% Free",
Round((df.bytes - SUM(fs.bytes)) * 100 / df.bytes) "% Used"
FROM dba_free_space fs,
(SELECT tablespace_name,SUM(bytes) bytes
FROM dba_data_files
GROUP BY tablespace_name) df
WHERE fs.tablespace_name = df.tablespace_name
GROUP BY df.tablespace_name,df.bytes
UNION ALL
SELECT /* + RULE */ df.tablespace_name tspace,
fs.bytes / (1024 * 1024),
SUM(df.bytes_free) / (1024 * 1024),
Nvl(Round((SUM(fs.bytes) - df.bytes_used) * 100 / fs.bytes), 1),
Round((SUM(fs.bytes) - df.bytes_free) * 100 / fs.bytes)
FROM dba_temp_files fs,
(SELECT tablespace_name,bytes_free,bytes_used
FROM v$temp_space_header
GROUP BY tablespace_name,bytes_free,bytes_used) df
WHERE fs.tablespace_name = df.tablespace_name
GROUP BY df.tablespace_name,fs.bytes,df.bytes_free,df.bytes_used
ORDER BY 4 DESC;"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Also could you execute manually below commands at SQL prompt
CREATE INDEX "SEOCOMPODF~TYP" ON "SEOCOMPODF" ( "TYPE" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 226603205 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
&
(CREATE INDEX "SEOCOMPODF~REF" ON "SEOCOMPODF" ( "REFCLSNAME" , "REFCMPNAME" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 112509283 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
After that retry the process and share the results.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arshad,
Could you check size of table space PSAPTEMP & PSAPSR3700, if possible try to extend if required and re run the process.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please share previous requested log files for analysis.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please see below logs
DD03L.log
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150203211902
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -ctf I /dumps/d51033500_2/EXP9/DATA/DD03L.STR /sap_installation/DDLORA_LRG.TPL DD03L.TSK ORA -l DD03L.log
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
/usr/sap/PRD/SYS/exe/run/R3load: job completed
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150203211902
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150203211902
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) INFO: DD03L created #20150203211903
(IMP) INFO: import of DD03L completed (4952599 rows) #20150203212406
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "DD03L~0" ON "DD03L" ( "TABNAME", "FIELDNAME", "AS4LOCAL", "AS4VERS", "POSITION" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 712194033 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P014
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150203213416
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204100716
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~0")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: DD03L~0 created #20150204101226
(DB) INFO: DD03L~1 created #20150204101641
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~2" ON "DD03L" ( "ROLLNAME" , "AS4LOCAL" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 373901867 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P005
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204101648
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204121102
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~2")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~2" ON "DD03L" ( "ROLLNAME" , "AS4LOCAL" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 373901867 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P011
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204121118
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204122026
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~2")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: DD03L~2 created #20150204122148
(DB) INFO: DD03L~3 created #20150204122416
(DB) INFO: DD03L~4 created #20150204122557
(DB) INFO: DD03L~5 created #20150204123002
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~6" ON "DD03L" ( "PRECFIELD" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 364999442 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P021
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204123006
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204150952
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~6")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~6" ON "DD03L" ( "PRECFIELD" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 364999442 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P008
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151000
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204151105
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~6")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~6" ON "DD03L" ( "PRECFIELD" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 364999442 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P014
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151109
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204151220
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~6")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~6" ON "DD03L" ( "PRECFIELD" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 364999442 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P018
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151224
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204161258
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204161258
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204161342
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204161342
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204164456
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204164456
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150210121132
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150210121132
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150210121211
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150210121211
SEOCOMPODF.log
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150203213433
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -ctf I /dumps/d51033500_1/EXP6/DATA/SEOCOMPODF.STR /sap_installation/DDLORA_LRG.TPL SEOCOMPODF.TSK ORA -l SEOCOMPODF.log
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
/usr/sap/PRD/SYS/exe/run/R3load: job completed
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150203213433
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150203213433
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) INFO: SEOCOMPODF created #20150203213433
(IMP) INFO: import of SEOCOMPODF completed (881566 rows) #20150203213909
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "SEOCOMPODF~0" ON "SEOCOMPODF" ( "CLSNAME", "CMPNAME", "VERSION" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 114093921 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P030
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150203213928
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204100716
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "SEOCOMPODF~0")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "SEOCOMPODF~0" ON "SEOCOMPODF" ( "CLSNAME", "CMPNAME", "VERSION" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 114093921 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P029
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204100720
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204121102
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "SEOCOMPODF~0")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: SEOCOMPODF~0 created #20150204121453
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "SEOCOMPODF~REF" ON "SEOCOMPODF" ( "REFCLSNAME" , "REFCMPNAME" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 112509283 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P015
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204121457
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204122026
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "SEOCOMPODF~REF")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "SEOCOMPODF~REF" ON "SEOCOMPODF" ( "REFCLSNAME" , "REFCMPNAME" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 112509283 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P040
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204122033
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204150952
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "SEOCOMPODF~REF")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: SEOCOMPODF~REF created #20150204151004
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "SEOCOMPODF~TYP" ON "SEOCOMPODF" ( "TYPE" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 226603205 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P025
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151006
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204151105
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151105
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204151220
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151220
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204161258
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204161258
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204161342
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204161342
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204164456
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204164456
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150210121132
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150210121132
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150210121211
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150210121211
Could you restart the system & try to rerun the process.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arshad,
Please share log file SEOCOMPODF.log & DD03L.log .
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please see below logs
DD03L.log
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150203211902
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -ctf I /dumps/d51033500_2/EXP9/DATA/DD03L.STR /sap_installation/DDLORA_LRG.TPL DD03L.TSK ORA -l DD03L.log
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
/usr/sap/PRD/SYS/exe/run/R3load: job completed
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150203211902
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150203211902
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) INFO: DD03L created #20150203211903
(IMP) INFO: import of DD03L completed (4952599 rows) #20150203212406
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "DD03L~0" ON "DD03L" ( "TABNAME", "FIELDNAME", "AS4LOCAL", "AS4VERS", "POSITION" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 712194033 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P014
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150203213416
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204100716
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~0")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: DD03L~0 created #20150204101226
(DB) INFO: DD03L~1 created #20150204101641
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~2" ON "DD03L" ( "ROLLNAME" , "AS4LOCAL" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 373901867 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P005
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204101648
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204121102
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~2")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~2" ON "DD03L" ( "ROLLNAME" , "AS4LOCAL" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 373901867 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P011
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204121118
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204122026
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~2")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: DD03L~2 created #20150204122148
(DB) INFO: DD03L~3 created #20150204122416
(DB) INFO: DD03L~4 created #20150204122557
(DB) INFO: DD03L~5 created #20150204123002
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~6" ON "DD03L" ( "PRECFIELD" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 364999442 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P021
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204123006
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204150952
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~6")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~6" ON "DD03L" ( "PRECFIELD" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 364999442 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P008
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151000
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204151105
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~6")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~6" ON "DD03L" ( "PRECFIELD" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 364999442 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P014
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151109
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204151220
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~6")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~6" ON "DD03L" ( "PRECFIELD" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 364999442 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P018
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151224
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204161258
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204161258
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204161342
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204161342
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204164456
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204164456
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150210121132
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150210121132
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150210121211
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150210121211
SEOCOMPODF.log
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150203213433
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -ctf I /dumps/d51033500_1/EXP6/DATA/SEOCOMPODF.STR /sap_installation/DDLORA_LRG.TPL SEOCOMPODF.TSK ORA -l SEOCOMPODF.log
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
/usr/sap/PRD/SYS/exe/run/R3load: job completed
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150203213433
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150203213433
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) INFO: SEOCOMPODF created #20150203213433
(IMP) INFO: import of SEOCOMPODF completed (881566 rows) #20150203213909
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "SEOCOMPODF~0" ON "SEOCOMPODF" ( "CLSNAME", "CMPNAME", "VERSION" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 114093921 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P030
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150203213928
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204100716
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "SEOCOMPODF~0")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "SEOCOMPODF~0" ON "SEOCOMPODF" ( "CLSNAME", "CMPNAME", "VERSION" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 114093921 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P029
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204100720
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204121102
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "SEOCOMPODF~0")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: SEOCOMPODF~0 created #20150204121453
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "SEOCOMPODF~REF" ON "SEOCOMPODF" ( "REFCLSNAME" , "REFCMPNAME" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 112509283 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P015
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204121457
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204122026
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "SEOCOMPODF~REF")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "SEOCOMPODF~REF" ON "SEOCOMPODF" ( "REFCLSNAME" , "REFCMPNAME" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 112509283 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P040
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204122033
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204150952
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "SEOCOMPODF~REF")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: SEOCOMPODF~REF created #20150204151004
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "SEOCOMPODF~TYP" ON "SEOCOMPODF" ( "TYPE" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 226603205 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P025
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151006
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204151105
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151105
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204151220
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151220
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204161258
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204161258
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204161342
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204161342
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204164456
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204164456
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150210121132
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150210121132
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150210121211
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150210121211
Hello Arshad,
From the Import Monitor log, we can only get to know that 2 R3Load Jobs has been failed while DD03L import and SEOCOMPODF import. But this is not the actual error.
I suggest you to check DD03L.log and SEOCOMPODF.log and search for error line "/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error" and "/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error". Search 4/5 lines up-down below those lines and you will find the actaul error information. Also check SEOCOMPODF.TSK and DD03L.TSK files for last import status "OK" or not.
Sometimes these R3load jobs might fail due to Lack of Memory Allocation during Runtime. In that case increase Physical Memory.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please see below logs
Physical Memory installed is 32GB
DD03L.log
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150203211902
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -ctf I /dumps/d51033500_2/EXP9/DATA/DD03L.STR /sap_installation/DDLORA_LRG.TPL DD03L.TSK ORA -l DD03L.log
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
/usr/sap/PRD/SYS/exe/run/R3load: job completed
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150203211902
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150203211902
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) INFO: DD03L created #20150203211903
(IMP) INFO: import of DD03L completed (4952599 rows) #20150203212406
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "DD03L~0" ON "DD03L" ( "TABNAME", "FIELDNAME", "AS4LOCAL", "AS4VERS", "POSITION" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 712194033 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P014
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150203213416
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204100716
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~0")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: DD03L~0 created #20150204101226
(DB) INFO: DD03L~1 created #20150204101641
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~2" ON "DD03L" ( "ROLLNAME" , "AS4LOCAL" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 373901867 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P005
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204101648
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204121102
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~2")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~2" ON "DD03L" ( "ROLLNAME" , "AS4LOCAL" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 373901867 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P011
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204121118
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204122026
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~2")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: DD03L~2 created #20150204122148
(DB) INFO: DD03L~3 created #20150204122416
(DB) INFO: DD03L~4 created #20150204122557
(DB) INFO: DD03L~5 created #20150204123002
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~6" ON "DD03L" ( "PRECFIELD" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 364999442 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P021
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204123006
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204150952
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~6")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~6" ON "DD03L" ( "PRECFIELD" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 364999442 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P008
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151000
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204151105
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~6")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~6" ON "DD03L" ( "PRECFIELD" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 364999442 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P014
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151109
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204151220
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~6")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~6" ON "DD03L" ( "PRECFIELD" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 364999442 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P018
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151224
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204161258
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204161258
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204161342
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204161342
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204164456
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204164456
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150210121132
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150210121132
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150210121211
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150210121211
SEOCOMPODF.log
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150203213433
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -ctf I /dumps/d51033500_1/EXP6/DATA/SEOCOMPODF.STR /sap_installation/DDLORA_LRG.TPL SEOCOMPODF.TSK ORA -l SEOCOMPODF.log
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
/usr/sap/PRD/SYS/exe/run/R3load: job completed
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150203213433
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150203213433
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) INFO: SEOCOMPODF created #20150203213433
(IMP) INFO: import of SEOCOMPODF completed (881566 rows) #20150203213909
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "SEOCOMPODF~0" ON "SEOCOMPODF" ( "CLSNAME", "CMPNAME", "VERSION" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 114093921 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P030
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150203213928
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204100716
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "SEOCOMPODF~0")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "SEOCOMPODF~0" ON "SEOCOMPODF" ( "CLSNAME", "CMPNAME", "VERSION" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 114093921 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P029
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204100720
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204121102
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "SEOCOMPODF~0")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: SEOCOMPODF~0 created #20150204121453
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "SEOCOMPODF~REF" ON "SEOCOMPODF" ( "REFCLSNAME" , "REFCMPNAME" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 112509283 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P015
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204121457
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204122026
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "SEOCOMPODF~REF")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "SEOCOMPODF~REF" ON "SEOCOMPODF" ( "REFCLSNAME" , "REFCMPNAME" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 112509283 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P040
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204122033
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204150952
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "SEOCOMPODF~REF")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: SEOCOMPODF~REF created #20150204151004
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "SEOCOMPODF~TYP" ON "SEOCOMPODF" ( "TYPE" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 226603205 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P025
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151006
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204151105
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151105
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204151220
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151220
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204161258
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204161258
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204161342
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204161342
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204164456
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204164456
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150210121132
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150210121132
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150210121211
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150210121211
Hi,
Could you share exact error logs & details ?
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Rana,
Below is error log taken from import_monito.log
INFO: 2015-02-10 12:11:30
Import Monitor is started.
CONFIG: 2015-02-10 12:11:30
Application options:
dbCodepage=4103
dbType=ORA
ddlMap=ddl_mapping.txt
extFiles=yes
importDirs=/dumps/d51033500_1/EXP1:/dumps/d51033500_1/EXP2:/dumps/d51033500_1/EXP3:/dumps/d51033500_1/EXP4:/dumps/d51033500_1/EXP5:/dumps/d51033500_1/EXP6:/dumps/d51033500_2/EXP7:/dumps/d51033500_2/EXP8:/dumps/d51033500_2/EXP9:/dumps/d51033500_2/EXP10:/dumps/d51033500_2/EXP11
installDir=/sap_installation
jobNum=3
loadArgs=-stop_on_error
monitorTimeout=30
orderBy=
r3loadExe=/usr/sap/PRD/SYS/exe/run/R3load
sapinst=
trace=all
tskFiles=yes
CONFIG: 2015-02-10 12:11:30
List of packages with table structure: 'SAP0000'.
CONFIG: 2015-02-10 12:11:30
List of packages with views: 'SAPVIEW'.
TRACE: 2015-02-10 12:11:30 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA.TPL' template file is started.
INFO: 2015-02-10 12:11:30 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA.TPL' template file is successfully completed.
Primary key creation: after load.
Index creation: after load.
TRACE: 2015-02-10 12:11:30 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA_LRG.TPL' template file is started.
INFO: 2015-02-10 12:11:30 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA_LRG.TPL' template file is successfully completed.
Primary key creation: after load.
Index creation: after load.
TRACE: 2015-02-10 12:11:30 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA.TPL' template file is started.
INFO: 2015-02-10 12:11:30 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA.TPL' template file is successfully completed.
Primary key creation: after load.
Index creation: after load.
INFO: 2015-02-10 12:11:30
Data codepage 1100 is determined using TOC file '/dumps/d51033500_1/EXP1/DATA/SAPSSEXC.TOC' for package 'SAPSSEXC'.
INFO: 2015-02-10 12:11:31
Version table 'SVERS' is found in STR file '/dumps/d51033500_2/EXP10/DATA/SAPNTAB.STR' from package 'SAPNTAB'.
INFO: 2015-02-10 12:11:31
Data conversion tables 'DDNTF,DDNTF_CONV_UC,DDNTT,DDNTT_CONV_UC' are found in STR file '/dumps/d51033500_2/EXP10/DATA/SAPNTAB.STR' from package 'SAPNTAB'.
TRACE: 2015-02-10 12:11:31 com.sap.inst.migmon.LoadTask run
Loading of 'DD03L' import package is started.
TRACE: 2015-02-10 12:11:31 com.sap.inst.migmon.LoadTask run
Loading of 'SEOCOMPODF' import package is started.
TRACE: 2015-02-10 12:11:31 com.sap.inst.migmon.LoadTask processPackage
Loading of 'DD03L' import package into database:
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
TRACE: 2015-02-10 12:11:31 com.sap.inst.migmon.LoadTask processPackage
Loading of 'SEOCOMPODF' import package into database:
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
ERROR: 2015-02-10 12:11:32 com.sap.inst.migmon.LoadTask run
Loading of 'SEOCOMPODF' import package is interrupted with R3load error.
Process '/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error' exited with return code 2.
For mode details see 'SEOCOMPODF.log' file.
Standard error output:
sapparam: sapargv( argc, argv) has not been called.
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
ERROR: 2015-02-10 12:11:32 com.sap.inst.migmon.LoadTask run
Loading of 'DD03L' import package is interrupted with R3load error.
Process '/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error' exited with return code 2.
For mode details see 'DD03L.log' file.
Standard error output:
sapparam: sapargv( argc, argv) has not been called.
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
WARNING: 2015-02-10 12:12:00
Cannot start import of packages with views because not all import packages with tables are loaded successfully.
WARNING: 2015-02-10 12:12:00
2 error(s) during processing of packages.
INFO: 2015-02-10 12:12:00
Import Monitor is stopped.
INFO: 2015-02-10 12:12:10
Import Monitor is started.
CONFIG: 2015-02-10 12:12:10
Application options:
dbCodepage=4103
dbType=ORA
ddlMap=ddl_mapping.txt
extFiles=yes
importDirs=/dumps/d51033500_1/EXP1:/dumps/d51033500_1/EXP2:/dumps/d51033500_1/EXP3:/dumps/d51033500_1/EXP4:/dumps/d51033500_1/EXP5:/dumps/d51033500_1/EXP6:/dumps/d51033500_2/EXP7:/dumps/d51033500_2/EXP8:/dumps/d51033500_2/EXP9:/dumps/d51033500_2/EXP10:/dumps/d51033500_2/EXP11
installDir=/sap_installation
jobNum=3
loadArgs=-stop_on_error
monitorTimeout=30
orderBy=
r3loadExe=/usr/sap/PRD/SYS/exe/run/R3load
sapinst=
trace=all
tskFiles=yes
CONFIG: 2015-02-10 12:12:10
List of packages with table structure: 'SAP0000'.
CONFIG: 2015-02-10 12:12:10
List of packages with views: 'SAPVIEW'.
TRACE: 2015-02-10 12:12:10 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA.TPL' template file is started.
INFO: 2015-02-10 12:12:10 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA.TPL' template file is successfully completed.
Primary key creation: after load.
Index creation: after load.
TRACE: 2015-02-10 12:12:10 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA_LRG.TPL' template file is started.
INFO: 2015-02-10 12:12:10 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA_LRG.TPL' template file is successfully completed.
Primary key creation: after load.
Index creation: after load.
TRACE: 2015-02-10 12:12:10 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA.TPL' template file is started.
INFO: 2015-02-10 12:12:10 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA.TPL' template file is successfully completed.
Primary key creation: after load.
Index creation: after load.
INFO: 2015-02-10 12:12:10
Data codepage 1100 is determined using TOC file '/dumps/d51033500_1/EXP1/DATA/SAPSSEXC.TOC' for package 'SAPSSEXC'.
INFO: 2015-02-10 12:12:11
Version table 'SVERS' is found in STR file '/dumps/d51033500_2/EXP10/DATA/SAPNTAB.STR' from package 'SAPNTAB'.
INFO: 2015-02-10 12:12:11
Data conversion tables 'DDNTF,DDNTF_CONV_UC,DDNTT,DDNTT_CONV_UC' are found in STR file '/dumps/d51033500_2/EXP10/DATA/SAPNTAB.STR' from package 'SAPNTAB'.
TRACE: 2015-02-10 12:12:11 com.sap.inst.migmon.LoadTask run
Loading of 'DD03L' import package is started.
TRACE: 2015-02-10 12:12:11 com.sap.inst.migmon.LoadTask run
Loading of 'SEOCOMPODF' import package is started.
TRACE: 2015-02-10 12:12:11 com.sap.inst.migmon.LoadTask processPackage
Loading of 'DD03L' import package into database:
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
TRACE: 2015-02-10 12:12:11 com.sap.inst.migmon.LoadTask processPackage
Loading of 'SEOCOMPODF' import package into database:
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
ERROR: 2015-02-10 12:12:11 com.sap.inst.migmon.LoadTask run
Loading of 'DD03L' import package is interrupted with R3load error.
Process '/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error' exited with return code 2.
For mode details see 'DD03L.log' file.
Standard error output:
sapparam: sapargv( argc, argv) has not been called.
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
ERROR: 2015-02-10 12:12:11 com.sap.inst.migmon.LoadTask run
Loading of 'SEOCOMPODF' import package is interrupted with R3load error.
Process '/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error' exited with return code 2.
For mode details see 'SEOCOMPODF.log' file.
Standard error output:
sapparam: sapargv( argc, argv) has not been called.
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
WARNING: 2015-02-10 12:12:40
Cannot start import of packages with views because not all import packages with tables are loaded successfully.
WARNING: 2015-02-10 12:12:40
2 error(s) during processing of packages.
INFO: 2015-02-10 12:12:40
Dear Sunil,
Please see below logs
DD02L.log
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150203211902
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -ctf I /dumps/d51033500_2/EXP9/DATA/DD03L.STR /sap_installation/DDLORA_LRG.TPL DD03L.TSK ORA -l DD03L.log
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
/usr/sap/PRD/SYS/exe/run/R3load: job completed
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150203211902
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150203211902
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) INFO: DD03L created #20150203211903
(IMP) INFO: import of DD03L completed (4952599 rows) #20150203212406
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "DD03L~0" ON "DD03L" ( "TABNAME", "FIELDNAME", "AS4LOCAL", "AS4VERS", "POSITION" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 712194033 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P014
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150203213416
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204100716
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~0")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: DD03L~0 created #20150204101226
(DB) INFO: DD03L~1 created #20150204101641
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~2" ON "DD03L" ( "ROLLNAME" , "AS4LOCAL" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 373901867 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P005
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204101648
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204121102
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~2")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~2" ON "DD03L" ( "ROLLNAME" , "AS4LOCAL" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 373901867 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P011
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204121118
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204122026
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~2")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: DD03L~2 created #20150204122148
(DB) INFO: DD03L~3 created #20150204122416
(DB) INFO: DD03L~4 created #20150204122557
(DB) INFO: DD03L~5 created #20150204123002
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~6" ON "DD03L" ( "PRECFIELD" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 364999442 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P021
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204123006
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204150952
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~6")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~6" ON "DD03L" ( "PRECFIELD" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 364999442 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P008
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151000
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204151105
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~6")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~6" ON "DD03L" ( "PRECFIELD" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 364999442 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P014
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151109
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204151220
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "DD03L~6")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "DD03L~6" ON "DD03L" ( "PRECFIELD" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 364999442 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P018
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151224
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204161258
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204161258
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204161342
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204161342
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204164456
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204164456
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150210121132
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150210121132
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150210121211
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150210121211
SEOCOMPODF.log
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150203213433
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -ctf I /dumps/d51033500_1/EXP6/DATA/SEOCOMPODF.STR /sap_installation/DDLORA_LRG.TPL SEOCOMPODF.TSK ORA -l SEOCOMPODF.log
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
/usr/sap/PRD/SYS/exe/run/R3load: job completed
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150203213433
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150203213433
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) INFO: SEOCOMPODF created #20150203213433
(IMP) INFO: import of SEOCOMPODF completed (881566 rows) #20150203213909
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "SEOCOMPODF~0" ON "SEOCOMPODF" ( "CLSNAME", "CMPNAME", "VERSION" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 114093921 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P030
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150203213928
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204100716
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "SEOCOMPODF~0")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "SEOCOMPODF~0" ON "SEOCOMPODF" ( "CLSNAME", "CMPNAME", "VERSION" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 114093921 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P029
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204100720
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204121102
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "SEOCOMPODF~0")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: SEOCOMPODF~0 created #20150204121453
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "SEOCOMPODF~REF" ON "SEOCOMPODF" ( "REFCLSNAME" , "REFCMPNAME" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 112509283 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P015
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204121457
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204122026
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "SEOCOMPODF~REF")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "SEOCOMPODF~REF" ON "SEOCOMPODF" ( "REFCLSNAME" , "REFCMPNAME" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 112509283 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P040
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204122033
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204150952
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.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
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(DB) ERROR: DDL statement failed
(DROP INDEX "SEOCOMPODF~REF")
DbSlExecute: rc = 103
(SQL error 1418)
error message returned by DbSl:
ORA-01418: specified index does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: SEOCOMPODF~REF created #20150204151004
DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)
(DB) ERROR: DDL statement failed
(CREATE INDEX "SEOCOMPODF~TYP" ON "SEOCOMPODF" ( "TYPE" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 226603205 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )
DbSlExecute: rc = 99
(SQL error 12801)
error message returned by DbSl:
ORA-12801: error signaled in parallel query server P025
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151006
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204151105
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151105
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204151220
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12537
DbSl Trace: CONNECT failed with sql error '12537'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204151220
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204161258
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204161258
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204161342
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204161342
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150204164456
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150204164456
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150210121132
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150210121132
/usr/sap/PRD/SYS/exe/run/R3load: START OF LOG: 20150210121211
/usr/sap/PRD/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/PRD/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 18:18:30
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541
DbSl Trace: CONNECT failed with sql error '12541'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/PRD/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/PRD/SYS/exe/run/R3load: END OF LOG: 20150210121211
you are getting below errors
ORA-12801: error signaled in parallel query server P025
ORA-00604: error occurred at recursive SQL level 2
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB
How many parallel R3load processes you have configured per CPU? You should not enter more than 3 processes per CPU. Search for above ora errors on SAP marketplace.
No one will help you unless you provide the detailed error logs.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Sunil,
Here is error log
INFO: 2015-02-10 12:11:30
Import Monitor is started.
CONFIG: 2015-02-10 12:11:30
Application options:
dbCodepage=4103
dbType=ORA
ddlMap=ddl_mapping.txt
extFiles=yes
importDirs=/dumps/d51033500_1/EXP1:/dumps/d51033500_1/EXP2:/dumps/d51033500_1/EXP3:/dumps/d51033500_1/EXP4:/dumps/d51033500_1/EXP5:/dumps/d51033500_1/EXP6:/dumps/d51033500_2/EXP7:/dumps/d51033500_2/EXP8:/dumps/d51033500_2/EXP9:/dumps/d51033500_2/EXP10:/dumps/d51033500_2/EXP11
installDir=/sap_installation
jobNum=3
loadArgs=-stop_on_error
monitorTimeout=30
orderBy=
r3loadExe=/usr/sap/PRD/SYS/exe/run/R3load
sapinst=
trace=all
tskFiles=yes
CONFIG: 2015-02-10 12:11:30
List of packages with table structure: 'SAP0000'.
CONFIG: 2015-02-10 12:11:30
List of packages with views: 'SAPVIEW'.
TRACE: 2015-02-10 12:11:30 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA.TPL' template file is started.
INFO: 2015-02-10 12:11:30 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA.TPL' template file is successfully completed.
Primary key creation: after load.
Index creation: after load.
TRACE: 2015-02-10 12:11:30 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA_LRG.TPL' template file is started.
INFO: 2015-02-10 12:11:30 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA_LRG.TPL' template file is successfully completed.
Primary key creation: after load.
Index creation: after load.
TRACE: 2015-02-10 12:11:30 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA.TPL' template file is started.
INFO: 2015-02-10 12:11:30 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA.TPL' template file is successfully completed.
Primary key creation: after load.
Index creation: after load.
INFO: 2015-02-10 12:11:30
Data codepage 1100 is determined using TOC file '/dumps/d51033500_1/EXP1/DATA/SAPSSEXC.TOC' for package 'SAPSSEXC'.
INFO: 2015-02-10 12:11:31
Version table 'SVERS' is found in STR file '/dumps/d51033500_2/EXP10/DATA/SAPNTAB.STR' from package 'SAPNTAB'.
INFO: 2015-02-10 12:11:31
Data conversion tables 'DDNTF,DDNTF_CONV_UC,DDNTT,DDNTT_CONV_UC' are found in STR file '/dumps/d51033500_2/EXP10/DATA/SAPNTAB.STR' from package 'SAPNTAB'.
TRACE: 2015-02-10 12:11:31 com.sap.inst.migmon.LoadTask run
Loading of 'DD03L' import package is started.
TRACE: 2015-02-10 12:11:31 com.sap.inst.migmon.LoadTask run
Loading of 'SEOCOMPODF' import package is started.
TRACE: 2015-02-10 12:11:31 com.sap.inst.migmon.LoadTask processPackage
Loading of 'DD03L' import package into database:
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
TRACE: 2015-02-10 12:11:31 com.sap.inst.migmon.LoadTask processPackage
Loading of 'SEOCOMPODF' import package into database:
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
ERROR: 2015-02-10 12:11:32 com.sap.inst.migmon.LoadTask run
Loading of 'SEOCOMPODF' import package is interrupted with R3load error.
Process '/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error' exited with return code 2.
For mode details see 'SEOCOMPODF.log' file.
Standard error output:
sapparam: sapargv( argc, argv) has not been called.
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
ERROR: 2015-02-10 12:11:32 com.sap.inst.migmon.LoadTask run
Loading of 'DD03L' import package is interrupted with R3load error.
Process '/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error' exited with return code 2.
For mode details see 'DD03L.log' file.
Standard error output:
sapparam: sapargv( argc, argv) has not been called.
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
WARNING: 2015-02-10 12:12:00
Cannot start import of packages with views because not all import packages with tables are loaded successfully.
WARNING: 2015-02-10 12:12:00
2 error(s) during processing of packages.
INFO: 2015-02-10 12:12:00
Import Monitor is stopped.
INFO: 2015-02-10 12:12:10
Import Monitor is started.
CONFIG: 2015-02-10 12:12:10
Application options:
dbCodepage=4103
dbType=ORA
ddlMap=ddl_mapping.txt
extFiles=yes
importDirs=/dumps/d51033500_1/EXP1:/dumps/d51033500_1/EXP2:/dumps/d51033500_1/EXP3:/dumps/d51033500_1/EXP4:/dumps/d51033500_1/EXP5:/dumps/d51033500_1/EXP6:/dumps/d51033500_2/EXP7:/dumps/d51033500_2/EXP8:/dumps/d51033500_2/EXP9:/dumps/d51033500_2/EXP10:/dumps/d51033500_2/EXP11
installDir=/sap_installation
jobNum=3
loadArgs=-stop_on_error
monitorTimeout=30
orderBy=
r3loadExe=/usr/sap/PRD/SYS/exe/run/R3load
sapinst=
trace=all
tskFiles=yes
CONFIG: 2015-02-10 12:12:10
List of packages with table structure: 'SAP0000'.
CONFIG: 2015-02-10 12:12:10
List of packages with views: 'SAPVIEW'.
TRACE: 2015-02-10 12:12:10 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA.TPL' template file is started.
INFO: 2015-02-10 12:12:10 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA.TPL' template file is successfully completed.
Primary key creation: after load.
Index creation: after load.
TRACE: 2015-02-10 12:12:10 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA_LRG.TPL' template file is started.
INFO: 2015-02-10 12:12:10 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA_LRG.TPL' template file is successfully completed.
Primary key creation: after load.
Index creation: after load.
TRACE: 2015-02-10 12:12:10 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA.TPL' template file is started.
INFO: 2015-02-10 12:12:10 com.sap.inst.migmon.imp.ImportStandardTask preCreate
Parse of '/sap_installation/DDLORA.TPL' template file is successfully completed.
Primary key creation: after load.
Index creation: after load.
INFO: 2015-02-10 12:12:10
Data codepage 1100 is determined using TOC file '/dumps/d51033500_1/EXP1/DATA/SAPSSEXC.TOC' for package 'SAPSSEXC'.
INFO: 2015-02-10 12:12:11
Version table 'SVERS' is found in STR file '/dumps/d51033500_2/EXP10/DATA/SAPNTAB.STR' from package 'SAPNTAB'.
INFO: 2015-02-10 12:12:11
Data conversion tables 'DDNTF,DDNTF_CONV_UC,DDNTT,DDNTT_CONV_UC' are found in STR file '/dumps/d51033500_2/EXP10/DATA/SAPNTAB.STR' from package 'SAPNTAB'.
TRACE: 2015-02-10 12:12:11 com.sap.inst.migmon.LoadTask run
Loading of 'DD03L' import package is started.
TRACE: 2015-02-10 12:12:11 com.sap.inst.migmon.LoadTask run
Loading of 'SEOCOMPODF' import package is started.
TRACE: 2015-02-10 12:12:11 com.sap.inst.migmon.LoadTask processPackage
Loading of 'DD03L' import package into database:
/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error
TRACE: 2015-02-10 12:12:11 com.sap.inst.migmon.LoadTask processPackage
Loading of 'SEOCOMPODF' import package into database:
/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error
ERROR: 2015-02-10 12:12:11 com.sap.inst.migmon.LoadTask run
Loading of 'DD03L' import package is interrupted with R3load error.
Process '/usr/sap/PRD/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4103 -l DD03L.log -stop_on_error' exited with return code 2.
For mode details see 'DD03L.log' file.
Standard error output:
sapparam: sapargv( argc, argv) has not been called.
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
ERROR: 2015-02-10 12:12:11 com.sap.inst.migmon.LoadTask run
Loading of 'SEOCOMPODF' import package is interrupted with R3load error.
Process '/usr/sap/PRD/SYS/exe/run/R3load -i SEOCOMPODF.cmd -dbcodepage 4103 -l SEOCOMPODF.log -stop_on_error' exited with return code 2.
For mode details see 'SEOCOMPODF.log' file.
Standard error output:
sapparam: sapargv( argc, argv) has not been called.
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
WARNING: 2015-02-10 12:12:40
Cannot start import of packages with views because not all import packages with tables are loaded successfully.
WARNING: 2015-02-10 12:12:40
2 error(s) during processing of packages.
INFO: 2015-02-10 12:12:40
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.