Trouble shoot ORA-01012: not logged on
Hi,
The problem started as follows
The users were experiencing slow performance.identifying a long running query (> 10 mins.). The processes for that query were killed.
Once that happened the users were getting ORA-01012: not logged on
The SQL database operation failed. : ORA-01012: not logged on
Process ID: 3437
Session ID: 762 Serial number: 381
Research:
According to Oracle 10g R2 Administrator's Guide you get ORA-01012 for every attempt to submit a request to the database after receiving an ORA-00028 (your session has been killed) message:
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/manproc.htm#sthref705
Are there any errors that precede the ORA-01012 message.
The problem started as follows
The users were experiencing slow performance.identifying a long running query (> 10 mins.). The processes for that query were killed.
Once that happened the users were getting ORA-01012: not logged on
The SQL database operation failed. : ORA-01012: not logged on
Process ID: 3437
Session ID: 762 Serial number: 381
Research:
According to Oracle 10g R2 Administrator's Guide you get ORA-01012 for every attempt to submit a request to the database after receiving an ORA-00028 (your session has been killed) message:
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/manproc.htm#sthref705
Are there any errors that precede the ORA-01012 message.
1