[opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3

Fri Oct 29 10:52:58 CEST 2004

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

> DearDariush,
>  
> First of all, sorry comming back to you too late.
> Now I shouldtell you that Before I wanted to use DataSource, I tested ConnPool but I hadfaced with the same problems which persists after using DataSource.So it seems these behaviors are not just related to DataSource orConnpool.
> Can you help me, which factors can cause theseproblems?
>  
> KindRegards,
> Farnaz.
>
> Dariush<dariush at eximia.it>wrote:Hi Farnaz,
> first of all you shouldinvestigate to understand if the access denied error
> occurs only usingDataSources (but I don't think so) or also using default
>connPool.
>
> If problem persists also using connPool, try torestart from a plain installation.
>
> Consider that from an accessprivilege point of view to opencms resources,
> datasources and connpoolare the same thing.
>
> Let me know if the problem occurs only withDataSources.
>
> Best regards, Dariush.
>
> ----------Original Message-----------
> Wrom:NNSKVFVWRKJVZCMHVIBGDADRZFSQHYUCDDJBLVLMHAALP
> To: The OpenCms mailinglist 
> Sent: Tue, 26 Oct 2004 07:33:43 -0700(PDT)
> Subject: Re: [opencms-dev] Urgent Opencms hangs Oracle 9IAS9.0.3
>
> > DearDariush,
> >
> > Thanks foryour help. That was useful for running opencms with
>thosedatasources.But unfortunately my problems haven't solved completely.
> > In somecases opencms works properly but others it hangs : pages
> (inexplorerview ) 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 caseslogfile
> shows methat access to those resources aredenied.
> >like:
> > [OpenCmsServlet] Accessdenied.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 solvetheseproblems?
> >
> > Regards,
> >Farnaz.
>>
> > Dariush wrote:Hi Farnaz,
> > myDatasourceImpl is intended tobe used in prod env, in wizard you should
>set useDataSource=false.
> > Whenthe installation is finished, turnonuseDatasource.
> >
> > P.S. Youshould have 3 datasources, not4: oracleOci, oracleOcionline
> andoracleOcibackup.
> > Rememberalso that you have to start oc4j with-userThreads option in order
> tomake context sharable on user threads.
> >
> > Regards,Dariush.
> >
> > ---------- OriginalMessage-----------
> > Wrom:RTNHGSWZIDREXCAXZOWCONEUQZAAFXISHJEXXIMQZUIVO
> > To: The OpenCmsmailing list 
> >Sent: Tue, 26 Oct 200402:20:09 -0700 (PDT)
> > Subject: Re: [opencms-dev]Urgent Opencms hangsOracle 9IAS 9.0.3
> >
> > > Hi,
> > >I wouldlike 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 applyingit:
> > > -made opencms.jar again.
> > > - deployedapplication
> > > -updated opencms.properties: datasource
>>>useDataSource=true
> >> - made four datasources for oracle as yourexample
> > > but when Itried to install it(with opencms wizard), Inimporting
> workpalce, some criticalerrors happened.
> > >would you please help me what's wrong with me?
> > > I use:
>> > opencms 5.0.1,
> > > oracle AS 10g,
> > > OC4j9.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: atsun.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:>>> atcom.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: >>> atjava.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:>>>atoracle.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: >> atcom.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
> > >87: >> atcom.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
>> > 86: >>atcom.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: >> atcom.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 incall
> > > 68: >>com.opencms.core.CmsException: 4Sqlexception. 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:>atjava.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: >atcom.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 Sqlexception.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 incall
> > > 36: root cause was com.opencms.core.CmsException:4Sqlexception. Detailed
> error: [com.opencms.file.oraclesql.CmsDbAccess]invalidarguments in call.
> > > 35: root causewascom.opencms.core.CmsException: 33 Resourcebroker-init
> error. Detailederror:Critical error while loading resourcebroker.
> > >34:com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed
>error:Database init failed.
> > > 33: . Critical initerror/3:com.opencms.core.CmsException: Critical error
> while loadingresourcebroker
> > > 32: [CmsRbManager] Critical error while loadingresourcebroker
> > > 31: . Database access init : ok
> >>30:[CmsDbAccess]fillDefaults() starting NOW!
> > > 29: . Database filldefault: yes
> > > 28: Looking upjdbc/oracleOci
> > >27: creatingInitialContext
> > > 26:jndiPoolName:jdbc/oracleOci
> > > 25:Creating newpool: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 offlinepool: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 choosethe correctdriver...
> > > 11: . Resource broker init :phase3 ok - creating dbaccess module
> > > 10: . Resource broker init :phase 2 ok -initializing database
> > > 9: . Resource broker init :phase 1 ok -starting
> > > 8: . Resource brokerclass:com.opencms.file.oraclesql.CmsResourceBroker
> > > 7: .Resource brokerused : oracleOci
> > > 6: . Operating sytem : Linux2.4.19-4GB i386
> > > 5: . Java VM in use : Java HotSpot(TM) ServerVM 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 JuanDavid,
> > >
> >> I had the same problem with OpenCms5.0.1, Oc4j10g and Oracle 9i.
> >> After alittleanalisys I decided to use a standard datasource, managed
> > >directly by oc4j.
> > >
> > > I posted on thislist animplementation to use standard Datasources instead
> > > ofopencmsconnpool.
> > >
> > > Now I have no more problemsandconnections are closed and managed without
> > >problems.
> > >
> > > Search on list for 'datasourceimplementation' and take a look atattached
> > > code.
> >>
> > > Let me know if you needhelp.
> > >
>> > Dariush.
> > >
> > >---------- OriginalMessage -----------
> > > 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 ananswerwith onlythat information.
> > > >
> > > > Itcould 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, orthe driver used (
> > > you must use ojdbc14.jar ) .... or whatever.... With moreinformation we
> > > could give you andanswer.
> > > >
> > > > We have developed ( forexample ) the new web and intranet of
> > > the "Parlamento deAndalucía" in Sevilla, Spain with OpenCMS5.0.1and J2EE
> > > in anenvironment very similar to yours, andeverything goes very well, and
>> > the client is really very happywith the platform and with oursolution. The
> > > web is finished butit'snotyet in internetbecause of politicians themes,
> > > you know... Soyour platform isnot 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.
> >> >
> > > >------------------------------------------------
> >> > FelipeRamos
> > > > Steria España
> > > > Paseode lasDoce Estrellas, 2
> > > > Campo de las Naciones
> >>> 28042 Madrid, Spain
> > > > Tel.: 913 939 832
>> > >-------------------------------------------------
> >> >
> >> >
> > > >
> > >
>> > Juan David AyllónBurguillo
> > > > Sentby:opencms-dev-bounces at opencms.org
> > > > 20/10/200416: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 portaldeveloped in Opencms 5.0.1,
> > > >it hangs several times a dayand log files from Opencms and Oc4j /
> > >> Oracle 9IAS doesn'thave information about whats happening, or i don't
> > > > seeit.
> > > >
> > > > I have beeninformed of a bugclosing connections with oracle DB, i
> > > > seethat connectionsopened in Oracle DB is not the problem ( about 5
> > >> - 10connections ).
> > > >
> > > > Actualconfigurationof the system:
> > > > Linux RedHat Advanced Server 2.1
>> > > Oracle 9IAS 9.0.3.0.0
> > > > Oracle DBServer9.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, pleasevisit
> > > >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, pleasevisit
> >>http://mail.opencms.org/mailman/listinfo/opencms-dev
> >>
> > >
>-----------------------------------------------------------------------
>Do you Yahoo!?
> >>Yahoo!Mail Address AutoComplete - You start. We finish.
> > -------End ofOriginal Message -------
> >
> > ------- EndofForwarded Message -------
> >
> >
> >
>>_______________________________________________
> > This mail issend to youfrom the opencms-dev mailing list
> > To change your listoptions, 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 youfrom the opencms-dev mailing list
> To change your list options, or tounsubscribe from the list,pleasevisit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
>
> __________________________________________________
>Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protectionaround
> http://mail.yahoo.com
------- End of Original Message-------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20041029/c26e699f/attachment.htm>