on 08-23-2011 7:47 PM
Hello,
I am trying to install solman 7.1 and I am getting this error during the Import ABAP phase:
The import Monitor jobs shows : completed 16 and failed 12
An error occurred while processing option SAP Solution Manager 7.1 > SAP Systems > Oracle > Central System > Central System( Last error reported by the step :Program 'Migration Monitor' exits with error code 103. For details see log file(s) import_monitor.java.log, import_monitor.log.).
Each failed import package like SAPSSEXC , 'SAPCLUST' etc and all the logs show "unable to create INITIAL extent for segment in tablespace PSAPSR3" , and also /oracle is at 100% occupying 130gb.
Please take a look at the log and let me know what i need to do?
How do i extend the tablespace without brtools? I am not sure what the SQL command is ?
SAPCLUST.LOG below:
DbSl Trace: Error 1658 in stmt_execute() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-01658 occurred when executing SQL stmt (parse error offset=786432)
(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed
rc = 99, table "EDI40"
(SQL error 1658)
error message returned by DbSl:
ORA-01658: unable to create INITIAL extent for segment in tablespace PSAPSR3
(DB) INFO: disconnected from DB
/usr/sap/SOL/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/SOL/SYS/exe/run/R3load: END OF LOG: 20110823124407
/usr/sap/SOL/SYS/exe/run/R3load: START OF LOG: 20110823131447
/usr/sap/SOL/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#3 $ SAP
/usr/sap/SOL/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE]
Compiled Aug 1 2010 22:52:09
/usr/sap/SOL/SYS/exe/run/R3load -i SAPCLUST.cmd -dbcodepage 4102 -l SAPCLUST.log -stop_on_error
DbSl Trace: ORA-1403 when accessing table SAPUSER
(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
(DB) INFO: EDI40 deleted/truncated #20110823131447
DbSl Trace: Error 1658 in stmt_execute() from oci_execute_stmt(), orpc=0
DbSl Trace: ORA-01658 occurred when executing SQL stmt (parse error offset=786432)
(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed
rc = 99, table "EDI40"
(SQL error 1658)
error message returned by DbSl:
ORA-01658: unable to create INITIAL extent for segment in tablespace PSAPSR3
(DB) INFO: disconnected from DB
/usr/sap/SOL/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/SOL/SYS/exe/run/R3load: END OF LOG: 20110823131450
Hi,
You need to use the basic brtools or alter tablespace commands:
BRTools -> Check Link http://www.docstoc.com/docs/67701806/Extending-Tablespace-with-SAP-Brtools
Or issue direct SQL command ->
ALTER TABLESPACE SAPSR3 ADD DATAFILE u2018<file path>u2019 size 20000m
But before this make sure you have free space in the /oracle. Else you need to add more disk space.
Regards,
Srikishan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.