Trace files of large sizes are getting generated

From: nilesh kumar <nileshkum_at_gmail.com>
Date: Fri, 6 Nov 2009 20:46:18 +0530
Message-ID: <7877ab4b0911060716h5cf76563v77567591c4815075_at_mail.gmail.com>



Hello DBA's,

Good Afternoon!!

Hope Every one is doing a great job.
I have a issue in one of my database, Where in I see trace files of 4mb's are getting generated but previous to that it was not like that the size it used to be of 3kb.
Due to this the database got hunged and we need to reboot and delete the contents of dump directories.
I could see in the trace files as

ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275 ORA-22288: file or LOB operation FILEOPEN failed

Permission denied

Current SQL statement for this session:

DECLARE iCount NUMBER :=1;

Status VARCHAR2(4);

BEGIN DB.stp_snr_ne_load_xml('NE_CMPNY_STORY_LINK_ST','200910240444NYT_____NEWS__

___387932_1490.3.xml','NEWSEDGEISSUE.xsl','NEWSEDGE_XML_SOURCE_DIR','NEWSEDGE_XS

L_SOURCE_DIR'); COMMIT; EXCEPTION WHEN OTHERS THEN PKG_DEBUG.stp_SetDebugState(TRUE, FALSE, TRUE);

PKG_DEBUG.STP_OUTPUT ('Loading of File Story Cmpny Relation failed');

RAISE; END; Your help will be highly appreciated.

Thanks

Nilesh

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 06 2009 - 09:16:18 CST

Original text of this message