This content has been marked as final. Show 7 replies
Clarify what you mean by "connecting through terminal server? " If you have an app server, you need to configure an oracle client on the app server to point at the database (usually TNS/JDBC). this app server will have logs
Can you check the application logs at those time of the crash to see what its doing, narrow it down to a module, refer to developers and ask what that module does regards SQL?
If youre new to DBAing, I wouldnt recommend tracing on the database just yet as you have many many concepts to go through to get there.
Concur with the responses so far - does not sound like an Oracle issue at all. Oracle does not "crash" applications running on a Windows Terminal Server somewhere, where that application GUI is display on a terminal somewhere else.
That is all Microsoft gunk. That is Microsoft applications that are crashing. That is likely a Microsoft problem.
Oracle's only involvement is receiving an application request, servicing that, and returning the results and status of that to the client. How can Oracle be blamed for application side crashing and acting in an unstable fashion!?
As others have pointed out, chances are that the Database Layer is not responsible for the problem.
To your questions:
You can see all connected sessions in v$session
You can make them write trace files (containing all the SQL) with DBMS_MONITOR
Search that in tahiti.oracle.com and you will find detailed guidelines.
"Don't believe it, test it!"
I can see the below log in Application:
2012-04-01 07:53:07.00 - Uniface session started
I/O function: F, mode: 1, on file/table: NUM index: 1 =
ORA-00054: resource busy and acquire with NOWAIT specified I/O function: F, mode: 1, on file/table: NUM index: 1 =
ORA-00054: resource busy and acquire with NOWAIT specified 2012-04-01 08:03:59.00 - Uniface session stopped
ORACLE Driver Error [-28]: sql driver function (SQL Workbench or sql Proc instruction) failed. I/O function: Q, mode: 0, on driver: ORA
ORA-01861: literal does not match format string
I can't see the current lock details... The session is crashing automatically, so lock is releasing that time.
Please let me know what I can do here,