Home » RDBMS Server » Server Administration » Issues with Trace (Oracle Server 10.2.0.1.0 for Linux 2.6.9-5.ELsmp)
Issues with Trace [message #379219] Mon, 05 January 2009 08:38 Go to next message
ashish1986
Messages: 12
Registered: July 2008
Junior Member
Dear All,
Greetings.
I am new to the community.

I am facing an issue while taking traces of applications.

I am using Oracle 10.2.0.1.0 for Linux 2.6.9-5.ELsmp EST 2005 i686 i686 i386 GNU/Linux.

The issue is that whenever we execute a section of an aplliaction with the trace ON at the PID of the process the the application hangs up and then terminates after a while stating Contact System Adminstrator.

When executed without the trace, it runs successfully.

We have an alternate oracle server which has Oracle 9i server 9.2.0.1.0 on an SunOS sun5 5.8 Generic_108528-22 sun4u sparc SUNW,Ultra-4.

The same application executes smoothly when this oracle DataBase is used.

Are there any compatibility issues between Linux and Oracle for using Trace utility.

I have used both dbms_system.set_sql_trace_in_session and DBMS_MONITOR.session_trace_enable for taking traces.

Please Help
Re: Issues with Trace [message #379277 is a reply to message #379219] Mon, 05 January 2009 17:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
anything in alert logs?
Re: Issues with Trace [message #379293 is a reply to message #379219] Mon, 05 January 2009 23:45 Go to previous messageGo to next message
ashish1986
Messages: 12
Registered: July 2008
Junior Member
Alert log :

Errors in file /oracle/Ora10g/product/10.2.0/db_1/admin/linqz02/udump/linqz02_ora_7143.trc:
ORA-00604: error occurred at recursive SQL level 51
ORA-00036: maximum number of recursive SQL levels (50) exceeded
ORA-00604: error occurred at recursive SQL level 50
ORA-00036: maximum number of recursive SQL levels (50) exceeded

The Same appliaction when run on a Oracle 9i server ( on SunOS )and Oracle 10.1 (on HP-UX ) runs successfully.

Please advise.
Re: Issues with Trace [message #379315 is a reply to message #379293] Tue, 06 January 2009 00:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You likely have a loop somewhere in triggers.

Regards
Michel
Re: Issues with Trace [message #379342 is a reply to message #379219] Tue, 06 January 2009 02:35 Go to previous messageGo to next message
ashish1986
Messages: 12
Registered: July 2008
Junior Member
Dear All,
Thanks for the replies.

The issue is that, when we execute our appliaction without setting the SQL Trace ON it executes smoothly.

It is only when i try to put a sql trace on the process that it goes haywire.

Is there a bug with 10.2 because this runs smoothly on Versions 9.x.x.x and 10.1.x.x

Please suggest

Kind Regards
Ashish

I found this link which also gives info regarding the same.
However i couldn't make much out of it.
http://dbaforums.org/oracle/index.php?showtopic=3945
Please help.

Re: Issues with Trace [message #379351 is a reply to message #379342] Tue, 06 January 2009 03:05 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you investigate the point I mentionned?
Did you try to see if there is any loop in the trace file?

Regards
Michel

[Updated on: Tue, 06 January 2009 03:05]

Report message to a moderator

Previous Topic: v$session issue
Next Topic: sql query from spid
Goto Forum:
  


Current Time: Tue Dec 06 12:20:17 CST 2016

Total time taken to generate the page: 0.21947 seconds