SAP Basis System: System Log "DBIF_DSQL2_SQL_ERROR " occurred

[Former Member]

Hi Experts,,

No dump has been displayed but after hitting any transactions i am gettigna empty dump

plz help me

Edited by: priyankshah123 on Sep 18, 2009 11:59 AM

[Former Member · Accepted solution]

Hi ,

Did you check the tablespace.Extend it & then your system will work fine.

Thanks..

Mohit

[Former Member]

Sorry, I was too quick hitting the "Post" button.

If all this has worked, schedule a full dbverify of the database:

brbackup -u / -m all -t offline_force -w only_dbv

Good luck,

Mark

[Former Member]

MY PSAPTEMP HAS BEEN FULL SO SHOULD I TRY WITH THAT

should increase the data files or increase the size of tablespace

Edited by: priyankshah123 on Sep 18, 2009 12:10 PM

[Former Member]

That would be good start. Making sure there is enough space.

pravin

[Former Member]

Does not really matter.

Add files. Simpler than resizing

Just make sure there is space

Pravin

[Former Member]

Hi ,

PSAPTEMP is 99% is no issues. What activity you was performing .Howcome suddenly you got this error.

There could be many reasons for this error.Please let us know little background for the same.

Thanks..

Mohit

[Former Member]

Hi Pravin when i try to increase the size of data file of PSAPTEMP tablespace of data file TEMP.DATA2 foll error occured

Internal error occurred while making a change to a data block

ORA-00600: internal error code, arguments: [4193], [3047], [3067], [], [], [], [

], []

BR0324W Insertion of database log header failed

[Former Member]

hello mohit,

when morning i started the server , i founded 2 wp in ended and then it changed automatically to waiting state...

after login when i any transactions is hited it gives a dump error...

but the dumps are ???

but in mmc system logs this error has been occured

SAP Basis System: Transaction Canceled 00 671 ( DBIF_RSQL_SQL_ERROR 20090918160215comp SAPSYS 0001 )

and

SAP Basis System: Run-time error "DBIF_DSQL2_SQL_ERROR " occurred

and

Database: Database error 600 at EXE

and

Database: Database error 607 at UPD access to table BTCCTL

Plz help

[Former Member]

Hi,

I found this on Google - always a good place to look first

ORA-600[4193] indicates corruption in the rollback segment, when the transaction table and the rollback block are out of sync.

Accompanying 607 means "ORA-00607: Internal error occurred while making a change to a data block"

I would strongly recommend to drop and rebuild your rollback segments and PSAPROLL tablespace, afterwards also run a full DBVERIFY to make sure no other part of your database is in such a bad state.

Regards,

Mark

[former_member204746]

if you drop PSAPROLL, I would highly advise you to convert to PSAPUNDO at the same time.

Please read SAP note 600141 -Oracle9i: Automatic UNDO Management.

This will improve your system and decrease the number those annoying ORA-01555 errors and wil lalso FIX your problem at the same time.

[Former Member]

HELLO,

THE MAIN PROBLEM IS ALL THE WP ARE NOW IN WAIT PROCESSES WHEN I ENTER ANY USERNAME AND PASSWD: it gives a dump ?????

When i check onMMC the system log gives a error of S

AP Basis System: Transaction Canceled 00 671 ( DBIF_RSQL_SQL_ERROR 20090918175100comp SAPSYS 0001 )

plz help me what to do

[Former Member]

Hi Expert,

One more i dont a have a tablespace PSAPROLL

[Former Member]

Hi again,

OK, in that case some more information will be needed. Could you execute the commands below and post the result:

sqlplus / as sysdba
select * from v$version;
show parameter undo
select SEGMENT_NAME,TABLESPACE_NAME,STATUS from dba_rollback_segs;
exit

Rgds,

Mark

[Former Member]

Hello Mark,

Here is the what u req.....plz help me

SQL> show parameter undo

NAME TYPE VALUE

-

---

-

---

-

---

undo_management string AUTO

undo_retention integer 43200

undo_suppress_errors boolean FALSE

undo_tablespace string PSAPUNDO

SQL> select SEGMENT_NAME,TABLESPACE_NAME,STATUS from dba_rollback_segs;

SEGMENT_NAME TABLESPACE_NAME STATUS

-

---

-

---

-

---

SYSTEM SYSTEM ONLINE

_SYSSMU1$ PSAPUNDO ONLINE

_SYSSMU2$ PSAPUNDO ONLINE

_SYSSMU3$ PSAPUNDO ONLINE

_SYSSMU4$ PSAPUNDO ONLINE

_SYSSMU5$ PSAPUNDO ONLINE

_SYSSMU6$ PSAPUNDO ONLINE

_SYSSMU7$ PSAPUNDO ONLINE

_SYSSMU8$ PSAPUNDO ONLINE

_SYSSMU9$ PSAPUNDO ONLINE

_SYSSMU10$ PSAPUNDO ONLINE

11 rows selected.

[Former Member]

OK, here goes - either do this yourself or if you are uncomofortable with it, ask your DBA:

I assume from a previous post you are on Windows, if not please adapt the path names:

Stop your SAP instance(s), leave the database running

Open a CMD shell as user <sid>adm
mkdir %SAPDATA_HOME%\sapdata1\undo2

sqlplus / as sysdba
select file_name, bytes/(1024*1024) "Megabytes" from dba_data_files
where tablespace_name='PSAPUNDO';
==> save the output of this command, you will use it later to rebuild PSAPUNDO

create undo tablespace PSAPUNDO2 datafile '<drive>:\oracle\<SID>\sapdata1\undo2\UNDO2.DATA1' size 1G;
alter system set undo_tablespace='PSAPUNDO2' scope=both;
shutdown immediate
startup

alter tablespace PSAPUNDO offline;
drop tablespace PSAPUNDO including contents and datafiles;
create undo tablespace PSAPUNDO datafile '<path>' size <size>M;
==> <path> and <size> are the file paths and sizes you retrieved from dba_data_files at the beginning

alter system set undo_tablespace='PSAPUNDO' scope=both;
shutdown immediate
startup
alter tablespace PSAPUNDO2 offline;
drop tablespace PSAPUNDO2 including contents and datafiles;
exit

rmdir %SAPDATA_HOME%\sapdata1\undo2