OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Issues with Trace (Oracle Server 10.2.0.1.0 for Linux 2.6.9-5.ELsmp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Issues with Trace [message #379219]

Mon, 05 January 2009 08:38

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

Report message to a moderator

Re: Issues with Trace [message #379277 is a reply to message #379219]

Mon, 05 January 2009 17:07

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

anything in alert logs?

Report message to a moderator

Re: Issues with Trace [message #379293 is a reply to message #379219]

Mon, 05 January 2009 23:45

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.

Report message to a moderator

Re: Issues with Trace [message #379315 is a reply to message #379293]

Tue, 06 January 2009 00:57

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You likely have a loop somewhere in triggers.

Regards
Michel

Report message to a moderator

Re: Issues with Trace [message #379342 is a reply to message #379219]

Tue, 06 January 2009 02:35

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.

Report message to a moderator

Re: Issues with Trace [message #379351 is a reply to message #379342]

Tue, 06 January 2009 03:05

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 15:51:10 CST 2024