[opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3
Farnaz Fotrousi
f_fotrousi at yahoo.com
Tue Oct 26 16:33:43 CEST 2004
Dear Dariush,
Thanks for your help. That was useful for running opencms with those datasources. But unfortunately my problems haven't solved completely.
In some cases opencms works properly but others it hangs : pages (in explorer view ) are not displayed and when I try to reach some parts in Administration view, the message which asks me username and password for connecting to Application Server, is displayed. In these cases logfile shows me that access to those resources are denied.
like:
<opencms_info> [OpenCmsServlet] Access denied. com.opencms.core.CmsException: [com.opencms.file.oraclesql.CmsResourceBroker] /default/vfs/system/workplace/administration/logfileviewer/index.html
Do you have any hints which can help me to solve these problems?
Regards,
Farnaz.
Dariush <dariush at eximia.it> wrote:
Hi Farnaz,
my DatasourceImpl is intended to be used in prod env, in wizard you should set useDataSource=false.
When the installation is finished, turn on useDatasource.
P.S. You should have 3 datasources, not 4: oracleOci, oracleOcionline and oracleOcibackup.
Remember also that you have to start oc4j with -userThreads option in order to make context sharable on user threads.
Regards, Dariush.
---------- Original Message -----------
Wrom: RTNHGSWZIDREXCAXZOWCONEUQZAAFXISHJEXXIMQZUIVO
To: The OpenCms mailing list <opencms-dev at opencms.org>
Sent: Tue, 26 Oct 2004 02:20:09 -0700 (PDT)
Subject: Re: [opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3
> Hi,
> I would like to install opencms on oracleAs 10g and OC4j. So I tried it and I faced with lots of problems. Then I tried to use datasource implementation founded in archive mailinglist and did instructions for applying it:
> - made opencms.jar again.
> - deployed application
> - updated opencms.properties: datasource
> useDataSource=true
> - made four datasources for oracle as your example
> but when I tried to install it(with opencms wizard), In importing workpalce, some critical errors happened.
> would you please help me what's wrong with me?
> I use:
> opencms 5.0.1,
> oracle AS 10g,
> OC4j 9.0.4,
> oracle 10g DB.
>
> Regards,
> Farnaz.
>
> Importing workpalce steps:
> 137: at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
> 136: at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
> 135: at com.opencms.boot.CmsMain.begin(CmsMain.java:164)
> 134: at java.lang.reflect.Method.invoke(Method.java:324)
> 133: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 132: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 131: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 130: at com.opencms.core.CmsShell.commands(CmsShell.java:168)
> 129: at com.opencms.core.CmsShellCommands.<init>(CmsShellCommands.java:78)
> 128: java.lang.NullPointerException
> 127:
> 126: >>> at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
> 125: >>> at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
> 124: >>> at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
> 123: >>> at java.lang.Class.newInstance(Class.java:261)
> 122: >>> at java.lang.Class.newInstance0(Class.java:308)
> 121: >>> at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
> 120: >>> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> 119: >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> 118: >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> 117: >>> at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
> 116: >>> at com.opencms.core.OpenCms.<init>(OpenCms.java:255)
> 115: >>> at com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
> 114: >>> at com.opencms.file.oraclesql.CmsResourceBroker.init(CmsResourceBroker.java:67)
> 113: >>> at com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:4182)
> 112: >>> at com.opencms.file.oraclesql.CmsResourceBroker.createDbAccess(CmsResourceBroker.java:58)
> 111: >>> at com.opencms.file.oraclesql.CmsDbAccess.<init>(CmsDbAccess.java:77)
> 110: >>> at com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:305)
> 109: >>> at com.opencms.file.genericSql.CmsDbAccess.fillDefaults(CmsDbAccess.java:2785)
> 108: >>> at com.opencms.file.genericSql.CmsDbAccess.createGroup(CmsDbAccess.java:1551)
> 107: >>> at com.evermind.sql.OrclCMTConnection.prepareStatement(OrclCMTConnection.java:1014)
> 106: >>> at com.evermind.sql.FilterConnection.prepareStatement(FilterConnection.java:228)
> 105: >>> at com.evermind.sql.OrionCMTConnection.intercept(OrionCMTConnection.java:138)
> 104: >>> at com.evermind.sql.OrionCMTConnection.setConnection(OrionCMTConnection.java:188)
> 103: >>> at com.evermind.sql.OrionPooledDataSource.getConnection(OrionPooledDataSource.java:341)
> 102: >>> at com.evermind.sql.PooledConnectionUsage.getPooledConnection(PooledConnectionUsage.java:22)
> 101: >>> at com.evermind.sql.OrionPooledDataSource.getPooledConnection(OrionPooledDataSource.java:561)
> 100: >>> at com.evermind.sql.DriverManagerConnectionPoolDataSource.getPooledConnection(DriverManagerConnectionPoolDataSource.java:36)
> 99: >>> at com.evermind.sql.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:181)
> 98: >>> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:345)
> 97: >>> at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:515)
> 96: >>> at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:377)
> 95: >>> at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:198)
> 94: >>> at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:985)
> 93: >>> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:231)
> 92: >>> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189)
> 91: >>>java.sql.SQLException: invalid arguments in call
> 90: >>>Root cause:
> 89: >>>-----------
> 88: >> at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
> 87: >> at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
> 86: >> at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
> 85: >> at java.lang.Class.newInstance(Class.java:261)
> 84: >> at java.lang.Class.newInstance0(Class.java:308)
> 83: >> at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
> 82: >> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> 81: >> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> 80: >> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> 79: >> at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
> 78: >> at com.opencms.core.OpenCms.<init>(OpenCms.java:255)
> 77: >> at com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
> 76: >> at com.opencms.file.oraclesql.CmsResourceBroker.init(CmsResourceBroker.java:67)
> 75: >> at com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:4182)
> 74: >> at com.opencms.file.oraclesql.CmsResourceBroker.createDbAccess(CmsResourceBroker.java:58)
> 73: >> at com.opencms.file.oraclesql.CmsDbAccess.<init>(CmsDbAccess.java:77)
> 72: >> at com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:305)
> 71: >> at com.opencms.file.genericSql.CmsDbAccess.fillDefaults(CmsDbAccess.java:2785)
> 70: >> at com.opencms.file.genericSql.CmsDbAccess.createGroup(CmsDbAccess.java:1566)
> 69: >>root cause was java.sql.SQLException: invalid arguments in call
> 68: >>com.opencms.core.CmsException: 4 Sql exception. Detailed error: [com.opencms.file.oraclesql.CmsDbAccess] invalid arguments in call.
> 67: >>Root cause:
> 66: >>-----------
> 65: > at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
> 64: > at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
> 63: > at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
> 62: > at java.lang.Class.newInstance(Class.java:261)
> 61: > at java.lang.Class.newInstance0(Class.java:308)
> 60: > at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
> 59: > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> 58: > at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> 57: > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> 56: > at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
> 55: > at com.opencms.core.OpenCms.<init>(OpenCms.java:255)
> 54: > at com.opencms.file.CmsRbManager.init(CmsRbManager.java:100)
> 53: >root cause was java.sql.SQLException: invalid arguments in call
> 52: >root cause was com.opencms.core.CmsException: 4 Sql exception. Detailed error: [com.opencms.file.oraclesql.CmsDbAccess] invalid arguments in call.
> 51: >com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed error: Critical error while loading resourcebroker.
> 50: >Root cause:
> 49: >-----------
> 48: at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
> 47: at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
> 46: at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
> 45: at java.lang.Class.newInstance(Class.java:261)
> 44: at java.lang.Class.newInstance0(Class.java:308)
> 43: at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
> 42: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> 41: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> 40: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> 39: at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
> 38: at com.opencms.core.OpenCms.<init>(OpenCms.java:259)
> 37: root cause was java.sql.SQLException: invalid arguments in call
> 36: root cause was com.opencms.core.CmsException: 4 Sql exception. Detailed error: [com.opencms.file.oraclesql.CmsDbAccess] invalid arguments in call.
> 35: root cause was com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed error: Critical error while loading resourcebroker.
> 34: com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed error: Database init failed.
> 33: . Critical init error/3: com.opencms.core.CmsException: Critical error while loading resourcebroker
> 32: [CmsRbManager] Critical error while loading resourcebroker
> 31: . Database access init : ok
> 30: [CmsDbAccess] fillDefaults() starting NOW!
> 29: . Database fill default: yes
> 28: Looking upjdbc/oracleOci
> 27: creating InitialContext
> 26: jndiPoolName:jdbc/oracleOci
> 25: Creating new pool:oracleOci
> 24: . Database access init : ok
> 23: . Using digest encoding: MD5 from SUN version 1.42
> 22: . Digest file encoding : UTF-8
> 21: . Digest configured : MD5
> 20: . Database backup pool : jdbc:opencmspool:oracleOcibackup
> 19: . Database online pool : jdbc:opencmspool:oracleOcionline
> 18: . Database offline pool: jdbc:opencmspool:oracleOci
> 17: . Database access init : ok
> 16: Enabling pool debug, level:1
> 15: . Using DatasourceDriver...
> 14: Using Datasource.
> 13: useDataSource:true
> 12: Using DriverFactory to choose the correct driver...
> 11: . Resource broker init : phase 3 ok - creating db access module
> 10: . Resource broker init : phase 2 ok - initializing database
> 9: . Resource broker init : phase 1 ok - starting
> 8: . Resource broker class: com.opencms.file.oraclesql.CmsResourceBroker
> 7: . Resource broker used : oracleOci
> 6: . Operating sytem : Linux 2.4.19-4GB i386
> 5: . Java VM in use : Java HotSpot(TM) Server VM 1.4.2_02-b03 mixed mode Sun Microsystems Inc.
> 4: . Ethernet address used: f3:94:7c:69:e1:18
> 3: . Encoding set to : UTF-8
> 2: . System file.encoding : UTF-8
> 1: . OpenCms encoding : UTF-8
> 0: %%% props: /home/oracle/OraHomeAS/j2ee/CMS_OC4J/applications/cmsdatasource/cmsdatasource/WEB-INF/config/opencms.properties
>
> Dariush <dariush at eximia.it> wrote: Hi Juan David,
>
> I had the same problem with OpenCms 5.0.1, Oc4j10g and Oracle 9i.
> After a little analisys I decided to use a standard datasource, managed
> directly by oc4j.
>
> I posted on this list an implementation to use standard Datasources instead
> of opencms connpool.
>
> Now I have no more problems and connections are closed and managed without
> problems.
>
> Search on list for 'datasource implementation' and take a look at attached
> code.
>
> Let me know if you need help.
>
> Dariush.
>
> ---------- Original Message -----------
> From: Felipe.Ramos at steria.es
> To: Juan David Ayll�n Burguillo , The OpenCms mailing
> list
> Sent: Wed, 20 Oct 2004 17:15:15 +0200
> Subject: Re: [opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3
>
> > Hello Juan David:
> >
> > It's very difficult to give an answer with only that information.
> >
> > It could be a firewall between the DB and the Application, or it could be
> the pool of connections ( don't use the hibernate pool on your server! ) or
> maybe another one application running on the server, or the driver used (
> you must use ojdbc14.jar ) .... or what ever.... With more information we
> could give you and answer.
> >
> > We have developed ( for example ) the new web and intranet of
> the "Parlamento de Andaluc�a" in Sevilla, Spain with OpenCMS 5.0.1and J2EE
> in an environment very similar to yours, and everything goes very well, and
> the client is really very happy with the platform and with our solution. The
> web is finished but it's not yet in internet because of politicians themes,
> you know... So your platform is not the guilty.
> >
> >
> > PD: You must give a solution to the bug with "closing connections",
> because it's very important in a production environment.
> >
> > Please, feel free to call me.
> >
> > ------------------------------------------------
> > Felipe Ramos
> > Steria Espa�a
> > Paseo de las Doce Estrellas, 2
> > Campo de las Naciones
> > 28042 Madrid, Spain
> > Tel.: 913 939 832
> > -------------------------------------------------
> >
> >
> >
>
> Juan David Ayll�n Burguillo
> > Sent by: opencms-dev-bounces at opencms.org
> > 20/10/2004 16:42
> > Please respond to Juan David Ayll�n Burguillo; Please respond to The
> OpenCms mailing list
> >
> > To: Lista Opencms
> > cc:
> > Subject: [opencms-dev] Urgent Opencms hangs Oracle 9IAS
> 9.0.3
>
> >
> > Hi!
> >
> > I have a tremendous problem with a portal developed in Opencms 5.0.1,
> > it hangs several times a day and log files from Opencms and Oc4j /
> > Oracle 9IAS doesn't have information about whats happening, or i don't
> > see it.
> >
> > I have been informed of a bug closing connections with oracle DB, i
> > see that connections opened in Oracle DB is not the problem ( about 5
> > - 10 connections ).
> >
> > Actual configuration of the system:
> > Linux RedHat Advanced Server 2.1
> > Oracle 9IAS 9.0.3.0.0
> > Oracle DB Server 9.2.0.3
> > JDK 1.4.2_03-b02
> >
> > on 2x Xeon 2.8Ghz 4GB Ram
> >
> > Thanks, and sorry for my english
> >
> > --
> > Juan David Ayll�n Burguillo
> > Consejeria de Cultura Junta de Andalucia
> >
> > _______________________________________________
> > This mail is send to you from the opencms-dev mailing list
> > To change your list options, or to unsubscribe from the list, please visit
> > http://mail.opencms.org/mailman/listinfo/opencms-dev
> >
> ------- End of Original Message -------
>
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
>
>
---------------------------------
Do you Yahoo!?
> Yahoo! Mail Address AutoComplete - You start. We finish.
------- End of Original Message -------
------- End of Forwarded Message -------
_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://mail.opencms.org/mailman/listinfo/opencms-dev
---------------------------------
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20041026/86bb5c15/attachment.htm>
More information about the opencms-dev
mailing list