Re: [Dspace-tech] ORA-01000: nUmero mAximo de cursoresabiertos excedido

2007-12-12 Thread marcelo.carius 
increase open_cursors on init.ora, if use oracle9i, oracle10g. Edit this
file and execute follow commands after save the file:



open_cursors=900 -- for example

SQL>shutdown;
SQL>startup pfile=/ini.ora;
SQL>create spfile from pfile;

this command can modified only with restart database.




On Tue, 11 Dec 2007 13:02:46 -0500, Blanco, Jose wrote
> Graham:
> 
> I notice that the default for db.statementpool is true, should we 
> have this set to false.  What is the danger in leaving it at true?
> 
> Thanks!
> Jose
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:dspace-tech-
> [EMAIL PROTECTED] On Behalf Of Graham Triggs Sent: 
> Tuesday, December 11, 2007 12:49 PM To: Rodrigo Castro Artigas Cc: 
> dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] ORA-
> 01000: nUmero mAximo de cursoresabiertos excedido
> 
> Hi,
> 
> Ensure that you have disable the prepared statement cache in your
> dspace.cfg:
> 
> db.statementpool = false
> 
> G
> 
> On Tue, 2007-12-11 at 14:26 -0300, Rodrigo Castro Artigas wrote:
> > HI, I AM run process import and have the followind message:
> > 
> > java.sql.SQLException: ORA-01000: número máximo de cursores abiertos 
> > excedido
> > at
> > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> > at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
> > at
> > oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.j
> > ava:21
> > 6)
> > at
> > oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.
> > java:966)
> > at
> > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatemen
> > t.java
> > :1170)
> > at
> > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepa
> > redSta
> > tement.java:3339)
> > at
> > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepare
> > dState
> > ment.java:3423)
> > at
> > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Dele
> > gating
> > PreparedStatement.java:101)
> > at
> > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Dele
> > gating
> > PreparedStatement.java:101)
> > at
> > org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.j
> > ava:51
> > 9)
> > at
> > org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.j
> > ava:53
> > 9)
> > at org.dspace.browse.Browse.itemRemoved(Browse.java:439)
> > at org.dspace.content.Collection.delete(Collection.java:952)
> > at org.dspace.content.Community.removeCollection(Community.java:751)
> > at
> > org.dspace.app.webui.servlet.admin.EditCommunitiesServlet.doDSPost(Edi
> > tCommu
> > nitiesServlet.java:275)
> > at
> > org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServle
> > t.java
> > :147)
> > at
> > org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105)
> > at 
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> > 
> > The solution with change configuration Dspace or Oracle??
> > 
> > Atte.,
> > Rodrigo
> > 
> > 
> > --
> > ---
> > SF.Net email is sponsored by: 
> > Check out the new SourceForge.net Marketplace.
> > It's the best place to buy or sell services for just about anything 
> > Open Source.
> > http://sourceforge.net/services/buy/index.php
> > ___
> > DSpace-tech mailing list
> > DSpace-tech@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/dspace-tech
> This email has been scanned by Postini.
> For more information please visit http://www.postini.com
> 
> -
> SF.Net email is sponsored by: 
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for just about anything 
> Open Source. http://sourceforge.net/services/buy/index.php
___
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
> 
> -
> SF.Net email is sponsored by: 
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> ___
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech


--
Open WebMail Project (http://openwebmail.org)


-
SF.Net email is sponsored b

Re: [Dspace-tech] Handle server error

2007-04-17 Thread marcelo.carius 
Tiago,
can you try execute a command, on prompt: telnet  port , to 
identify a response of server. If has any problem, you will contact a MIT. If 
the telnet sucess, return for identify other possible problem.

[]'s
Marcelo Carius

On Tue, 17 Apr 2007 15:16:51 -0300, Tiago Ferreira wrote
> I´m getting this error, when starting my handle server
> 
> "2007/04/17 02:46:00 BRT" 100 class net.handle.server.HdlUdpInterface: Error 
> setting up server socket: java.net.BindException: Cannot assign requested 
> address: Cannot bind
> "2007/04/17 02:46:00 BRT" 100 class net.handle.server.HdlUdpInterface: Error 
> setting up server socket: java.net.BindException: Cannot assign requested 
> address: Cannot bind
> "2007/04/17 02:46:00 BRT" 100 class net.handle.server.HdlTcpInterface: Error 
> setting up server socket: java.net.BindException: Cannot assign requested 
> address: JVM_Bind
> "2007/04/17 02:46:00 BRT" 100 class net.handle.server.HdlTcpInterface: Error 
> setting up server socket: java.net.BindException: Cannot assign requested 
> address: JVM_Bind
> "2007/04/17 02:46:00 BRT" 100 class net.handle.server.HdlHttpInterface: Error 
> setting up server socket: java.net.BindException: Cannot assign requested 
> address: JVM_Bind
> "2007/04/17 02:46:00 BRT" 100 class net.handle.server.HdlHttpInterface: Error 
> setting up server socket: java.net.BindException: Cannot assign requested 
> address: JVM_Bind
> 
> Any Ideas?
> 
> Thanks in advance
> Tiago Ferreira

 
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] Handle server error

2007-04-17 Thread marcelo.carius 
Tiago,
can you try execute a command telnet  port to identify a response of 
server. If has any problem, you will contact a MIT. If the telnet sucess, 
return for identify other possible problem.

[]'s
Marcelo Carius

On Tue, 17 Apr 2007 15:16:51 -0300, Tiago Ferreira wrote
> I´m getting this error, when starting my handle server
> 
> "2007/04/17 02:46:00 BRT" 100 class net.handle.server.HdlUdpInterface: Error 
> setting up server socket: java.net.BindException: Cannot assign requested 
> address: Cannot bind
> "2007/04/17 02:46:00 BRT" 100 class net.handle.server.HdlUdpInterface: Error 
> setting up server socket: java.net.BindException: Cannot assign requested 
> address: Cannot bind
> "2007/04/17 02:46:00 BRT" 100 class net.handle.server.HdlTcpInterface: Error 
> setting up server socket: java.net.BindException: Cannot assign requested 
> address: JVM_Bind
> "2007/04/17 02:46:00 BRT" 100 class net.handle.server.HdlTcpInterface: Error 
> setting up server socket: java.net.BindException: Cannot assign requested 
> address: JVM_Bind
> "2007/04/17 02:46:00 BRT" 100 class net.handle.server.HdlHttpInterface: Error 
> setting up server socket: java.net.BindException: Cannot assign requested 
> address: JVM_Bind
> "2007/04/17 02:46:00 BRT" 100 class net.handle.server.HdlHttpInterface: Error 
> setting up server socket: java.net.BindException: Cannot assign requested 
> address: JVM_Bind
> 
> Any Ideas?
> 
> Thanks in advance
> Tiago Ferreira

 
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech