ORA-00028 combined with ORA-02063 - preceding line

[Former Member]

Hello,

We had undergone an SAP release upgrade form SAP 4.7 to SAP 6.0.

From time to time, some of the customer legacy programs, dumps while trying to enter parameters in the Oracle database. They are not crashing every time but latley every night. After we restart then, they are working ok without a dump.

We are suspectin an Database peak, that is killing our session.

If you encounter this type or error before, can you please advise on how to proceed further. To singe out what parameter in Oracle or SAP may need updating ?

The error is like this:

Fehlertext der Datenbank...: "ORA-00028: your session has been

killed#ORA-02063: preceding line from VVS"

Fehlercode der Datenbank...: 28

Auslösende SQL-Anweisung...: "update v_sap_sbdc@vvs set sap_uebernahme_dat =

trunc ( sysdate ) where vvs_batch_nr = ? "

Interne Aufrufcodierung....: "[DBDS/NEW DSQL]"

Thanks and regards,

Adrian Irimes

[lbreddemann]

Hi there.

Have you had a look at the failing statement?

It's obviously a remote SQL, that is, it's executed via a DBLINK VVS (see that the update is on table v_sap_sbdc@vvs ).

And the error message is returned by the remote database - not from your NetWeaver DB.

If this was my problem, I'd check what's going on on the remote DB...

I don't suspect a bug here.

regards,

Lars

[Former Member]

Hello,

Thx for following up.

The ABAP code is :

EXEC sql.

update v_sap_sbdc@vvs

set sap_uebernahme_dat = trunc(sysdate)

where vvs_batch_nr = :zbtchnr

ENDEXEC.

We are suspecting that some think is happening in the database, also if we look to the record in st22, coudl it be also 2062 to blame ?

FC DBIF_DSQL2_SQL_ERROR

AP ZZVVS

AI ZZVVS

AL 2756

TD 4DBA75995C743122E1000000A0321162

XC CX_SY_NATIVE_SQL_ERROR

CM //bas/701_REL/src/krn/runt/abexsql.c#1

CF DsqlErrorHandler

CL 2062

RT 20110430015055

SR 16128

SP 24576

SV 0

SA 17751264

MU 14442872

MF 170688

SX 18446697011922745759

Thx and regards,

Adrian Irimes

[lbreddemann]

Hmm...

ok, this is about pure custom coding (Z-Report ZZVS) and it's about a problem that occurs when by-passing the SAP DBIF-Layer and using native SQL to access data via a database link.

AND you get error codes:ORA-00028 and ORA-02063.

So, looking up these error codes may help..

ORA-00028: your session has been killed Cause: A privileged user has killed your session and you are no longer logged on to the database.

Action: Login again if you wish to continue working.

ORA-02062: distributed recovery received DBID string, expected string Cause: a database link at a coordinator no longer points to the expected database. Link may have been redefined, or a different DB mounted.

Action: restore link definition or remote database.

ORA-02063: preceding stringstring from stringstring Cause: an Oracle error was received from a remote database link.

Action: refer to the preceding error message(s)

To me, this all looks like as if something is not OK with this database link.

Why don't you just check it?

regards,

Lars

[Former Member]

Hi Lars,

Thx for following up.

The problem is, that it is failing only occasional.

In the morning when we check the jobs, and restart them if necessary it works ok. Some times it just failes during the night ( not allways ).

Regards,

Adrian

[Former Member]

Dear Adrian Irimes ,

Oracle BUG may be the reason for this. Have you updated the oracle MOPATCH and OPATCH and also the parameters for 11G as per SAP recommendations.

If not please do that and then check.

hope your problem will get solved.

thanks

chaitanya.

[Former Member]

Hello Chaitanya,

Thx for following up.

I had informed the cusomer, and basis team to check the SAP parameters by note 830576.

The oracle MOPATCH and OPATCH are to be found in SAP or in Oracle ?

Thx and regards,

Adrian Irimes