ora 00060 deadlock detected while waiting for resource

Ora 00060 deadlock detected while waiting for resource password#

Ĭ 1 Connecting as on connection 1 (nls 0).

Ĭ 1 Closing user session (con=1, svc=0616AE48, usr=0689C488) Ĭ 1 Disconnected (con=1) from ORACLE.

Ora 00060 deadlock detected while waiting for resource password#

Ĭ 1 Now is connected: con=1, nls=0, session=-1, time=' 14:12:00' [dbsloci.c#1529Ĭ E ORA-1031 when updating table SAPUSER Ĭ 1 Got SAPSR3's password from OPS$-user Ĭ 1 Disconnecting from connection 1. (dbsl 720 291112, UNICODE) [dbsloci.c#15268Ĭ 1 Starting user session: OCISessionBegin(con=1, usr='/', svc=0616AE48, srv=07F3E258, usr=0689C48Ĭ 1 OCIStmtExecute() failed with -1=OCI_ERROR Ĭ 1 Could not read session ID from V$MYSTAT. Since the caller of the procedure could not have anticipated that theĮxception would occur, the current program is terminated.ĭatabase error text: 'ORA-00060: deadlock detected while waiting for resource'Ĭ 1 Client NLS setting (by OCINlsGetInfo(con=1)): 'AMERICAN_AMERICA.UTF16' Ĭ 1 Logon as OPS$-user to get SAPSR3's password Ĭ 1 Connecting as on connection 1 (nls 0). Procedure 'WRITE_ICFACT' '(FORM)', nor was it propagated by a RAISING clause. The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught Tried to run the DTP in process chain but same issue.īelow is part of dump which i found relevant, can post more if anybody require more data to analyse the issue.Īn exception occurred that is explained in detail below.

) the request is showing in yellow but when i access the request id to check which datapackage fails it turns red. Processing mode :- parallel extration and processingĪfter the batch job completion(some failed due to dump and oters finished. i have applied the sap note 84348, but still am facing the issue. In the short dump it says, ORA-00060 error. I have getting short dump(ST22) when i run my DTP.