RE: error in SQL Monitoring screen 11.2.0.3.4
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: Oracle-L Freelists <Oracle-L@xxxxxxxxxxxxx>
- Date: Tue, 12 Mar 2013 18:26:20 +0000
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of John Hurley
Sent: Monday, March 11, 2013 4:47 PM
To: Oracle-L Freelists
Cc: tanel@xxxxxxxxxxxxxx
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!
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
