Re: Oracle 10g Release 2 OpenVMS I64 V8.4 porting OpenBravo ERP
Date: Thu, 24 Mar 2011 13:51:48 -0400
Message-ID: <WwLip.753751$De6.463590_at_en-nntp-01.dc1.easynews.com>
"BillPedersen" <wmapedersen_at_gmail.com> wrote in message
news:add047bc-ce58-4df0-9772-d22c23c777fe_at_j13g2000pro.googlegroups.com...
On Mar 10, 11:46 pm, John Hurley <hurleyjo..._at_yahoo.com> wrote:
> Sounds like a bad query somehow ... can you try running that query
> thru some other tool ( like SQL Developer or Toad etc ) to give you
> some idea on what needs to be check out and/or fixed?
>
> Ok, finally got my Oracle 10gR2 Linux (x86) implementation up and
> running and it gets past the offending point in the code.
>
> Configuration is:
>
> ANT and necessary code residing on OpenVMS I64 V8.4 with Oracle JDBC
> Thin Driver pointing at the Linux DB instance.
>
> Linux environment is Red Hat V4.8 with Oracle 10gR2.
>
> In this environment the ANT build of OpenBravo ERP is proceeding... I
> has proceeded past the point of failure when entirely on OpenVMS.
>
> So this points at the NETV2 process as either not having sufficient
> quotas or similar. I would generally doubt privileges as well over
> 15000 SQL transactions had already been processed and additionally
> other transactions of a similar nature have been executed. I am
> leaning toward the quotas as the particular transaction is fairly
> large but not to the extent of surpassing SQL limits as it has run
> properly in this other environment.
>
> Any suggestions?
>
> Any place I should look for the particular quotas the NETV2 server is
> started with and possibly how to change?
>
> Now, that said, I have now seen an error - farther on, where is it
> JAVA and fork oriented... So I will need to explore that problem now
> while I think of the other issues and talk with folks.
>
> Thanks,
>
> Bill.
>
I have these quotas setup on my Oracle server, and they are based upon Oracle's recommendations (among others, I run lots of different things on that server).
SYSGEN> SHOW PQL_M
Parameter Name Current Default Min. Max. Unit
Dynamic
-------------- ------- ------- ------- ------- ---- ------- PQL_MASTLM 2048 4 4 -1 Ast D PQL_MBIOLM 1000 4 4 -1 I/O D PQL_MBYTLM 1000000 128000 128000 -1 Bytes D PQL_MCPULM 0 0 0 -1 10Ms D PQL_MDIOLM 2048 4 4 -1 I/O D PQL_MFILLM 2048 2 2 -1 Files D PQL_MPGFLQUOTA 2000000 512000 512000 -1 Pagelets D internal value 125000 32000 32000 -1 Pages D PQL_MPRCLM 20 0 0 -1 Processes D PQL_MTQELM 2000 0 0 -1 Timers D PQL_MWSDEFAULT 43888 16384 16384 -1 Pagelets internal value 2743 1024 1024 -1 Pages PQL_MWSQUOTA 87776 32768 32768 -1 Pagelets D internal value 5486 2048 2048 -1 Pages D PQL_MWSEXTENT 1873920 65536 65536 -1 Pagelets D internal value 117120 4096 4096 -1 Pages D PQL_MENQLM 8192 64 64 -1 Locks D PQL_MJTQUOTA 8192 0 0 -1 BytesD
HTH
Syltrem
Received on Thu Mar 24 2011 - 12:51:48 CDT