Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ORA-23463

ORA-23463

From: Alexander Ordonez <aordonez_at_ccss.sa.cr>
Date: Fri, 08 Mar 2002 19:58:20 -0800
Message-ID: <F001.00423C99.20020308195820@fatcity.com>


Hi gurus,
i have this error in the replication process, when execute dbms_offline_og.end_load

any idea for this error... i search in the metalink and no found solution .. help me please ....

@L£K



  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

> -----Mensaje original-----
> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US