on 06-27-2013 11:40 PM
Hi
I´m trying to update the portal to SP 08, I ran SUM and in the requierement checks I obtain this error
Could not execute DMT command runhandler. See previous messages. Could not check the DB free space in the temporary tablespace due to problems with the database connectivity. com.sap.sql.exception.OpenSQLException: ORA-01157: cannot identify/lock data file 202 - see DBWR trace file ORA-01110: data file 202: '+DG_DATA/aup/tempfile/temp.307.773359701' OpenSQLExceptionCategories: [] java.sql.SQLException: ORA-01157: cannot identify/lock data file 202 - see DBWR trace file ORA-01110: data file 202: '+DG_DATA/aup/tempfile/temp.307.773359701'
I check the SUM log CHECK-JDBC-DRIVER_01.LOG and see this
<!--LOGHEADER[START]/-->
<!--HELP[Manual modification of the header may cause parsing problem!]/-->
<!--LOGGINGVERSION[2.0.7.1006]/-->
<!--NAME[/usr/sap/trans/SUM4/SUM/sdt/log/SUM/CHECK-JDBC-DRIVER_01.LOG]/-->
<!--PATTERN[CHECK-JDBC-DRIVER_01.LOG]/-->
<!--FORMATTER[com.sap.tc.logging.TraceFormatter(%d [%6s]: %m)]/-->
<!--ENCODING[UTF8]/-->
<!--LOGHEADER[END]/-->
Jun 27, 2013 3:40:21 PM [Info ]: Checking version of jdbc driver /oracle/client/10x_64/instantclient/ojdbc6.jar.
and no more info, could you please help me with this issue???
Best Regards
Hi Adriana,
Could you update th brtools as described in SAP note
Note 1763972 - Corrections in BR*Tools 7.20 patch 26
Additionally refer link as a similar issue with its resolution is explained
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Adriana,
What is the status of file 202?
execute the command below and paste the output :-
SELECT * FROM V$recover_file;
SELECT * FROM DBA_DATA_FILES WHERE FILE_ID=202;
As it seems your tempfile has been lost... try to re-create it ..
ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '%' SIZE 10G REUSE AUTOEXTEND OFF;
Best Regards
Marius
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi all,
I have got the same problem and I corrected that via the command below :
1 - create temporary tablespace temp2 tempfile 'NAME OF DISK GROUP ASM';
2 - alter database default temporary tablespace temp2;
3 - drop tablespace psaptemp including contents and datafiles;
After that the SUM was finished successufully.
Regards,
Philippe.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.