Symptom
Sessions fail and you see the error below:
Database Error Text: "ORA-01012: not logged on Process ID: <xxxxxxxx> Session ID:
<X> Serial number: <XXXX>"
dev_w* trace --->
C Disconnecting con=0
C OCITransRollback(OCI_DEFAULT) failed with SQL error 1012:
C ORA-01012: not logged on
C Process ID: 28836208
C Session ID: 13 Serial number: 19636
C OCISessionEnd(con=0, svc=11649e650, srv=115b9bb90='<SID>'): Close session usr=11621fea8, rc=0
C OCIServerDetach(stale2 con=0, svc=11649e650, srv=115b9bb90='<SID>') successfully detached
C OCIHandleFree(con=0, svc=11649e650): Server handle srv=115b9bb90 freed
C OCIHandleFree(con=0): Service hdl. svc=11649e650 freed.
B dbcon[exec_reconnect]: disconnected from connection 0
B dbcon[exec_reconnect]: opening connection 0 ...
C Connecting as SAP<SID>/<pwd>@<SID> on connection 0 (nls 0) ... (dbsl 722 300322, UNICODE[2])
C OCIHandleAlloc(con=0, env=115b677d0): New service svc=11649e650 created, rc=0
C OCIServerAttach(con=0, svc=11649e650): New server hdl. srv=115b9bb90 attached to '<SID>'
C OCISessionBegin(con=0, svc=11649e650, srv=115b9bb90='<SID>'): start session usr=115be3db0='SAP<SID>', rc=0
C Now 'SAP<SID>/<pwd>@<SID>' is connected: con=0, nls=0, session=13, time='2023-08-22 12:25:00'
...
Alert.log --->
2023-08-24T21:47:32.164166+05:30
KILL SESSION for sid=(45, 21425):
Reason = profile limit idle_time
Mode = KILL SOFT -/-/NO_REPLAY
Requestor = PMON (orapid = 2, ospid = 8847620, inst = 1)
Owner = Process: USER (orapid = 33, ospid = 32702878)
Result = ORA-0
Read more...
Environment
- Oracle RDBMS any version
- Not restricted to any SAP product
- Not restricted to any OS platform
Product
Keywords
Default, idel_time, oracle, profile limit idle_time, ORA-01012: not logged on, failed with SQL error 1012 , KBA , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.