Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> ORA-23463
any idea for this error... i search in the metalink and no found solution ..
help me please ....
@L£K
> -----Mensaje original-----
Hi gurus,
i have this error in the replication process, when execute
dbms_offline_og.end_load
Lic. Alexander Ordóñez Arroyo
Caja Costarricense del Seguro Social
Soporte Técnico - División de Informática
Telefono: 295-2004, San José, Costa Rica
Aordonez_at_ccss.sa.cr Icq# 30173325
------------------------------------------------------------
The true is out there in WWW
> De: Ron Yount [SMTP:ronwy_at_swbell.net]
> Enviado el: Viernes 8 de Marzo de 2002 09:23 PM
> Para: Multiple recipients of list ORACLE-L
> Asunto: RE: cursor not closing
>
> In the for what it is worth department, I had similiar issues. After the
> developers knocked themselves out looking for code that was not closing
> the
> cursor, I opened a tar:
>
> In a nutshell: yet another "feature" that cursors "even though closed by
> the
> session that opened them" remain available.... this is touted as a feature
> since there may be a session later that could benefit from a previous
> cursor... this behavior will continue until max_cursors is reached and
> then
> you are done...:-(
>
> You can remedy this situation with the _CLOSE_CACHED_OPEN_CURSORS=true
> init
> parameter.
>
> If you are interested in more detail... my tar number is: 1921166.995
>
> HTH,
>
> -Ron-
>
> > -----Original Message-----
> > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Ji, Richard
> > Sent: Friday, March 08, 2002 6:23 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: cursor not closing
> >
> >
> > Identify all the codes where ResultSet, Statement are used and make sure
> > they are closed after it's done.
> >
> > -----Original Message-----
> > Sent: Friday, March 08, 2002 4:48 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi,
> >
> > We have a Application that user JDBC thin client connecting to Oracle
> > database.
> > It seems like java code is opening the cursor , running some sql but not
> > closing
> > the cusrsor.
> > Now the number of open_cursor reached 3568 .
> > Is there any way we can close cursor from sqlplus.
> >
> > Thanks
> > --Harvinder
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Harvinder Singh
> > INET: Harvinder.Singh_at_MetraTech.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ji, Richard
> > INET: Richard.Ji_at_MobileSpring.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ron Yount
> INET: ronwy_at_swbell.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez INET: aordonez_at_ccss.sa.cr Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Mar 08 2002 - 21:58:20 CST