RE: error in SQL Monitoring screen 11.2.0.3.4
Date: Tue, 12 Mar 2013 18:26:20 +0000
Message-ID: <1E24812FBE5611419EFAFC488D7CCDD117CF9F51_at_G5W2734.americas.hpqcorp.net>
I did not follow the previous entries but have you reviewed the following at Oracle support to see if any of this applies?
BUG:8246403 - NEED HINTS TO DEBUG "ORA-31011: XML PARSING FAILED" ERROR NOTE:8246403.8 - Bug 8246403 - XDB reports ORA-31011 if content contains illegal characters OEM SQL Monitoring Page Throws ORA-31061: XDB error: special char to escaped char conversion failed error [ID 1344065.1]
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Hurley
Sent: Monday, March 11, 2013 4:47 PM
To: Oracle-L Freelists
Cc: tanel_at_tanelpoder.com
Subject: error in SQL Monitoring screen 11.2.0.3.4
Anyone seen this?
I have a query that uses a text index ( catsearch ). When it gets picked up for real time SQL Monitoring in 11.2.0.3.4 and you click on the sqlid ... OEM screen throws an error and does not display the SQL and of course does not display the SQL monitoring report.
Works just fine in 11.1.0.7.12 ( really all the 11.1.0.7.x versions ).
Text returned in OEM monitoring screen looks like this:
java.sql.SQLException: ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00225: end-element tag "bind" does not match start-element tag "query" Error at line 1
ORA-06512: at "SYS.DBMS_SQLTUNE", line 13969 ORA-06512: at "SYS.DBMS_SQLTUNE", line 14265 ORA-06512: at line 1
SQL involved looks like this:
SELECT /*+ index(VS_CUSTOMER CUSTOMER_SX1) */ IMAGE_RECNBR, CUSTOMER_ID, CONTROL_SEQ_ID, CUSTOMER_ID_NEW, NAME_LAST, NAME_FIRST, ADDRESS_1, ADDRESS_2, ADDRESS_3, CITY, STATE, ZIP, QTY_FIXTIME_INQUIRY, AB_COVER, FDX_SIGNATURE_RELEASE, DATE_SHIP_FIRST, GOOD_RISK, OPT_IN_OUT, COD_RISK, CATALOG_PREF_1, CATALOG_PREF_2, CATALOG_PREF_3, CATALOG_PREF_4, CATALOG_PREF_5, CATALOG_PREF_6, FLAG_SHIP_PREF, DATE_MAIL_ORDER_FIRST, WEB_ONLY, LANGUAGE, AREA_CODE, PHONE_NBR, COUNTRY_ID, TAX_EXEMPT_ID, SOURCE_CODE_FIRST, SOURCE_CODE_LAST, DATE_TRANSACTION_FIRST, DATE_TRANSACTION_LAST, CNT_ORDER, TOT_NET_ORDER_AMT, FLAG_ORDER_TYPE, FLAG_NIXIE, FLAG_NOMAIL, FLAG_PROMO, FLAG_FRAUD, FLAG_COD, FLAG_REFUSED, FLAG_CATALOG, FLAG_SHIP_TO, FLAG_DELETE, FLAG_BUSINESS_CUSTOMER, FLAG_CASH_CHECK FROM sre_corp.VS_CUSTOMER WHERE ((catsearch(NAME_LAST,:"SYS_B_0",NULL) > :"SYS_B_1")) ORDER BY IMAGE_RECNBR
***
I have a bad feeling I need to submit an SR ... dang!
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 12 2013 - 19:26:20 CET