[opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3
Farnaz Fotrousi
f_fotrousi at yahoo.com
Sat Oct 30 07:42:20 CEST 2004
Dear Dariush,
If I understand the meaning of plain installation exactly, I should tell you that I installed opencms with Tomcat4.0.6 and Oracle10g DB and it worked without any problems. But when I switched to oracleAS 10g which has OC4j 9.0.4.,the problems appeared.
So it seems the problem is related to OracleAs or OC4j but what is the reason, I don't know.
Can you guess any reasons?
Regards,
Farnaz
Dariush <dariush at eximia.it> wrote:
Hi Farnaz,
if I were you, I would restart from a plain installation, just to find out if the problem is connected with your current network /application server/db environment or (hope it) with your current opencms installation.
To do that, you should create a new db and opencms instance and investigate on this plain inst.
Let me know,
Dariush.
---------- Original Message -----------
Wrom: VOTQNQEMSFDULHPQQWOYIYZUNNYCGPKYLEJGDGVCJVTLB
To: The OpenCms mailing list <opencms-dev at opencms.org>
Sent: Thu, 28 Oct 2004 14:51:30 -0700 (PDT)
Subject: Re: [opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3
> Dear Dariush,
>
> First of all, sorry comming back to you too late.
> Now I should tell you that Before I wanted to use DataSource, I tested ConnPool but I had faced with the same problems which persists after using DataSource.So it seems these behaviors are not just related to DataSource or Connpool.
> Can you help me, which factors can cause these problems?
>
> Kind Regards,
> Farnaz.
>
> Dariush <dariush at eximia.it> wrote: Hi Farnaz,
> first of all you should investigate to understand if the access denied error
> occurs only using DataSources (but I don't think so) or also using default
> connPool.
>
> If problem persists also using connPool, try to restart from a plain installation.
>
> Consider that from an access privilege point of view to opencms resources,
> datasources and connpool are the same thing.
>
> Let me know if the problem occurs only with DataSources.
>
> Best regards, Dariush.
>
> ---------- Original Message-----------
> Wrom: NNSKVFVWRKJVZCMHVIBGDADRZFSQHYUCDDJBLVLMHAALP
> To: The OpenCms mailing list
> Sent: Tue, 26 Oct 2004 07:33:43 -0700 (PDT)
> Subject: Re: [opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3
>
> > DearDariush,
> >
> > Thanks for your help. That was useful for running opencms with
> thosedatasources. But unfortunately my problems haven't solved completely.
> > In some cases opencms works properly but others it hangs : pages
> (inexplorer view ) are not displayed and when I try to reach some parts
> inAdministration view, the message which asks me username and password
> forconnecting to Application Server, is displayed. In these cases logfile
> shows methat access to those resources aredenied.
> > like:
> > [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 theseproblems?
> >
> > Regards,
> >Farnaz.
> >
> > Dariush wrote:Hi Farnaz,
> > my DatasourceImpl is intended tobe used in prod env, in wizard you should
> set useDataSource=false.
> > Whenthe installation is finished, turn on useDatasource.
> >
> > P.S. Youshould have 3 datasources, not 4: oracleOci, oracleOcionline
> andoracleOcibackup.
> > 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
> >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
> Ifaced with lots of problems. Then I tried to use datasource
> implementationfoundedin 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 Itried to install it(with opencms wizard), In importing
> workpalce, some criticalerrors 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.
> > >
> > > Importingworkpalce steps:
> > > 137: atcom.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
> > > 136:at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
> > > 135: atcom.opencms.boot.CmsMain.begin(CmsMain.java:164)
> > > 134: atjava.lang.reflect.Method.invoke(Method.java:324)
> > >
> 133:atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> > > 132:
> atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> > > 131: at sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)
> > > 130: atcom.opencms.core.CmsShell.commands(CmsShell.java:168)
> > > 129: atcom.opencms.core.CmsShellCommands.(CmsShellCommands.java:78)
> > > 128: java.lang.NullPointerException
> > > 127:
> >> 126: >>> atcom.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: >>> atjava.lang.reflect.Constructor.newInstance(Constructor.java:274)
> > >120:>>>
> atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> > > 119: >>>
> atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> > > 118: >>> atsun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> >> 117: >>> atcom.opencms.core.CmsShell.(CmsShell.java:105)
> > > 116:>>> at com.opencms.core.OpenCms.(OpenCms.java:255)
> >> 115: >>> atcom.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
> > > 114:>>>
> atcom.opencms.file.oraclesql.CmsResourceBroker.init(CmsResourceBroker.java:67)
> > > 113: >>>
> atcom.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:4182)
> > > 112: >>>
> atcom.opencms.file.oraclesql.CmsResourceBroker.createDbAccess(CmsResourceBroker.java:58)
> > > 111: >>>atcom.opencms.file.oraclesql.CmsDbAccess.(CmsDbAccess.java:77)
> > > 110: >>>
> atcom.opencms.file.genericSql.CmsDbAccess.(CmsDbAccess.java:305)
> > > 109: >>>
> atcom.opencms.file.genericSql.CmsDbAccess.fillDefaults(CmsDbAccess.java:2785)
> > > 108: >>>
> atcom.opencms.file.genericSql.CmsDbAccess.createGroup(CmsDbAccess.java:1551)
> > > 107: >>>
> atcom.evermind.sql.OrclCMTConnection.prepareStatement(OrclCMTConnection.java:1014)
> > > 106: >>>
> atcom.evermind.sql.FilterConnection.prepareStatement(FilterConnection.java:228)
> > > 105: >>>
> atcom.evermind.sql.OrionCMTConnection.intercept(OrionCMTConnection.java:138)
> > > 104: >>>
> atcom.evermind.sql.OrionCMTConnection.setConnection(OrionCMTConnection.java:188)
> > > 103: >>>
> atcom.evermind.sql.OrionPooledDataSource.getConnection(OrionPooledDataSource.java:341)
> > > 102:
> >>>atcom.evermind.sql.PooledConnectionUsage.getPooledConnection(PooledConnectionUsage.java:22)
> > > 101: >>>
> atcom.evermind.sql.OrionPooledDataSource.getPooledConnection(OrionPooledDataSource.java:561)
> > > 100: >>>
> atcom.evermind.sql.DriverManagerConnectionPoolDataSource.getPooledConnection(DriverManagerConnectionPoolDataSource.java:36)
> > > 99: >>>
> atcom.evermind.sql.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:181)
> > > 98: >>> atoracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:345)
> > > 97:>>>
> atoracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:515)
> > > 96: >>>
> atoracle.jdbc.driver.OracleConnection.(OracleConnection.java:377)
> > > 95: >>> atoracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:198)
> > > 94:>>> at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:985)
> > > 93: >>>atoracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:231)
> > >92: >>> atoracle.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: >> atcom.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: >> atjava.lang.Class.newInstance0(Class.java:308)
> > > 83: >> atjava.lang.reflect.Constructor.newInstance(Constructor.java:274)
> > >82: >>
> atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> > > 81:
> >>atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> > > 80: >> atsun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> >> 79: >> at com.opencms.core.CmsShell.(CmsShell.java:105)
> > > 78: >> atcom.opencms.core.OpenCms.(OpenCms.java:255)
> > > 77:>> at com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
> >> 76: >>
> atcom.opencms.file.oraclesql.CmsResourceBroker.init(CmsResourceBroker.java:67)
> > > 75: >>
> atcom.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:4182)
> > > 74: >>
> atcom.opencms.file.oraclesql.CmsResourceBroker.createDbAccess(CmsResourceBroker.java:58)
> > > 73: >> atcom.opencms.file.oraclesql.CmsDbAccess.(CmsDbAccess.java:77)
> > > 72: >> atcom.opencms.file.genericSql.CmsDbAccess.(CmsDbAccess.java:305)
> > > 71:
> >>atcom.opencms.file.genericSql.CmsDbAccess.fillDefaults(CmsDbAccess.java:2785)
> > > 70: >>
> atcom.opencms.file.genericSql.CmsDbAccess.createGroup(CmsDbAccess.java:1566)
> > > 69: >>root cause was java.sql.SQLException: invalidarguments in call
> > > 68: >>com.opencms.core.CmsException: 4 Sqlexception. Detailed error:
> [com.opencms.file.oraclesql.CmsDbAccess] invalidarguments in call.
> > > 67: >>Root cause:
> > > 66:>>-----------
> > > 65: > atcom.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: > atjava.lang.Class.newInstance0(Class.java:308)
> > > 60: > atjava.lang.reflect.Constructor.newInstance(Constructor.java:274)
> > >59:
> >atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> > > 58: >
> atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> > > 57: > atsun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> >> 56: > at com.opencms.core.CmsShell.(CmsShell.java:105)
> > > 55: > atcom.opencms.core.OpenCms.(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 incall.
> > > 51: >com.opencms.core.CmsException: 33Resourcebroker-init error. Detailed
> error: Critical error while loadingresourcebroker.
> > > 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: atjava.lang.Class.newInstance(Class.java:261)
> > > 44: atjava.lang.Class.newInstance0(Class.java:308)
> > > 43: atjava.lang.reflect.Constructor.newInstance(Constructor.java:274)
> > >42:
> atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> > > 41:
> atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> > > 40: atsun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> >> 39: at com.opencms.core.CmsShell.(CmsShell.java:105)
> >> 38: at com.opencms.core.OpenCms.(OpenCms.java:259)
> >> 37: root cause was java.sql.SQLException: invalid arguments in call
> > > 36: root cause was com.opencms.core.CmsException:4Sql exception. Detailed
> error: [com.opencms.file.oraclesql.CmsDbAccess] invalidarguments in call.
> > > 35: root cause wascom.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: creatingInitialContext
> > > 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 backuppool : 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: . UsingDatasourceDriver...
> > > 14: Using Datasource.
> > > 13:useDataSource:true
> > > 12: Using DriverFactory to choose the correctdriver...
> > > 11: . Resource broker init : phase 3 ok - creating dbaccess 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 brokerused : oracleOci
> > > 6: . Operating sytem : Linux 2.4.19-4GB i386
> > > 5: . Java VM in use : Java HotSpot(TM) Server VM 1.4.2_02-b03mixed mode
> Sun MicrosystemsInc.
> > > 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 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 thislist an implementation to use standard Datasources instead
> > > ofopencms connpool.
> > >
> > > Now I have no more problems andconnections are closed and managed without
> > > problems.
> > >
> > > Search on list for 'datasource implementation' and take a look atattached
> > > code.
> > >
> > > Let me know if you needhelp.
> > >
> > > Dariush.
> > >
> > >---------- Original Message -----------
> > > From:Felipe.Ramos at steria.es
> > > To: Juan David Ayll�n Burguillo , The OpenCms mailing
> > > list
> > > Sent: Wed, 20 Oct200417:15:15 +0200
> > > Subject: Re: [opencms-dev] Urgent Opencms hangsOracle 9IAS 9.0.3
> > >
> > > > Hello Juan David:
> >> >
> > > > It's very difficult to give an answer with onlythat information.
> > > >
> > > > It could be a firewallbetween the DB and the Application, or it could be
> > > the pool ofconnections ( 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 moreinformation 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 OpenCMS5.0.1and J2EE
> > > in an environment very similar to yours, andeverything goes very well, and
> > > the client is really very happywith the platform and with our solution. The
> > > web is finished butit'snotyet in internet because of politicians themes,
> > > you know... Soyour 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
> > > > Paseode las Doce Estrellas, 2
> > > > Campo de las Naciones
> > >> 28042 Madrid, Spain
> > > > Tel.: 913 939 832
> > > >-------------------------------------------------
> > > >
> >> >
> > > >
> > >
> > > Juan David Ayll�nBurguillo
> > > > 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 mailinglist
> > > >
> > > > To: Lista Opencms
> > > > cc:
> > > > Subject: [opencms-dev]Urgent Opencms hangs Oracle 9IAS
> > > 9.0.3
> > >
> > >>
> > > > Hi!
> > > >
> > > > I have atremendous 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 beeninformed of a bug closing connections with oracle DB, i
> > > > seethat connections opened in Oracle DB is not the problem ( about 5
> > >> - 10 connections ).
> > > >
> > > > Actualconfiguration of the system:
> > > > Linux RedHat Advanced Server 2.1
> > > > Oracle 9IAS 9.0.3.0.0
> > > > Oracle DB Server9.2.0.3
> > > > JDK 1.4.2_03-b02
> > > >
> > >> on 2x Xeon 2.8Ghz 4GBRam
> > > >
> > > > 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 -------
> > >
> > > _______________________________________________
> > > Thismail is send to you from the opencms-dev mailing list
> > > To changeyour 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 ofOriginal Message -------
> >
> > ------- End ofForwarded Message -------
> >
> >
> >
> >_______________________________________________
> > This mail is send to youfrom the opencms-dev mailing list
> > To change your list options, or tounsubscribe from the list, please visit
> >http://mail.opencms.org/mailman/listinfo/opencms-dev
> >
> -----------------------------------------------------------------------
> Do you Yahoo!?
> >Read only the mail you want - Yahoo!MailSpamGuard.
> ------- 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!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
------- 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20041029/f97882bc/attachment.htm>
More information about the opencms-dev
mailing list