SAP Knowledge Base Article - Preview

3427024 - "ORA-01012: not logged

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

SAP NetWeaver all versions

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.